Oracle
1Z0-060 · Question #94
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.
New Features for Security
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
(44 responses)- A80% (35)
- B7% (3)
- C11% (5)
- D2% (1)
Explanation
*The ORA_DATABASE_PARAMETER policy audits commonly used Oracle Database parameter settings. By default, this policy is not enabled.
Topics
#unified auditing#audit policy BY clause#successful failed executions#Oracle 12c auditing
Community Discussion
No community discussion yet for this question.