Problems occurs if we don’t implement a proper locking strategy

Related MCQs

• Database locking concept is used to solve the problem of
• Database locking concept is used to solve the problem of
• 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.
• 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.
• Although the ____ locking approach improves the availability of data, its management requires high overhead.
• The concept of locking can be used to solve the problem of