1.Which of the following best defines a distributed database management system (DDBMS)?
A) DDBMS governs the storage and processing of logically related data over interconnected computer systems in which both data and processing functions are distributed among several sites.
2. Which of the following is NOT an advantage of distributed database management systems?
A) Increased operating costs
3. Which component of distributed database management systems (DDBMS) may be a centralized DBMS?
A) Data manager
4. Which of the following is not a level of data and process distribution?
A) Single-site processing, multiple-site data
5. Which of the following statements is false?
A) Distribution transparency allows a distributed database to be treated as a single physical database.
6. Which of the following statements is false?
A) Coordinator is a data processor (DP) node that participates in a distributed transaction using the two-phase COMMIT protocol.
7. Which of the following is not valid regarding data fragmentation?
A) Horizontal data fragmentation is a process that breaks a table into a subset of columns from the original table.
8. Which of the following statements best defines data replication?
A) Data replication refers to the storage of data copies at multiple sites served by a computer network.
9. Which of the following statements is true?
A) A fully replicated database stores multiple copies of each database fragment at multiple sites.
10. What does the acronym CAP in distributed computing stand for?
A) Consistency, Availability, and Partition tolerance