Note: this question-is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question-in the series. Each question-is independent of the other questions in the series. Information and details provided in a question-apply only to that question.
You are developing an application to track customer sales.
You need to create an object that meets to following requirements:
Run managed code packaged in an assembly that was created in the Microsoft.NET Framework and uploaded in Microsoft SQL Server.
Run written a transaction and roll back if a failure occurs. Run when a table is created or modified.
What should you create?
A. extended procedure
B. CLR procedure
C. user-defined procedure
D. DML trigger
E. DDL trigger
F. scalar-valued function
G. table-valued function
A DDL CLR Trigger