Home » MCQs » DBMS MCQs » DBMS Multiple Granularity MCQs

In a ___, some nodes are locked in exclusive mode by the same transaction while others are locked in shared mode

12. In a ___, some nodes are locked in exclusive mode by the same transaction while others are locked in shared mode.

1. IS Lock
2. IX Lock
3. SIX Lock
4. None

Answer: C) SIX Lock

Explanation:

In a SIX lock, some nodes are locked in exclusive mode by the same transaction while others are locked in shared mode.