Which lock should be obtained to prevent a concurrent transaction from – McqOptions

MCQOPTIONS

1.	Which lock should be obtained to prevent a concurrent transaction from executing a conflicting read, insert or delete operation on the same key value.
A.	Higher-level lock
B.	Lower-level lock
C.	Read only lock
D.	Read write
Answer» B. Lower-level lock

Discussion

No Comment Found

Related MCQs

IF_____________ARE_NOT_OBTAINED_IN_UNDO_OPERATION_IT_WILL_CAUSE_PROBLEM_IN_UNDO-PHASE.?$
For correct behaviour during recovery, undo and redo operation must b?
Shadow paging has
Immediate database modification technique uses
An operation is said to be __________ if executing it several times in a row gives the same result as executing it once.
To perform logical redo or undo, the database state on disk must be operation ___________ that is, it should not have partial effects of any operation.
Redo operations are performed exclusively using
Which of the following is used for undo operations alone?
Once the lower-level lock is released, the operation cannot be undone by using the old values of updated data items, and must instead be undone by executing a compensating operation; such an operation is called
Which lock should be obtained to prevent a concurrent transaction from executing a conflicting read, insert or delete operation on the same key value.