1.Which of the following best defines a distributed database management system (DDBMS)?

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?

Increased operating costs

3. Which component of distributed database management systems (DDBMS) may be a centralized DBMS?

Data manager

4. Which of the following is not a level of data and process distribution?

Single-site processing, multiple-site data

5. Which of the following statements is false?

Distribution transparency allows a distributed database to be treated as a single physical database.

6. Which of the following statements is false?

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?

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?

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 fully replicated database stores multiple copies of each database fragment at multiple sites.

10. What does the acronym CAP in distributed computing stand for?

Consistency, Availability, and Partition tolerance

Chapter 12 Use It

1.A library system has three offices: A) a central administrative office, B) the book circulation desk, and C) the media circulation desk. The database is distributed so that patrons who check out primarily books are stored in a fragment with the book information and that the patrons who check out primarily media are stored with the media records.

A query was executed at the central office for a list of all patrons who have any type of material that is past due. Complete the distributed transaction diagram including the database tables and fragments and whether the workstation is the Transaction Processor (TP) or Data Processor (DP).