Multiple choice technology databases

What is a Two-Phase Commit

  1. Two-phase commit is mechanism that guarantees a distributed transaction that always commits on all involved nodes to maintain data consistency across the global distributed database.

  2. Two-phase commit is mechanism that guarantees a distributed transaction either commits on all involved nodes or rolls back on all involved nodes to maintain data consistency across the global distributed database. It has two phase, a Prepare Phase and a C

  3. Two-phase commit is mechanism that guarantees a distributed transaction that always rollback on all involved nodes to maintain data consistency across the global distributed database.

  4. Two-phase commit is mechanism that guarantees a distributed transaction that always commit on all involved nodes to maintain data consistency across the global heirarchical database.
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Two-Phase Commit (2PC) ensures distributed transactions either commit on all nodes OR roll back on all nodes, maintaining consistency. It has two phases: Prepare Phase (all nodes verify they can commit) and Commit Phase (coordinator instructs all to commit). Option A incorrectly states it always commits, which would allow inconsistency. Option C incorrectly states it always rolls back. Option D mentions 'heirarchical database' (typo for hierarchical) and incorrectly states it always commits. Option B correctly describes the all-or-nothing guarantee with both phases.

Keep practicing — related questions