Oracle Database 11g: Administration I — Question 2

Which three are true about auditing? (Choose three.)

Answer options

• A. DDL statements can be audited when they fail to execute.
• B. Audit of the use of system privileges can be enabled for individual database users.
• C. Auditing is active only when the database is OPEN.
• D. All Oracle auditing operations occur by default.
• E. Audit records are always stored in the database.
• F. DML statements can be audited when they execute successfully.

Correct answer: B, E, F

Explanation

The correct answers are B, E, and F because auditing can indeed be enabled for specific users, audit records are typically stored in the database, and DML statements can be audited upon successful execution. Options A, C, and D are incorrect as DDL statements are usually audited upon execution regardless of outcome, auditing can be active when the database is in other states, and not all operations occur by default.