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: 611 | Points: 40
Select from following answers:
  1. All the values that make up the foreign key are set to NULL in the documents table
  2. Corresponding rows in the referenced table (documents) will be deleted
  3. Rows are deleted from the medical records table but the documents table is unchanged
  4. All the values that comprise the foreign key are set to their default values in the documents table
  5. All Above

Show Correct Answer


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response