Computer Sciences > GATE 2024 Set-2 > DBMS
Which of the following statements about the Two Phase Locking (2PL) protocol is/are TRUE?
A
2PL permits only serializable schedules
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
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
D
A deadlock is possible with 2PL

Correct : c,d

Similar Questions

Once the DBMS informs the user that a transaction has been successfully completed, its effect should persist even if the system crashes before all its changes a...
#907 MCQ
Which of the following file organizations is/are I/O efficient for the scan operation in DBMS?
#914 MSQ
A palindrome is a word that reads the same forwards and backwards. In a game of words, a player has the following two plates painted with letters. From...
#1 MCQ

Related Topics

No tags found

Unique Visitor Count

Total Unique Visitors

Loading......

Question Options

Contributed by: