Database Redesign MCQs

40 questionsDatabasePage 4 of 5

Practice free Database Redesign multiple-choice questions with instant answer feedback and step-by-step solutions. Click an option to check yourself, reveal the full explanation, and work through all 40 questions — no login required.

Question 28hard
Because of the need for extensive knowledge of SQL, many database developers choose to automate the redesign process.
⚑ Report✎ Feedback
Question 29hard
The data model produced from the reverse engineering process does not include intersection table data.
⚑ Report✎ Feedback
Question 30hard
If a database is built correctly the first time, it will not have to be redesigned.
⚑ Report✎ Feedback
Advertisement
Question 31hard
The SQL-92 command to change a table name is RENAME TABLE.
⚑ Report✎ Feedback
Question 32hard
Reverse engineering is the process of reading a database schema and producing a data model from that schema.
⚑ Report✎ Feedback
Question 33hard
The data model produced from the reverse engineering process is a true logical model.
⚑ Report✎ Feedback
Advertisement
Question 34medium
It is not easy to build a database correctly the first time.
⚑ Report✎ Feedback
Question 35hard
Typically, there should be at least two different copies of the database schema used in the redesign process.
⚑ Report✎ Feedback
Question 36hard
Information systems and organizations do not just influence each other; they create each other.
⚑ Report✎ Feedback
1…345