It is possible for local DBMSs to commit updates at some sites and undo updates at other sites. How can this inconsistency be prevented?
A) using a two-step rollback
B) using a two-phase commit
C) using a two-phase rollback
D) using a two-phase transaction

Question

Quizplus · Accepted Answer

Using a two-phase commit protocol can prevent inconsistency in a distributed database system. This protocol ensures that all sites either commit or abort updates, thus maintaining consistency across the system. A two-step rollback can undo updates at a single site, but it does not guarantee consistency across multiple sites. A two-phase rollback is not a recognized protocol, and a two-phase transaction may not be sufficient to prevent inconsistency in a distributed system.

It Is Possible for Local DBMSs to Commit Updates at Some