Oracle Database 12c: Installation and Administration — Question 140

You enabled an audit policy by issuing the following statements:
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER BY SCOTT;
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER BY SYS, SYSTEM;
For which database users and for which executions is the audit policy now active? Select two.

Answer options

• A. SYS, SYSTEM
• B. SCOTT
• C. Only for successful executions
• D. Only for failed executions
• E. Both successful and failed executions

Correct answer: A, E

Explanation

The audit policy applies to the users SYS and SYSTEM as specified in the command, making option A correct. Additionally, the audit policy tracks both successful and failed executions, which makes option E the right choice as well. Options B, C, and D do not encompass the complete scope of the audit policy activation.