Difficulty: Easy
Correct Answer: Incorrect
Explanation:
Introduction / Context:Distributed databases coordinate a single logical database across multiple networked sites. This question tests whether merely having databases in many places—without networking—meets the definition of “distributed.”
Given Data / Assumptions:
Concept / Approach:Distribution implies coordination. A distributed DBMS provides a unified interface, concurrency control, and recovery across nodes. Physically separated but unconnected databases are simply independent databases, not parts of a distributed database. Tape/drive sneaker-net copies do not create distribution; they create replicas or backups without online coordination.
Step-by-Step Solution:
Check for a single logical schema spanned across sites.Verify network connectivity enabling distributed query, concurrency, and recovery.If absent, recognize the systems as separate, not distributed.Add a distributed layer (e.g., sharding, replication) to achieve true distribution.Verification / Alternative check:Run a cross-site transaction. If there is no facility for two-phase commit, distributed queries, or global catalogs, the environment is not a distributed database.
Why Other Options Are Wrong:
Common Pitfalls:Assuming offsite backups form a distributed DB; they do not provide distributed concurrency or transparency.
Final Answer:Incorrect
Discussion & Comments