WAEC Data Processing 2016 Question 40

Question 40

Distributed and Parallel Databases

Which of the following defines a heterogeneous distributed database?

  1. A.Same DBMS is used at each location but data are not distributed across all nodes
  2. B.Same DBMS is used at each location with data distributed across all nodes
  3. C.Different DBMS is used at each location and data are not distributed across all nodes
  4. D.Different DBMS is used at each location and data are distributed across all nodes
Show the answer and explanation

Answer: D (Different DBMS is used at each location and data are distributed across all nodes)

Explanation

Heterogeneous means the sites use different DBMSs; distributed means the data is spread across the nodes.