All of the following are true of a centralized database on a network, except ____.
A) the site with the database can become a bottleneck
B) there is no need for a distributed directory since all of the data is in one place
C) the single site arrangement provides a high degree of security, concurrency, and backup and recovery control
D) all data accesses from other than the site with the database incur telecommunications costs
E) it uses a two-phase commit process

Question

Quizplus · Accepted Answer

A centralized database does not inherently use a two-phase commit process. The two-phase commit is a protocol primarily used in distributed database systems to ensure all parts of a transaction are committed across all nodes or none at all, ensuring data consistency. Centralized databases, being located in a single site, do not require this mechanism for managing transactions across multiple locations.

All of the Following Are True of a Centralized Database