Open In App

ISRO | ISRO CS 2007 | Question 60

Like Article
Like
Save
Share
Report

Which of the following is correct with respect to Two phase commit protocol?
(A) Ensures serializability
(B) Prevents Deadlock
(C) Detects Deadlock

(D) Recover from Deadlock


Answer: (A)

Explanation: The two phase commit protocol is a distributed algorithm which lets all sites in a distributed system agree to commit or rollback a transaction based upon consensus of all participating sites.If any database server is unable to commit its portion of the transaction, all database servers participating in the transaction must be prevented from committing their work.
It ensures serializability but does not ensures freedom from deadlock.

Option (A) is correct.

Quiz of this Question


Last Updated : 25 Jun, 2018
Like Article
Save Article
Previous
Next
Share your thoughts in the comments
Similar Reads