Question 1

Timestamping avoids the need to lock rows in the database and eliminates the processing time needed to apply and release locks and to detect and resolve deadlocks.

Accepted Answer

A) True 
 B)False

Question 2

Explain how a database is updated using batch processing.

Accepted Answer

When users need to update the database,

Question 3

What technique is used to identify the person who is attempting to access the DBMS?

Accepted Answer

A)  encryption 
B)  authentication 
C)  authorization 
D)  viewing 
A)  encryption 
B)  authentication 
C)  authorization 
D)  viewing

Question 4

____________________ involves maintaining a log of all updates in the database.

Accepted Answer

The answer of ____________________ involves maintaining a log of all...

Question 5

____________________ integrity constraints consist of primary key constraints and foreign key constraints.

Accepted Answer

The answer of ____________________ integrity constraints consist of primary key...

Question 6

Which of the following is a federal law that sets a national standard to protect an individual's medical records and other personal health information?

Accepted Answer

A)  FCRA 
B)  HIPAA 
C)  FERPA 
D)  IDEA 
A)  FCRA 
B)  HIPAA 
C)  FERPA 
D)  IDEA

Question 7

Encryption converts the data in a database to a format that is indecipherable to unauthorized users who attempt to bypass the DBMS.

Accepted Answer

A) True 
 B)False

Question 8

When a DBMS uses journaling, the update log is part of the same file in which the database is stored.

Accepted Answer

A) True 
 B)False

Question 9

In two-phase locking, the second phase is where the DBMS releases all locks and acquires no new locks.

Accepted Answer

A) True 
 B)False

Question 10

_________________________ allows users at different sites to use and modify copies of a database and then share their changes with the other users.

Accepted Answer

The answer of _________________________ allows users at different sites to...

Question 11

Which of the following is an authentication method in which information used to identify a user is stored on a plastic card?

Accepted Answer

A)  biometrics 
B)  sign-in 
C)  smart card 
D)  password 
A)  biometrics 
B)  sign-in 
C)  smart card 
D)  password

Question 12

____________________ is the prevention of unauthorized access, either intentional or accidental.

Accepted Answer

The answer of ____________________ is the prevention of unauthorized access,...

Question 13

Which process returns the database to a state that is known to be correct?

Accepted Answer

A)  recovery 
B)  concurrent update 
C)  encryption 
D)  batch processing 
A)  recovery 
B)  concurrent update 
C)  encryption 
D)  batch processing

Question 14

In Microsoft Access, what do you need to decrypt an encrypted database?

Accepted Answer

A)  128-bit decryption software 
B)  a password 
C)  an administrator account 
D)  backup software 
A)  128-bit decryption software 
B)  a password 
C)  an administrator account 
D)  backup software

Question 15

Which type of data integrity constraint states that the value entered for any field should be consistent with the data type for that field?

Accepted Answer

A)  data type 
B)  legal value 
C)  format 
D)  secondary 
A)  data type 
B)  legal value 
C)  format 
D)  secondary

Question 16

A DBMS provides a number of ____________________ services that assist in the general maintenance of the database.

Accepted Answer

The answer of A DBMS provides a number of ____________________...

Question 17

What occurs when two or more users are waiting for the other user to release a lock before their transaction can proceed?

Accepted Answer

A)  commit 
B)  timestamp 
C)  deadlock 
D)  transaction 
A)  commit 
B)  timestamp 
C)  deadlock 
D)  transaction

Question 18

What is data replication? Describe how replication can lead to more efficient database processing.

Accepted Answer

A DBMS must manage multiple copies of th

Question 19

Which property of a DBMS lets you change the database structure without requiring you to change the programs that access the database?

Accepted Answer

A)  field independence 
B)  data integrity constraints 
C)  key integrity constraints 
D)  data independence 
A)  field independence 
B)  data integrity constraints 
C)  key integrity constraints 
D)  data independence

Question 20

What does a DBMS do to break a deadlock?

Accepted Answer

