MadeEasy Full Length Test 2018: Databases - Transactions

Question

Q50. how many statements is true

1. unrepeatable read also know as read write conflict
2. Strict 2PL may have read write conflict 

---

1st one given as true now my doubt is we know that read write conflict that is https://www.revolvy.com/page/Read%E2%80%93write-conflict and we also know unrepeatable read https://www.youtube.com/watch?v=mLNfpqybSZM .

how we can call unrepeatable read as read write conflict

---

2nd one given as false but i think it is true

Comments

Any transaction written in 2PL format will be conflict serializable. because it is conflict serializable we do not have read-write conflict.

and yes unrepeatable read is also known as read write problem/conflict.

Answer 1

1.TRUE,The unrepeatable problem occurs when two or more read operations of the same transaction read different values of the same variable.

2.FALSE,Strict 2PL is recoverable + conflict serializable