Question

In two-phase locking (2PL), a transaction must be _______ .

• A. Release all locks before acquiring new ones
• B. Acquire all locks before releasing any
• C. Use only shared locks
• D. Avoid deadlocks by timeouts

Hint:

The two-phase locking protocol ensures serializability and prevents deadlocks by enforcing a strict order in acquiring and releasing locks.

Answer 1

The Correct Option is B

Two-phase locking protocol requires that a transaction must acquire all locks before releasing any. This ensures that the transaction follows the "growing phase" and "shrinking phase," which are essential for preventing deadlocks.