DBMS-Distributed Database Systems Questions and Answers
Distributed Database questions with answers form an integral part of DBMS aptitude tests, especially for engineering and placement exams. A distributed database manages data stored across multiple locations, ensuring consistency and reliability in a connected environment. This set of aptitude questions and answers with explanations helps candidates grasp concepts like data fragmentation, replication, and concurrency control. Practicing distributed database aptitude questions with solutions PDF enables students to prepare effectively for TCS, Infosys, and Capgemini tests. Understanding distributed database principles not only strengthens academic knowledge but also builds the analytical thinking needed for real-world software systems.
Questions on distributed database management. Complement with database system architecture and database recovery systems
DBMS-Distributed Database Systems
11. In heterogeneous DDBS, different sites run under the control of different DBMSs, essentially automously and are connected somehow to enable access to data from multiple sites.
- TRUE
- FALSE
12. A distributed database system allows applications to access data from local and remote databases.
- TRUE
- FALSE
13. Homogeneous database systems have well-accepted standards for gateway protocols to expose DBMS functionality to external applications.
- TRUE
- FALSE
15. In the client/server architecture, client is the provider of the resource whereas the server is a user of the resource.
- TRUE
- FALSE
16. The client/server architecture does not allow a single query to span multiple servers.
- TRUE
- FALSE
17. A horizontal fragmentation is produced by spcifying a predicate that performs a restriction on the tuples in the relation.
- TRUE
- FALSE
18. Data replication is used to improve the local database performance and protect the availability of applications.
- TRUE
- FALSE
19. Transparrency in data replication makes the user unaware of the xistence of the copies.
- TRUE
- FALSE
20. The server is the machine that runs the DBMS softweare and handles the functions required for concurrent, shared data access.
- TRUE
- FALSE