Question 1

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

Accepted Answer

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

The answer of Explain how a DBMS breaks a deadlock.​...

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

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

Question 10

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

Accepted Answer

A) True 
 B)False

Exam 7: Dbms Functions

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