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
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
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

Related Topics

No tags found

Unique Visitor Count

Total Unique Visitors

Loading......
Question Options

Contributed by: