0 of 5 questions completed
DBMS Locking Protocol 2PL MCQ Based Online Test
You have already completed the quiz before. Hence you can not start it again.
Quiz is loading...
You must sign in or sign up to start the quiz.
You have to finish following quiz, to start this quiz:
0 of 5 questions answered correctly
Time has elapsed
You have reached 0 of 0 points, (0)
Consider the following tree and locking sequences:
I. Lock-X(A), Lock-X(B), Lock-X(D), unlock(D), lock-X(F), unlock(F),
unlock (B), unlock (A)
II. Lock-X(A), lock-X(E), lock-X(H), unlock (H), unlock(E), unlock (A)
III. Lock-X(B), lock-X(F), lock-X(E), unlock (F), unlock(E), unlock (B)
Which of the above is (are) the valid locking sequence(s) for tree-based
The number of different locks used in multi-version two phase locking,
is equal toCorrect
Locks held for a short duration are termed as _______Correct
Which of the following is a false statement?Correct
The write ahead protocol simply means that _________Correct