5 votes 5 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 asked Jun 10, 2016 go_editor 7.5k views answer comment Share Follow See all 0 reply Please log in or register to add a comment.
Best answer 7 votes 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 See all 3 3 Comments reply Mangilal Saraswat commented Jun 18, 2016 reply Follow Share Two-phase commit (2PC) protocol should not be confused with the two-phase locking (2PL) protocol, a concurrency control protocol. 3 votes 3 votes cse23 commented Jun 19, 2016 reply Follow Share 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 votes 2 votes Mangilal Saraswat commented Jun 20, 2016 reply Follow Share 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 votes 2 votes Please log in or register to add a comment.
3 votes 3 votes (A) IS CORRECT. Jishan answered Mar 22, 2018 Jishan comment Share Follow See 1 comment See all 1 1 comment reply Utsav09 commented Apr 16, 2018 reply Follow Share It's 2 phase commit protocol not 2PL 0 votes 0 votes Please log in or register to add a comment.
2 votes 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 See all 0 reply Please log in or register to add a comment.