Multiple Granularity Locking Multiple Choice Questions with Answers – PDF Download

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

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

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

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

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

Various concurrency-control schemes are used to ensure

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