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

Question

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

Quizplus · Accepted Answer

Two-phase commit ensures that either all updates are committed or all updates are rolled back at all sites, eliminating inconsistencies that may arise from partial commit/rollback operations. Two-step rollback, two-phase rollback, and two-phase transaction do not provide the same level of consistency as two-phase commit.

It Is Possible for Local DBMSs to Commit Updates at Some