If you have ON DELETE CASCADE statement to the foreign key relationship. What will happen when a row is deleted from the parent table?

 Posted by Bandi on 11/21/2013 | Category: Sql Server Interview questions | Views: 1165 | Points: 40
Select from following answers:
  1. All the values that make up the foreign key are set to NULL in the child table
  2. All the values that comprise the foreign key are set to their default values in the child table
  3. Corresponding rows in the referenced table (child table) will be deleted
  4. Rows are deleted from the parent table but the child table is unchanged
  5. All Above

Show Correct Answer

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response