Home / CSE / Database System 2 - CS :: Data and Database Administration

CSE :: Database System 2 - CS

  1. Information repositories are replacing data dictionaries in many organizations.

  2. A.

     True

    B.

     False

    View Answer

    Workspace

    Discuss Discuss in Forum


  3. Mirrored databases are almost always provided in high-availability systems.

  4. A.

     True

    B.

     False

    View Answer

    Workspace

    Discuss Discuss in Forum


  5. Databases are not the property of a single function or individual within the organization.

  6. A.

     True

    B.

     False

    View Answer

    Workspace

    Discuss Discuss in Forum


  7. Queries that do full table scans should be avoided.

  8. A.

     True

    B.

     False

    View Answer

    Workspace

    Discuss Discuss in Forum


  9. The restore/rerun technique involves reprocessing the day's transactions up to the point of failure.

  10. A.

     True

    B.

     False

    View Answer

    Workspace

    Discuss Discuss in Forum


  11. Backward recovery is used to reverse the changes made by transactions that have aborted, or terminated abnormally.

  12. A.

     True

    B.

     False

    View Answer

    Workspace

    Discuss Discuss in Forum


  13. A disaster recovery plan does not need to include the shipment of database backups to other sites.

  14. A.

     True

    B.

     False

    View Answer

    Workspace

    Discuss Discuss in Forum


  15. With concurrent processing involving updates, a database with concurrency control will be compromised due to interference between users.

  16. A.

     True

    B.

     False

    View Answer

    Workspace

    Discuss Discuss in Forum


  17. Data modeling and database design are key responsibilities of data and data base administration.

  18. A.

     True

    B.

     False

    View Answer

    Workspace

    Discuss Discuss in Forum


  19. Incorrect data is easy to detect.

  20. A.

     True

    B.

     False

    View Answer

    Workspace

    Discuss Discuss in Forum