Instead of locking index leaf nodes in a two-phase manner, some index – McqOptions

MCQOPTIONS

1.	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.
A.	B+ tree locking
B.	Link level locking
C.	Key-value locking
D.	Next value locking
Answer» D. Next value locking

Discussion

No Comment Found

Related MCQs

In timestamp ordering protocol, suppose that the transaction Ti issues read(Q) and TS(Ti)
In timestamp ordering protocol, suppose that the transaction Ti issues write(Q) and TS(Ti)
The type of constraints that specifies the uniqueness of data stored in the database are considered as
The property of DBMS which ensures the execution of all the operations in transaction or none of the operation is executed is classified as
The control feature in database management system which ensures the accuracy of data updated by multiple users is classified as
The property of DBMS which ensures whether the hundreds of applications are executed, each transaction must be executed in isolation is classified as
In crabbing protocol the the lock obtained on the root node is in _________ mode.
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.
The extent of the database resource that is included with each lock is called the level of
Evaluate the CREATE TABLE statement:CREATE TABLE products(product_id NUMBER(6) CONSTRAINT prod_id_pk PRIMARY KEY, product_name VARCHAR2(15));Which statement is true regarding the PROD_ID_PK constraint?