Recent questions tagged serializability

0 votes
0 answers
1
Show that the two phase locking protocol ensures conflict serializability and that transaction can be serialized according to their lock points.
1 votes
2 answers
3
Is only conflict serializable schedules are recoverable?Or both view as well as conflict serializable schedules are recoverable?I have been seeing different answers in di...
1 votes
1 answer
4
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...
1 votes
0 answers
7
Consider the following schedules with data item xThe number of serial schedules which are view equal to schedules but not conflict equal is ___________.
0 votes
2 answers
8
2 votes
1 answer
11
0 votes
1 answer
12
1 votes
1 answer
13
3 votes
2 answers
14
Tl:R(X), T1:R(Y), T1:W(X), T2:R(Y), T3:W(Y), Tl:W(X), T2:R(Y)is this schedule view serializable?
2 votes
0 answers
18
S1: R(A) W(A) W(B) S2: R(A) W(A) R(B) W(B)How many view serializable schedules are possible which are not conflict serializable?(A) 0 (B) 1 (C) 2 (D) 3
0 votes
1 answer
22
3 votes
1 answer
23
Consider the following schedule:S:R2(A) W1(B) W1(C) R3(B) R2(B) R1(A) C1 R2(C) C2 W3(A)C3Please explain how it is allowed in 2 PL
1 votes
1 answer
24
If total n! serial schedules are possible , will all of them give the same result?
2 votes
2 answers
25
State True or False and Tell reason1) 2PL is always conflict serializable2)Timestamp protocol is conflict and view serializable
1 votes
1 answer
26