Two-phase commit - Definition - Oracle Distributed Database concepts

Q.  What is the mechanism which guarantees that all database servers participating in a distributed transaction either all commit or all roll back the statements in the transaction?
- Published on 29 Jul 15

a. Commit
b. Commit transaction
c. Two-phase commit
d. Three-phase commit

ANSWER: Two-phase commit
 

    Discussion

  • Nirja Shah   -Posted on 21 Sep 15
    - A distributed transaction is a transaction that includes one or more statements that update data on two or more distinct nodes of a distributed database.

    - A two-phase commit mechanism guarantees that all database servers participating in a distributed transaction either all commit or all undo the statements in the transaction.

    - A two-phase commit mechanism also protects implicit DML operations performed by integrity constraints, remote procedure calls, and triggers.

Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)