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
1. In a distributed database system, each site is typically managed by a DBMS that is dependent on the other sites
- TRUE
- FALSE
2. Distributed database systems arose from the need to offer local database autonomy at gegraphially distributed locations.
- TRUE
- FALSE
3. Distributed database systems arose from the need to offer local database autonomy at gegraphially distributed locations.
- TRUE
- FALSE
4. The main aim of client/server architecture is to utilise the processing power on the desktop while retaining the best aspects of centralised data processing.
- TRUE
- FALSE
5. Distribued transaction atomicity property enables users to ask queries without specifying where the reference relations, or copies or frangments of the relations, are located.
- TRUE
- FALSE
6. Distributed data independence property enables users to write transactions that access and update data at several sites just as they would write transactions over purily local data.
- TRUE
- FALSE
7. Distributed data independence property enables users to write transactions that access and update data at several sites just as they would write transations over purely local data.
- TRUE
- FALSE
8. Although geographically dispersed, a distributed database system manages and controls the entire database as single collection of data
- TRUE
- FALSE
9. Although geographically dispersed, a distributed database system manages and controls the entire database as a single collection of data
- TRUE
- FALSE
10. In homogeneous DDBS, there are several sites, each running their own applications on the same DBMS software.
- TRUE
- FALSE