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

Oracle Label Security

Answer

Oracle Database Vault

Answer

Transparent Data Encryption

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

CONNECT

Answer

DATABASE ACCESS

Answer

LOGIN

Question 3

What does the AUDIT_TRAIL initialization parameter control in Oracle?

Accepted Answer

Destination where audit records are written

Answer

Retention period of audit records

Answer

Users exempt from auditing

Answer

Maximum size of the audit trail

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

Oracle Data Redaction

Answer

Oracle Data Masking

Answer

Oracle Advanced Security Gateway

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

The privilege becomes permanent and cannot be revoked

Answer

The privilege is restricted to administrative schemas only

Answer

The user inherits all DBA-level privileges

Question 6

Which data dictionary view displays all system privileges granted to users and roles in Oracle?

Accepted Answer

DBA_SYS_PRIVS

Answer

DBA_ROLE_PRIVS

Answer

SESSION_PRIVS

Answer

ALL_GRANTED_PRIVS