OCP 23ai New Features — 15 Questions

Question 1

You are implementing AI Vector Search in Oracle Database 23ai. Which data type is mandatory for storing vector embeddings?

Accepted Answer

VECTOR. The VECTOR data type is specifically designed for high-performance similarity search in Oracle 23ai.

Answer

BLOB

Answer

CLOB

Answer

JSON

Question 2

You are migrating a legacy application to use Wide Tables in 23ai. What is the maximum number of columns supported by a Wide Table?

Accepted Answer

4096. Oracle 23ai supports up to 4096 columns in a table.

Answer

1000

Answer

8192

Answer

2048

Question 3

To enable lock-free reservations on a table, which clause must be used in the CREATE or ALTER TABLE statement?

Accepted Answer

LOCK-FREE RESERVATIONS. The LOCK-FREE RESERVATIONS clause enables updates to numeric columns without traditional row-level locking.

Answer

ENABLE LOCK-FREE

Answer

RESERVATIONS ON

Answer

CONCURRENT DML

Question 4

When using Blockchain Tables, what is the default behavior for rows that have reached their 'no drop' period?

Accepted Answer

Rows remain immutable until deleted manually. Blockchain tables prevent modification and deletion until the retention period expires.

Answer

Rows are moved to archive storage

Answer

Rows are automatically purged

Answer

Rows become updateable

Question 5

You have a vector index and notice search performance is slow. Which index type should you use to optimize similarity search?

Accepted Answer

HNSW. HNSW (Hierarchical Navigable Small World) index is the standard for efficient vector similarity search in 23ai.

Answer

Inverted Index

Answer

B-tree

Answer

Bitmap

Question 6

When configuring Parallel DML in 23ai, which parameter must be set to 'ALWAYS' to ensure parallel execution for DML statements without hints?

Accepted Answer

ENABLE_PARALLEL_DML. Setting ENABLE_PARALLEL_DML to ALWAYS ensures that all DML operations are executed in parallel if possible.

Answer

PARALLEL_DEGREE_LIMIT

Answer

DML_PARALLEL_MODE

Answer

PARALLEL_EXECUTION_ENABLED

Question 7

Which database feature is recommended for high-frequency inserts into a single table with minimal overhead?

Accepted Answer

Memoptimized Write. Memoptimized Write (Fast Ingest) is designed for high-frequency inserts.

Answer

Materialized Views

Answer

Flashback

Answer

Partitioning

Question 8

Which component allows True Cache to provide high performance for read-only workloads by caching data on the application tier?

Accepted Answer

True Cache. True Cache is a read-only cache that resides in the application tier to offload the primary database.

Answer

Result Cache

Answer

Data Guard

Answer

Oracle Connection Manager

Question 9

What is the primary benefit of Lock-Free Reservations in high-concurrency environments?

Accepted Answer

Reduced row-level locking contention. It eliminates wait events associated with row-level locking for numeric updates.

Answer

Faster queries

Answer

Better compression

Answer

Automatic indexing

Question 10

Which TWO of the following statements about True Cache are correct?

Accepted Answer

It resides in the application tier. True Cache is read-only and is deployed in the application tier.

Answer

It replaces Data Guard

Answer

It requires a dedicated database

Answer

It supports DML operations

Question 11

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

Accepted Answer

HNSW indexing. AI Vector Search includes the VECTOR data type, vector indexing, and SQL operators for distance calculation.

Answer

Automatic backup

Answer

JSON Schema validation

Question 12

Which SQL function is used to calculate the similarity between two vectors?

Accepted Answer

VECTOR_DISTANCE(). VECTOR_DISTANCE is the standard operator for similarity search in 23ai.

Answer

COSINE_SIM()

Answer

DIST()

Answer

SIMILARITY()

Question 13

In 23ai, when using the 'JSON relational duality' feature, how are changes to the JSON document propagated to the underlying tables?

Accepted Answer

Automatically propagated by the database. Updates made via JSON Duality Views are transparently propagated to the underlying relational tables using the view's defined mapping.

Answer

Only allowed via stored procedures

Answer

Manual re-synchronization

Answer

Requires a trigger

Question 14

You want to use Memoptimized Write to speed up data ingestion. Which type of table should you use?

Accepted Answer

Heap-organized table. Memoptimized Write is specifically enabled on tables that have the MEMOPTIMIZE FOR WRITE clause.

Answer

External table

Answer

Global temporary table

Answer

Index-organized table

Question 15

What happens if a user tries to drop a Blockchain table that still contains rows within the retention period?

Accepted Answer

The command fails with an error. Blockchain tables protect against deletion of the table itself if rows are within the protection period.

Answer

The command succeeds

Answer

The table is renamed to _OLD

Answer

The rows are archived then dropped