309 views
1 votes
1 votes

1 Answer

1 votes
1 votes

All of the statements are true.The reason being :

Statement 1 is true because the schedule is 2PL serialisable only if there is no conflicting locks..All locks should be acquired accourding to the lock points defined..Else it is not allowed by 2PL thus ensuring serialisablilty in this way..

Statement 2 is true as the requirement of 2PL says this that unlock should be preceded by locks..

Statement  3 is true as the data transactions (reads and writes) are allowed after locks are acquired successfully else not..

Hence all statements are true..

Related questions

0 votes
0 votes
2 answers
1
0 votes
0 votes
0 answers
2
mehul vaidya asked Jan 21, 2019
137 views
Do we consider Shared lock for deciding whether transaction in given schedule following 2PL or not?or in simple words can transaction which follows 2PL use Shared lock af...
2 votes
2 votes
0 answers
3
vinay chauhan asked Jan 18, 2019
574 views
Is different 2 phase locking a subset of each other? For example, if the schedule is Strict 2PL then it will also be simple 2PL.Something like a 2PL is a subset of Strict...
1 votes
1 votes
1 answer
4
aditi19 asked Nov 25, 2018
444 views
T1: W(X), T2: R(Y), T1: R(Y), T2: R(X)does 2PL protocol allows it? T1 T2L-X(X)W(X)L-S(Y)R(Y)U(X) L-S(Y)R(Y)L-S(X)R(X)here T2 is granted lock on X as T1 enters sh...