logo

CuriousTab

CuriousTab

Discussion

Home ‣ Database ‣ Managing Multiuser Databases Comments
  • Question

  • Locks placed by command are implicit locks.


  • Options
  • A. True
  • B. False

  • Correct Answer
  • False 

    • Managing Multiuser Databases problems

    Search Results

    • 1. Database administration refers to a function that applies to the entire organization.

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

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

    • Options
    • A. True
    • B. False
      • Discuss
    • 4. An ACID transaction is one that is atomic, consistent isolated, and durable.

    • Options
    • A. True
    • B. False
      • Discuss
    • 5. The size of the lock is referred to as the lock granularity.

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

    • Options
    • A. True
    • B. False
      • Discuss
    • 7. 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
    • 8. 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
      • Discuss
    • 9. In optimistic locking, the assumption is made that conflict will occur.

    • Options
    • A. True
    • B. False
      • Discuss
    • 10. 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

    Comments

    There are no comments.
Enter a new Comment




Aptitude

Engineering

Programming

Reasoning

Links

Copyright ©CuriousTab. All rights reserved.