Oracle Database 12c: Installation and Administration — Question 131

Which two statements are true about standard database auditing? (Choose two.)

Answer options

• A. DDL statements can be audited.
• B. Statements that refer to standalone procedure can be audited.
• C. Operations by the users logged on as SYSDBA cannot be audited.
• D. Only one audit record is ever created for a session per audited statement even though it is executed more than once.

Correct answer: A, B

Explanation

Options A and B are correct because standard database auditing includes the ability to track DDL statements and standalone procedure references. Option C is incorrect as SYSDBA operations can be audited, and option D is wrong since multiple audit records can be generated for repeated executions of the same statement within a session.