Week 14

1. Which of the following is not a goal of distributed data? a. Decreased communication costs b. Increased corporate control over data c. Increased data availability d. Increased performance 2. Which of the following is true? a. There is only one coordinator for each transaction in the two-phase commit protocol. b. In distributed processing, transactions do not necessarily have to conform to all of the ACID properties. c. When the primary copy protocol is used for replicated data, secondary copies are updated at the same time as the primary copy to the keep the database consistent. d. All of the above. 3. An overriding design issue in client-server database architecture is a. Number of clients b. Number of servers c. Division of processing d. Choice of hardware for client 4. In a distributed DBMS, the distributed data manager: a. Optimizes global query execution b. Coordinates global concurrency control c. Coordinates recovery from failures across all sites d. All of the above 5. Which of the following is not true? a. The two-phase commit protocol involves a voting phase, a decision, and a wrap-up phase, which must be coordinated by a central coordinator site. b. Two-phase commit to determine the fate of a transaction updating data at multiple sites in a distributed database. c. Two-phase commit should only be used with two-phase locking. d. All of the above