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

PYQ GATE 2024

Which of the following statements about the Two Phase Locking (2PL) protocol is/are TRUE?

  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 243 students.

Sign up free to check your answer

Sign up free

Explore the full course: Zero To Hero

Loading lesson…