Microsoft
70-433 · Question #68
70-433 Question #68: Real Exam Question with Answer & Explanation
Sign in or unlock 70-433 to reveal the answer and full explanation for question #68. The question stem and answer options stay visible for context.
Question
You are developing a database using Microsoft SQL Server 2008. The database contains the tables shown in the exhibit. You are required to prevent parts from being deleted if they belong to a kit. If a part belongs to a kit, the delete should not occur and the IsDeleted column for the row should be changed to 'True'. Parts can be deleted if they do not belong to a kit. You have the following Transact-SQL statement to be used in a trigger: UPDATE p SET IsDeleted = 1 FROM KitPart kp JOIN deleted d ON kp.PartID = d.PartID JOIN Part p ON kp.PartID = p.PartID; DELETE FROM p FROM Part p JOIN deleted d ON p.PartID = d.PartID LEFT OUTER JOIN KitPart kp ON p.PartID = kp.PartID WHERE kp.KitID IS NULL; You need to implement the Transact-SQL statement in a trigger. Which trigger syntax should you use?
Exhibit
Options
- ACREATE TRIGGER tr_Part_d ON Part
- BCREATE TRIGGER tr_Part_d ON Part
- CCREATE TRIGGER tr_KitPart_d ON KitPart
- DCREATE TRIGGER tr_KitPart_d ON KitPart
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.