Question 1

COGNITIVE ASSESSMENT What was Megan's Law designed to do?

Accepted Answer

A)  predict the accuracy of data in a database and ways to improve the data integrity 
B)  create a list of names and addresses of people convicted of crimes against children 
C)  compile a list of database techniques and processes to share with DBMS users 
D)  make unauthorized access or data entry in a database illegal 
A)  predict the accuracy of data in a database and ways to improve the data integrity 
B)  create a list of names and addresses of people convicted of crimes against children 
C)  compile a list of database techniques and processes to share with DBMS users 
D)  make unauthorized access or data entry in a database illegal

Question 2

In a file processing system, each department or area in an organization shares files collectively.

Accepted Answer

A) True 
 B)False

Question 3

Which of the following kinds of backup are used by organizations such as hospitals, communications companies, and financial institutions?

Accepted Answer

A)  dynamic 
B)  interactive 
C)  collaborative 
D)  continuous 
A)  dynamic 
B)  interactive 
C)  collaborative 
D)  continuous

Question 4

____________________ is a computer phrase that points out that the accuracy of a computer's output depends on the accuracy of its input.

Accepted Answer

The answer of ____________________ is a computer phrase that points...

Question 5

COGNITIVE ASSESSMENT In a database, what is the smallest unit of data a user accesses?

Accepted Answer

A)  a field 
B)  a character 
C)  a record 
D)  a file 
A)  a field 
B)  a character 
C)  a record 
D)  a file

Question 6

To assist with sound decision making, the information must have value.

Accepted Answer

A) True 
 B)False

Question 7

With a distributed database, the data is accessible through a variety of servers.

Accepted Answer

A) True 
 B)False

Question 8

COGNITIVE ASSESSMENT Complex DBMSs maintain a listing of activities that modify the contents of a database. What is this listing called?

Accepted Answer

A)  recovery disk 
B)  backup 
C)  index 
D)  log 
A)  recovery disk 
B)  backup 
C)  index 
D)  log

Question 9

In a relational database, where does the only data redundancy exist?

Accepted Answer

A)  in the hypermedia 
B)  in the fields 
C)  in the hypertext 
D)  in the relationships 
A)  in the hypermedia 
B)  in the fields 
C)  in the hypertext 
D)  in the relationships

Question 10

COGNITIVE ASSESSMENT Which of the following is not considered a part of file maintenance?

Accepted Answer

A)  adding a record to a database 
B)  modifying data in a record 
C)  the creation of a new database 
D)  deleting records from a database 
A)  adding a record to a database 
B)  modifying data in a record 
C)  the creation of a new database 
D)  deleting records from a database

Question 11

COGNITIVE ASSESSMENT Which of the following statements best describes a form?

Accepted Answer

A)  a window on the screen that provides areas for entering or modifying data in a database 
B)  a formatted, printable retrieval of specific data 
C)  a screen that enables a database user to add or delete tables 
D)  the opening screen in a DBMS in which the user logs in to achieve authorization to modify or retrieve data 
A)  a window on the screen that provides areas for entering or modifying data in a database 
B)  a formatted, printable retrieval of specific data 
C)  a screen that enables a database user to add or delete tables 
D)  the opening screen in a DBMS in which the user logs in to achieve authorization to modify or retrieve data

Question 12

Explain data validation and the various types of validity checks.

Accepted Answer

The answer of Explain data validation and the various types...

Question 13

Which of the following is a process designed to ensure the data within the relations (tables) contains the least amount of duplication?

Accepted Answer

A)  concatenation 
B)  rasterization 
C)  dithering 
D)  normalization 
A)  concatenation 
B)  rasterization 
C)  dithering 
D)  normalization

Question 14

COGNITIVE ASSESSMENT Which of the following contains a database that helps a group or department make decisions?

Accepted Answer

A)  data speedset 
B)  data mart 
C)  data warehouse 
D)  data market 
A)  data speedset 
B)  data mart 
C)  data warehouse 
D)  data market

Question 15

A database eliminates redundant data.

Accepted Answer

A) True 
 B)False

Question 16

____________________ information has meaning to the person who receives it.

Accepted Answer

The answer of ____________________ information has meaning to the person...

Question 17

Which of the following kind of checks is a validity check performed on data, like that in the accompanying figure, which ensures users enter only alphabetic data into a field?

Accepted Answer

A)  alphabetic 
B)  numeric 
C)  range 
D)  consistency 
A)  alphabetic 
B)  numeric 
C)  range 
D)  consistency

Question 18

Most DBMSs include a feature, as shown in the middle image within the accompanying figure, which has a graphical user interface to assist users with retrieving data. What is this feature called?

Accepted Answer

A)  QBA 
B)  SQL 
C)  QBE 
D)  schema 
A)  QBA 
B)  SQL 
C)  QBE 
D)  schema

Question 19

COGNITIVE ASSESSMENT Which of the following is not one of the qualities associated with identifying the value of information?

Accepted Answer

A)  accurate 
B)  verifiable 
C)  useful 
D)  expensive 
A)  accurate 
B)  verifiable 
C)  useful 
D)  expensive

