Testbook Test Series: Databases - Transactions

Question

Let a schedule be strict recoverable schedule then it will suffer from which problem?

 

1.ww

2.rw

3.wr

4.lost update

Comments

Option 3..?? Can any one explain strict recoverable ?? Is it related to strict 2PL??

---

https://gateoverflow.in/240430/%23self-doubt?show=240584

check it 

---

option 2 ???

---

yes

Answer 1

Since, strict recoverable schedule is free from ww, wr and lost update cascading rollback and on the other hand, irecoverable schedule suffers from rw problem.

So, the answer should be none of this as the question is asking about the "recoverable schedule" only.

Comments

https://gateoverflow.in/240430/%23self-doubt?show=240584