Home / CSE / Database System 2 - CS :: Database Redesign

CSE :: Database System 2 - CS

  1. The SQL-92 command to change a table name is RENAME TABLE.

  2. A.

     True

    B.

     False

    View Answer

    Workspace

    Discuss Discuss in Forum


  3. Reverse engineering is the process of reading a database schema and producing a data model from that schema.

  4. A.

     True

    B.

     False

    View Answer

    Workspace

    Discuss Discuss in Forum


  5. The data model produced from the reverse engineering process is a true logical model.

  6. A.

     True

    B.

     False

    View Answer

    Workspace

    Discuss Discuss in Forum


  7. It is not easy to build a database correctly the first time.

  8. A.

     True

    B.

     False

    View Answer

    Workspace

    Discuss Discuss in Forum


  9. Typically, there should be at least two different copies of the database schema used in the redesign process.

  10. A.

     True

    B.

     False

    View Answer

    Workspace

    Discuss Discuss in Forum


  11. Information systems and organizations do not just influence each other; they create each other.

  12. A.

     True

    B.

     False

    View Answer

    Workspace

    Discuss Discuss in Forum


  13. Adding null columns to a table is straightforward.

  14. A.

     True

    B.

     False

    View Answer

    Workspace

    Discuss Discuss in Forum


  15. The NOT EXISTS keyword will be true if any row in the subquery meets the condition.

  16. A.

     True

    B.

     False

    View Answer

    Workspace

    Discuss Discuss in Forum


  17. Dependency graphs are diagrams that consist of nodes and arcs that show the dependencies of a database.

  18. A.

     True

    B.

     False

    View Answer

    Workspace

    Discuss Discuss in Forum


  19. The EXISTS keyword will be true if any row in the subquery meets the condition.

  20. A.

     True

    B.

     False

    View Answer

    Workspace

    Discuss Discuss in Forum