1Z0-067 · Question #24
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…
The correct answer is B. all users except scott. https://docs.oracle.com/database/121/DBSEG/audit_config.htm#DBSEG459 If you run multiple AUDIT statements on the same unified audit policy but specify different EXCEPT users, then Oracle Database uses the last exception user list, not any of the users from the preceding lists…
Question
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?
Options
- Aall users except sys
- Ball users except scott
- Call users except sys and scott
- Dall users except sys, system, and scott
How the community answered
(30 responses)- A3% (1)
- B77% (23)
- C13% (4)
- D7% (2)
Explanation
https://docs.oracle.com/database/121/DBSEG/audit_config.htm#DBSEG459 If you run multiple AUDIT statements on the same unified audit policy but specify different EXCEPT users, then Oracle Database uses the last exception user list, not any of the users from the preceding lists. This means the effect of the earlier AUDIT POLICY ... EXCEPT statements are overridden by the latest AUDIT POLICY ... EXCEPT statement.
Topics
Community Discussion
No community discussion yet for this question.