Register

Recent questions tagged 2phaselocking

0 votes
0 answers
2
concurrency control
question about concurrency control methods
question about concurrency control methods
User Avatar
1 votes
1 answer
3
2 Phase Locking | Made Easy Test Series
Given Problem : S1 can be shown allowed under 2PL. However, the solution that they have provided for S2 : Seems wrong, as So, is S2 allowed under 2PL, or the answer given is incorrect?
Given Problem : S1 can be shown allowed under 2PL.However, the solution that they have provided for S2 : Seems wrong, as So, is S2 allowed under 2PL, or the answer give...
User Avatar
0 votes
1 answer
5
DBMS: SELF DOUBT .
Is basic 2 phase locking always recoverable?
Is basic 2 phase locking always recoverable?
User Avatar
2 votes
0 answers
6
Self doubt, 2PL
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 2PL is a subset of rigorous 2PL.
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...
User Avatar
0 votes
0 answers
7
GA Test series
pls explain why C is correct not A? isn’t every schedule that is supported by 2PL conflict serializable?
pls explain why C is correct not A?isn’t every schedule that is supported by 2PL conflict serializable?
User Avatar
1 votes
1 answer
9
2PL Doubt
T1: W(X), T2: R(Y), T1: R(Y), T2: R(X) does 2PL protocol allows it? T1 T2 L-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 shrinking phase as no exclusive locks are held on X is my solution correct?
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...
User Avatar
0 votes
3 answers
10
is conservative 2PL is recoverable
is conservative 2PL is recoverable schedule ?
is conservative 2PL is recoverable schedule ?
User Avatar
0 votes
0 answers
11
transaction and concurrency control protocol
Consider th following schedule r1(A)r2(B)r3(C)w1(B)w2(C)w3(D) Find the schedule which are possible to execute by strict 2PL protocol? consider commit operation as immediate last operation of each transaction
Consider th following scheduler1(A)r2(B)r3(C)w1(B)w2(C)w3(D)Find the schedule which are possible to execute by strict 2PL protocol? consider commit operation as immediate...
User Avatar
0 votes
0 answers
12
2pl protocol
Can someone explain how transactions can be serialized in order of their lock points (the point where the transactions acquire their final lock)?
Can someone explain how transactions can be serialized in order of their lock points (the point where the transactions acquire their final lock)?
User Avatar
1 votes
0 answers
13
2PL Protocol
Consider the following schedules involving two transactions. Which of the following statements is true? A. Both S1 and S2 are allowed under 2PL. B. Only S2 is allowed under 2PL. C. Only S1 is allowed under 2PL. D. Neither S1 nor S2 allowed under 2PL.
Consider the following schedules involving two transactions.Which of the following statements is true?A. Both S1 and S2 are allowed under 2PL.B. Only S2 is allowed under ...
User Avatar
1 votes
1 answer
16
DBMS: CONCURRENCY CONTROL 2 PHASE LOCKING PROTOCOL
T1: r1(x)w1(x)r1(y)w1(y) T2: r2(y)w2(y) L is xclusive lock and U is unlock L1(y)L1(X)R1(Y)W1(Y)R1(X)W1(X)U1(X)U1(Y)L2(Y)R2(Y)W2(Y)U2(Y)? IS THIS SCHEDULE VALID UNDER A 2 PHASE LOCKING SCHEDULER????
T1: r1(x)w1(x)r1(y)w1(y)T2: r2(y)w2(y)L is xclusive lock and U is unlock L1(y)L1(X)R1(Y)W1(Y)R1(X)W1(X)U1(X)U1(Y)L2(Y)R2(Y)W2(Y)U2(Y)?IS THIS SCHEDULE VALID UNDER A 2 PH...
User Avatar
To see more, click for the full list of questions or popular tags.