logo

CuriousTab

CuriousTab

Discussion


Home Database Managing Multiuser Databases Comments

  • Question
  • An ACID transaction is one that is atomic, consistent isolated, and durable.


  • Options
  • A. True
  • B. False

  • Correct Answer
  • True 


  • Managing Multiuser Databases problems


    Search Results


    • 1. The size of the lock is referred to as the lock granularity.

    • Options
    • A. True
    • B. False
    • Discuss
    • 2. When two transactions are being processed against the database at the same time they are termed concurrent transactions.

    • Options
    • A. True
    • B. False
    • Discuss
    • 3. The overall responsibility of the DBA is to facilitate the development and use of the database.

    • Options
    • A. True
    • B. False
    • Discuss
    • 4. A transaction is a series of actions to be taken on the database so that either all of them are performed successfully or none of them are performed at all.

    • Options
    • A. True
    • B. False
    • Discuss
    • 5. A phantom read occurs when a transaction rereads data it has previously read and finds modifications or deletions caused by a committed transaction.

    • Options
    • A. True
    • B. False
    • Discuss
    • 6. A durable transaction is one in which all committed changes are permanent.

    • Options
    • A. True
    • B. False
    • Discuss
    • 7. An exclusive lock locks the item from change but not from read.

    • Options
    • A. True
    • B. False
    • Discuss
    • 8. Database administration refers to a function that applies to the entire organization.

    • Options
    • A. True
    • B. False
    • Discuss
    • 9. Locks placed by command are implicit locks.

    • Options
    • A. True
    • B. False
    • Discuss
    • 10. The size of a lock is referred to as lock sizing.

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


    Comments

    There are no comments.

Enter a new Comment