Register

How to check whether a schedule is in strict 2pl or not?

728 views

1 Answer

0 votes
0 votes

Strict 2PL: Only EXCLUSIVE locks are released/unlocked after performing a commit action.

Rigorous 2PL: Both SHARED and EXCLUSIVE locks are released/unlocked after performing a commit action.

Now, consider following example:

Hope this solves your doubt!

User Avatar
Voting & Accepting an answer helps improve the community
← PreviousNext →
← Previous in categoryNext in category →

Related questions

3 votes
3 votes
2 answers
1
reena_kandari asked Jul 22, 2017
7,650 views
How to check if a schedule is 2PL or not?
How to check if a schedule is allowed in 2PL or not? S1:R2(A)W1(B)W1(C)R3(B)R2(B)R1(A)R2(C)W3(A) S2:W2(A)W1(A)W3(A)W2(B)W1(B)W3(B)
How to check if a schedule is allowed in 2PL or not?S1:R2(A)W1(B)W1(C)R3(B)R2(B)R1(A)R2(C)W3(A)S2:W2(A)W1(A)W3(A)W2(B)W1(B)W3(B)
User Avatar
2 votes
2 votes
1 answer
3
Kapil asked Sep 29, 2016
976 views
Check whether the given schedule is conflict serializable or not ?
Check whether the given schedule is conflict serializable or not ? R2(A); R3(C); W3(A); W2(A); W2(B); W3(C); R1(A); R1(B); W1(A); W1(B)
Check whether the given schedule is conflict serializable or not ? R2(A); R3(C); W3(A); W2(A); W2(B); W3(C); R1(A); R1(B); W1(A); W1(B)
User Avatar
Link Copied!