OCP Practice Test 9 — 10 Questions

Question 1

You are reviewing security best practices for 23ai. Which THREE of the following represent recommended actions to harden a production instance?

Accepted Answer

Apply the latest quarterly Release Update (RU). Using Oracle Key Vault, enforcing password complexity, and applying the latest Release Updates are core hardening practices.

Answer

Run database in NoArchiveLog mode for security

Answer

Disable all default schemas immediately

Question 2

What is the primary purpose of 'Data Masking' in the Oracle Data Masking and Subsetting Pack?

Accepted Answer

To protect sensitive data in non-production databases. Data masking permanently obscures sensitive data in a non-production environment.

Answer

To improve performance

Answer

To encrypt data in transit

Answer

To audit privileged users

Question 3

When upgrading a database, what is a 'Flashback Database' used for?

Accepted Answer

Quick recovery after a failed upgrade. Flashback Database allows you to quickly revert to a point-in-time if the upgrade fails.

Answer

User authentication

Answer

Data migration

Answer

Performance tuning

Question 4

Which THREE of the following are valid methods to patch an Oracle 23ai database?

Accepted Answer

OPatchAuto. OPatch, OPatchAuto, and Fleet Patching and Provisioning (FPP) are the standard methods for patching Oracle databases.

Answer

Data Pump Patching

Answer

SQL*Plus Patch

Question 5

Which TWO components must be secured to maintain database integrity?

Accepted Answer

Data files. The data files and the backup files must be secured to prevent tampering.

Answer

User manual

Answer

System logs

Answer

Client browser

Question 6

Which TWO audit trails can be enabled simultaneously?

Accepted Answer

Unified Audit. Unified and traditional audit trails can both be active, though it is not recommended.

Answer

Redo log audit

Answer

Memory audit

Answer

Tablespace audit

Question 7

What is the purpose of the 'Wallet' in Oracle security?

Accepted Answer

To store encryption keys and credentials. A wallet stores sensitive credentials like passwords and encryption keys.

Answer

To backup the database

Answer

To manage database users

Answer

To improve query performance

Question 8

Which view displays the list of active Unified Audit policies?

Accepted Answer

AUDIT_UNIFIED_POLICIES. AUDIT_UNIFIED_POLICIES shows the policies defined in the database.

Answer

UNIFIED_AUDIT_TRAIL

Answer

DBA_AUDIT_POLICIES

Answer

DBA_PRIV_AUDIT_POLICIES

Question 9

What is the best way to ensure an encrypted connection between the application server and the database?

Accepted Answer

Using Native Network Encryption. Configuring Native Network Encryption (NNE) or TLS on the listener ensures encrypted traffic.

Answer

Using Audit Vault

Answer

Using Database Vault

Answer

Using TDE

Question 10

Which THREE items are generally included in an Oracle Patch?

Accepted Answer

Security updates. Patches typically contain bug fixes, security updates, and performance improvements.

Answer

Application source code

Answer

New hardware drivers