Made-easy-test-series closed

Question

Consider the following schedule involving two transactions:

S1: r1(A); w1(A); w2(B); w3(C); r1(D); w2(D).

S2:r3(A); w4(B); r1(C); r3(D); w3(B); w2(D); r3(A); w1(D); r3(B); r2(C); r1(A).

A) only S1 is followed under 2PL.

B) only s2 is followed under 2PL.

C) both s1 and s2 are allowed under 2PL.

D) neither s1 nor s2 are allowed under 2PL.

Comments

@jatin khachane 1 no idea about that bro :(

---

For the set of transactions to be in 2PL, we need to have 2 phases

phase 1 : locking 

phase 2 : unlocking

for now, conside s() as shared lock and x() as exclusive lock.

in s1 :  X(A);r1(A); w1(A); X(B)w2(B); X(C)w3(C); S(D)r1(D);  *here we cannot gain exclusive lock until lock is released* w2(D).

hence first one is not 2PL.

similarly the next one also.

---

@Utkarsh Joshi

What is difference here between 'followed under' and 'allowed under'