Multiple Granularity Locking Multiple Choice Questions (MCQ) PDF Download

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

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

MCQ 1: 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 2: 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 3: 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 4: Various concurrency-control schemes are used to ensure

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