Which of the following statements is wrong?
2007
Which of the following statements is wrong?
- A.
2-phase Locking Protocols suffer from deadlocks
- B.
Time-Stamp Protocols suffer from more aborts
- C.
Time-Stamp Protocols suffer from cascading roll back whereas 2-Phase locking Protocol do not
- D.
None of these
Attempted by 90 students.
Show answer & explanation
Correct answer: C
The question asks to identify the incorrect statement regarding database concurrency control protocols.
Option A states that 2PL suffers from deadlocks, which is factually true.
Option C claims TSO suffers from cascading rollback while 2PL does not. This is false since basic 2PL allows it and TSO avoids it via aborts.
Therefore, the correct selection is Option 2, as Statement C is the false claim.
A video solution is available for this question — log in and enroll to watch it.