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
41. Data allocation is a
- technique of breaking up the database into logical units, which may be assigned for storage at the various sites
- process of deciding about locating (or placing) data to several sites.
- technique that permits storage of certain data in more than one site.
- None of these.
42. Data rreplication is a
- Technique of breaking up the database into logical units, which may be assigned for storage at the various sites.
- process of deciding about locating (or placing) data to severall sites.
- technique that permits storage of certain data in more than one site.
- None of these
43. Which of the following refers to the operation of copying and maintaining database objects in multiple database belonging to a distributed system ?
- Replication
- Backup
- Recovery
- None of these
44. In distributed query processing, semijoin operation is used to
- reduce the size of a relation that needs to be transmitted.
- reduce the communication costs.
- Both (a) and (b)
- None of these
45. Which of the following is the function of a distibutted DBMS ?
- Distributed data recovery
- Distributed query processing
- Replicated data management
- All of these