Microsoft
98-364 · Question #20
You are a database developer for a database named Customers hosted on a SQL Server 2008 server. Recently, several customers were deleted from the Customers database. To ensure this is not repeated…
The correct answer is B. CREATE TRIGGER trgDeleteCustomer D. CREATE TRIGGER trgDeleteCustomer. See the full explanation below for the reasoning.
Question
You are a database developer for a database named Customers hosted on a SQL Server 2008 server. Recently, several customers were deleted from the Customers database. To ensure this is not repeated in future, you have decided to create a DML trigger to prevent it. What code will create the trigger to meet your goals? Each correct answer represents a complete solution. Choose all that apply.
Options
- ACREATE TRIGGER trgDeleteCustomer
- BCREATE TRIGGER trgDeleteCustomer
- CCREATE TRIGGER trgDeleteCustomer
- DCREATE TRIGGER trgDeleteCustomer
How the community answered
(44 responses)- A5% (2)
- B84% (37)
- C11% (5)
Community Discussion
No community discussion yet for this question.