Question

Which of the following protocol is the lock based mechanism for concurrency control?

• A. Two Phase lock protocol
• B. Timestamp based protocol
• C. Validation based protocol
• D. Time lock protocol

Hint:

Two-Phase Locking is the standard method for ensuring serializability in databases.

Answer 1

The Correct Option is A

Lock-based concurrency control uses locks to manage access to the database.
Two-Phase Locking (2PL) protocol ensures serializability by dividing the transaction into two phases: growing (acquiring locks) and shrinking (releasing locks).