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…

The correct answer is A. SYS, SYSTEM E. Both successful and failed executions. The ORA_DATABASE_PARAMETER policy audits commonly used Oracle Database parameter settings. By default, this policy is not enabled.

Implementing Oracle Database Auditing

Question

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.

Options

ASYS, SYSTEM
BSCOTT
COnly for successful executions
DOnly for failed executions
EBoth successful and failed executions

How the community answered

(25 responses)

A
72% (18)
B
8% (2)
C
16% (4)
D
4% (1)

Explanation

The ORA_DATABASE_PARAMETER policy audits commonly used Oracle Database parameter settings. By default, this policy is not enabled.

Topics

#audit policy#database auditing#user auditing#execution logging

Community Discussion

No community discussion yet for this question.

Full 1Z0-062 Practice