Lock Based Protocols

Question 1
Marks : +2 | -2
Pass Ratio : 33%
A transaction is made to wait until all ________ locks held on the item are released
Compatible
Incompatible
Concurrent
Equivalent
Explanation:
A transaction is made to wait until all compatible locks held on the item are released. This ensures that no other transaction is concurrently accessing the same item.
Question 2
Marks : +2 | -2
Pass Ratio : 33%
State true or false: It is not necessarily desirable for a transaction to unlock a data item immediately after its final access
True
False
Explanation:
It is not necessarily desirable for a transaction to unlock a data item immediately after its final access because serializability may be violated due to this.
Question 3
Marks : +2 | -2
Pass Ratio : 33%
The protocol that indicates when a transaction may lock and unlock each of the data items is called as __________
Locking protocol
Unlocking protocol
Granting protocol
Conflict protocol
Explanation:
The protocol that indicates when a transaction may lock and unlock each of the data items is called as locking protocol. Locking protocols restrict the number of schedules.
Question 4
Marks : +2 | -2
Pass Ratio : 33%
The situation where no transaction can proceed with normal execution is known as ________
Road block
Deadlock
Execution halt
Abortion
Explanation:
The situation where no transaction can proceed with normal execution is known as a deadlock.
Question 5
Marks : +2 | -2
Pass Ratio : 33%
The two phase locking protocol consists which of the following phases?
Growing phase
Shrinking phase
More than one of the mentioned
None of the mentioned
Explanation:
The two phased locking protocol consists of the growing phase and the shrinking phase.
Question 6
Marks : +2 | -2
Pass Ratio : 67%
If a transaction can be granted a lock on an item immediately in spite of the presence of another mode, then the two modes are said to be ________
Concurrent
Equivalent
Compatible
Executable
Explanation:
If a transaction can be granted a lock on an item immediately in spite of the presence of another mode, then the two modes are said to be compatible.
Question 7
Marks : +2 | -2
Pass Ratio : 33%
If a transaction has obtained a __________ lock, it can read but cannot write on the item
Shared mode
Exclusive mode
Read only mode
Write only mode
Explanation:
If a transaction Ti has obtained a shared-mode lock (denoted by S) on item Q, then Ti can read, but cannot write, Q.
Question 8
Marks : +2 | -2
Pass Ratio : 33%
A transaction can proceed only after the concurrency control manager ________ the lock to the transaction
Grants
Requests
Allocates
None of the mentioned
Explanation:
A transaction can proceed only after the concurrency control manager grants the lock to the transaction.
Question 9
Marks : +2 | -2
Pass Ratio : 33%
If a transaction Ti may never make progress, then the transaction is said to be ____________
Deadlocked
Starved
Committed
Rolled back
Explanation:
If a transaction Ti may never make progress, then the transaction is said to be starved.
Question 10
Marks : +2 | -2
Pass Ratio : 33%
If a transaction has obtained a ________ lock, it can both read and write on the item
Shared mode
Exclusive mode
Read only mode
Write only mode
Explanation:
If a transaction has obtained an exclusive mode lock, then it can both read and write on the item on which it in operating.