logo

CuriousTab

CuriousTab

Discussion


Home Database Database Redesign Comments

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


  • Options
  • A. True
  • B. False

  • Correct Answer
  • True 


  • Database Redesign problems


    Search Results


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

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

    • Options
    • A. True
    • B. False
    • Discuss
    • 3. Although creating test databases is a critical and necessary job, there are few career opportunities in this area.

    • Options
    • A. True
    • B. False
    • Discuss
    • 4. Typically, there should be at least two different copies of the database schema used in the redesign process.

    • Options
    • A. True
    • B. False
    • Discuss
    • 5. Reverse engineering is the process of reading a database schema and producing a data model from that schema.

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

    • Options
    • A. True
    • B. False
    • Discuss
    • 7. Because of the need for extensive knowledge of SQL, many database developers choose to automate the redesign process.

    • Options
    • A. True
    • B. False
    • Discuss
    • 8. If a database is built correctly the first time, it will not have to be redesigned.

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

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

    • Options
    • A. True
    • B. False
    • Discuss


    Comments

    There are no comments.

Enter a new Comment