Which of the following is a disadvantage of a centralized database ?

2025

Which of the following is a disadvantage of a centralized database ?

Answer: C. It may lead to a single point of failureA centralized database stores all data in a single location, which simplifies management but introduces significant risks. The primary disadvantage is that it…

  1. A.

    It can be more secure due to limited access

  2. B.

    It provides real-time data consistency

  3. C.

    It may lead to a single point of failure

  4. D.

    It can be easily scaled

Attempted by 1023 students.

Show answer & explanation

Correct answer: C

A centralized database stores all data in a single location, which simplifies management but introduces significant risks. The primary disadvantage is that it creates a single point of failure; if the central server crashes or suffers network issues, the entire system becomes inaccessible to all users. This contrasts with distributed systems where redundancy ensures continuity.\nOption A is incorrect because while centralized access can enhance security through strict controls, it is not inherently a disadvantage. Option B describes an advantage, as centralized databases typically ensure real-time consistency across all records without complex synchronization. Option D is also an advantage in some contexts, though scaling a single server has limits compared to distributed architectures. Ultimately, the vulnerability of relying on one central node makes Option C the correct answer regarding disadvantages.

Explore the full course: Tpsc Assistant Technical Officer

Loading lesson…