Oracle Database 12c: Advanced Administration — Question 135

You wish to enable an audit policy for all database users, except sys, system, and scott. You issue the following statements:
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYS;
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYSTEM;
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SCOTT;
For which database users is the audit policy now active?

Answer options

• A. all users except sys
• B. all users except scott
• C. all users except sys and scott
• D. all users except sys, system, and scott

Correct answer: B

Explanation

The correct answer is B because the audit policy is set to exclude sys, and the last command excludes scott as well. Therefore, the only user not included in the audit policy is scott, while sys is already excluded by the previous commands. Options A, C, and D incorrectly imply that other users besides scott are also excluded.