Free Practice Exam -
70-461 - SQL Server 2012
Question 1 of 15
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?
Corresponding rows in the referenced table (documents) will be deleted
All the values that make up the foreign key are set to NULL in the documents table
All the values that comprise the foreign key are set to their default values in the documents table
Rows are deleted from the medical records table but the documents table is unchanged
That was the correct answer, well done!
Sorry, that was the wrong answer
Don't forget that ON DELETE statements are included as part of the foreign key relationship.
Exam Progress
Move on to the next question
Home
Microsoft Exams
Free practice exams are provided free of charge by Accelerated Ideas. Please respect our exams and do not reproduce our material or abuse the testing system. Thank you. Microsoft exams for MCPD, MCTS, MCP, MCSE, MCSA, MCAD, MCSD
Home
Copyright © Accelerated Ideas 2005-2019
All rights reserved