DATABASE REDESIGN QUIZ

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

optimistic

ambivalent

None of these

skeptical

TRUE ANSWER : ?
YOUR ANSWER : ?

A correlated subquery is processed as a nested subquery.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

How many copies of the database schema are typically used in the redesign process?

One

Three

Two

Four

TRUE ANSWER : ?
YOUR ANSWER : ?

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

A regular subquery is processed from the bottom up.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

The data model produced from the reverse engineering process is a true logical model.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

Typically, there should be at least two different copies of the database schema used in the redesign process.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Database redesign is not terribly difficult if the:

database is well-designed.

database is structured.

database has no data.

database is relatively small.

TRUE ANSWER : ?
YOUR ANSWER : ?

Which is not true of a correlated subquery?

The processing of the SELECT statements is nested.

They are very similar to a regular subquery.

EXISTS/NOT EXISTS is a form of a correlated subquery.

They can be used to verify functional dependencies.

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following modifications may not succeed?

Both of the above actions should succeed

Changing a column data type from char to date

Neither of the above actions will succeed

Changing a column data type from numeric to char

TRUE ANSWER : ?
YOUR ANSWER : ?