DATABASE REDESIGN QUIZ

True

False

False

True

True

False

True

False

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

All of these

test any changes on a test database only.

create a complete backup of the operational database only.

None of these

graphical display.

data model.

dependency graph.

False

True

They can be used to verify functional dependencies.

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

They are very similar to a regular subquery.

The processing of the SELECT statements is nested.

True

False

a rare database design task, but does occur.

a common database design task.

a database design task that never occurs.

is impossible to do, so a new database must be constructed and the data moved into it.