All of the Following Are True When There Is Targeted

question 43

Multiple Choice

All of the following are true when there is targeted data replication on a distributed database network, except ____.

• A) there is no need for distributed joins because one site must have a copy of the entire database
• B) a two-phase commit is necessary if all of the replicated copies of a table must be kept up-to-date all of the time
• C) there is improved availability because of the data replication
• D) communications costs for read-only data access are reduced because copies of tables can be located at multiple sites that most heavily use them
• E) it requires a distributed directory

---

Definitions:

Positive Externalities

Benefits that are enjoyed by a third-party or the broader society as a result of an economic transaction or activity, without them directly participating in it.

Public Good

A good or service that is characterized by nonrivalry and nonexcludability. These characteristics typically imply that no private firm can break even when attempting to provide such products. As a result, they are often provided by governments, who pay for them using general tax revenues.

Federal Government

The national government of a federated state, which shares sovereignty with its subnational entities and is typically responsible for national defense, foreign affairs, and federal law.

Marginal Benefit

The increase in satisfaction or utility that a person receives from consuming an additional unit of a good or service.