In crabbing protocol, the lock obtained on the root node is in                    mode.

Related MCQs

• If needed to split a node or coalesce it with its siblings, or redistribute key values between siblings, the crabbing protocol locks the parent of the node in                           mode.
• In crabbing protocol locking
• If a node is locked in                              the subtree rooted by that node is locked explicitly in shared mode, and that explicit locking is being done at a lower level with exclusive-mode locks.
• The situation where the lock waits only for a specified amount of time for another lock to be released is
• A(n) ____ lock exists when concurrent transactions are granted Read access on the basis of a common lock.
• In a ____ lock, the DBMS will lock an entire disk page.
• Assume transaction A holds a shared lock R. If transaction B also requests for a shared lock on R.
• If a node is locked in                          then explicit locking is being done at a lower level, with exclusive-mode or shared-mode locks.
• In concurrency control policy the lock is obtained on
• Which lock should be obtained to prevent a concurrent transaction from executing a conflicting read, insert or delete operation on the same key value.