Home » MCQs » DBMS MCQs » DBMS Lock-Based Protocol MCQs

What is TRUE about Pre-claiming lock protocol?

12. What is TRUE about Pre-claiming lock protocol?

1. In pre-claiming lock protocols, all items on which locks are needed are analyzed by evaluating the transaction.
2. It requests the DBMS for a lock on all the data items before initiating the transaction.
3. This protocol allows the transaction to begin if all the locks have been granted.
4. All of the above

Answer: D) All of the above

Explanation:

In case of Pre-claiming lock protocol -

1. In pre-claiming lock protocols, all items on which locks are needed are analyzed by evaluating the transaction.
2. It requests the DBMS for a lock on all the data items before initiating the transaction.
3. This protocol allows the transaction to begin if all the locks have been granted.