Database Redesign MCQs
Practice Database Redesign MCQs for competitive exams.
Database Redesign MCQs
Practice questions from this topic.
The EXISTS keyword will be true if any row in the subquery meets the condition.
Correct Answer: A
Dependency graphs are diagrams that consist of nodes and arcs that show the dependencies of a database.
Correct Answer: A
The NOT EXISTS keyword will be true if any row in the subquery meets the condition.
Correct Answer: B
Adding null columns to a table is straightforward.
Correct Answer: A
Information systems and organizations do not just influence each other; they create each other.
Correct Answer: A
Typically, there should be at least two different copies of the database schema used in the redesign process.
Correct Answer: B
It is not easy to build a database correctly the first time.
Correct Answer: A
The data model produced from the reverse engineering process is a true logical model.
Correct Answer: B
Reverse engineering is the process of reading a database schema and producing a data model from that schema.
Correct Answer: A
The SQL-92 command to change a table name is RENAME TABLE.
Correct Answer: B
If a database is built correctly the first time, it will not have to be redesigned.
Correct Answer: B
The data model produced from the reverse engineering process does not include intersection table data.
Correct Answer: B