Which of the following statements about the Two Phase Locking (2PL) protocol…

GATE · 2024 · CS · Set 2 · Computer Science & IT

1. A.

   2PL permits only serializable schedules

2. B.

   With 2PL, a transaction always locks the data item being read or written just before every operation and always releases the lock just after the operation

3. C.

   With 2PL, once a lock is released on any data item inside a transaction, no more locks on any data item can be obtained inside that transaction

4. D.

   A deadlock is possible with 2PL

Attempted by 204 students.