Home » MCQs » DBMS MCQs » DBMS Multiple Granularity MCQs

The protocol requires a node to follow which protocol(s) when attempting to lock a node?

14. The protocol requires a node to follow which protocol(s) when attempting to lock a node?

1. The lock-compatibility matrix should be followed for transactions.
2. The first transaction in the tree locks the root.
3. In any mode, the root can be locked.
4. All of the above

Answer: D) All of the above

Explanation:

The protocol requires a node to follow these protocols when attempting to lock a node:

1. The lock-compatibility matrix should be followed for transactions.
2. The first transaction in the tree locks the root.
3. In any mode, the root can be locked.