1Z0-182 practice question 6 of 15

Which two methods can be used to purge audit records of the Unified Audits?

Answer options

A: Only viewed audit records can be purged from Unified Audits.

B: Use DBMS_AUDIT_MGMT.CREATE_PURGE_JOB as a privileged user to schedule an automatic purge job. Correct answer

C: Only the owner of a Unified Audit Policy can purge audit records by resetting the policy.

D: Use DBMS_AUDIT_MGMT.CLEAN_AUDIT_TRAIL as a privileged user to manually purge audit records. Correct answer

E: Use DBMS_AUDIT_MGMT.DELETE_AUDIT_RECORDS('POLICY_NAME') as a privileged user to manually purge audit records of a specified Unified Policy.

Correct Answer:

B. Use DBMS_AUDIT_MGMT.CREATE_PURGE_JOB as a privileged user to schedule an automatic purge job.; D. Use DBMS_AUDIT_MGMT.CLEAN_AUDIT_TRAIL as a privileged user to manually purge audit records.

Explanation

The DBMSAUDITMGMT package provides the necessary procedures for managing the unified audit trail. To purge audit records, administrators can use two primary methods. For automated, periodic purging, DBMSAUDITMGMT.CREATEPURGEJOB is used to schedule a job that runs at specified intervals. For immediate, manual purging of the audit trail up to a certain timestamp, the DBMSAUDITMGMT.CLEANAUDITTRAIL procedure is executed. Both methods require a privileged user with the AUDITADMIN role.

Why Incorrect

A. Purging is based on the age of the audit records (timestamp), not on whether they have been viewed or accessed.
C. Purging is a privileged administrative task, not restricted to the owner of a specific audit policy. It affects the entire audit trail.
E. The procedure DELETEAUDITRECORDS does not exist in the DBMSAUDITMGMT package for this purpose; the correct procedure is CLEANAUDITTRAIL.

References

Oracle Database 23ai Security Guide, "Configuring and Administering Auditing", section "Purging Audit Records".

Oracle Database 23ai PL/SQL Packages and Types Reference, "DBMSAUDITMGMT", sections "CREATEPURGEJOB Procedure" and "CLEANAUDITTRAIL Procedure".

Keep practicing

Take the free 1Z0-182 practice test

Ten exam-style questions with answers and explanations, plus the exam facts and study guides.

Start the free practice test