Question 1

A ____ is the smallest unit of data a computer can process.

Accepted Answer

A)  bit 
B)  character 
C)  field 
D)  record 
A)  bit 
B)  character 
C)  field 
D)  record

Question 2

A(n) ____ verifies that a required field contains data.

Accepted Answer

A)  range check 
B)  completeness check 
C)  consistency check 
D)  alphabetic/numeric check 
A)  range check 
B)  completeness check 
C)  consistency check 
D)  alphabetic/numeric check

Question 3

A DBMS places a copy of the record after a change, called the ____________________, in the log.

Accepted Answer

The answer of A DBMS places a copy of the...

Question 4

Many database programs today have a Web page as their back end.

Accepted Answer

A) True 
 B)False

Question 5

Like a form, a report generator is used to maintain and retrieve data.

Accepted Answer

A) True 
 B)False

Question 6

____________________ refers to the procedures that keep data current.

Accepted Answer

The answer of ____________________ refers to the procedures that keep...

Question 7

____________________ is the process of comparing data with a set of rules or values to find out if the data is correct.

Accepted Answer

The answer of ____________________ is the process of comparing data...

Question 8

With the database approach, most data items are stored in multiple files, which greatly increases duplicate data.

Accepted Answer

A) True 
 B)False

Question 9

With a(n) ____, users create a computerized database; add, change, and delete data in the database; sort and retrieve data from the database; and create forms and reports from the data in the database.

Accepted Answer

A)  DBMS 
B)  RMS 
C)  QBE 
D)  XML 
A)  DBMS 
B)  RMS 
C)  QBE 
D)  XML

Question 10

When a program flags a deleted record, the record ____ process it.

Accepted Answer

A)  is deleted physically from the disk and is deleted logically because the program will not 
B)  is deleted physically from the disk but remains logically because the program will 
C)  remains physically on the disk but is deleted logically because the program will not 
D)  remains physically on the disk and remains logically because the program will 
A)  is deleted physically from the disk and is deleted logically because the program will not 
B)  is deleted physically from the disk but remains logically because the program will 
C)  remains physically on the disk but is deleted logically because the program will not 
D)  remains physically on the disk and remains logically because the program will

Question 11

Rollback restores a database to its condition after a failure.

Accepted Answer

A) True 
 B)False

Question 12

Many search engines use databases to store Web site descriptions.

Accepted Answer

A) True 
 B)False

Question 13

A data ____ is a huge database that stores and manages the data required to analyze historical and current transactions.

Accepted Answer

A)  stockyard 
B)  warehouse 
C)  storehouse 
D)  storage unit 
A)  stockyard 
B)  warehouse 
C)  storehouse 
D)  storage unit

Question 14

A(n) ____________________ is a value that a DBMS initially displays in a field.

Accepted Answer

The answer of A(n) ____________________ is a value that a...

Question 15

Figure 10-1 A user of a relational database, such as that pictured in Figure 10-1, refers to a file as a ____.

Accepted Answer

A)  table 
B)  column 
C)  row 
D)  relationship 
A)  table 
B)  column 
C)  row 
D)  relationship

Question 16

Critical Thinking Questions Case 2 In your database course, your instructor has given you a small database that has a lot of invalid data, issuing the challenge to you that you work to apply validation rules to the data and determine what checks need to be applied in order to restore integrity to the data. The instructor tells you that this is a mailing database, and yet you can see at a glance that there are some records with no data in the city fiel d. What kind of check should you run on this field?

Accepted Answer

A)  completeness check 
B)  consistency check 
C)  range check 
D)  check digit 
A)  completeness check 
B)  consistency check 
C)  range check 
D)  check digit

Question 17

Many database programs perform a(n) ____________________ that analyzes entered data to help ensure that it is correct.

Accepted Answer

validation

Question 18

____, a user deletes it from a file.

Accepted Answer

A)  To correct inaccurate data 
B)  When new data is obtained 
C)  To update old data with new data 
D)  When a record no longer is needed 
A)  To correct inaccurate data 
B)  When new data is obtained 
C)  To update old data with new data 
D)  When a record no longer is needed

Question 19

A standard query language exists for multidimensional databases.

Accepted Answer

A) True 
 B)False

Question 20

Verifiable information ____.

Accepted Answer

A)  gives more value than it costs to produce 
B)  is arranged to suit the needs and requirements of a decision maker 
C)  has meaning to the person who receives it 
D)  can be proven as correct or incorrect 
A)  gives more value than it costs to produce 
B)  is arranged to suit the needs and requirements of a decision maker 
C)  has meaning to the person who receives it 
D)  can be proven as correct or incorrect

A ____ is the smallest unit of data a computer can process.

A(n) ____ verifies that a required field contains data.

A DBMS places a copy of the record after a change, called the ____________________, in the log.

Many database programs today have a Web page as their back end.

Like a form, a report generator is used to maintain and retrieve data.

____________________ refers to the procedures that keep data current.

____________________ is the process of comparing data with a set of rules or values to find out if the data is correct.

With the database approach, most data items are stored in multiple files, which greatly increases duplicate data.

With a(n) ____, users create a computerized database; add, change, and delete data in the database; sort and retrieve data from the database; and create forms and reports from the data in the database.

When a program flags a deleted record, the record ____ process it.

Rollback restores a database to its condition after a failure.

Many search engines use databases to store Web site descriptions.

A data ____ is a huge database that stores and manages the data required to analyze historical and current transactions.

A(n) ____________________ is a value that a DBMS initially displays in a field.

Figure 10-1 A user of a relational database, such as that pictured in Figure 10-1, refers to a file as a ____.

Many database programs perform a(n) ____________________ that analyzes entered data to help ensure that it is correct.

____, a user deletes it from a file.

A standard query language exists for multidimensional databases.

Verifiable information ____.

Introduction to Computers

The Internet and World Wide Web

Application Software

The Components of the System Unit

Input

Output

Storage

Operating Systems and Utility Programs

Communications and Networks

Computer Security, Ethics, and Privacy

Information System Development

Programming Languages and Program Development

Enterprise Computing

Computer Careers and Certification

Filters

Exam 10: Database Management

A ____ is the smallest unit of data a computer can process.

A(n) ____ verifies that a required field contains data.

A DBMS places a copy of the record after a change, called the ____________________, in the log.

Many database programs today have a Web page as their back end.

Like a form, a report generator is used to maintain and retrieve data.

____________________ refers to the procedures that keep data current.

____________________ is the process of comparing data with a set of rules or values to find out if the data is correct.

With the database approach, most data items are stored in multiple files, which greatly increases duplicate data.

With a(n) ____, users create a computerized database; add, change, and delete data in the database; sort and retrieve data from the database; and create forms and reports from the data in the database.

When a program flags a deleted record, the record ____ process it.

Rollback restores a database to its condition after a failure.

Many search engines use databases to store Web site descriptions.

A data ____ is a huge database that stores and manages the data required to analyze historical and current transactions.

A(n) ____________________ is a value that a DBMS initially displays in a field.

Figure 10-1 A user of a relational database, such as that pictured in Figure 10-1, refers to a file as a ____.

Many database programs perform a(n) ____________________ that analyzes entered data to help ensure that it is correct.

____, a user deletes it from a file.

A standard query language exists for multidimensional databases.

Verifiable information ____.

Introduction to Computers

The Internet and World Wide Web

Application Software

The Components of the System Unit

Input

Output

Storage

Operating Systems and Utility Programs

Communications and Networks

Computer Security, Ethics, and Privacy

Information System Development

Programming Languages and Program Development

Enterprise Computing

Computer Careers and Certification

Filters