nerdexam
Oracle

1Z0-074 · Question #19

You create and enable a unified audit policy on a database that has the default auditing configuration. What is true about the SELECT statement and why?

The correct answer is C. It is audited because, by default, all user activities in the database are audited. Explanation/Reference:

New Features for Security

Question

You create and enable a unified audit policy on a database that has the default auditing configuration. What is true about the SELECT statement and why?

Exhibit

1Z0-074 question #19 exhibit

Options

  • AIt is audited because unified auditing is disabled be default.
  • BIt is audited because, by default, the database is in mixed auditing mode with default policies enabled.
  • CIt is audited because, by default, all user activities in the database are audited.
  • DIt is not audited because the table belongs to another schema.
  • EIt is not audited because audit records are stored only when unified auditing is enabled in the database.

How the community answered

(65 responses)
  • A
    6% (4)
  • B
    3% (2)
  • C
    78% (51)
  • D
    2% (1)
  • E
    11% (7)

Explanation

Explanation/Reference:

Topics

#unified auditing#mixed auditing mode#audit policy#default auditing

Community Discussion

No community discussion yet for this question.

Full 1Z0-074 Practice