Multiple Granularity Locking Multiple Choice Questions with Answers – PDF Download

MCQ 1: The multiple-granularity locking protocol uses multiple lock modes to ensure:

1. Sequence
2. Serializability
3. Deadlocks
4. Locking

MCQ 2: A set of rules applied over a transaction that may lock and unlock each of the data items in the database, is known to be:

1. Unlocking protocol
2. Locking protocol
3. Deadlock protocol
4. Validation protocol

MCQ 3: A protocol that permits a transaction to lock a new data item only if it has not yet unlocked any data item, is called:

1. Two-phase unlocking protocol
2. One-phase locking protocol
3. Two-phase locking protocol
4. One-phase unlocking protocol

MCQ 4: Exclusive locks are released at the end of the transaction to ensure:

1. Recoverability
2. Cascadelessness
3. Key-value locking
4. Both A and B

MCQ 5: Various concurrency-control schemes are used to ensure:

1. Serializability
2. Deadlock prevention
3. Timeouts
4. Locking states