OCP Practice Test 13 — 15 Questions

Question 1

Which THREE of the following are components of AI Vector Search in 23ai?

Accepted Answer

HNSW indexing. Option A (HNSW indexing) is correct because Oracle AI Vector Search in 23ai supports Hierarchical Navigable Small World (HNSW) vector indexes, an in-memory graph-based index type used for fast approximate nearest-neighbor similarity searches on vector embeddings. Option C (Vector distance functions) is correct because AI Vector Search provides built-in distance metrics such as COSINE, DOT (inner product), EUCLIDEAN, and EUCLIDEAN_SQUARED, exposed through SQL functions like VECTOR_DISTANCE, which are essential for ranking vectors by similarity. Option D (VECTOR data type) is correct because 23ai introduces the native VECTOR data type, allowing vector embeddings to be stored directly in tables as a first-class column type with a specified number of dimensions and format (e.g., FLOAT32, INT8, BINARY). Option B (Automatic backup) is not a component of AI Vector Search; it is a general database administration feature provided by RMAN and Oracle Cloud infrastructure, unrelated to vector search functionality. Option E (JSON Schema validation) is not part of AI Vector Search either; JSON schema validation relates to Oracle's JSON capabilities (e.g., IS JSON VALIDATE constraints), not to vector indexing, storage, or similarity search.

Answer

Automatic backup

Answer

JSON Schema validation

Question 2

How do you check the status of all current RMAN backup jobs?

Accepted Answer

SELECT * FROM V$RMAN_STATUS. V$RMAN_STATUS provides the most comprehensive view of backup job history and status.

Answer

SHOW ALL

Answer

LIST JOB SUMMARY

Answer

REPORT SCHEMA

Question 3

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. Oracle Data Masking and Subsetting Pack is designed to replace sensitive production data with realistic but fictitious values before it is used in non-production environments such as development, test, and QA. This protects sensitive data (PII, PCI, PHI) from exposure while preserving data format and referential integrity for application testing. It is not a performance, encryption-in-transit, or auditing tool.

Answer

To improve performance

Answer

To encrypt data in transit

Answer

To audit privileged users

Question 4

Can you use standard SQL DML on a Blockchain table?

Accepted Answer

Yes, standard SQL is supported. Yes, you can insert rows into a Blockchain table using standard INSERT statements.

Answer

Only via Java/JDBC

Answer

Only via stored procedures

Answer

No, it requires a special API

Question 5

When a PDB is in 'RESTRICTED' mode, which sessions are allowed?

Accepted Answer

Only users with RESTRICTED SESSION. Only users with RESTRICTED SESSION privilege are allowed.

Answer

All users

Answer

No users

Answer

Only SYSDBA

Question 6

What is the default location for RMAN backups if no FRA is configured?

Accepted Answer

The current working directory of the RMAN session.. If no Fast Recovery Area (FRA) is configured, RMAN backups default to the current working directory of the RMAN session. This means the backup pieces are created in the directory from which the RMAN client was invoked, unless an explicit format or location is specified.

Answer

The system tablespace.

Answer

The database home directory.

Answer

The redo log path.

Question 7

What is the recommended approach for updating data in a table using Lock-Free Reservations?

Accepted Answer

Use standard UPDATE. Lock-Free Reservations in Oracle 23ai are designed to work transparently with standard DML. The database automatically detects when a column has a reservation column defined and uses the reservation mechanism to avoid row-level lock contention, so developers simply issue a normal UPDATE statement. No special API, procedure, or trigger is required — the optimization is applied by the database engine itself.

Answer

Disable row locking

Answer

Call a special procedure

Answer

Use a trigger

Question 8

In the context of 23ai, what does 'True Cache' mean for application developers?

Accepted Answer

It is transparent to the application. Oracle 23ai True Cache is a transparent, read-only cache that sits in front of the primary database and serves read queries without requiring application changes. Applications connect to True Cache using the same connection string semantics, and the cache automatically routes reads while forwarding writes to the primary. Developers do not need to rewrite SQL, use a special driver, or flag queries.

Answer

They must write special SQL

Answer

They must use a specific driver

Answer

They must flag read queries

Question 9

For Memoptimized Write, where is the data initially stored before being written to the database?

Accepted Answer

SGA memory buffer. Memoptimized Write is an Oracle Database feature that accelerates high-frequency, low-latency inserts by buffering incoming row data in a dedicated area of the SGA called the Memoptimized Rowstore. Once the buffer fills or a threshold is reached, the data is asynchronously written to the database in bulk, reducing commit overhead and improving throughput. The SGA buffer acts as a staging area, so the data is not immediately persisted to disk or redo logs until the write is flushed.

Answer

Flash cache

Answer

Undo tablespace

Answer

Redo log

Question 10

Which view provides information about the open status of all PDBs in a CDB?

Accepted Answer

V$PDBS. V$PDBS provides the current status of each PDB in the container database.

Answer

V$INSTANCE

Answer

V$CONTAINERS

Answer

V$DATABASE

Answer

DBA_PDBS

Question 11

How does 23ai handle vector distance calculations at scale?

Accepted Answer

Using optimized native SQL execution. Oracle Database 23ai implements vector distance calculations natively inside the database engine, so operations such as VECTOR_DISTANCE are executed as optimized native SQL rather than being shipped to external services. This allows the optimizer to use vector indexes (such as HNSW or IVF) and parallel execution to compute distances at scale while keeping data local and transactionally consistent. The result is that similarity search can be combined with relational filters in a single SQL statement.

Answer

By offloading to external servers

Answer

By caching every result

Answer

Using a temporary tablespace

Question 12

What is the primary benefit of using Unified Auditing in 23ai?

Accepted Answer

Simplified audit management and unified audit trail. Unified Auditing provides a single, unified audit trail for all audit records from various sources.

Answer

Improved query performance for application tables

Answer

Increased storage capacity

Answer

Automatic data masking

Question 13

Which background process is responsible for capturing AWR snapshots?

Accepted Answer

MMNL. The MMNL (Manageability Monitor) process is responsible for AWR snapshots.

Answer

PMON

Answer

DBWn

Answer

LGWR

Question 14

Which command is used to move a PDB from one CDB to another without using Data Pump?

Accepted Answer

ALTER PLUGGABLE DATABASE UNPLUG. The unplug/plug method using an XML metadata file is the standard for PDB transport.

Answer

CREATE PDB AS CLONE

Answer

DBMS_PDB.COPY

Answer

MOVE PLUGGABLE DATABASE

Question 15

What is the primary role of the 'Patching' phase in an upgrade?

Accepted Answer

To apply necessary updates to the dictionary. Ensuring the binaries and the data dictionary match the desired target version.

Answer

To clear the redo logs

Answer

To reorganize the tables

Answer

To increase memory