DATABASE REDESIGN QUIZ

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

A correlated subquery is processed as a nested subquery.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Reverse engineering is the process of reading a database schema and producing a data model from that schema.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

The data model produced from the reverse engineering process does not include intersection table data.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

If a database is built correctly the first time, it will not have to be redesigned.

False

True

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 : ?

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

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

The data model that is produced from reverse engineering is:

None of these

a conceptual model.

an internal model.

a logical model.

TRUE ANSWER : ?
YOUR ANSWER : ?

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

None of these

ALTER TABLE

CHANGE TABLE

RENAME TABLE

TRUE ANSWER : ?
YOUR ANSWER : ?

Which is not true of a correlated subquery?

The processing of the SELECT statements is nested.

They can be used to verify functional dependencies.

They are very similar to a regular subquery.

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

TRUE ANSWER : ?
YOUR ANSWER : ?

↑