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.

Related MCQs

• 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                      explicit locking is being done at a lower level of the tree, but with only shared-mode locks.
• If a node is locked in an intention mode, explicit locking is done at a lower level of the tree. This is called
• 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.
• Which of the following is a procedure for acquiring the necessary locks for a transaction where all necessary locks are acquired before any are released?
• Assume transaction A holds a shared lock R. If transaction B also requests for a shared lock on R.
• Each array declaration need not give, implicitly or explicitly, the information about
• 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