Free 1Z0-083 Web TestEngine Demo

Q25 Single choice

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 or OE_ADMIN role.
B
It fails because the command does notspecify when the unified audit policy should be enforced.
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 system privileges cannot be granted with roles in the same audit policy.

1Z0-083 Web TestEngine demo