The hardness level of this Test / Quiz section is high. This section contain Database management system / DBMS / DBMS Locking Protocol 2PL Multiple Choice Questions and Answers MCQ that has been already asked in some of the previous competitive exam like System Analyst / System Administrator / IBPS IT OFFICER / BSNL JE etc. we strongly recommend you to check the Question pattern and go through it once at-least.
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