0 votes 0 votes Which of the following 2PL schemes guarantee conflict serializability? Basic 2PL Conservative 2PL Strict 2PL Rigorous 2PL Databases transaction-and-concurrency concurrency + – Aghori asked Dec 3, 2016 edited Dec 3, 2016 by Aghori Aghori 995 views answer comment Share Follow See 1 comment See all 1 1 comment reply iita commented Dec 3, 2016 reply Follow Share For details you can see this..https://en.wikipedia.org/wiki/Two-phase_locking 1 votes 1 votes Please log in or register to add a comment.
0 votes 0 votes Any schedule which is possible under 2-PL scheme ensures conflict serializability iita answered Dec 3, 2016 iita comment Share Follow See all 5 Comments See all 5 5 Comments reply Show 2 previous comments Aghori commented Dec 3, 2016 reply Follow Share Meanwhile got it. 2PL guaranteed conflict serializable schedule are proper set of conflict serializable schedules. i.e every 2PL schedule is conflict serializable but every serializable schedule is not to be ensured by 2PL. 0 votes 0 votes Akriti sood commented Dec 3, 2016 reply Follow Share ok..thnaks for confirming.and what about uther 2pl??do they ensure conflcit serializabiltiy?? 0 votes 0 votes Aghori commented Dec 3, 2016 reply Follow Share All 2PL schemes guarantee conflict serializability. 0 votes 0 votes Please log in or register to add a comment.