7 7 votes Which of the following is correct with respect to Two phase commit protocol? Ensures serializability Prevents Deadlock Detects Deadlock Recover from Deadlock Databases isro2007 databases transaction-and-concurrency + – go_editor 9.4k views answer comment Share Follow Print 0 reply Please log in or register to add a comment.
Best answer 7 7 votes 2 Phase commit protocol ensures serializability. ManojK answered Jun 10, 2016 • selected Jun 27, 2016 by Arjun ManojK comment Share Follow See all 3 Comments 3 3 Comments reply Mangilal Saraswat commented Jun 18, 2016 reply Follow flag Two-phase commit (2PC) protocol should not be confused with the two-phase locking (2PL) protocol, a concurrency control protocol. 3 3 replyShare cse23 commented Jun 19, 2016 reply Follow flag two phase protocol(growing and shrinking) is not free from deadlock that's why we use tree based or graph based protocol. It ensures the serializability by maintaining the order of lock point(last point where transaction acquire the lock in a given schedule) so ans should be (A) 2 2 replyShare Mangilal Saraswat commented Jun 20, 2016 reply Follow flag What do I think! I think no one option is correct. If there would this question about 2PL then answer would be A but here question is about 2PC. So, no option is looking perfect answer. 2PC is a distributed algorithm that coordinates all the processes that participate in a distributed atomic transaction. However in process of 2PC, deadlock occurs sometimes then this protocol have ability to recover from deadlock but this recovering of deadlock is not in general context. Reference: https://en.wikipedia.org/wiki/Two-phase_commit_protocol 2 2 replyShare Please log in or register to add a comment.
3 3 votes (A) IS CORRECT. Jishan answered Mar 22, 2018 Jishan comment Share Follow See 1 comment 1 1 comment reply Utsav09 commented Apr 16, 2018 reply Follow flag It's 2 phase commit protocol not 2PL 1 1 replyShare Please log in or register to add a comment.
2 2 votes NO 2PC SO IS THERE SO IT MUST BE 2PL SO APPROPIATE ANSWER OPTION A IS CORRECT vijju answered Sep 22, 2016 vijju comment Share Follow 0 reply Please log in or register to add a comment.
