Local Transaction & Distributed Transaction difference - ADO.NET

Q.   What is the difference between a Local Transaction and a Distributed Transaction?
- Published on 28 Jul 15

a. Local transactions are performed on a single database table, but distributed transactions are performed on more than one database tables.
b. Local transactions are performed on a single database server, but distributed transactions can be performed across multiple database servers.
c. Local transactions are performed on a database on the local machine, but distributed transactions are performed on a database on a remote machine.
d. None of the above.

ANSWER: Local transactions are performed on a single database server, but distributed transactions can be performed across multiple database servers.

Related Content

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