DBMS-Distributed Database 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
Show Answer
12. A distributed database system allows applications to access data from local and remote databases.
  • TRUE
  • FALSE
Show Answer
13. Homogeneous database systems have well-accepted standards for gateway protocols to expose DBMS functionality to external applications.
  • TRUE
  • FALSE
Show Answer
14. Distributed database do not use client/server architecture.
  • TRUE
  • FALSE
Show Answer
15. In the client/server architecture, client is the provider of the resource whereas the server is a user of the resource.
  • TRUE
  • FALSE
Show Answer
16. The client/server architecture does not allow a single query to span multiple servers.
  • TRUE
  • FALSE
Show Answer
17. A horizontal fragmentation is produced by spcifying a predicate that performs a restriction on the tuples in the relation.
  • TRUE
  • FALSE
Show Answer
18. Data replication is used to improve the local database performance and protect the availability of  applications.
  • TRUE
  • FALSE
Show Answer
19. Transparrency in data replication makes the user unaware of the xistence of the copies.
  • TRUE
  • FALSE
Show Answer
20. The server is the machine that runs the DBMS softweare and handles the functions required for concurrent, shared data access.
  • TRUE
  • FALSE
Show Answer
Database
Questions and Answers for Competitive Exams Various Entrance Test