Multiple Choice
In the two-phase locking protocol:
A) A transaction only acquires a lock after the previously acquired lock has been released
B) A transaction acquires locks as needed. After it starts releasing locks, it does not acquire new locks
C) A transaction acquires all needed locks at once, then releases them after completion
D) The transaction locks the full database, then releases the locks
Correct Answer:
Verified
Correct Answer:
Verified
Q30: A(n)_ is also known as a dirty
Q31: The serializable isolation level is not as
Q32: When the recovery manager performs a(n)_ operation
Q33: In designing a hierarchical form,the best choice
Q34: Name three types of inconsistent retrievals: _
Q36: The degree to which a transaction is
Q37: One of the tools used by the
Q38: The recovery manager uses _ to control
Q39: Which of the following is not considered
Q40: When the recovery manager performs a(n)_ operation