Oracle Database 11g: Administration I — Question 7

You want to audit update statements that refer to USER1.DEPT.DNAME.
Which type of auditing must you use?

Answer options

• A. standard auditing
• B. mandatory auditing
• C. value-based auditing
• D. fine-grained auditing

Correct answer: C

Explanation

Value-based auditing is the appropriate choice because it allows for tracking specific values in database objects, such as the DNAME attribute in USER1.DEPT. The other options, while relevant to auditing, do not provide the granularity required to monitor changes to specific data values.