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
Explanation:
* The ORA_DATABASE_PARAMETER policy audits commonly used Oracle
Database parameter settings. By default, this policy is not enabled.
ABE are correct.
A & E Not B
When you want to enable an audit policy for multiple users then you need to execute Audit Policy statment once including all users. If you include an audit statement including a uesr then a statement executed last will be effective.
Example – This enables auditing for only user 2;
audit policy pol_name by user1;
audit policy pl_name by user2;
Example 2 – This enables auditing for both user1 and user2 ;
audit policy pol_name by user1, user2;
E is correct
A is incorrect. The correct answer is the union of A&B.
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.
(rf. https://docs.oracle.com/database/121/SQLRF/statements_4008.htm#SQLRF56110)