Question 15 : 70-464 SQL Server 2012 | Free practice exams

Question 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?

All the values that make up the foreign key are set to NULL in the documents table

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

Corresponding rows in the referenced table (documents) will be deleted

Don't forget that ON DELETE statements are included as part of the foreign key relationship.

This is a sample question. You can start the practice exam by clicking the 'Start Practice Exam' link on the exam page.

Back to practice exam

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