Microsoft
70-451 · Question #60
A database contains two tables named Table1 and Table1_Details. Table1_Details contains details about the items in Table1. You need to ensure that when an item is removed from Table1, all related…
The correct answer is B. Create a foreign key relationship. Set Cascade Delete to Cascade. See the full explanation below for the reasoning.
Question
A database contains two tables named Table1 and Table1_Details. Table1_Details contains details about the items in Table1. You need to ensure that when an item is removed from Table1, all related items are removed from Table1_Details. You must achieve this goal by using the minimum amount of Transact-SQL code. What should you do?
Options
- ACreate a foreign key relationship. Set Cascade Delete to Set Null.
- BCreate a foreign key relationship. Set Cascade Delete to Cascade.
- CCreate a trigger on Table1_Details that fires on the Delete action.
- DCreate a stored procedure that deletes all related items from Table1_Detai!s.
How the community answered
(33 responses)- A6% (2)
- B79% (26)
- C12% (4)
- D3% (1)
Community Discussion
No community discussion yet for this question.