If a node is locked in an intention mode, explicit locking is done at – McqOptions

MCQOPTIONS

1.	If a node is locked in an intention mode, explicit locking is done at a lower level of the tree. This is called
A.	Intention lock modes
B.	Explicit lock
C.	Implicit lock
D.	Exclusive lock
Answer» B. Explicit lock

Discussion

No Comment Found

Related MCQs

THE____________REQUIRES_THAT_EACH_TRANSACTION_TI_EXECUTES_IN_TWO_OR_THREE_DIFFERENT_PHASES_IN_ITS_LIFETIME,_DEPENDING_ON_WHETHER_IT_IS_A_READ-ONLY_OR_AN_UPDATE_TRANSACTION.?$
This_validation_scheme_is_called_the___________scheme_since_transactions_execute_optimistically,_assuming_they_will_be_able_to_finish_execution_and_validate_at_the_end.$
The _____________ ensures that any conflicting read and write operations are executed in timestamp order?
____________ denotes the largest timestamp of any transaction that executed write(Q) successfully.
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.
If a node is locked in ____________ then explicit locking is being done at a lower level, with exclusive-mode or shared-mode locks.
If a node is locked in __________ explicit locking is being done at a lower level of the tree, but with only shared-mode locks.
If a node is locked in an intention mode, explicit locking is done at a lower level of the tree. This is called
In a database the file is contained in ________
In a granularity hierarchy the highest level represents the