Exam 1z0-062 topic 1 question 106 discussion

Actual exam question from Oracle's 1z0-062

Question #: 106
Topic #: 1

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.

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

Show Suggested Answer

Suggested Answer: AE 🗳️
* The ORA_DATABASE_PARAMETER policy audits commonly used Oracle Database parameter settings. By default, this policy is not enabled.

by dancymonkey at Aug. 20, 2020, 2:01 p.m.

Comments

Submit Cancel

DANG257315

Highly Voted 4 years, 5 months ago

The correct answer are A and E. b is not correct bacause by default the SCOTT user is disable

upvoted 7 times

Ray_gk

3 years ago

I agree with you. I would argue that E is correct based on an excerpt from the documentation for 12.1. "Specify WHENEVER SUCCESSFUL to audit only SQL statements and operations that succeed. Specify WHENEVER NOT SUCCESSFUL to audit only SQL statements and operations that fail or result in errors. If you omit this clause, then Oracle Database performs the audit regardless of success or failure." --> E I agree that user scott is disabled in 12.1 DB upon creating database as well so I would rule out B. The most appropriate answers seem to be A and E.

upvoted 1 times

...

yosiw96816

Highly Voted 4 years, 6 months ago

Agree AB https://docs.oracle.com/database/121/SQLRF/statements_4008.htm#SQLRF56110 If multiple AUDIT ... BY ... statements are specified for the same unified audit policy, then the policy is enabled for the union of the users specified in each statement.

upvoted 5 times

NorwayOracle

3 years, 2 months ago

Agree.

upvoted 1 times

...

dancymonkey

Most Recent 4 years, 9 months ago

AB are correct Both commands enable predefined policy Note: You need to open a new session to see that 3 users get audit by this policy. AUDIT POLICY ORA_DATABASE_PARAMETER BY C##AX; AUDIT POLICY ORA_DATABASE_PARAMETER BY SYS, SYSTEM; select * from audit_unified_enabled_policies; select * from AUDIT_UNIFIED_POLICIES where policy_name = 'ORA_DATABASE_PARAMETER'; ALTER SYSTEM set DEFERRED_SEGMENT_CREATION = TRUE; exec dbms_audit_mgmt.flush_unified_audit_trail; select dbusername,sql_text, unified_audit_policies, event_timestamp, to_char(sysdate, 'HH MI SS AM') from unified_audit_trail order by event_timestamp desc

upvoted 2 times

...