Database-Management-System
May 14, 2024Question 156 – Database-Management-System
May 14, 2024Database-Management-System
| Question 892 |
Which of the following is correct with respect to Two phase commit protocol?
| Ensures serializability | |
| Prevents Deadlock | |
| Detects Deadlock | |
| Recover from Deadlock |
Question 892 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.
It ensures serializability but does not ensures freedom from deadlock.
Correct Answer: A
Question 892 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.
It ensures serializability but does not ensures freedom from deadlock.