Match List I with List II

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
Timestamp ordering is deadlock-free; strict 2PL gives cascadeless rollback; in 2PL a running transaction acquires its locks in the first (growing) phase; the lock point is where the transaction holds its final lock.
More Database Management Systems questions
- Consider the schedule S: t1: R2(X), R3(Y); t2: W2(X), W3(Y); t3: R1(Y), R4(X); t4: W1(Y), W4(X); t5: R3(X); t6: W3(X). Choose the correct s…
- Given below are the two statements: Statement I : Any retrieval request that is specified in the basic relational algebra can also be speci…
- Which of the following queries would retrieve the roll number and names of students who have enrolled for all the prerequisite courses of t…
- Given query: select s.rollno from students where s.sex = ALL (select f.sex from professor f where f.empid = s.advisor). Consider the follow…
- Which of the following queries would compute, for each department, the total credits of all the courses offered by the department?
- Which of the following queries would retrieve the dept id and name of all the departments that are such that the total of the credits of al…