Distributed transaction contains statements that access more than one node

Q.  Which transaction contains statements that access more than one node?
- Published on 12 Aug 15

a. A Remote Transaction
b. A Distributed transaction
c. Both A & B
d. None of the above

ANSWER: A Distributed transaction
 

    Discussion

  • Nirja Shah   -Posted on 21 Sep 15
    - A transaction is a logical unit of work constituted by one or more SQL statements executed by a single user.

    - A transaction begins with the user's first executable SQL statement and ends when it is committed or rolled back by that user.

    - A remote transaction contains only statements that access a single remote node.

    - A distributed transaction contains statements that access more than one node.

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