nerdexam
Oracle

1Z0-063 · Question #82

You wish to enable an audit policy for all database users, except sys, system, and scott. You issue the following statements: SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYS; SQL> AUDIT POLICY…

The correct answer is B. all users except scott. See the full explanation below for the reasoning.

Question

You wish to enable an audit policy for all database users, except sys, system, and scott. You issue the following statements: SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYS; SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYSTEM; SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SCOTT; For which database users is the audit policy now active?

Options

  • Aall users exceptsys
  • Ball users except scott
  • Call users except sys and scott
  • Dall users except sys, system, and scott

How the community answered

(48 responses)
  • A
    4% (2)
  • B
    75% (36)
  • C
    6% (3)
  • D
    15% (7)

Community Discussion

No community discussion yet for this question.

Full 1Z0-063 Practice