Microsoft
70-433 · Question #112
You have the following two tables. The foreign key relationship between these tables has CASCADE DELETE enabled. You need to remove all records from the Orders table. Which Transact-SQL statement…
The correct answer is B. DELETE FROM Orders. See the full explanation below for the reasoning.
Question
You have the following two tables. The foreign key relationship between these tables has CASCADE DELETE enabled. You need to remove all records from the Orders table. Which Transact-SQL statement should you use?
Exhibit
Options
- ADROP TABLE Orders
- BDELETE FROM Orders
- CTRUNCATE TABLE Orders
- DDELETE FROM OrderDetails
How the community answered
(59 responses)- A15% (9)
- B71% (42)
- C8% (5)
- D5% (3)
Community Discussion
No community discussion yet for this question.