Login
Register
Dark Mode
Brightness
Profile
Edit Profile
Messages
My favorites
My Updates
Logout
Recent questions tagged view-serializable
2
votes
0
answers
31
Are they view Equivalent?
S1: T(1) T(2) Read(Q) Write(Q) Write(Q) S2: T(1) T(2) Write(Q) Read(Q) Write (Q) Are Schedule S1 and S2 view equivalent? I don't think so because, in S1, T1 read the value of Q which is different from the value read by T1(in S2).
S1: T(1) T(2) Read(Q) Write(Q) Write(Q)S2: T(1) T(2) Write(...
Hemant Parihar
470
views
Hemant Parihar
asked
Jan 7, 2018
Databases
view-serializable
+
–
3
votes
1
answer
32
No. Of serial schedules view equal to S
No. Of serial schedules view equal to S S: R1(A), R3(D), W1(B), R2(B), W3(B), R4(B), W2(C), R5(C), W4(E), R5(E), W5(B) . If possible please provide detailed solutions. Thank you in advance
No. Of serial schedules view equal to SS: R1(A), R3(D), W1(B), R2(B), W3(B), R4(B), W2(C), R5(C), W4(E), R5(E), W5(B) .If possible please provide detailed solutions.Thank...
thepeeyoosh
3.1k
views
thepeeyoosh
asked
Jan 6, 2018
Databases
transaction-and-concurrency
databases
view-serializable
+
–
3
votes
2
answers
33
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
+
–
1
votes
0
answers
34
View Seializability
Can anyone explain or give any link to study View Serializability ... Will be really thankful..
Can anyone explain or give any link to study View Serializability ... Will be really thankful..
Sahil1994
243
views
Sahil1994
asked
Dec 22, 2017
Databases
databases
view-serializable
+
–
3
votes
3
answers
35
VIEW SERIALIZABILITY
Consider the 2 transactions T1: R(A) W(A) W(B) T2: 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
Consider the 2 transactionsT1: R(A) W(A) W(B)T2: 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(...
shivangi5
2.9k
views
shivangi5
asked
Dec 6, 2017
Databases
view-serializable
databases
transaction-and-concurrency
concurrency
+
–
2
votes
1
answer
36
Conflict and View serializable
Parshu gate
916
views
Parshu gate
asked
Dec 5, 2017
Databases
conflict-serializable
view-serializable
transaction-and-concurrency
databases
concurrency
+
–
0
votes
0
answers
37
View Serializable schedules
Consider the following schedule: S: r1(A), r3(D), w1(B), r2(B), r4(B), w2(C), r5(C), w4(E), r5(E), w5(B) The number of serial schedules which are view equal to schedule S ?
Consider the following schedule:S: r1(A), r3(D), w1(B), r2(B), r4(B), w2(C), r5(C), w4(E), r5(E), w5(B)The number of serial schedules which are view equal to schedule S ?...
Upasana singh
565
views
Upasana singh
asked
Oct 17, 2017
Databases
view-serializable
databases
+
–
1
votes
2
answers
38
Doubt Question on Transaction schedules
Consider a Serial Schedule given- T1 T2 T3 w1(A) w1(B) r2(A) w2(B) r3(A) w3(B) How many schedules which are view equivalent to above schedule? How many schedules which are confilct equivalent to above schedule? ... serializable/ view serializable? If yes How many serial schedules are possible which are conflict equivalent/ view equivalent to able schedule?
Consider a Serial Schedule given-T1T2T3w1(A) w1(B) r2(A) w2(B) r3(A) w3(B) How many schedules which are view equivalent to above schedule?How many schedules whic...
Durgesh Singh
878
views
Durgesh Singh
asked
Sep 30, 2017
Databases
databases
transaction-and-concurrency
view-serializable
conflict-serializable
+
–
2
votes
2
answers
39
Practice
All Conflict serializable schedule are also view serializable but reverse is not true . True or False
All Conflict serializable schedule are also view serializable but reverse is not true . True or False
Nikhil Patil
516
views
Nikhil Patil
asked
Sep 30, 2017
Databases
databases
view-serializable
+
–
3
votes
2
answers
40
Test by Bikram | Databases | Test 2 | Question: 17
Which of the following is TRUE about the given schedule S? ... is conflict serializable. It is view serializable but not conflict serializable. It is conflict serializable but not view serializable. It is not serializable.
Which of the following is TRUE about the given schedule S?$\begin{array}{|c|c|} \hline \text{Schedule:} & S \\ \hline T1 & T2 \\ \hline R(A) & {} \\ \hline A=A+100 & {} ...
Bikram
458
views
Bikram
asked
Aug 26, 2017
Databases
tbb-dbms-2
databases
transaction-and-concurrency
serializability
conflict-serializable
view-serializable
+
–
1
votes
2
answers
41
#Transaction-Schedules
How to order these schedules in terms of flexibility of concurrency? 1. View serializable 2. Conflict Serializable 3.Recoverable 4.Strict 5.Cascadeless
How to order these schedules in terms of flexibility of concurrency?1. View serializable2. Conflict Serializable3.Recoverable4.Strict5.Cascadeless
Tuhin Dutta
681
views
Tuhin Dutta
asked
Aug 12, 2017
Databases
databases
transaction-and-concurrency
view-serializable
conflict-serializable
strict-schedule
cascadeless-schedule
recoverable-schedule
+
–
3
votes
2
answers
42
view-serializablity
Draw the polygraph and explain whether it is view-serializable or not?
Draw the polygraph and explain whether it is view-serializable or not?
shashank023
572
views
shashank023
asked
Jul 24, 2017
Databases
view-serializable
databases
serializability
+
–
4
votes
1
answer
43
DBMS Number of serializable schedules
Consider thw following transactions:- T1 :- r1(A) w1(A) r1(B) w1(B) T1 :- r2(A) w2(A) r2(B) w2(B) a) Number of schedules serializable as t1->t2? b) Number of schedules serializable as t2->t1?
Consider thw following transactions:-T1 :- r1(A) w1(A) r1(B) w1(B)T1 :- r2(A) w2(A) r2(B) w2(B)a) Number of schedules serializable as t1->t2?b) Number of schedules serial...
rahul sharma 5
1.2k
views
rahul sharma 5
asked
Jul 12, 2017
Databases
databases
view-serializable
transaction-and-concurrency
+
–
11
votes
3
answers
44
[DBMS] Number of view equal schedules
Number of schedules view equal to following schedule :- r1(A), w1(B), r2(A), w2(B), r3(A), w3(B)
Number of schedules view equal to following schedule :- r1(A), w1(B), r2(A), w2(B), r3(A), w3(B)
rahul sharma 5
10.4k
views
rahul sharma 5
asked
Jul 9, 2017
Databases
databases
view-serializable
transaction-and-concurrency
+
–
0
votes
1
answer
45
PREDICT SERIALIZABILITY OF GIVEN SCHEDULE
T1 T2 READ-Q WRITE-P WRITE-Q READ-P Given schedule is: a) Not conflct serializable, but view serializable b) conflct serializable, not view serializable c) Both conflct serializable, and view serializable d) Not conflct serializable, not view serializable
T1T2READ-Q WRITE-P WRITE-QREAD-P Given schedule is:a) Not conflct serializable, but view serializableb) conflct serializable, not view serializablec) Both conflct seria...
sh!va
371
views
sh!va
asked
Feb 10, 2017
Databases
databases
view-serializable
+
–
1
votes
1
answer
46
Predict serializability of given schedule
S:r1(P),r2(Q),r1(Q),r2(P),w1(Q),w2(P) Predict serializability of given schedule: a) It is view serializable NOT conflict serializble b) It is view serializable but NOT conflict serializble only if P= Q c) It is view serializable and conflict serializble d) It is neither view serializable nor conflict serializble
S:r1(P),r2(Q),r1(Q),r2(P),w1(Q),w2(P)Predict serializability of given schedule:a) It is view serializable NOT conflict serializbleb) It is view serializable but NOT conf...
sh!va
376
views
sh!va
asked
Feb 7, 2017
Databases
databases
view-serializable
+
–
2
votes
1
answer
47
Is this correct?
Which one among the following is true? [ A ] All Strict Schedules are Cascadeless and Recoverable. [ B ] All Recoverable Schedules are Strict and Cascadeless. [ C ] All Conflict Serializable Schedules are Strict and Cascadeless. [ D ] All View Serializable ... cascadeless, may not be cascadeless, may be strict may not be strict. Is this the correct way to infer this diagram?
Which one among the following is true?[ A ]All Strict Schedules are Cascadeless and Recoverable.[ B ]All Recoverable Schedules are Strict and Cascadeless.[ C ]All Conflic...
Krunal2016
1.7k
views
Krunal2016
asked
Feb 4, 2017
Databases
view-serializable
databases
+
–
0
votes
0
answers
48
Made Easy Test Series
pranjalgennext
272
views
pranjalgennext
asked
Feb 3, 2017
Databases
made-easy-test-series
databases
view-serializable
+
–
7
votes
3
answers
49
view serializable
$S: R_1(A),R_2(B),W_2(A),W_3(C),R_4(C),R_3(A),W_3(B),R_4(A),W_2(B),W_4(B),W_3(A)$ View serializable or not?
$S: R_1(A),R_2(B),W_2(A),W_3(C),R_4(C),R_3(A),W_3(B),R_4(A),W_2(B),W_4(B),W_3(A)$View serializable or not?
Supremo
2.1k
views
Supremo
asked
Jan 28, 2017
Databases
view-serializable
databases
transaction-and-concurrency
concurrency
+
–
1
votes
1
answer
50
Self Doubt
Do commit operations matter while checking serilizability?If yes why?
Do commit operations matter while checking serilizability?If yes why?
Gate Madrista
504
views
Gate Madrista
asked
Jan 28, 2017
Databases
databases
transaction-and-concurrency
view-serializable
conflict-serializable
+
–
1
votes
0
answers
51
Made Easy Test Series
The number of view equal serial schedules possible for the given schedule are: S: w1(A) r2(A) w3(A) r4(A) w5(A) r6(A) w7(A) r8(A)
The number of view equal serial schedules possible for the given schedule are:S: w1(A) r2(A) w3(A) r4(A) w5(A) r6(A) w7(A) r8(A)
pranjalgennext
231
views
pranjalgennext
asked
Jan 26, 2017
Databases
databases
view-serializable
+
–
1
votes
2
answers
52
Serializability
Consider the following schedule S : r1(A) w2(A) commit2, w1(A) w3(A) commit3, commit1 Which of the following is true? a) Schedule is view serializable schedule and strict recoverable schedule b) Schedule is non serializable ... c) Schedule is non serializable schedule and not strict recoverable schedule d)Schedule is serializable schedule and not strict recoverable schedule
Consider the following schedule S : r1(A) w2(A) commit2, w1(A) w3(A) commit3, commit1Which of the following is true?a) Schedule is view serializable schedule a...
srestha
3.3k
views
srestha
asked
Jan 18, 2017
Databases
databases
view-serializable
+
–
1
votes
0
answers
53
view serializable
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
indrajeet
490
views
indrajeet
asked
Dec 25, 2016
Databases
databases
transaction-and-concurrency
view-serializable
+
–
6
votes
3
answers
54
Schedules
$1)$ Find the number of all possible conflict-equivalent and view-equivalent schedules to the following serial schedules. (a) r1(A), w1(B), r2(A), w2(B), r3(A), w3(B).
$1)$ Find the number of all possible conflict-equivalent and view-equivalent schedules to the following serial schedules. (a) r1(A), w1(B), r2(A), w2(B), r3(A), w3(B)....
Prabhanjan_1
4.9k
views
Prabhanjan_1
asked
Dec 24, 2016
Databases
transaction-and-concurrency
conflict-serializable
view-serializable
+
–
1
votes
1
answer
55
ACE-MockTest-Serializability Problem
KISHALAY DAS
407
views
KISHALAY DAS
asked
Dec 21, 2016
Databases
view-serializable
databases
conflict-serializable
+
–
0
votes
1
answer
56
serializability
How it is view serializable?
How it is view serializable?
vaishali jhalani
701
views
vaishali jhalani
asked
Dec 16, 2016
Databases
databases
view-serializable
conflict-serializable
+
–
1
votes
1
answer
57
Conflict + View + Concurrency
Do they all ensure serializability??? Strict 2PL Rigirous 2PL Conservative 2PL Multiversion 2PL Timestamp Stirct timestamp Multiversion timestamp Graph based protocol Thomas write rule Multiple granuality And among them which policy allows schedules that are not conflict serializable by are view serializable???
Do they all ensure serializability???Strict 2PLRigirous 2PLConservative 2PLMultiversion 2PLTimestampStirct timestampMultiversion timestampGraph based protocolThomas write...
Rahul Jain25
576
views
Rahul Jain25
asked
Oct 22, 2016
Databases
view-serializable
conflict-serializable
transaction-and-concurrency
databases
concurrency
+
–
11
votes
2
answers
58
serializablity and recoverability of schedules
1) T1: R(X), T2: W(X), T1: W(X), T2: Abort, T1: Commit 2) T1: W(X), T2: R(X), T1: W(X), T2: Abort, T1: Commit 3) T1: W(X), T2: R(X), T1: W(X), T2: ... : Abort Can anyone explain whether these schedules are serializable, conflict-serializable, view serializable, recoverable, avoids-cascading-aborts, and strict? The abort operation actually bugging me.
1) T1: R(X), T2: W(X), T1: W(X), T2: Abort, T1: Commit2) T1: W(X), T2: R(X), T1: W(X), T2: Abort, T1: Commit3) T1: W(X), T2: R(X), T1: W(X), T2: Commit, T1: AbortCan anyo...
vix28
12.0k
views
vix28
asked
Sep 8, 2016
Databases
transaction-and-concurrency
concurrency
conflict-serializable
view-serializable
databases
+
–
2
votes
1
answer
59
#View Serializability #DBMS
I know that this is Conflict serializable and i know all schedules which are Conflict serializable are also view serializable But still wanted to know what is the view serializable sequence?
I know that this is Conflict serializable and i know all schedules which are Conflict serializable are also view serializableBut still wanted to know what is the view ser...
Prajwal Bhat
971
views
Prajwal Bhat
asked
Sep 5, 2016
Databases
view-serializable
databases
transaction-and-concurrency
+
–
3
votes
2
answers
60
Can someone please explain the steps to check view serializability using polygraph method ?
Can someone please explain the steps to check view serializability using polygraph method ? I am really having trouble in understanding it.
Can someone please explain the steps to check view serializability using polygraph method ? I am really having trouble in understanding it.
Aakash Das
932
views
Aakash Das
asked
Jun 22, 2016
Databases
view-serializable
databases
transaction-and-concurrency
+
–
Page:
« prev
1
2
3
next »
Email or Username
Show
Hide
Password
I forgot my password
Remember
Log in
Register