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.

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.
• In crabbing protocol, the lock obtained on the root node is in                    mode.
• If a node is locked in                          then explicit locking is being done at a lower level, with exclusive-mode or shared-mode locks.
• 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?
• If a node is locked in                      explicit locking is being done at a lower level of the tree, but with only shared-mode locks.
• In crabbing protocol locking
• Which of the syntax is correct for insert statement? i) insert into <table_name> values <list of values> ii) insert into <table_name> (column list) values <list of values>
• 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.
• State true or false i) A candidate key is a minimal super key. ii) A candidate key can also refer to as surrogate key.
• If an attribute of a composite key is dependent on an attribute of the other composite key, normalization called ................ is needed.