PrepAway - Latest Free Exam Questions & Answers

Author: seenagape

What should you create to meet this need?

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?