Which of the following concurrency control protocol ensures both conflict…
2017
Which of the following concurrency control protocol ensures both conflict serializability and free from deadlock?
- A.
Time stamp ordering
- B.
2 Phase locking
- C.
Both (a) and (b)
- D.
None of the above
Attempted by 290 students.
Show answer & explanation
Correct answer: A
Time Stamp Ordering (TSO) ensures conflict serializability by assigning timestamps to transactions and ordering their execution. Unlike Two Phase Locking, TSO does not use locks, which eliminates the possibility of deadlock cycles. Therefore, it satisfies both conflict serializability and freedom from deadlock.
A video solution is available for this question — log in and enroll to watch it.