You work as a database developer for www.company.com.com.
The company has a database named www.company.com that is hosted on a SQL Server 2008 server. The database includes a table named Employees, which contains the details of the employees.
You want to ensure that anytime any data in the Employees table is modified with an UPDATE statement, they are recorded in a table named EmployeeChanges. The EmployeeChanges table includes columns to record what the change was, who made the change, and when they made the change.
What should you create to meet this need?
A. A DDL trigger that queries the updated table
B. A DML trigger that queries the inserted table
C. A DDL trigger that queries the inserted table
D. A DML trigger that queries the updated table
How To Pass 98-364 Exam?FULL Printable PDF and Software. VALID exam to help you PASS. |
 |
