Which of the following statements is/are true? I. Strict 2Pl ensures strict…
Which of the following statements is/are true?
I. Strict 2Pl ensures strict schedules
II. Basic 2PL allows cascading aborts
Answer: C. Both I & II — Statement I: Strict 2PL ensures strict schedules. In strict 2PL, exclusive locks are held until the transaction commits. This prevents any transaction from…
- A.
Only I
- B.
Only II
- C.
Both I & II
- D.
None of the above
Attempted by 182 students.
Show answer & explanation
Correct answer: C
Statement I: Strict 2PL ensures strict schedules.
In strict 2PL, exclusive locks are held until the transaction commits.
This prevents any transaction from reading or writing data modified by an uncommitted transaction.
Such behavior ensures that schedules are strict, so statement I is correct.
Statement II: Basic 2PL allows cascading aborts.
In basic 2PL, locks can be released before the transaction commits.
If a transaction reads data after another transaction unlocks it, and the first transaction aborts, the second must also abort.
This chain reaction leads to cascading aborts, so statement II is correct.