Strict 2pl

Question

 

Comments

It should be strict .

---

Sir what should be the answer According to u.

Sir please provide the reference for Strict 2pl to be strict

---

I am refrencing made easy note book and also read in book also.

Answer 1

• If a schudle is in strict 2pl then it must be

1. All exclusive modes taken by a transaction must be held untill  transaction commits.
2. It should be conflict serializable
3. It should be strict .
4. It is in growing phase and shrinking phase .

Option b is right

Comments

Sir when a schdule is said to be strict it means the every write operation will be done of T1 first completely then write of T2 will be done, Read can come in any order ??

As here R1(A) comes then R2(B).

I thought in strict first all the operation i.e. reads as well as writes will be done then T2 will be start to execute.

Is it sir?

---

Strict ---->If a transaction T1 writes data item "A" and some other transaction T2 R(A)/W(A) must delay untill T1 commit.

 

---

in the option b .

T2 did not release the share lock on data A  then how can T1 can take exclusive lock on data A