Register

Search results for -2phaselocking

0 votes
0 answers
2
concurrency control
question about concurrency control methods
question about concurrency control methods
User Avatar
1 votes
1 answer
4
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
3 answers
5
is conservative 2PL is recoverable
is conservative 2PL is recoverable schedule ?
is conservative 2PL is recoverable schedule ?
User Avatar
0 votes
1 answer
7
DBMS: SELF DOUBT .
Is basic 2 phase locking always recoverable?
Is basic 2 phase locking always recoverable?
User Avatar
1 votes
1 answer
8
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
2 votes
0 answers
9
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
1 votes
1 answer
12
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
0 answers
13
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
0 votes
0 answers
15
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
0 votes
0 answers
16
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
1 votes
0 answers
17
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
2 votes
2 answers
19
2 Phase Locking
State True or False and Tell reason 1) 2PL is always conflict serializable 2)Timestamp protocol is conflict and view serializable
State True or False and Tell reason1) 2PL is always conflict serializable2)Timestamp protocol is conflict and view serializable
User Avatar
Page: