B.A collection of autonomous databases that appear as one
C.A database that only stores metadata
D.A database that is only accessible through APIs
Solution
A federated database system is a collection of autonomous databases that appear as one, allowing for distributed data access while maintaining individual database autonomy.
Correct Answer: B — A collection of autonomous databases that appear as one
Q. What is the role of a transaction manager in a distributed database?
A.To manage data replication
B.To ensure ACID properties across distributed transactions
C.To handle user authentication
D.To optimize query performance
Solution
The transaction manager in a distributed database ensures that ACID properties (Atomicity, Consistency, Isolation, Durability) are maintained across distributed transactions.
Correct Answer: B — To ensure ACID properties across distributed transactions
Q. Which of the following is a method for concurrency control in distributed databases?
A.Two-phase locking
B.Data sharding
C.Indexing
D.Data warehousing
Solution
Two-phase locking is a method for concurrency control in distributed databases that helps prevent conflicts when multiple transactions access the same data.