logo

CuriousTab

CuriousTab

Discussion

Home ‣ Database ‣ Database Redesign Comments
  • Question

  • If a database is built correctly the first time, it will not have to be redesigned.


  • Options
  • A. True
  • B. False

  • Correct Answer
  • False 

    • Database Redesign problems

    Search Results

    • 1. Because of the need for extensive knowledge of SQL, many database developers choose to automate the redesign process.

    • Options
    • A. True
    • B. False
      • Discuss
    • 2. Correlated subqueries are similar to a regular subquery.

    • Options
    • A. True
    • B. False
      • Discuss
    • 3. The EXISTS keyword will be true if any row in the subquery meets the condition.

    • Options
    • A. True
    • B. False
      • Discuss
    • 4. Dependency graphs are diagrams that consist of nodes and arcs that show the dependencies of a database.

    • Options
    • A. True
    • B. False
      • Discuss
    • 5. A regular subquery is processed from the bottom up.

    • Options
    • A. True
    • B. False
      • Discuss
    • 6. Database redesign is especially difficult if the database has no data.

    • Options
    • A. True
    • B. False
      • Discuss
    • 7. The data model produced from the reverse engineering process is a true logical model.

    • Options
    • A. True
    • B. False
      • Discuss
    • 8. A correlated subquery is processed as a nested subquery.

    • Options
    • A. True
    • B. False
      • Discuss
    • 9. The SQL-92 command to change a table name is RENAME TABLE.

    • Options
    • A. True
    • B. False
      • Discuss
    • 10. The use of the double NOT EXISTS can be used to find rows that do not match some specified condition.

    • 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.