remote transaction-distributed transaction-two-phased commit -Interview QA
Q: What is the difference between remote transaction and distributed
transaction? Which requires a two-phased commit??
A: A remote transaction contains one or more statements which ALL reference
the same remote database. The transaction processing is all done on the
Remote Database Server.
A distributed transaction contains statements that modify data in TWO or more
distinct databases. Some communications protocol is necessary such as TCP/IP.
SQL*Net is most likely (or is likely) needed to allow communication between
the two or more different instances. An Update, Delete, or Insert takes place
on more than one tables, on more than one Remote Servers.
A distributed transaction requires a two-phase commit.
Filed under: DBA (DataBase Administrator), ERP, Interview Questions(& answers), PL/SQL, SQL
Free Dashboards
Here are some more interesting ArticlesOne Response to “remote transaction-distributed transaction-two-phased commit -Interview QA”
Leave a Reply
You must be logged in to post a comment.
[…] Marketing Idea | Internet Marketing Marketing Strategies Marketing Resources wrote an interesting post today onHere’s a quick excerpt Q: What is the difference between remote transaction and distributed transaction? Which requires a two-phased commit?? A: A remote transaction contains one or more statements which ALL reference the same remote database. The transaction processing is all done on the Remote Database Server. A distributed transaction contains statements that modify data in TWO or more distinct databases. Some communications protocol is necessary such as TCP/IP. SQL*Net is most likely (or is likely) needed […]