OCP OCP Security and Auditing 2

Question 1

Which Oracle auditing framework introduced in Oracle 12c consolidates all audit data into a single unified audit trail?

Accepted Answer

Unified Auditing

Answer

Unified Auditing, introduced in Oracle 12c, consolidates audit records from all sources into a single trail in the AUDSYS schema.

Question 2

Which Oracle component creates 'realms' to prevent even privileged DBAs from accessing sensitive application data?

Accepted Answer

Oracle Database Vault

Answer

Oracle Database Vault uses realms and command rules to restrict privileged users, including DBAs, from accessing protected data.

Question 3

What is the default profile automatically assigned to a new Oracle user if no profile is specified during creation?

Accepted Answer

DEFAULT

Answer

The DEFAULT profile is automatically assigned to all new Oracle users unless a specific profile is named in the CREATE USER statement.

Question 4

Which data dictionary view shows the auditing options currently configured for individual database objects?

Accepted Answer

DBA_OBJ_AUDIT_OPTS

Answer

DBA_OBJ_AUDIT_OPTS displays the audit options set for every database object, showing which operations are audited.

Question 5

What does Oracle Data Redaction do to sensitive data when a user queries a protected column?

Accepted Answer

Masks the value in query results without altering stored data

Answer

Oracle Data Redaction dynamically replaces sensitive column values in query output while leaving the actual stored data unchanged.

(OCP) Oracle Certified Professional Practice Test