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
31. The main components of the client/server architecture is
- communication networks
- server
- application softwares
- All of these
32. Which of the following is not a benefit of client/server architecture ?
- Reduction in operating cost
- Adaptablility
- Platform independence
- None of these
33. Which of the following are the components of DDBS ?
- Communication network
- Server
- Client
- All of these
34. Which of the computing architecture is used by DDBS
- Client/Server computing
- Mainframe computing
- Personal computing
- None of these
35. In collaborating server architecture.
- there are several database servers.
- Each server is capable of running transactions against local data.
- Transactions are executed spannng multiple servers.
- All of these.
36. The middleware database architecture
- is designed to allow single query to span multiple servers.
- provides users with a consistent interface to multiple DBMSs and file systems in a transparent manner.
- provides users with a means of accessing live data in multiple sources.
- All of these
37. Data ragmentation 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.
38. A horizontal fragmentation is produced by specifying a
- predicate operation of relational algebra.
- projection operation of relational algebra.
- selection and projection operations of relational algebra.
- None of these.
39. A vertical fragmentation is produced by specifying a
- predicate operation of relational algebra.
- projection operation of relational algebra.
- selection and projection operations of relational jalgebra.
- None of these.
40. A mied ragmentation is produced by specifying a
- predicate operation of relational algebra.
- projection operation of relationalj algebra.
- selection and projection operations of relationalj algebra.
- None of these.