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

Discussion

A heterogeneous distributed database is which of the following?

  • A.The same DBMS is used at each location and data are not distributed across all nodes.
  • B.The same DBMS is used at each location and data are distributed across all nodes.
  • C.A different DBMS is used at each location and data are not distributed across all nodes.
  • D.A different DBMS is used at each location and data are distributed across all nodes.

Answer: D

Correct answer: A different DBMS is used at each location and data are distributed across all nodes.

Heterogeneous means the sites run different products, and the difficulty is exactly that: differing SQL dialects, data types, transaction models and catalogue structures must be reconciled before a single query can span them. Homogeneity is easier to manage but is often not available, since sites arrive through acquisition and separate history.

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

Post your comment

Please log in or register to post a comment.