Two-phase commit - Completely transparent to users who issue Distributed transactions - Oracle Transaction

Q.  Two-phase commit mechanism is completely transparent to users who issue _________________ .
- Published on 27 Jul 15

a. Commit a transaction
b. Rollback a transaction
c. Non distributed transactions
d. Distributed transactions

ANSWER: Distributed transactions

Related Content

 

    Discussion

  • Nirja Shah   -Posted on 23 Sep 15
    - The Oracle two-phase commit mechanism is completely transparent to users who issue distributed transactions.

    - In fact, users need not even know the transaction is distributed.

    - A COMMIT statement denoting the end of a transaction automatically triggers the two-phase commit mechanism to commit the transaction.

    - No coding or complex statement syntax is required to include distributed transactions within the body of a database application.

➨ 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.)
▲