Microsoft
70-433 · Question #25
70-433 Question #25: Real Exam Question with Answer & Explanation
Sign in or unlock 70-433 to reveal the answer and full explanation for question #25. The question stem and answer options stay visible for context.
Question
You work as a network database administrator at ABC.com. ABC.com has a database server named ABC-DB02 hosting the Inventory database. The Inventory database has two tables named Sales and SalesRep that are related by a foreign key with the CASCADE DELETE option. How would have the records of the Sales table removed?
Options
- ABy creating a Transact-SQL statement utilizing the ALTER TABLE Sales.
- BBy creating a Transact-SQL statement utilizing the DELETE FROM SalesRep.
- CBy creating a Transact-SQL statement utilizing the TRUNCATE DATABASE Inventory.
- DBy creating a Transact-SQL statement utilizing the INSTEAD OF DELETE.
- EBy creating a Transact-SQL statement utilizing the DELETE TOP Sales.
Unlock 70-433 to see the answer
You've previewed enough free 70-433 questions. Unlock 70-433 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.