Teaching UGC NET Mock Test Series 2025 (Paper 1 & 2) DBMS Concurrency Control Two Phase Locking Protocol
2PL guarantees serializability, but it does not prevent deadlocks. 2PL has two phases: growing and shrinking. which of the following rules are used to govern the 2PL protocol?
A. Two transactions cannot have conflicting locks
B. No unlock operation can precede a lock operation in the same direction
C. No data are affected until all locks are obtained i.e. until the transaction is in its locked point
1
A and B only
2
C only
3
A and C only
4
A, B and C