In your production database, data manipulation language (DML) operations are executed on
the SALES table. You have noticed some dubious values in the SALES table during the last
few days. You are able to track users, actions taken, and the time of the action for this
particular period but the changes in data are not tracked. You decide to keep track of both
the old data and new data in the table long with the user information. What action would you
take to achieve this task?
A.
Implement value-based auditing.
B.
Impose standard database auditing to audit object privileges.
C.
Apply fine-grained auditing.
D.
Impose standard database auditing to audit SQL statements.
Explanation:
A
The DBMS_FGA package administers these value-based audit policies. Using DBMS_FGA, the security administrator creates an audit policy on the target table. If any of the rows returned from a query block matches the audit condition (these rows are referred to as interested rows), then an audit event entry, including username