0 votes 0 votes please check the statement 3 Databases databases + – Shivani gaikawad asked Oct 27, 2018 Shivani gaikawad 601 views answer comment Share Follow See all 4 Comments See all 4 4 Comments reply Verma Ashish commented Oct 27, 2018 reply Follow Share I think 3 is false. 0 votes 0 votes Shobhit Joshi commented Oct 27, 2018 reply Follow Share Every 2pl is conflict-serializable but every conflict serializable is not 2pl 3 is not correct ... This will eliminate the options 1,3,4 so 2 is the answer 0 votes 0 votes Soumya Tiwari commented Oct 27, 2018 reply Follow Share @Verma Ashish @Shobit Can you give any example where a schedule is conflict serializable but not in 2pl. Link to any source will also work... 0 votes 0 votes adarsh_1997 commented Oct 27, 2018 reply Follow Share @soumya https://gateoverflow.in/42378/conflict-serializable-and-2pl-schedule 0 votes 0 votes Please log in or register to add a comment.
1 votes 1 votes $T1$ $T2$ $LOCK-EX-W(x)$ $R(X)$ $R(X)$ $T1$ taken the exclusive lock on $X$ , T2 can't take it for $R(X)$ because T1 can't release ,because T1 again need the lock for $R(X)$ so it is CSS but not in 2PL 3 is wrong Prince Sindhiya answered Oct 27, 2018 Prince Sindhiya comment Share Follow See all 7 Comments See all 7 7 Comments reply Show 4 previous comments Magma commented Oct 28, 2018 reply Follow Share Prince Sindhiya Yes I know And do the same check carefully 0 votes 0 votes Magma commented Oct 28, 2018 reply Follow Share Read the 2nd point 0 votes 0 votes Shivani gaikawad commented Dec 29, 2018 reply Follow Share @magma you have unlock T1 then you are taking lock on T2 which can not happen in 2pl 0 votes 0 votes Please log in or register to add a comment.