In crabbing protocol locking

Related MCQs

• In crabbing protocol, the lock obtained on the root node is in                    mode.
• 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 two-phase locking protocol.
• Database locking concept is used to solve the problem of
• Database locking concept is used to solve the problem of
• Problems occurs if we don’t implement a proper locking strategy
• If a node is locked in an intention mode, explicit locking is done at a lower level of the tree. This is called
• If a node is locked in                      explicit locking is being done at a lower level of the tree, but with only shared-mode locks.
• If a node is locked in                          then explicit locking is being done at a lower level, with exclusive-mode or shared-mode locks.
• 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.