nerdexam
Oracle

1Z0-062 · Question #376

In one of your databases, unified auditing is enabled and an SH.SALES table exists. You can successfully execute these commands: Which statement is true about SALES_POL?

The correct answer is D. Only successful queries of SH.SALES are written to the audit trail. SALES_POL refers to a unified audit policy that has been configured to log only successful query operations on the SH.SALES table, demonstrating granular control over audit trail generation.

Implementing Oracle Database Auditing

Question

In one of your databases, unified auditing is enabled and an SH.SALES table exists. You can successfully execute these commands:

Which statement is true about SALES_POL?

Exhibit

1Z0-062 question #376 exhibit

Options

  • AAudit records are always stored in an external audit file.
  • BIt is enabled for all users having SELECT privilege on SH.SALES.
  • CIt is only enabled for SH.
  • DOnly successful queries of SH.SALES are written to the audit trail.

How the community answered

(18 responses)
  • A
    6% (1)
  • B
    6% (1)
  • C
    17% (3)
  • D
    72% (13)

Why each option

SALES_POL refers to a unified audit policy that has been configured to log only successful query operations on the SH.SALES table, demonstrating granular control over audit trail generation.

AAudit records are always stored in an external audit file.

Unified audit records are primarily stored in an internal database table called UNIFIED_AUDIT_TRAIL, not always in an external audit file.

BIt is enabled for all users having SELECT privilege on SH.SALES.

Unified audit policies are enabled for specific users or roles, or universally, based on explicit configuration, not automatically for all users with a specific privilege.

CIt is only enabled for SH.

Unified audit policies are not limited to being enabled for the schema owner only; they can be applied to any user, set of users, or globally.

DOnly successful queries of SH.SALES are written to the audit trail.Correct

Unified auditing policies can be configured to audit specific operations, such as queries, and can further specify whether to audit only successful operations, failed operations, or both. If SALES_POL is a unified audit policy configured with 'ON SUCCESS', only successful queries on SH.SALES would generate audit records.

Concept tested: Oracle Unified Auditing Policy Configuration

Source: https://docs.oracle.com/en/database/oracle/oracle-database/23/dbseg/administering-unified-auditing.html#GUID-BC14D571-5573-455E-BE17-B91F83084B6F

Topics

#Unified auditing#AUDIT POLICY#audit trail

Community Discussion

No community discussion yet for this question.

Full 1Z0-062 Practice