A replicated database is appropriate when
A)there is minimal data sharing among information processing units
B)there exists a high degree of data sharing and no primary user
C)there is no risk of the deadlock phenomenon
D)most data sharing consists of read-write transactions

Question

Quizplus · Accepted Answer

Replicated databases are suitable when there is a high degree of data sharing, and there is no primary user. This helps in reducing network traffic and improving availability and response times. Replication can also improve fault tolerance by providing redundancy. Therefore, option B is the correct choice. Option A is incorrect because minimal data sharing does not require replication. Option C is also incorrect because the risk of deadlock exists in all distributed databases, including replicated databases. Option D is incorrect because read-only transactions do not require replication, and replication is more useful for read-write transactions.

A Replicated Database Is Appropriate When