A(n) _____ phase in a two phase lock is when a transaction releases all locks and cannot obtain a new lock.
A) growing
B) shrinking
C) locking
D) unlocking

Question

Quizplus · Accepted Answer

In a two phase lock, the shrinking phase is when a transaction releases all locks and cannot obtain a new lock. During the shrinking phase, a transaction releases all the locks it acquired during the growing phase and cannot acquire any more locks. This ensures that the transaction does not make any further updates to the database and prepares itself for the commit phase.

A(n) _____ Phase in a Two Phase Lock Is When