DBMS-Distributed Database 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.