DATABASE REDESIGN QUIZ

ALTER TABLE

CHANGE TABLE

RENAME TABLE

None of these

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

They are very similar to a regular subquery.

They can be used to verify functional dependencies.

The processing of the SELECT statements is nested.

neither of these two conditions is met.

any row in the subquery meets the condition only.

both of these two conditions are met.

all rows in the subquery fail the condition only.

False

True

True

False

NOT EXISTS

EXISTS

None of these

Double use of NOT EXISTS

a conceptual model.

None of these

a logical model.

an internal model.

False

True

Correlated subqueries only

None of these

Both of the above are helpful

EXISTS/NOT EXISTS expressions only

ALTER TABLE TableName ADD COLUMN ColumnName

MODIFY TABLE TableName ADD ColumnName

MODIFY TABLE TableName ADD COLUMN ColumnName

ALTER TABLE TableName ADD ColumnName