Match List I with List II
| List I | List II |
|---|---|
| A. Timestamp protocol | I. As long as the transaction is running, it obtains the required locks in the first phase. |
| B. Strict two-phase locking protocol | II. Indicates the final lock of the schedule. |
| C. Two-phase locking | III. Ensures freedom from deadlock. |
| D. Lock point in two-phase locking protocol | IV. Ensures cascadeless rollback. |
Pick an option to check yourself, or open the answer below.
Show answer & explanation
Correct answer: B. A-III, B-IV, C-I, D-II
Explanation
The timestamp protocol is deadlock-free (III). Strict 2PL ensures cascadeless rollback (IV). In 2PL a running transaction acquires its locks in the first (growing) phase (I). The lock point is the transaction's final lock acquisition (II).More Database Management Systems questions
- Consider the schedule S (operations at successive timestamps t1–t6): t1: T2 R(X), T3 R(Y) t2: T2 W(X), T3 W(Y) t3: T1 R(Y), T4 R(X) t4: T1…
- Statement I: Any retrieval request that can be specified in basic relational algebra can also be specified in relational calculus. Statemen…
- Which of the following queries would retrieve the roll numbers and names of students who have enrolled in ALL the prerequisite courses of c…
- Given the query SELECT s.rollno FROM student s WHERE s.sex = ALL (SELECT f.sex FROM professor f WHERE f.empid = s.advisor); which retrieves…
- Which of the following queries computes, for each department, the total credits of all the courses offered by the department?
- Which of the following queries retrieves the deptid and name of all departments whose total credits of offered courses is strictly greater…