Given below are two statements: Which of the following concurrency control…

2023

Given below are two statements:

Which of the following concurrency control protocol ensures both conflict serializability and freedom from deadlock?

Statement I: Two phase locking

Statement II: Timestamp ordering

In the light of the above statements, choose the most appropriate answer from the options given below:

  1. A.

    Both Statement I and Statement II are correct

  2. B.

    Both Statement I and Statement II are incorrect

  3. C.

    Statement I is correct but Statement II is incorrect

  4. D.

    Statement I is incorrect but Statement II is correct

Attempted by 169 students.

Show answer & explanation

Correct answer: D

Statement I is incorrect but Statement II is correct

A video solution is available for this question — log in and enroll to watch it.

Explore the full course: Mppsc Assistant Professor