Question 1

In a(n) ____________________, the DBMS uses the log to undo any changes made to a database during a certain period.

Accepted Answer

backward r

Question 2

A ____ stores images, audio clips, and/or video clips.

Accepted Answer

A)  multimedia database 
B)  groupware database 
C)  computer-aided design (CA
D)  database 
D)  hypertext database 
A)  multimedia database 
B)  groupware database 
C)  computer-aided design (CA
D)  database 
D)  hypertext database

Question 3

A checkout clerk with ____ privileges to the e-mail addresses in a discount warehouse database could view the addresses but not change them.

Accepted Answer

A)  read-only 
B)  write-only 
C)  full-update 
D)  no access 
A)  read-only 
B)  write-only 
C)  full-update 
D)  no access

Question 4

Generally, users change records in a file ____.

Accepted Answer

A)  when they obtain new data and to correct inaccurate data 
B)  to correct inaccurate data and to update old data with new data 
C)  to update old data with new data and when a record no longer is needed 
D)  when a record no longer is needed and when they obtain new data 
A)  when they obtain new data and to correct inaccurate data 
B)  to correct inaccurate data and to update old data with new data 
C)  to update old data with new data and when a record no longer is needed 
D)  when a record no longer is needed and when they obtain new data

Question 5

Most companies realize that information is one of their most valuable assets - because information is used to generate data.

Accepted Answer

A) True 
 B)False

Question 6

Accurate information ____.

Accepted Answer

A)  is error free 
B)  has meaning to the person who receives it 
C)  is available when a decision maker needs it 
D)  has an age suited to its use 
A)  is error free 
B)  has meaning to the person who receives it 
C)  is available when a decision maker needs it 
D)  has an age suited to its use

Question 7

An object-oriented database stores unstructured data less efficiently than a relational database.

Accepted Answer

A) True 
 B)False

Question 8

Applications best suited for relational databases are those whose data can be organized in a two-dimensional table.

Accepted Answer

A) True 
 B)False

Question 9

From time to time, users should run a utility program that removes indexed records and reorganizes current records.

Accepted Answer

A) True 
 B)False

Question 10

In a database, a(n) ____ field is a field that uniquely identifies each record in a file.

Accepted Answer

A)  main 
B)  identifying 
C)  master 
D)  key 
A)  main 
B)  identifying 
C)  master 
D)  key

Question 11

A manager would have ____ privileges to member data in a discount warehouse database.

Accepted Answer

A)  read-only 
B)  write-only 
C)  full-update 
D)  no access 
A)  read-only 
B)  write-only 
C)  full-update 
D)  no access

Question 12

Because a data dictionary contains details about the data in a database, some call it ____________________.

Accepted Answer

The answer of Because a data dictionary contains details about...

Question 13

A(n) ____________________, or copy, of the entire database should be made on a regular basis.

Accepted Answer

The answer of A(n) ____________________, or copy, of the entire...

Question 14

A Web database usually resides on a database server.

Accepted Answer

A) True 
 B)False

Question 15

The developer of a relational database refers to a field as a(n) ____.

Accepted Answer

A)  tuple 
B)  attribute 
C)  key 
D)  relation 
A)  tuple 
B)  attribute 
C)  key 
D)  relation

Question 16

A(n) ____ tests the data in two or more associated fields to ensure that the relationship is logical.

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 17

Figure 10-2 In the database pictured in Figure 10-2, a(n) ____________________ uniquely identifies each field.

Accepted Answer

The answer of   Figure 10-2 In the database...

Question 18

One application that uses multidimensional databases is a data warehouse.

Accepted Answer

A) True 
 B)False

Question 19

DBMSs will process flagged records unless an instruction is issued to ignore them.

Accepted Answer

A) True 
 B)False

Question 20

A(n) ____________________ is a number(s) or character(s) that is appended to or inserted into a primary key field.

Accepted Answer

The answer of A(n) ____________________ is a number(s) or character(s)...

In a(n) ____________________, the DBMS uses the log to undo any changes made to a database during a certain period.

A ____ stores images, audio clips, and/or video clips.

A checkout clerk with ____ privileges to the e-mail addresses in a discount warehouse database could view the addresses but not change them.

Generally, users change records in a file ____.

Most companies realize that information is one of their most valuable assets - because information is used to generate data.

Accurate information ____.

An object-oriented database stores unstructured data less efficiently than a relational database.

Applications best suited for relational databases are those whose data can be organized in a two-dimensional table.

From time to time, users should run a utility program that removes indexed records and reorganizes current records.

In a database, a(n) ____ field is a field that uniquely identifies each record in a file.

A manager would have ____ privileges to member data in a discount warehouse database.

Because a data dictionary contains details about the data in a database, some call it ____________________.

A(n) ____________________, or copy, of the entire database should be made on a regular basis.

A Web database usually resides on a database server.

The developer of a relational database refers to a field as a(n) ____.

A(n) ____ tests the data in two or more associated fields to ensure that the relationship is logical.

Figure 10-2 In the database pictured in Figure 10-2, a(n) ____________________ uniquely identifies each field.

One application that uses multidimensional databases is a data warehouse.

DBMSs will process flagged records unless an instruction is issued to ignore them.

A(n) ____________________ is a number(s) or character(s) that is appended to or inserted into a primary key field.

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

In a(n) ____________________, the DBMS uses the log to undo any changes made to a database during a certain period.

A ____ stores images, audio clips, and/or video clips.

A checkout clerk with ____ privileges to the e-mail addresses in a discount warehouse database could view the addresses but not change them.

Generally, users change records in a file ____.

Most companies realize that information is one of their most valuable assets - because information is used to generate data.

Accurate information ____.

An object-oriented database stores unstructured data less efficiently than a relational database.

Applications best suited for relational databases are those whose data can be organized in a two-dimensional table.

From time to time, users should run a utility program that removes indexed records and reorganizes current records.

In a database, a(n) ____ field is a field that uniquely identifies each record in a file.

A manager would have ____ privileges to member data in a discount warehouse database.

Because a data dictionary contains details about the data in a database, some call it ____________________.

A(n) ____________________, or copy, of the entire database should be made on a regular basis.

A Web database usually resides on a database server.

The developer of a relational database refers to a field as a(n) ____.

A(n) ____ tests the data in two or more associated fields to ensure that the relationship is logical.

Figure 10-2 In the database pictured in Figure 10-2, a(n) ____________________ uniquely identifies each field.

One application that uses multidimensional databases is a data warehouse.

DBMSs will process flagged records unless an instruction is issued to ignore them.

A(n) ____________________ is a number(s) or character(s) that is appended to or inserted into a primary key field.

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