DATABASE REDESIGN QUIZ

False

True

ALTER TABLE

CHANGE TABLE

None of these

RENAME TABLE

database is well-designed.

database is structured.

database has no data.

database is relatively small.

False

True

True

False

None of these

an internal model.

a conceptual model.

a logical model.

True

False

ALTER TABLE TableName DROP COLUMN ColumnName

MODIFY TABLE TableName DROP COLUMN ColumnName

MODIFY TABLE TableName DROP ColumnName

ALTER TABLE TableName DROP ColumnName

False

True

They can be used to verify functional dependencies.

The processing of the SELECT statements is nested.

They are very similar to a regular subquery.

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