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?
Answer: A. Time stamp ordering — Time Stamp Ordering (TSO) ensures conflict serializability by assigning timestamps to transactions and ordering their execution. Unlike Two Phase Locking, TSO…
- A.
Time stamp ordering
- B.
2 Phase locking
- C.
Both (a) and (b)
- D.
None of the above
Attempted by 602 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.
Explore the full course: Iocl Engineers Officers Grade A Paper 2