Question 1 :
A correlated subquery is processed as a nested subquery.
Question 2 :
A regular subquery is processed from the bottom up.
Question 3 :
Correlated subqueries are similar to a regular subquery.
Question 4 :
Database redesign is especially difficult if the database has no data.
Question 5 :
Some organizations take the stand that no application should ever employ the true name of a table.
Question 6 :
The use of the double NOT EXISTS can be used to find rows that do not match some specified condition.
Question 7 :
Although creating test databases is a critical and necessary job, there are few career opportunities in this area.
Question 8 :
Because of the need for extensive knowledge of SQL, many database developers choose to automate the redesign process.
Question 9 :
The data model produced from the reverse engineering process does not include intersection table data.
Question 10 :
If a database is built correctly the first time, it will not have to be redesigned.
Question 11 :
The SQL-92 command to change a table name is RENAME TABLE.
Question 12 :
Reverse engineering is the process of reading a database schema and producing a data model from that schema.
Question 13 :
The data model produced from the reverse engineering process is a true logical model.
Question 14 :
It is not easy to build a database correctly the first time.
Question 15 :
Typically, there should be at least two different copies of the database schema used in the redesign process.
Question 16 :
Information systems and organizations do not just influence each other; they create each other.
Question 17 :
Adding null columns to a table is straightforward.
Question 18 :
The NOT EXISTS keyword will be true if any row in the subquery meets the condition.
Question 19 :
Dependency graphs are diagrams that consist of nodes and arcs that show the dependencies of a database.
Question 20 :
The EXISTS keyword will be true if any row in the subquery meets the condition.