Login
Register
Dark Mode
Brightness
Profile
Edit Profile
Messages
My favorites
My Updates
Logout
Recent questions tagged conflict-serializable
0
votes
1
answer
61
UGC NET CSE | July 2018 | Part 2 | Question: 65
Consider the following schedules involving two transactions. $S_1 : r_1(X) ; r_1(Y); r_2(X); r_2(Y); w_2(Y); w_1(X)$ $S_2 : r_1(X) ; r_2(X); r_2(Y); w_2(Y); r_1(Y); w_1(X)$ Which one of the following statements is correct ... not conflict serializable $S_1$ is not conflict serializable and $S_2$ is conflict serializable
Consider the following schedules involving two transactions.$S_1 : r_1(X) ; r_1(Y); r_2(X); r_2(Y); w_2(Y); w_1(X)$$S_2 : r_1(X) ; r_2(X); r_2(Y); w_2(Y); r_1(Y); w_1(X)$...
Pooja Khatri
1.5k
views
Pooja Khatri
asked
Jul 13, 2018
Databases
ugcnetcse-july2018-paper2
databases
transaction-and-concurrency
conflict-serializable
easy
+
–
2
votes
1
answer
62
View Serializability
Consider the following schedules: Which of the following is correct about above schedule? Only view serializable Only conflict serializable Both conflict and view serializable Neither view serializable nor conflict serializable. Please tell me the approach for checking view serializability ?
Consider the following schedules: Which of the following is correct about above schedule?Only view serializableOnly conflict serializableBoth conflict and view serializab...
Na462
1.5k
views
Na462
asked
May 29, 2018
Databases
databases
view-serializable
conflict-serializable
+
–
9
votes
1
answer
63
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
+
–
0
votes
1
answer
64
Transaction
Consider the following schedule: Which of the following is correct about above schedule? $Schedule(S)$ is not conflict serializable schedule. $Schedule(S)$ is allowed by $2PL$. $Schedule(S)$ is strict recoverable schedule. $Schedule(S)$ is allowed by strict $2PL$. Reason Please
Consider the following schedule: Which of the following is correct about above schedule?$Schedule(S)$ is not conflict serializable schedule.$Schedule(S)$ is allowed by $2...
Na462
755
views
Na462
asked
May 26, 2018
Databases
databases
conflict-serializable
two-phase-locking-protocol
+
–
1
votes
1
answer
65
Transaction
how view serializability ensures serial schedule?? i mean in view we leave many conflict like RW,WW,......we only talks about WR conflict and intial read and final write. then how it ensurs serailizability??
how view serializability ensures serial schedule??i mean in view we leave many conflict like RW,WW,......we only talks about WR conflict and intial read and final write.t...
Ravi prakash pandey
305
views
Ravi prakash pandey
asked
Apr 10, 2018
Databases
conflict-serializable
databases
transaction-and-concurrency
+
–
0
votes
1
answer
66
Databases
How to find number of conflict equivalent schedules possible :)
How to find number of conflict equivalent schedules possible :)
gauravkc
540
views
gauravkc
asked
Feb 1, 2018
Databases
databases
conflict-serializable
+
–
2
votes
0
answers
67
Ace Test Series: DBMS - Transaction And Serializablity
Answer given is 24 which is the no. of serial schedules possible, but my doubt is since no two transactions share same variables then all the schedules possible will be conflict serializable then why only serial schedules are considered ?
Answer given is 24 which is the no. of serial schedules possible, but my doubt is since no two transactions share same variables then all the schedules possible will be c...
ashish pal
452
views
ashish pal
asked
Jan 26, 2018
Databases
ace-test-series
databases
transaction-and-concurrency
conflict-serializable
+
–
2
votes
1
answer
68
Conflict Serializable
It is not conflict serializable, So, why not option A) ??
It is not conflict serializable, So, why not option A) ??
srestha
799
views
srestha
asked
Jan 24, 2018
Databases
databases
conflict-serializable
+
–
2
votes
0
answers
69
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
+
–
1
votes
0
answers
70
Precedence graph
Consider 2 schedules S1 and S2 with same set of transactions and precedence graph of S1 is same as precedence graph of S2. Which of the following statement is True? (a) Both S1 and S2 are conflict equal and conflict serializable schedule (b) Both S1 and S2 ... and S2 are conflict equal but may not equal schedules (d) Both S1 and S2 are conflict equal and but may not view equivalent
Consider 2 schedules S1 and S2 with same set of transactions and precedence graph of S1 issame as precedence graph of S2. Which of the following statement is True?(a) Bot...
hacker16
1.1k
views
hacker16
asked
Jan 18, 2018
Databases
precedence-graph
databases
conflict-serializable
+
–
2
votes
4
answers
71
Conflict serializability
Balaji Jegan
1.8k
views
Balaji Jegan
asked
Jan 17, 2018
Databases
conflict-serializable
transaction-and-concurrency
databases
+
–
2
votes
2
answers
72
Database question : Transactions
thepeeyoosh
1.4k
views
thepeeyoosh
asked
Jan 9, 2018
Databases
databases
transaction-and-concurrency
conflict-serializable
serializability
+
–
1
votes
0
answers
73
Conflict Serializable
Two transaction T1 and T2 are given as follows T1: R1(A),W1(A),R1(B),W1(B) T2: R2(B),W2(B),R3(C),W3(C) Number of conflict serializable be ____________
Two transaction T1 and T2 are given as followsT1: R1(A),W1(A),R1(B),W1(B)T2: R2(B),W2(B),R3(C),W3(C)Number of conflict serializable be ____________
srestha
523
views
srestha
asked
Jan 3, 2018
Databases
databases
conflict-serializable
+
–
3
votes
1
answer
74
Conflict equivalent
Find the number of conflict equivalent schedule: $r_{1}\left ( x \right ),w_{1}\left ( y \right ),w_{1}\left ( z \right ) , r_{2}\left ( x \right ),w_{2}\left ( y \right ),w_{2}\left ( z \right )$
Find the number of conflict equivalent schedule:$r_{1}\left ( x \right ),w_{1}\left ( y \right ),w_{1}\left ( z \right ) , r_{2}\left ( x \right ),w_{2}\left ( y \right )...
srestha
1.2k
views
srestha
asked
Jan 3, 2018
Databases
conflict-serializable
+
–
1
votes
0
answers
75
Conflict equivalent
Anup patel
417
views
Anup patel
asked
Dec 26, 2017
Databases
databases
conflict-serializable
concurrency
+
–
1
votes
0
answers
76
2 PL with lock upgrade and Conflict serializability
Hi Guys, Please tell following statement is T/F --> If there is a schedule which is conflict serializable. But there may not exist any 2 PL with lock upgrade scheme to execute it. PS: ping @Krish__, @rahul sharma 5, @Red_devil, @Shivam Chauhan, @Tuhin Dutta, @Anu007, @Ashwin Kulkarni @reena_kandari and @srestha ji.
Hi Guys,Please tell following statement is T/F >If there is a schedule which is conflict serializable. But there may not exist any 2 PL with lock upgrade scheme to execu...
Chhotu
905
views
Chhotu
asked
Dec 26, 2017
Databases
databases
transaction-and-concurrency
conflict-serializable
2phaselocking
+
–
0
votes
1
answer
77
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
+
–
0
votes
0
answers
78
Ace Test Series: Databases - Conflict Serializable
Serializable: Conflict or View?
Serializable: Conflict or View?
saxena0612
374
views
saxena0612
asked
Dec 13, 2017
Databases
ace-test-series
databases
bad-question
conflict-serializable
+
–
2
votes
1
answer
79
Transaction
Abhijeet_Kumar
368
views
Abhijeet_Kumar
asked
Dec 8, 2017
Databases
transaction-and-concurrency
databases
test-series
conflict-serializable
+
–
3
votes
1
answer
80
transaction
Abhijeet_Kumar
567
views
Abhijeet_Kumar
asked
Dec 8, 2017
Databases
transaction-and-concurrency
databases
test-series
conflict-serializable
+
–
4
votes
0
answers
81
Transaction
Abhijeet_Kumar
397
views
Abhijeet_Kumar
asked
Dec 8, 2017
Databases
transaction-and-concurrency
databases
test-series
conflict-serializable
+
–
2
votes
1
answer
82
Conflict and View serializable
Parshu gate
916
views
Parshu gate
asked
Dec 5, 2017
Databases
conflict-serializable
view-serializable
transaction-and-concurrency
databases
concurrency
+
–
1
votes
1
answer
83
Ace Test Series: Databases - Conflict Serializable
conflict serialization or not? $R1(A), R2(A),W2(A),commit_2,W1(A) ,commit_1$
conflict serialization or not?$R1(A), R2(A),W2(A),commit_2,W1(A) ,commit_1$
aaru14
366
views
aaru14
asked
Oct 29, 2017
Databases
ace-test-series
databases
conflict-serializable
+
–
2
votes
0
answers
84
Transactions
shivangi5
393
views
shivangi5
asked
Oct 16, 2017
Databases
databases
transaction-and-concurrency
conflict-serializable
+
–
1
votes
2
answers
85
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
+
–
1
votes
1
answer
86
Test by Bikram | Databases | Test 2 | Question: 28
Given below are some transaction schedules that involve three transactions $T1 \ T2 \ T3$: $\textbf{Schedule 1:}$ $T2 : Rx , T2 : Ry , T1 : Wx , T3 : Wy , T3 : Wz , T2 : Wz , T1 : Rz , T2 : Wy $ ... $1$ Schedule $2$ Schedule $3$ Schedule $4$
Given below are some transaction schedules that involve three transactions $T1 \ T2 \ T3$:$\textbf{Schedule 1:}$$T2 : Rx , T2 : Ry , T1 : Wx , T3 : Wy , T3 : Wz , T2 : W...
Bikram
262
views
Bikram
asked
Aug 26, 2017
Databases
tbb-dbms-2
databases
transaction-and-concurrency
conflict-serializable
+
–
3
votes
2
answers
87
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
88
#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
+
–
0
votes
3
answers
89
CONFLICT SERIALIZABLE
What is the answer?
What is the answer?
learner_geek
512
views
learner_geek
asked
Jun 21, 2017
Databases
databases
conflict-serializable
+
–
1
votes
1
answer
90
dbms, concurrency control
Can a schedule ( s) be irrecoverable and conflict serializable at same time?
Can a schedule ( s) be irrecoverable and conflict serializable at same time?
Ashish Mishra 4
580
views
Ashish Mishra 4
asked
Jun 14, 2017
Databases
conflict-serializable
concurrency
+
–
Page:
« prev
1
2
3
4
next »
Email or Username
Show
Hide
Password
I forgot my password
Remember
Log in
Register