Teaching HPSC Lecturer (Technical) Mock Test 2024 DBMS Concurrency Control Two Phase Locking Protocol
2PL guaranteed serializability, but it does not prevent deadlocks. 2PL has two phases: growing and shrinking. Which of the following are used to govern the 2PL protocol?
1
Two transactions cannot have conflicting locks
2
No unlock operation can precede a lock operation in the same transaction
3
No data are affected until all locks are obtained i.e. until the transaction is in its locked point.
4
All of these
5
Question Not Attempted