Which Of The Following Is Included In The Operational Mechanism #498
Which of the following is included in the operational mechanism of the index locking protocol?
This multiple choice question (MCQ) is related to the book/course gs gs114 Relational Database Management System. It can also be found in gs gs114 Concurrency Control - Insert, Delete Operations and Predicate Reads - Quiz No.1.
Which of the following is included in the operational mechanism of the index locking protocol?
Every transaction must have at least one index
A transaction that performs a lookup must acquire a shared lock on all the index leaf nodes that it accesses
The rule of the two phase locking mechanism must be observed
All of the mentioned