logo

CuriousTab

CuriousTab

Discussion


Home Database Managing Multiuser Databases Comments

  • Question
  • Resource locking is a process to prevent multiple applications from obtaining copies of the same record when the record is about to be changed.


  • Options
  • A. True
  • B. False

  • Correct Answer
  • True 


  • Managing Multiuser Databases problems


    Search Results


    • 1. The goal of database security is to ensure that only authorized users can perform authorized activities at authorized times.

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

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

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

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

    • Options
    • A. True
    • B. False
    • Discuss
    • 6. In optimistic locking, the assumption is made that conflict will occur.

    • Options
    • A. True
    • B. False
    • Discuss
    • 7. When one transaction reads a changed record that has not been committed to the database a filthy read occurs.

    • Options
    • A. True
    • B. False
    • Discuss
    • 8. The transaction log contains a copy of every database record (or page) after it has changed. These records are called before images.

    • Options
    • A. True
    • B. False
    • Discuss
    • 9. The lost update problem is when User A reads data that have been processed by a portion of a transaction from User B.

    • Options
    • A. True
    • B. False
    • Discuss
    • 10. Locks placed by the DBMS are explicit locks.

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


    Comments

    There are no comments.

Enter a new Comment