DATABASE REDESIGN QUIZ

They can be used to verify functional dependencies.

The processing of the SELECT statements is nested.

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

They are very similar to a regular subquery.

data modeling.

reverse engineering.

None of these

database design.

False

True

True

False

True

False

a database design task that never occurs.

a rare database design task, but does occur.

a common database design task.

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

True

False

False

True

Double use of NOT EXISTS

EXISTS

None of these

NOT EXISTS

MODIFY TABLE TableName ADD COLUMN ColumnName

ALTER TABLE TableName ADD ColumnName

MODIFY TABLE TableName ADD ColumnName

ALTER TABLE TableName ADD COLUMN ColumnName