OCP OCP Security and Auditing

Question 1

Which Oracle feature enables row-level security by dynamically appending a WHERE clause to queries on a table?

Accepted Answer

Virtual Private Database (VPD)

Answer

Virtual Private Database (VPD) enforces row-level security by attaching policy functions that add a WHERE clause to queries transparently.

Question 2

Which system privilege must be granted to a user to allow them to establish a connection to an Oracle database?

Accepted Answer

CREATE SESSION

Answer

CREATE SESSION is the system privilege required for a user to open a session and connect to an Oracle database.

Question 3

What does the AUDIT_TRAIL initialization parameter control in Oracle?

Accepted Answer

Destination where audit records are written

Answer

AUDIT_TRAIL determines where Oracle writes audit records, such as to the database (DB), operating system files (OS), or XML files.

Question 4

Which Oracle security feature encrypts tablespaces and data files at the storage level without requiring application changes?

Accepted Answer

Transparent Data Encryption (TDE)

Answer

Transparent Data Encryption (TDE) encrypts data at rest in tablespaces and data files, remaining invisible to the application.

Question 5

What is the effect of granting a system privilege WITH ADMIN OPTION to a user?

Accepted Answer

The user can grant that system privilege to other users

Answer

WITH ADMIN OPTION allows the grantee to further grant the same system privilege to other users or roles.

(OCP) Oracle Certified Professional Practice Test