Skip to content
Related Articles

Related Articles

Improve Article
Save Article
Like Article

ISRO | ISRO CS 2007 | Question 60

  • Last Updated : 25 Jun, 2018

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

My Personal Notes arrow_drop_up
Recommended Articles
Page :

Start Your Coding Journey Now!