Câu 4: 70-762: Developing SQL Databases

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 a database object that meets the following requirements: ✑ Launch when table data is modified. ✑ Evaluate the state of a table before and after a data modification and take actions based on the difference. ✑ Prevent malicious or incorrect table data operations. ✑ Prevent changes that violate referential integrity by cancelling the attempted data modification. ✑ Run managed code packaged in an assembly that is created in the Microsoft. NET Framework and located into Microsoft SQL Server. What should you create?

1. A. extended procedure
2. B. CLR procedure — đáp án hiện tại
3. C. user-defined procedure
4. D. DML trigger
5. E. scalar-valued function
6. F. table-valued function
7. G. DDL trigger