Multiple Choice
When dropping a foreign key column from a table,which of the following steps is (are) included in the process? (The order of the steps listed below is not relevant,only the steps themselves. )
A) Drop the foreign key constraint from the table
B) Drop the foreign key column from the table
C) Drop the primary key in the other table referenced by the referential integrity constraint
D) A and B
E) A,B,and C
Correct Answer:

Verified
Correct Answer:
Verified
Q3: SQL Server 2012 contains a system-stored procedure
Q23: In the database redesign process,two SQL tools
Q37: Adding new tables and relationships to a
Q50: A continuous circular process of changes in
Q60: In a correlated subquery,the same table is
Q70: Typically,there are at least four different copies
Q75: Dependency graphs are graphical displays like bar
Q80: What is a dependency graph,and what is
Q83: Why do databases need redesigning?
Q85: When redesigning a database,how can we check