logo

CuriousTab

CuriousTab

Discussion

Home ‣ Database ‣ Distributed Databases Comments
  • Question

  • The problem of concurrency control is more complex in a distributed database.


  • Options
  • A. True
  • B. False

  • Correct Answer
  • True 

    • Distributed Databases problems

    Search Results

    • 1. The purpose of timestamping is to avoid the use of locks.

    • Options
    • A. True
    • B. False
      • Discuss
    • 2. A distributed unit of work allows various statements within a unit of work to refer to multiple remote DBMS locations.

    • Options
    • A. True
    • B. False
      • Discuss
    • 3. Databases that are stored on computers at multiple locations and are not interconnected by a network are known as distributed databases.

    • Options
    • A. True
    • B. False
      • Discuss
    • 4. Synchronization for pull replication is less disruptive and occurs only when needed by each site, not when a central master site thinks it is best to update.

    • Options
    • A. True
    • B. False
      • Discuss
    • 5. Periodic data are data that are physically altered once added to the store.

    • Options
    • A. True
    • B. False
      • Discuss
    • 6. An increasingly popular option for data distribution as well as for fault tolerance of any database is to store a separate copy of the database at each of two or more sites.

    • Options
    • A. True
    • B. False
      • Discuss
    • 7. Asynchronous technology can result in unsatisfactorily slow response time because the distributed DBMS is spending considerable time checking that an update is accurately and completely propagated across the network.

    • Options
    • A. True
    • B. False
      • Discuss
    • 8. In a semijoin, only the joining attribute is sent from one site to another, and then only the required rows are returned.

    • Options
    • A. True
    • B. False
      • Discuss
    • 9. With failure transparency, all of the actions of a transaction are committed or none of them are committed.

    • Options
    • A. True
    • B. False
      • Discuss
    • 10. Data replication is favored where most process requests are read-only and where the data are relatively static.

    • Options
    • A. True
    • B. False
      • Discuss

    Comments

    There are no comments.
Enter a new Comment




Aptitude

Engineering

Programming

Reasoning

Links

Copyright ©CuriousTab. All rights reserved.