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


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

  4. A.

     True

    B.

     False


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

  6. A.

     True

    B.

     False


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

  8. A.

     True

    B.

     False


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

  10. A.

     True

    B.

     False


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

  12. A.

     True

    B.

     False


  13. Adding null columns to a table is straightforward.

  14. A.

     True

    B.

     False


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

  16. A.

     True

    B.

     False


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

  18. A.

     True

    B.

     False


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

  20. A.

     True

    B.

     False