In a Rigorous 2 phase protocol

In a Rigorous 2 phase protocol

Answer: C. All locks held by the transaction are released after the transaction is committedIn a Rigorous 2-phase protocol, transactions follow strict lock acquisition and release rules to ensure serializability. Step 1: Locks are acquired during the…

  1. A.

    All shared locks held by the transaction are related after the transaction is committed

  2. B.

    All exclusive locks held by the transaction are released after the transaction is committed

  3. C.

    All locks held by the transaction are released after the transaction is committed

  4. D.

    All locks held by the transaction are released before the transaction is committed

Attempted by 183 students.

Show answer & explanation

Correct answer: C

In a Rigorous 2-phase protocol, transactions follow strict lock acquisition and release rules to ensure serializability.

Step 1: Locks are acquired during the growing phase and released during the shrinking phase.

Step 2: Shared locks (for read operations) are released after the transaction completes, not before.

Step 3: Exclusive locks (for write operations) are held until the transaction commits and are released after commit.

Step 4: In a Rigorous 2-phase protocol, all locks—both shared and exclusive—are released only after the transaction is committed.

Step 5: Locks are not released before commit, as this would compromise consistency and violate the protocol.

Explore the full course: Database Management System

Loading lesson…