DATABASE REDESIGN QUIZ

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 data model produced from the reverse engineering process is a true logical model.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

To drop a column that is used as a foreign key, first:

drop the primary key.

drop the foreign key constraint.

All of these

drop the table containing the foreign key.

TRUE ANSWER : ?
YOUR ANSWER : ?

A regular subquery is processed from the bottom up.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

The EXISTS keyword will be true if:

neither of these two conditions is met.

both of these two conditions are met.

all rows in the subquery fail the condition only.

any row in the subquery meets the condition only.

TRUE ANSWER : ?
YOUR ANSWER : ?

How can you find rows that do not match some specified condition?

NOT EXISTS

None of these

EXISTS

Double use of NOT EXISTS

TRUE ANSWER : ?
YOUR ANSWER : ?

Although creating test databases is a critical and necessary job, there are few career opportunities in this area.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Database redesign is especially difficult if the database has no data.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

Three

Two

One

Four

TRUE ANSWER : ?
YOUR ANSWER : ?

↑