1Z0-082 Oracle Database Monitoring and Auditing 2

Question 1

Which Oracle auditing feature allows policies to audit specific rows based on column values, such as auditing access to salary data over $100,000?

Accepted Answer

Fine-Grained Auditing (FGA)

Answer

Fine-Grained Auditing (FGA) allows administrators to create policies that trigger audit records only when specific column values or conditions are met in a query.

Question 2

Which initialization parameter must be set to enable traditional (non-unified) database auditing in Oracle?

Accepted Answer

AUDIT_TRAIL

Answer

The AUDIT_TRAIL parameter controls whether auditing is enabled and where audit records are stored, with values such as DB, OS, XML, or NONE.

Question 3

When AUDIT_TRAIL is set to DB, where are standard audit records stored?

Accepted Answer

In the SYS.AUD$ table in the database

Answer

When AUDIT_TRAIL=DB, Oracle writes audit records to the SYS.AUD$ table, which is accessible through the DBA_AUDIT_TRAIL data dictionary view.

Question 4

Which data dictionary view shows audit records for DDL and DML operations performed by database users?

Accepted Answer

DBA_AUDIT_TRAIL

Answer

DBA_AUDIT_TRAIL is a view over SYS.AUD$ that shows all standard audit trail entries including the user, action, object, and timestamp.

Question 5

What is Unified Auditing introduced in Oracle 12c?

Accepted Answer

A single consolidated audit framework that replaces all previous auditing methods with one policy-based system

Answer

Unified Auditing consolidates standard auditing, FGA, SYS auditing, and RMAN auditing into a single framework stored in AUDSYS.AUD$UNIFIED and managed via audit policies.

1Z0-082 - Oracle Database Administration I Practice Test

1Z0-082 - Oracle Database Administration I Practice Test

1Z0-082 Oracle Database Monitoring and Auditing 2