Database - Distrubuted Database

Database - Distrubuted Database
1. A distributed database has which of the following advantages over a centralized database?
  • Software cost
  • Software complexity
  • Slow Response
  • Modular growth
Show Answer
2. An autonomous homogenous environment is which of the following?
  • The same DBMS is at each node and each DBMS works independently.
  • The same DBMS is at each node and a central DBMS coordinates database access.
  • A different DBMS is at each node and each DBMS works independently.
  • A different DBMS is at each node and a central DBMS coordinates database access.
Show Answer
3. A transaction manager is which of the following?
  • Maintains a log of transactions
  • Maintains before and after database images
  • Maintains appropriate concurrency control
  • All of the above.
Show Answer
4. Location transparency allows for which of the following?
  • Users to treat the data as if it is at one location
  • Programmers to treat the data as if it is at one location
  • Managers to treat the data as if it is at one location
  • All of the above.
Show Answer
5. A heterogeneous distributed database is which of the following?
  • The same DBMS is used at each location and data are not distributed across all nodes.
  • The same DBMS is used at each location and data are distributed across all nodes.
  • A different DBMS is used at each location and data are not distributed across all nodes.
  • A different DBMS is used at each location and data are distributed across all nodes
Show Answer
6. Some of the columns of a relation are at different sites is which of the following?
  • Data Replication
  • Horizontal Partitioning
  • Vertical Partitioning
  • Horizontal and Vertical Partitioning
Show Answer
7.  Which of the following is true concerning a global transaction?
  • The required data are at one local site and the distributed DBMS routes requests as necessary.
  • The required data are located in at least one nonlocal site and the distributed DBMS routes requests as necessary.
  • The required data are at one local site and the distributed DBMS passes the request to only the local DBMS.
  • The required data are located in at least one nonlocal site and the distributed DBMS passes the request to only the local DBMS.
Show Answer
8.  A homogenous distributed database is which of the following?
  • The same DBMS is used at each location and data are not distributed across all nodes.
  • The same DBMS is used at each location and data are distributed across all nodes.
  • A different DBMS is used at each location and data are not distributed across all nodes.
  • A different DBMS is used at each location and data are distributed across all nodes
Show Answer
9. Replication should be used when which of the following exist?
  • When transmission speeds and capacity in a network prohibit frequent refreshing of large tables.
  • When using many nodes with different operating systems and DBMSs and database designs.
  • The application's data can be somewhat out-of-date.
  • All of the above.
Show Answer
10. Storing a separate copy of the database at multiple locations is which of the following?
  • Data Replication
  • Horizontal Partitioning
  • Vertical Partitioning
  • Horizontal and Vertical Partitioning
Show Answer
Database
Questions and Answers for Competitive Exams Various Entrance Test