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
Article Tags :
Recommended Articles