If a node is locked in ______________ the subtree rooted by that node – McqOptions

MCQOPTIONS

1.	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.
A.	Intention lock modes
B.	shared and intention-exclusive (SIX) mode
C.	Intention-exclusive (IX) mode
D.	Intention-shared (IS) mode
Answer» C. Intention-exclusive (IX) mode

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