Question 20

If the lowest annual fee at a discount warehouse is $20.25 and the highest is $55.50, a(n) ____________________ on the Annual Fee field ensures it is a value between $20.25 and $55.50.

Accepted Answer

The answer of If the lowest annual fee at a...

COGNITIVE ASSESSMENT What was Megan's Law designed to do?

In a file processing system, each department or area in an organization shares files collectively.

Which of the following kinds of backup are used by organizations such as hospitals, communications companies, and financial institutions?

____________________ is a computer phrase that points out that the accuracy of a computer's output depends on the accuracy of its input.

COGNITIVE ASSESSMENT In a database, what is the smallest unit of data a user accesses?

To assist with sound decision making, the information must have value.

With a distributed database, the data is accessible through a variety of servers.

COGNITIVE ASSESSMENT Complex DBMSs maintain a listing of activities that modify the contents of a database. What is this listing called?

In a relational database, where does the only data redundancy exist?

COGNITIVE ASSESSMENT Which of the following is not considered a part of file maintenance?

COGNITIVE ASSESSMENT Which of the following statements best describes a form?

Explain data validation and the various types of validity checks.

Which of the following is a process designed to ensure the data within the relations (tables) contains the least amount of duplication?

COGNITIVE ASSESSMENT Which of the following contains a database that helps a group or department make decisions?

A database eliminates redundant data.

____________________ information has meaning to the person who receives it.

Which of the following kind of checks is a validity check performed on data, like that in the accompanying figure, which ensures users enter only alphabetic data into a field?

Most DBMSs include a feature, as shown in the middle image within the accompanying figure, which has a graphical user interface to assist users with retrieving data. What is this feature called?

COGNITIVE ASSESSMENT Which of the following is not one of the qualities associated with identifying the value of information?

If the lowest annual fee at a discount warehouse is $20.25 and the highest is $55.50, a(n) ____________________ on the Annual Fee field ensures it is a value between $20.25 and $55.50.

Digital Literacy: Introducing a World of Technology

The Internet: Accessing, Searching, Sharing, and Communicating

Computers and Mobile Devices: Evaluating the Possibilities

Programs and Apps: Using Software at Work, School, and Home

Digital Safety and Security: Identifying Threats, Issues, and Defenses

Inside Computers and Mobile Devices: Exploring the Components

Input and Output: Examining Popular Devices

Digital Storage: Preserving on Media and on the Cloud

Operating Systems: Managing, Coordinating, and Monitoring Resources

Communications and Networks: Sending and Receiving Digital Content

Information Systems and Program Development: Designing and Building Solutions

Filters

Exam 11: Information and Data Management: Organizing, Verifying, Maintaining, and Accessing

COGNITIVE ASSESSMENT What was Megan's Law designed to do?

In a file processing system, each department or area in an organization shares files collectively.

Which of the following kinds of backup are used by organizations such as hospitals, communications companies, and financial institutions?

____________________ is a computer phrase that points out that the accuracy of a computer's output depends on the accuracy of its input.

COGNITIVE ASSESSMENT In a database, what is the smallest unit of data a user accesses?

To assist with sound decision making, the information must have value.

With a distributed database, the data is accessible through a variety of servers.

COGNITIVE ASSESSMENT Complex DBMSs maintain a listing of activities that modify the contents of a database. What is this listing called?

In a relational database, where does the only data redundancy exist?

COGNITIVE ASSESSMENT Which of the following is not considered a part of file maintenance?

COGNITIVE ASSESSMENT Which of the following statements best describes a form?

Explain data validation and the various types of validity checks.

Which of the following is a process designed to ensure the data within the relations (tables) contains the least amount of duplication?

COGNITIVE ASSESSMENT Which of the following contains a database that helps a group or department make decisions?

A database eliminates redundant data.

____________________ information has meaning to the person who receives it.

Which of the following kind of checks is a validity check performed on data, like that in the accompanying figure, which ensures users enter only alphabetic data into a field?

Most DBMSs include a feature, as shown in the middle image within the accompanying figure, which has a graphical user interface to assist users with retrieving data. What is this feature called?

COGNITIVE ASSESSMENT Which of the following is not one of the qualities associated with identifying the value of information?

If the lowest annual fee at a discount warehouse is $20.25 and the highest is $55.50, a(n) ____________________ on the Annual Fee field ensures it is a value between $20.25 and $55.50.

Digital Literacy: Introducing a World of Technology

The Internet: Accessing, Searching, Sharing, and Communicating

Computers and Mobile Devices: Evaluating the Possibilities

Programs and Apps: Using Software at Work, School, and Home

Digital Safety and Security: Identifying Threats, Issues, and Defenses

Inside Computers and Mobile Devices: Exploring the Components

Input and Output: Examining Popular Devices

Digital Storage: Preserving on Media and on the Cloud

Operating Systems: Managing, Coordinating, and Monitoring Resources

Communications and Networks: Sending and Receiving Digital Content

Information Systems and Program Development: Designing and Building Solutions

Filters