Database Redesign
To drop a column that is used as a foreign key, first:

All of these
drop the foreign key constraint.
drop the primary key.
drop the table containing the foreign key.

ANSWER DOWNLOAD EXAMIANS APP

Database Redesign
Which is not true of a correlated subquery?

The processing of the SELECT statements is nested.
EXISTS/NOT EXISTS is a form of a correlated subquery.
They can be used to verify functional dependencies.
They are very similar to a regular subquery.

ANSWER DOWNLOAD EXAMIANS APP