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.

Related MCQs

• In a                      index, an index entry appears for only some of the search-key values.
• In a __________ index, an index entry appears for only some of the search-key values.
• In                                index instead of storing all the columns for a record together, each column is stored separately with all other rows in an index.
• In concurrency control policy the lock is obtained on
• A concurrency-control policy such as this one leads to              performance since it forces transactions to wait for preceding transactions to finish before they can start.
• Why do we need concurrency control on B+ trees ?
• How many techniques are available to control concurrency on B+ trees?
• Concurrency control is important for which of the following reasons?
• Incase the indices values are larger, index is created for these values of the index. This is called
• In a                clustering index, the index record contains the search-key value and a pointer to the first data record with that search-key value and the rest of the records will be in the sequential pointers.