DATABASE REDESIGN QUIZ

A regular subquery can be processed:

from the top down.

by nesting.

None of these

from the bottom up.

TRUE ANSWER : ?
YOUR ANSWER : ?

Correlated subqueries are similar to a regular subquery.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

Because of the importance of making data model changes correctly, many professionals are ________ about using an automated process for database redesign.

ambivalent

None of these

skeptical

optimistic

TRUE ANSWER : ?
YOUR ANSWER : ?

Because of the need for extensive knowledge of SQL, many database developers choose to automate the redesign process.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

The SQL-92 command to change a table name is RENAME TABLE.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Some organizations take the stand that no application should ever employ the true name of a table.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

Before any changes to database structure are attempted one should first:

test any changes on a test database only.

All of these

create a complete backup of the operational database only.

clearly understand the current structure and contents of the database only.

TRUE ANSWER : ?
YOUR ANSWER : ?

Dependency graphs are diagrams that consist of nodes and arcs that show the dependencies of a database.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following SQL statements are helpful in database redesign?

Correlated subqueries only

EXISTS/NOT EXISTS expressions only

None of these

Both of the above are helpful

TRUE ANSWER : ?
YOUR ANSWER : ?

Database redesign is not terribly difficult if the:

database has no data.

database is well-designed.

database is structured.

database is relatively small.

TRUE ANSWER : ?
YOUR ANSWER : ?

↑