A correlated subquery is processed as a nested subquery.
Select an option to see the answer and solution.
Database · all questionsDatabase Redesign
Database Redesign
practice.
Practice every MCQ with options. Use Show answers when you want the correct option and solution.
40
Questions
2/2
Page
Pick an option on a question to see the right answer and solution.
A regular subquery is processed from the bottom up.
Select an option to see the answer and solution.
Correlated subqueries are similar to a regular subquery.
Select an option to see the answer and solution.
Database redesign is especially difficult if the database has no data.
Select an option to see the answer and solution.
Some organizations take the stand that no application should ever employ the true name of a table.
Select an option to see the answer and solution.
The use of the double NOT EXISTS can be used to find rows that do not match some specified condition.
Select an option to see the answer and solution.
Although creating test databases is a critical and necessary job, there are few career opportunities in this area.
Select an option to see the answer and solution.
Because of the need for extensive knowledge of SQL, many database developers choose to automate the redesign process.
Select an option to see the answer and solution.
The data model produced from the reverse engineering process does not include intersection table data.
Select an option to see the answer and solution.
If a database is built correctly the first time, it will not have to be redesigned.
Select an option to see the answer and solution.
The SQL-92 command to change a table name is RENAME TABLE.
Select an option to see the answer and solution.
Reverse engineering is the process of reading a database schema and producing a data model from that schema.
Select an option to see the answer and solution.
The data model produced from the reverse engineering process is a true logical model.
Select an option to see the answer and solution.
It is not easy to build a database correctly the first time.
Select an option to see the answer and solution.
Typically, there should be at least two different copies of the database schema used in the redesign process.
Select an option to see the answer and solution.
Information systems and organizations do not just influence each other; they create each other.
Select an option to see the answer and solution.
Adding null columns to a table is straightforward.
Select an option to see the answer and solution.
The NOT EXISTS keyword will be true if any row in the subquery meets the condition.
Select an option to see the answer and solution.
Dependency graphs are diagrams that consist of nodes and arcs that show the dependencies of a database.
Select an option to see the answer and solution.
The EXISTS keyword will be true if any row in the subquery meets the condition.
Select an option to see the answer and solution.