Read-only response - Definition - Oracle Transaction

Q.  When a node is told to prepare, it can respond in several ways, one of the ways is “no data on the node has been or can be modified, so no preparation is necessary”. What is this response called?

- Published on 03 Aug 15

a. Prepared
b. Read-only
c. Abort
d. None of the above

ANSWER: Read-only
 

    Discussion

  • Nirja Shah   -Posted on 22 Sep 15
    - The first phase in committing a distributed transaction is the prepare phase.

    - In this phase, the database does not actually commit or roll back the transaction.

    - Instead, all nodes referenced in a distributed transaction are told to prepare to commit.

    - When a node is told to prepare, it can respond in the following ways:

    1. Prepared - Data on the node has been modified by a statement in the distributed transaction, and the node has successfully prepared.

    2. Read-only - No data on the node has been, or can be, modified (only queried), so no preparation is necessary.

    3. Abort - The node cannot successfully prepare.

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