Database Redesign MCQs

40 questionsDatabasePage 3 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 19easy
How many copies of the database schema are typically used in the redesign process?
⚑ Report✎ Feedback
Question 20medium
Because of the importance of making data model changes correctly, many professionals are ________ about using an automated process for database redesign.
⚑ Report✎ Feedback
Question 21medium
A correlated subquery is processed as a nested subquery.
⚑ Report✎ Feedback
Advertisement
Question 22medium
A regular subquery is processed from the bottom up.
⚑ Report✎ Feedback
Question 23medium
Correlated subqueries are similar to a regular subquery.
⚑ Report✎ Feedback
Question 24medium
Database redesign is especially difficult if the database has no data.
⚑ Report✎ Feedback
Advertisement
Question 25hard
Some organizations take the stand that no application should ever employ the true name of a table.
⚑ Report✎ Feedback
Question 26hard
The use of the double NOT EXISTS can be used to find rows that do not match some specified condition.
⚑ Report✎ Feedback
Question 27hard
Although creating test databases is a critical and necessary job, there are few career opportunities in this area.
⚑ Report✎ Feedback
12345