Discussion
Home ‣ Database ‣ Distributed Databases Comments
- Question
Replication should be used when which of the following exist?
Options- A. When transmission speeds and capacity in a network prohibit frequent refreshing of large tables.
- B. When using many nodes with different operating systems and DBMSs and database designs.
- C. The application's data can be somewhat out-of-date.
- D. All of the above.
- Correct Answer
- The application's data can be somewhat out-of-date.
- 1. A distributed database is which of the following?
Options- A. A single logical database that is spread to multiple locations and is interconnected by a network
- B. A loose collection of file that is spread to multiple locations and is interconnected by a network
- C. A single logical database that is limited to one location.
- D. A loose collection of file that is limited to one location. Discuss
- 2. A transaction manager is which of the following?
Options- A. Maintains a log of transactions
- B. Maintains before and after database images
- C. Maintains appropriate concurrency control
- D. All of the above. Discuss
- 3. An autonomous homogenous environment is which of the following?
Options- A. The same DBMS is at each node and each DBMS works independently.
- B. The same DBMS is at each node and a central DBMS coordinates database access.
- C. A different DBMS is at each node and each DBMS works independently.
- D. A different DBMS is at each node and a central DBMS coordinates database access. Discuss
- 4. A multifield transformation does which of the following?
Options- A. Converts data from one field into multiple fields
- B. Converts data from multiple fields into one field
- C. Converts data from multiple fields into multiple fields
- D. All of the above Discuss
- 5. The load and index is which of the following?
Options- A. A process to reject data from the data warehouse and to create the necessary indexes
- B. A process to load the data in the data warehouse and to create the necessary indexes
- C. A process to upgrade the quality of data after it is moved into a data warehouse
- D. A process to upgrade the quality of data before it is moved into a data warehouse Discuss
- 6. Which of the following is a disadvantage of replication?
Options- A. Reduced network traffic
- B. If the database fails at one site, a copy can be located at another site.
- C. Each site must have the same storage capacity.
- D. Each transaction may proceed without coordination across the network. Discuss
- 7. A homogenous distributed database is which of the following?
Options- A. The same DBMS is used at each location and data are not distributed across all nodes.
- B. The same DBMS is used at each location and data are distributed across all nodes.
- C. A different DBMS is used at each location and data are not distributed across all nodes.
- D. A different DBMS is used at each location and data are distributed across all nodes. Discuss
- 8. Some of the columns of a relation are at different sites is which of the following?
Options- A. Data Replication
- B. Horizontal Partitioning
- C. Vertical Partitioning
- D. Horizontal and Vertical Partitioning Discuss
- 9. Location transparency allows for which of the following?
Options- A. Users to treat the data as if it is at one location
- B. Programmers to treat the data as if it is at one location
- C. Managers to treat the data as if it is at one location
- D. All of the above. Discuss
- 10. A distributed database has which of the following advantages over a centralized database?
Options- A. Software cost
- B. Software complexity
- C. Slow Response
- D. Modular growth Discuss
Distributed Databases problems
Search Results
Correct Answer: A single logical database that is spread to multiple locations and is interconnected by a network
Correct Answer: All of the above.
Correct Answer: The same DBMS is at each node and each DBMS works independently.
Correct Answer: All of the above
Correct Answer: A process to load the data in the data warehouse and to create the necessary indexes
Correct Answer: Each site must have the same storage capacity.
Correct Answer: The same DBMS is used at each location and data are distributed across all nodes.
Correct Answer: Vertical Partitioning
Correct Answer: All of the above.
Correct Answer: Modular growth
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.