logo

CuriousTab

CuriousTab

Discussion


Home Database Distributed Databases Comments

  • Question
  • 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

  • Correct Answer
  • Modular growth 


  • Distributed Databases problems


    Search Results


    • 1. 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
    • 2. 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
    • 3. 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
    • 4. 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
    • 5. 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.
    • Discuss
    • 6. Which of the following is true concerning a global transaction?

    • Options
    • A. The required data are at one local site and the distributed DBMS routes requests as necessary.
    • B. The required data are located in at least one nonlocal site and the distributed DBMS routes requests as necessary.
    • C. The required data are at one local site and the distributed DBMS passes the request to only the local DBMS.
    • D. The required data are located in at least one nonlocal site and the distributed DBMS passes the request to only the local DBMS.
    • Discuss
    • 7. A semijoin is which of the following?

    • Options
    • A. Only the joining attributes are sent from one site to another and then all of the rows are returned.
    • B. All of the attributes are sent from one site to another and then only the required rows are returned.
    • C. Only the joining attributes are sent from one site to another and then only the required rows are returned.
    • D. All of the attributes are sent from one site to another and then only the required rows are returned.
    • Discuss
    • 8. A heterogeneous 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
    • 9. Storing a separate copy of the database at multiple locations is which of the following?

    • Options
    • A. Data Replication
    • B. Horizontal Partitioning
    • C. Vertical Partitioning
    • D. Horizontal and Vertical Partitioning
    • Discuss
    • 10. Which of the following is not one of the stages in the evolution of distributed DBMS?

    • Options
    • A. Unit of work
    • B. Remote unit of work
    • C. Distributed unit of Work
    • D. Distributed request
    • Discuss


    Comments

    There are no comments.

Enter a new Comment