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
|
Download Printable PDF. VALID exam to help you PASS. |
 |
I ran in my db:
AUDIT POLICY ORA_DATABASE_PARAMETER BY TEST;
AUDIT POLICY ORA_DATABASE_PARAMETER BY PDBADMIN;
AUDIT POLICY ORA_DATABASE_PARAMETER BY SYS, SYSTEM;
I checked what is being audited:
TEST ORA_DATABASE_PARAMETER BY BY USER TEST USER YES YES
SYS ORA_DATABASE_PARAMETER BY BY USER SYS USER YES YES
SYSTEM ORA_DATABASE_PARAMETER BY BY USER SYSTEM USER YES YES
PDBADMIN ORA_DATABASE_PARAMETER BY BY USER PDBADMIN USER YES YES
So, the answer B is also correct.