Login
Register
Dark Mode
Brightness
Profile
Edit Profile
Messages
My favorites
My Updates
Logout
Recent questions tagged serializability
0
votes
0
answers
1
Databases
Show that the two phase locking protocol ensures conflict serializability and that transaction can be serialized according to their lock points.
Show that the two phase locking protocol ensures conflict serializability and that transaction can be serialized according to their lock points.
gateexplore
199
views
gateexplore
asked
Jun 30, 2023
Databases
databases
two-phase-locking-protocol
serializability
+
–
0
votes
1
answer
2
Ace Test Series | DBMS
A schedule S is having 3 transactions and each transaction is having two different data items and a blind 'Write A' statement is in all the three transactions.With the above information can you say whether the schedule is ... how many equivalent serial schedules are there serializable and it is equivalent to only two serial schedule detailed schedule is needed
A schedule S is having 3 transactions and each transaction is having two different data items and a blind 'Write A’ statement is in all the three transactions.With the ...
none30
310
views
none30
asked
Jun 16, 2023
Databases
ace-test-series
databases
serializability
+
–
1
votes
2
answers
3
Is a Serial Schedule always Recoverable?
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 different forum.
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...
DebRC
1.9k
views
DebRC
asked
Aug 16, 2022
Databases
databases
concurrency
transaction-and-concurrency
serializability
+
–
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...
palashbehra5
968
views
palashbehra5
asked
Jan 17, 2022
Databases
databases
transaction-and-concurrency
2phaselocking
serializability
+
–
2
votes
0
answers
5
NIELIT 2017 July Scientist B (CS) - Section B: 46
Consider the following four schedules due to three transactions (indicated by the subscript) using read and write on a data item $x$, denoted by $r(x)$ and $w(x)$respectively. Which one of them is conflict serializable? $r_1(x);r_2(x);w_1(x);r_3(x);w_2(x)$ ... $r_2(x);w_2(x);r_3(x);r_1(x);w_1(x)$ $1$ $2$ $3$ $4$
Consider the following four schedules due to three transactions (indicated by the subscript) using read and write on a data item $x$, denoted by $r(x)$ and $w(x)$respecti...
admin
810
views
admin
asked
Mar 30, 2020
Databases
nielit2017july-scientistb-cs
databases
serializability
conflict-serializable
+
–
0
votes
0
answers
6
Virtual Gate Test Series: Databases - Schedules
A' is set of all possible schedules 'C' is set of all possible schedules that are guaranteed to produce a correct final result 'S' is the set of all serializable schedules 'P' is the set of all schedules possible under 2-phase locking protocol Which is FALSE? $P\subseteq C$ $S\subset P$ $S\subseteq P$ $P\subset C$
A' is set of all possible schedules'C' is set of all possible schedules that are guaranteed to produce a correct final result'S' is the set of all serializable schedules'...
aditi19
1.0k
views
aditi19
asked
May 28, 2019
Databases
databases
serializability
two-phase-locking-protocol
virtual-gate-test-series
+
–
1
votes
0
answers
7
Made Easy Databases
Consider the following schedules with data item x The number of serial schedules which are view equal to schedules but not conflict equal is ___________.
Consider the following schedules with data item xThe number of serial schedules which are view equal to schedules but not conflict equal is ___________.
Hirak
679
views
Hirak
asked
May 5, 2019
Databases
view-serializable
conflict-serializable
serializability
+
–
0
votes
2
answers
8
Gate Previous Year Question-2009
I am getting the answer as c but the given answer is b. How b can be ans, there is a cycle R1x->W1x (s1->s2) and W1y->w1y(s2->s1),so s1,s2 can not be conflict serializable… i m confused.. what is the right answer?
I am getting the answer as c but the given answer is b. How b can be ans, there is a cycle R1x->W1x (s1->s2) and W1y->w1y(s2->s1),so s1,s2 can not be conflict serializabl...
debasree88
863
views
debasree88
asked
Feb 24, 2019
Databases
transaction-and-concurrency
serializability
conflict-serializable
+
–
1
votes
1
answer
9
How to solve this question.
A schedule S contains three transactions $T_1$, $T_2$, $T_3$ and the oeprations sequence is given below: $T_1$: $Read$ $A$; $T_2$: $Write$ $A$; $T_3$: $Read$ $A$; $T_1$: $Write$ $A$; $T_3$: $Write$ $A$ and all ... above schedule is serializable or not? If yes it is equivalent to which serial schedule. Find the proper combination of the given alternatives from I to VII
A schedule S contains three transactions $T_1$, $T_2$, $T_3$ and the oeprations sequence is given below:$T_1$: $Read$ $A$; $T_2$: $Write$ $A$; $T_3$: $Read$ $A$; $T_1$: $...
`JEET
1.3k
views
`JEET
asked
Jan 16, 2019
Databases
databases
serializability
+
–
1
votes
2
answers
10
Ace Test Series: DBMS - Transaction And Serializable
Kaushal Sanadhya
598
views
Kaushal Sanadhya
asked
Jan 9, 2019
Databases
ace-test-series
databases
transaction-and-concurrency
serializability
+
–
2
votes
1
answer
11
Raghuramkrishnan
T1 T2 T3 R(X) W(X) commit W(X) commit R(X) commit is this transaction conflict serializable and view serializable?
T1T2T3R(X)W(X)commitW(X)commitR(X)commit is this transaction conflict serializable and view serializable?
aditi19
2.2k
views
aditi19
asked
Nov 18, 2018
Databases
databases
transaction-and-concurrency
serializability
conflict-serializable
+
–
0
votes
1
answer
12
Raghuramkrishnan
T1 T2 T3 W(Y) commit R(X) R(Y) W(Z) commit W(X) commit is this schedule a strict schedule?
T1 T2 T3W(Y)commitR(X)R(Y)W(Z)commitW(X)commitis this schedule a strict schedule?
aditi19
598
views
aditi19
asked
Nov 18, 2018
Databases
databases
transaction-and-concurrency
serializability
conflict-serializable
strict-schedule
+
–
1
votes
1
answer
13
RaghuramKrishnan
Tl:W(X), T2:R(X), Tl:W(X), T2:Commit, Tl:Abort is this schedule conflict serializable?
Tl:W(X), T2:R(X), Tl:W(X), T2:Commit, Tl:Abortis this schedule conflict serializable?
aditi19
1.1k
views
aditi19
asked
Nov 17, 2018
Databases
databases
transaction-and-concurrency
serializability
conflict-serializable
view-serializable
+
–
3
votes
2
answers
14
Raghuramkrishnan
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?
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?
aditi19
561
views
aditi19
asked
Nov 16, 2018
Databases
databases
transaction-and-concurrency
serializability
+
–
0
votes
0
answers
15
2 Phase Locking
https://gateoverflow.in/1484/gate1999-2-6 in this questions after T2 is not granted exclusive lock on A does the transaction T2 gets blocked entirely or it can continue to acquire exclusive lock on B? and if T2 continues to acquire lock on B followed by T1 requesting for read and write lock on B successively, is it deadlock situation here? And is that why it is not 2PL?
https://gateoverflow.in/1484/gate1999-2-6in this questions after T2 is not granted exclusive lock on A does the transaction T2 gets blocked entirely or it can continue to...
aditi19
436
views
aditi19
asked
Nov 11, 2018
Databases
-2phaselocking
databases
serializability
transaction-and-concurrency
+
–
1
votes
1
answer
16
Serializability
Na462
1.0k
views
Na462
asked
Jul 14, 2018
Databases
databases
conflict-serializable
view-serializable
transaction-and-concurrency
serializability
+
–
9
votes
1
answer
17
Are aborted transactions ALWAYS ignored when determining result/view/conflict serializability?
I am looking for some clarity on this topic. Here is some random schedule as an example: $r1(x) w1(x) r2(x) w2(x) r3(y) r3(x) w3(x) c3 a1 c2$ I was told, that for ... , strictness or avoidance of cascading rollbacks. I would be grateful if the question would be answered since this really confuses me.
I am looking for some clarity on this topic. Here is some random schedule as an example:$r1(x) w1(x) r2(x) w2(x) r3(y) r3(x) w3(x) c3 a1 c2$I was told, that for conflict...
flow2539
3.4k
views
flow2539
asked
May 28, 2018
Databases
databases
transaction-and-concurrency
conflict-serializable
view-serializable
result-serializable
serializability
+
–
2
votes
0
answers
18
TheGateBook
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
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
yolorn123
458
views
yolorn123
asked
Jan 31, 2018
Databases
view-serializable
serializability
+
–
2
votes
0
answers
19
Concurrency Control
Which of the following statement is true? 1. time stamp protocol may not result recoverable schedule 2. in 2PL, No data are affected until all locks are obtained i.e., until the transaction is in its locked point. a) only a b) only b c) a and b d) none
Which of the following statement is true?1. time stamp protocol may not result recoverable schedule2. in 2PL, No data are affected until all locks are obtained i.e., unti...
hacker16
1.3k
views
hacker16
asked
Jan 18, 2018
Databases
conflict-serializable
transaction-and-concurrency
serializability
concurrency
+
–
2
votes
2
answers
20
Database question : Transactions
thepeeyoosh
1.4k
views
thepeeyoosh
asked
Jan 9, 2018
Databases
databases
transaction-and-concurrency
conflict-serializable
serializability
+
–
3
votes
2
answers
21
draw polygraph of this , check for view serializability
T1 T2 W(x) R(x) W(x) ABORT COMMIT
T1T2W(x) R(x)W(x) ABORTCOMMIT
sumit goyal 1
3.7k
views
sumit goyal 1
asked
Dec 25, 2017
Databases
view-serializable
serializability
databases
normal
+
–
0
votes
1
answer
22
Transactions & Concurrency Control
The above question has a blind write so it should be View Serializable. But can it be Conflict Serializable?
The above question has a blind write so it should be View Serializable. But can it be Conflict Serializable?
Kaustubh _15
469
views
Kaustubh _15
asked
Dec 15, 2017
Databases
serializability
conflict-serializable
transaction-and-concurrency
+
–
3
votes
1
answer
23
2 Phase Locking
Consider the following schedule: S:R2(A) W1(B) W1(C) R3(B) R2(B) R1(A) C1 R2(C) C2 W3(A)C3 Please explain how it is allowed in 2 PL
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
shivangi5
1.2k
views
shivangi5
asked
Dec 6, 2017
Databases
-2phaselocking
serializability
databases
transaction-and-concurrency
+
–
1
votes
1
answer
24
serial schedules
If total n! serial schedules are possible , will all of them give the same result?
If total n! serial schedules are possible , will all of them give the same result?
Parshu gate
329
views
Parshu gate
asked
Sep 21, 2017
Databases
databases
serializability
+
–
2
votes
2
answers
25
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
srestha
2.8k
views
srestha
asked
Sep 16, 2017
Databases
-2phaselocking
serializability
+
–
1
votes
1
answer
26
Serializability and 2 phase locking protocol
Why is cascading rollback possible in 2 phase locking protocol, we know it guarantee serializability and serializable schedule are strict, which implies it is cascadeless? Please clear the doubt and correct me.
Why is cascading rollback possible in 2 phase locking protocol, we know it guarantee serializability and serializable schedule are strict, which implies it is cascadeless...
Kushagra Gusain
992
views
Kushagra Gusain
asked
Sep 7, 2017
Databases
-2phaselocking
databases
serializability
+
–
Page:
1
2
next »
Email or Username
Show
Hide
Password
I forgot my password
Remember
Log in
Register