Multiple Choice
All of the following are principles of data replication in a distributed database network, except ____.
A) place a copy of every table at a central node to avoid having a bottleneck
B) place copies of tables at the sites that use them most heavily in order to minimize telecommunications costs
C) ensure that there are at least two copies of important or frequently used tables to realize the gains in availability
D) limit the number of copies of any one table to control the security and concurrency issues
E) avoid any one site becoming a bottleneck to maintain performance
Correct Answer:

Verified
Correct Answer:
Verified
Q14: In one use of the term three-tier
Q15: Horizontal partitioning is advisable on a distributed
Q16: The commit phase is the first phase
Q17: One use of the term three-tier approach
Q18: Partitioned tables in a distributed database network
Q20: In a three-tier approach to client/server database
Q21: An advantage of a centralized database is
Q22: In the commit phase of the two-phase
Q23: Distributed data with no replication provides a
Q24: All of the following are true about