Recent questions tagged transaction-and-concurrency

2 votes
2 answers
332
Consider the following scheduleS : r1(A) w2(A) r3(A) w4(A) r5(A) w6(A)The number of schedules equal to given schedule(s) which not conflict equal to schedule(s) are _____...
0 votes
1 answer
333
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) _______...
0 votes
0 answers
334
0 votes
3 answers
336
W1(A),R2(A),W2(A),W2(B),W1(B)This schedule has WW conflict but not Lost update problem,Please explain why?Is it possible to have WW conflict without lost update?
1 votes
0 answers
340
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
5 votes
1 answer
341
$1)$ Consider schedule below. Determine whether schedule is cascadeless or not ?r1(x); r2(z); r1(z); r3(x); r3(y); w1(x); c1; w3(y); c3; r2(y); w2(z); w2(y);c2
6 votes
3 answers
342
$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)....
0 votes
2 answers
346
0 votes
1 answer
348
Which of the following 2PL schemes guarantee conflict serializability?Basic 2PLConservative 2PLStrict 2PLRigorous 2PL
3 votes
2 answers
353
Consider the following database schedule with two transactions T1T1 and T2T2.S=r2(X);r1(X);r2(Y);w1(X);r1(Y);a1;a2 where a1 and a2 stands for abort. Is It a strict sched...
3 votes
1 answer
355
There exist an schedule which serializable but is neither view serializable nor conflict serializable ?
0 votes
2 answers
357
2 votes
1 answer
358
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...
3 votes
2 answers
359
2 votes
2 answers
360
The basic variants of time-stampbased method of concurrency control areTotal time stamp-orderingPartial time stamp orderingMultiversion Time stamp orderingAll of the abov...