Question 1

​In order to accomplish serial processing of updates,many DBMSs use ____.

Accepted Answer

A)  ​backups 
B)  ​locking 
C)  ​encryption 
D)  ​biometrics 
A)  ​backups 
B)  ​locking 
C)  ​encryption 
D)  ​biometrics

Question 2

Additional storage and memory space are not required to store timestamp values.
​

Accepted Answer

A) True 
 B)False

Question 3

The DBMS must successfully complete all transaction steps or none at all for the database to remain in a correct state.​

Accepted Answer

A) True 
 B)False

Question 4

Explain how a DBMS breaks a deadlock.​

Accepted Answer

To break the deadlock,the DBMS chooses o

Question 5

In two-phase locking,the second phase is the shrinking phase.​

Accepted Answer

A) True 
 B)False

Question 6

A(n)____________________ is a set of steps completed by a DBMS to accomplish a single user task.​

Accepted Answer

The answer of A(n)____________________ is a set of steps completed...

Question 7

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

Accepted Answer

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

Question 8

____ is the process of returning the database to a state that is known to be correct from a state known to be incorrect.​

Accepted Answer

A)  ​Recovery 
B)  ​Concurrent update 
C)  ​Encryption 
D)  ​Batch processing 
A)  ​Recovery 
B)  ​Concurrent update 
C)  ​Encryption 
D)  ​Batch processing

Question 9

To break a deadlock,the DBMS chooses one deadlocked user to be the ____.​

Accepted Answer

A)  ​log 
B)  ​victim 
C)  ​workgroup 
D)  ​backup 
A)  ​log 
B)  ​victim 
C)  ​workgroup 
D)  ​backup

Question 10

The most common security features used by DBMSs are batch processing,journaling,and timestamping.

Accepted Answer

A) True 
 B)False

In order to accomplish serial processing of updates,many DBMSs use ____.

Additional storage and memory space are not required to store timestamp values.

The DBMS must successfully complete all transaction steps or none at all for the database to remain in a correct state.

Explain how a DBMS breaks a deadlock.

In two-phase locking,the second phase is the shrinking phase.

A(n)____________________ is a set of steps completed by a DBMS to accomplish a single user task.

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

____ is the process of returning the database to a state that is known to be correct from a state known to be incorrect.

To break a deadlock,the DBMS chooses one deadlocked user to be the ____.

The most common security features used by DBMSs are batch processing,journaling,and timestamping.

Introduction to Database Management

The Relational : Introduction, QBE, and Relational Algebra

The Relational : SQL

The Relational : Advanced Topics

Database Design 1: Normalization

Database Design 2: Design Method

Database Administration

Database Management Approaches

Filters

Exam 7: Dbms Functions

​In order to accomplish serial processing of updates,many DBMSs use ____.

Additional storage and memory space are not required to store timestamp values. ​

The DBMS must successfully complete all transaction steps or none at all for the database to remain in a correct state.​

Explain how a DBMS breaks a deadlock.​

In two-phase locking,the second phase is the shrinking phase.​

A(n)____________________ is a set of steps completed by a DBMS to accomplish a single user task.​

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

____ is the process of returning the database to a state that is known to be correct from a state known to be incorrect.​

To break a deadlock,the DBMS chooses one deadlocked user to be the ____.​

The most common security features used by DBMSs are batch processing,journaling,and timestamping.

Introduction to Database Management

The Relational : Introduction, QBE, and Relational Algebra

The Relational : SQL

The Relational : Advanced Topics

Database Design 1: Normalization

Database Design 2: Design Method

Database Administration

Database Management Approaches

Filters

In order to accomplish serial processing of updates,many DBMSs use ____.

Additional storage and memory space are not required to store timestamp values.

The DBMS must successfully complete all transaction steps or none at all for the database to remain in a correct state.

Explain how a DBMS breaks a deadlock.

In two-phase locking,the second phase is the shrinking phase.

A(n)____________________ is a set of steps completed by a DBMS to accomplish a single user task.

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

____ is the process of returning the database to a state that is known to be correct from a state known to be incorrect.

To break a deadlock,the DBMS chooses one deadlocked user to be the ____.