2 votes 2 votes How many concurrent schedules are conflict serializable of given transactions T1 and T2: T1 = r1(A) W1(A)R1(B)W1(B) T2 = R2(B)W2(B)R2(A)W2(A) Databases transaction-and-concurrency databases + – sunaina rawat asked Dec 4, 2017 sunaina rawat 804 views answer comment Share Follow See all 2 Comments See all 2 2 Comments reply vamp_vaibhav commented Dec 6, 2017 reply Follow Share Answer is 2 or 0?? 0 votes 0 votes Ajay Jadhav commented Jan 21, 2018 reply Follow Share I think 0 $\ either \ T_1 \rightarrow T_2 \ or \ T_2 \rightarrow T_1$ 0 votes 0 votes Please log in or register to add a comment.
1 votes 1 votes no any concurrent serializable schedule possible only two serial schedules are possible T1->T2 and T2->T1 Kaluti answered Jan 13, 2018 Kaluti comment Share Follow See all 6 Comments See all 6 6 Comments reply Show 3 previous comments Sona Barman commented Jan 21, 2018 reply Follow Share @ gari Serial Schedule: Transactions are executed one after another in non-preemtive manner. Given question is the example of serial schedule. Concurrent Schedule: Transaction are executed in preemptive mannar. T1 T2 T1(A) W2(B) W1(A) T2(A) This is concurrent Schedule. Concurrency leads to inconsistent state of database. Hope this will help you. 0 votes 0 votes Prateek Raghuvanshi commented Aug 3, 2018 reply Follow Share @gari serial schedules also concurrent schedules. 0 votes 0 votes sandeep singh gaur commented Nov 15, 2018 reply Follow Share I think non serial schedule is concurrent schedule 0 votes 0 votes Please log in or register to add a comment.