DATABASE REDESIGN QUIZ

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

The NOT EXISTS keyword will be true if any row in the subquery meets the condition.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

It is not easy to build a database correctly the first time.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

The use of the double NOT EXISTS can be used to find rows that do not match some specified condition.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Which SQL-92 standard SQL command can be used to change a table name?

ALTER TABLE

CHANGE TABLE

RENAME TABLE

None of these

TRUE ANSWER : ?
YOUR ANSWER : ?

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

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

The data model that is produced from reverse engineering is:

an internal model.

a conceptual model.

a logical model.

None of these

TRUE ANSWER : ?
YOUR ANSWER : ?

The NOT EXISTS keyword will be true if:

all rows in the subquery fail the condition.

both of these two conditions are met.

any row in the subquery meets the condition.

neither of these two conditions is met.

TRUE ANSWER : ?
YOUR ANSWER : ?

Correlated subqueries are similar to a regular subquery.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

↑