Lock Based Protocols MCQ (Multiple Choice Questions) PDF Download

A two-phase locking protocol variant that requires that all locks be held until the transaction commit is called

1. Lock-point two-phase locking protocol
2. Deadlock two-phase locking protocol
3. Strict two-phase locking protocol
4. Rigorous two-phase locking protocol

Cascading rollbacks can be avoided by

1. Strict two-phase locking protocol
2. Rigorous two-phase locking protocol
3. Deadlock two-phase locking protocol
4. Lock-point two-phase locking protocol

A process known to receive messages from transactions and in response send messages, is

1. Recovery manager
2. Lock manager
3. Process manager
4. Database administrator

The two modes of locking a data item, are termed as 'shared' and

1. Composite
2. Compatible
3. Exclusive
4. Linear

Two-phase locking does not ensure freedom from

1. Obtain locks
2. Release locks
3. New locks
4. Deadlocks