GATE CS 2024 (Afternoon) — Question 27

Database Management Systems (DBMS)Transactions, Concurrency Control, Conflict SerializabilityMSQ1 markMedium

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.
Practise the full 2024-AN paper
Challenge a friend: WhatsApp Telegram
From RENYXERAPractise this subject in the exam simulatorTimed, GATE-style tests with analytics that find your weak topics.
Practise more on Transactions, Concurrency Control, Conflict SerializabilityTimed, in the real exam interface · free to start

A GATE question every morning

One real past-paper question every morning for your branch, answer hidden until you tap. Free on Telegram.

Join
Stuck? Ask in the student group