How many techniques are available to control concurrency on B+ trees?

Related MCQs

• Why do we need concurrency control on B+ trees ?
• 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.
• 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.
• Concurrency control is important for which of the following reasons?
• A table on the many side of a one to many or many to many relationship must:
• A relation project guidance Project Guidance(professor, project, student no. st-name, dept) A professor can give many projects to many students A project will have many students A project may be guided by many professors The 4 NF relation corresponding to this are
• Which are types of recovery control techniques:
• The three basic techniques to control deadlocks are: deadlock ____, deadlock detection, and deadlock avoidance.
• Which prefixes are available to Oracle triggers?