logo

CuriousTab

CuriousTab

Discussion


Home Database Distributed Databases Comments

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

  • Correct Answer
  • Unit of work 


  • Distributed Databases problems


    Search Results


    • 1. 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
    • 2. 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
    • 3. 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
    • 4. 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
    • 5. 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
    • 6. A distributed database can use which of the following strategies?

    • Options
    • A. Totally centralized at one location and accessed by many sites
    • B. Partially or totally replicated across sites
    • C. Partitioned into segments at different sites
    • D. All of the above
    • Discuss
    • 7. The keyword "inverse" is used in which of the following?

    • Options
    • A. Class
    • B. Attribute
    • C. Relationship
    • D. All of the above.
    • Discuss
    • 8. The reserved word enum is used for which of the following?

    • Options
    • A. To define a range for an attribute.
    • B. To define a range for a class.
    • C. To define a range for a relationship.
    • D. All of the above.
    • Discuss
    • 9. Which of the following is an unordered collection of elements that may contain duplicates?

    • Options
    • A. Set
    • B. Bag
    • C. List
    • D. Dictionary
    • Discuss
    • 10. A relationship should be specified how in the ODL?

    • Options
    • A. One direction starting with the first class
    • B. One direction starting with the second class
    • C. Neither direction.
    • D. Both directions.
    • Discuss


    Comments

    There are no comments.

Enter a new Comment