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 a major disadvantage of distributed databases?
A.
Increased data availability
B.
Higher complexity in management
C.
Improved performance
D.
Reduced data redundancy
Solution
A major disadvantage of distributed databases is the higher complexity in management due to the need to coordinate multiple nodes and ensure data consistency.
Correct Answer:
B
— Higher complexity in management
Q. What is the main challenge of concurrency control in distributed databases?
A.
Ensuring data is stored in a single location
B.
Managing transactions across multiple nodes
C.
Reducing the size of the database
D.
Simplifying the database schema
Solution
The main challenge of concurrency control in distributed databases is managing transactions across multiple nodes to prevent conflicts and ensure data integrity.
Correct Answer:
B
— Managing transactions across multiple nodes
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 common method for achieving data consistency in distributed databases?
A.
Two-phase commit protocol
B.
Single-phase commit protocol
C.
Data normalization
D.
Indexing
Solution
The two-phase commit protocol is a common method used to achieve data consistency in distributed databases by ensuring all nodes agree on a transaction before it is committed.
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.