A)  rolls back all transactions involved in the deadlock 
B)  chooses one deadlocked user to be the victim 
C)  closes the database and restores from the last backup 
D)  erases the records involved in the deadlock and reschedules the transactions 
A)  rolls back all transactions involved in the deadlock 
B)  chooses one deadlocked user to be the victim 
C)  closes the database and restores from the last backup 
D)  erases the records involved in the deadlock and reschedules the transactions

Timestamping avoids the need to lock rows in the database and eliminates the processing time needed to apply and release locks and to detect and resolve deadlocks.

Explain how a database is updated using batch processing.

What technique is used to identify the person who is attempting to access the DBMS?

____________________ involves maintaining a log of all updates in the database.

____________________ integrity constraints consist of primary key constraints and foreign key constraints.

Which of the following is a federal law that sets a national standard to protect an individual's medical records and other personal health information?

Encryption converts the data in a database to a format that is indecipherable to unauthorized users who attempt to bypass the DBMS.

When a DBMS uses journaling, the update log is part of the same file in which the database is stored.

In two-phase locking, the second phase is where the DBMS releases all locks and acquires no new locks.

_________________________ allows users at different sites to use and modify copies of a database and then share their changes with the other users.

Which of the following is an authentication method in which information used to identify a user is stored on a plastic card?

____________________ is the prevention of unauthorized access, either intentional or accidental.

Which process returns the database to a state that is known to be correct?

In Microsoft Access, what do you need to decrypt an encrypted database?

Which type of data integrity constraint states that the value entered for any field should be consistent with the data type for that field?

A DBMS provides a number of ____________________ services that assist in the general maintenance of the database.

What occurs when two or more users are waiting for the other user to release a lock before their transaction can proceed?

What is data replication? Describe how replication can lead to more efficient database processing.

Which property of a DBMS lets you change the database structure without requiring you to change the programs that access the database?

What does a DBMS do to break a deadlock?

Introduction to Database Management

The Relational Model 1: Introduction, QBE, and Relational Algebra

The Relational Model 2: SQL

The Relational Model 3: Advanced Topics

Database Design 1: Normalization

Database Design 2: Design Method

Database Administration

Database Management Approaches

Filters

Exam 7: Dbms Functions

Timestamping avoids the need to lock rows in the database and eliminates the processing time needed to apply and release locks and to detect and resolve deadlocks.

Explain how a database is updated using batch processing.

What technique is used to identify the person who is attempting to access the DBMS?

____________________ involves maintaining a log of all updates in the database.

____________________ integrity constraints consist of primary key constraints and foreign key constraints.

Which of the following is a federal law that sets a national standard to protect an individual's medical records and other personal health information?

Encryption converts the data in a database to a format that is indecipherable to unauthorized users who attempt to bypass the DBMS.

When a DBMS uses journaling, the update log is part of the same file in which the database is stored.

In two-phase locking, the second phase is where the DBMS releases all locks and acquires no new locks.

_________________________ allows users at different sites to use and modify copies of a database and then share their changes with the other users.

Which of the following is an authentication method in which information used to identify a user is stored on a plastic card?

____________________ is the prevention of unauthorized access, either intentional or accidental.

Which process returns the database to a state that is known to be correct?

In Microsoft Access, what do you need to decrypt an encrypted database?

Which type of data integrity constraint states that the value entered for any field should be consistent with the data type for that field?

A DBMS provides a number of ____________________ services that assist in the general maintenance of the database.

What occurs when two or more users are waiting for the other user to release a lock before their transaction can proceed?

What is data replication? Describe how replication can lead to more efficient database processing.

Which property of a DBMS lets you change the database structure without requiring you to change the programs that access the database?

What does a DBMS do to break a deadlock?

Introduction to Database Management

The Relational Model 1: Introduction, QBE, and Relational Algebra

The Relational Model 2: SQL

The Relational Model 3: Advanced Topics

Database Design 1: Normalization

Database Design 2: Design Method

Database Administration

Database Management Approaches

Filters