Exam 1z0-062 topic 1 question 270 discussion

Actual exam question from Oracle's 1z0-062

Question #: 270
Topic #: 1

Unified auditing is enabled in your database. The HR_ADMIN and OE_ADMIN roles exist and are granted system privileges.
You execute the command:
SQL>CREATE AUDIT POLICY tab1e_aud PRIVILEGES CREATE ANY TABLE, DROP ANY TABLE ROLES hr_admin, oe_admin;
Which statement is true?

A. It succeeds and needs to be enabled to capture all SQL statements that require either the specified privileges or any privilege granted to the HR_ADMIN and role. OE_ADMIN
B. It fails because system privileges cannot be granted with roles in the same audit policy.
C. It succeeds and starts capturing only successful SQL statements for all users who have either the specified privileges or roles granted to them.
D. It fails because the command does not specify when the unified audit policy should be enforced.

Show Suggested Answer

Suggested Answer: C 🗳️

by khan at March 31, 2019, 9:31 p.m.

Comments

Submit Cancel

khan

Highly Voted 5 years, 8 months ago

Answer: A After you create the policy, you must enable it by using the AUDIT statement. The audit trail will capture SQL statements that require the CREATE ANY TABLE system privilege or the DROP ANY TABLE system privilege or any system privilege directly granted to the role. https://docs.oracle.com/database/121/DBSEG/audit_config.htm#DBSEG357

upvoted 13 times

...

sherifelia

Highly Voted 5 years ago

Answer: A

upvoted 6 times

...

Ray520

Most Recent 2 years, 7 months ago

Selected Answer: A

After you create the policy, you must enable it by using the AUDIT statement. AUDIT POLICY { policy_auditing } [WHENEVER [NOT] SUCCESSFUL];

upvoted 1 times

...

TuxBingo

4 years, 4 months ago

The correct answer should be A because after creating the unified audit policy, you will need to enable it with the AUDIT POLICY statement and apply the unified audit policies to users. https://docs.oracle.com/database/121/DBSEG/audit_config.htm#DBSEG460

upvoted 4 times

...

Winterschill

4 years, 8 months ago

I think C is correct. This plus the two below all say C. SO 3 sources agree. http://itexam.io/exam/engine?exam=1z0-062 https://vceguide.com/which-statement-is-true-353/