Developing SQL Databases — Question 160

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution. Determine whether the solution meets the stated goals.
You have a database that contains a table named Employees. The table stored information about the employees of your company.
You need to implement the following auditing rules for the Employees table:
- Record any changes that are made to the data in the Employees table.
- Customize the data that is recorded by the audit operations.
Solution: You implement a check constraint on the Employees table.
Does the solution meet the goal?

Answer options

Correct answer: B

Explanation

The solution does not meet the auditing goals because a check constraint is used to enforce data integrity rules rather than to track changes or log modifications. It cannot record changes to the data, which is necessary for auditing purposes. Therefore, the correct answer is B.