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.
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
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)- A6% (1)
- B6% (1)
- C17% (3)
- D72% (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.
Unified audit records are primarily stored in an internal database table called UNIFIED_AUDIT_TRAIL, not always in an external audit file.
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.
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.
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
Community Discussion
No community discussion yet for this question.
