ITPEC FE Subject A October 2025 Question 20
Which of the following is an appropriate description of distributed database?
Explanation
Parts stored in different locations, with processing distributed across them — a distributed database is physically split but used as one database.
A distributed database divides its data among sites connected by a network, by splitting tables, copying them, or both, and each site processes its own part. Users and applications still see one logical database and need not know where each piece is stored (location transparency).
Answer (d)
Why not others:
- •(a) — one database server shared by users around the world is a centralised database with distributed users
- •(b) — describes publishing data for others to use, not how a database is organised
- •(c) — distribution and data model are independent: relational databases can be distributed, and a NoSQL database may run on one server
Key rule: "Distributed" describes where the data is stored and processed, not who uses it or which data model it has.
Databases · AI-written, may contain errors
This question comes from an official ITPEC past paper. ITPEC Practice is an independent study tool and is not affiliated with ITPEC. See the official FE past-paper collection or Report an issue.