If a node is locked in an intention mode, explicit locking is done at a lower level of the tree. This is called

Related MCQs

• 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.
• 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.
• In B+ tree the node which points to another node 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.
• 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
• In crabbing protocol locking
• Instead of locking index leaf nodes in a two-phase manner, some index concurrency- control schemes use                        on individual key values, allowing other key values to be inserted or deleted from the same leaf.