Condition applied while determining commit point site - Oracle Transaction

Q.  Which condition is applied while determining the commit point site?
- Published on 04 Aug 15

a. A read-only node can be the commit point site
b. If multiple nodes directly referenced by the global coordinator have the same commit point strength, then the database designates one of these as the commit point site
c. If a distributed transaction starts with a rollback, then the prepare and commit phases are not needed
d. None of the above

ANSWER: If multiple nodes directly referenced by the global coordinator have the same commit point strength, then the database designates one of these as the commit point site
 

    Discussion

  • Nirja Shah   -Posted on 22 Sep 15
    - The following conditions apply when determining the common point site

    1. A read-only node can be the commit point site.

    2. If multiple nodes directly referenced by the global coordinator have the same commit point strength, then the database designates one of these as the commit point site.

    3. if a distributed transaction ends with a rollback, then the prepare and commit phases are not needed. Consequently, the database never determines a commit point site. Instead,the global coordinator sends a ROLLBACK statement to all nodes and ends the processing of the distributed transaction.

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