Machine-translated by Google. Questions are authored in English.
Top

Discussion

Which of the following is true concerning a global transaction?

  • A.The required data are at one local site and the distributed DBMS routes requests as necessary.
  • B.The required data are located in at least one nonlocal site and the distributed DBMS routes requests as necessary.
  • C.The required data are at one local site and the distributed DBMS passes the request to only the local DBMS.
  • D.The required data are located in at least one nonlocal site and the distributed DBMS passes the request to only the local DBMS.

Answer: B

Correct answer: The required data are located in at least one nonlocal site and the distributed DBMS routes requests as necessary.

A transaction is global when it needs data from beyond its own site, and the distributed DBMS then decomposes it and routes the pieces to wherever the data lives. A local transaction is satisfied entirely at one site and needs no such routing - the distinction that decides how much coordination the transaction costs.

No comment is present. Be the first to comment.
Loading…

Post your comment

Please log in or register to post a comment.