You're designing a new table that will hold information about medical records. Another table called documents contains a foreign key that references this table. To make sure information is cleaned up when a delete operation is performed, you've added an ON DELETE CASCADE statement to the foreign key relationship. What will happen when a row is deleted from the medical records table?

Posted by Bandi on 7/30/2014 | Category: Sql Server Interview questions | Views: 1879 | Points: 40

Select from following answers:

All the values that make up the foreign key are set to NULL in the documents table
Corresponding rows in the referenced table (documents) will be deleted
Rows are deleted from the medical records table but the documents table is unchanged
All the values that comprise the foreign key are set to their default values in the documents table
All Above