To drop a column that is used as a foreign key, first:%! – McqOptions

MCQOPTIONS

1.	To drop a column that is used as a foreign key, first:%!
A.	drop the primary key.
B.	drop the table containing the foreign key.
C.	drop the foreign key constraint.
D.	All of the above must be done.
Answer» D. All of the above must be done.

Discussion

No Comment Found

Related MCQs

If a database is built correctly the first time, it will not have to be redesigned.%!
Some organizations take the stand that no application should ever employ the true name of a table.%!
The EXISTS keyword will be true if any row in the subquery meets the condition.%!
Typically, there should be at least two different copies of the database schema used in the redesign process.%!
The data model produced from the reverse engineering process does not include intersection table data.%!
Database redesign is especially difficult if the database has no data.%!
Dependency graphs are diagrams that consist of nodes and arcs that show the dependencies of a database.%!
It is not easy to build a database correctly the first time.%!
Because of the need for extensive knowledge of SQL, many database developers choose to automate the redesign process.%!
Correlated subqueries are similar to a regular subquery.%!