OCP 23ai New Features — Timed 30 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

Question 16

When using Wide Tables, what is the impact on performance for queries that select only a small subset of columns?

Accepted Answer

No significant performance degradation. Wide Tables in 23ai are optimized to handle many columns without significant performance degradation compared to vertical splitting.

Answer

Severe performance degradation

Answer

Requires partitioning

Answer

Requires a full table scan

Question 17

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

Accepted Answer

SGA memory buffer. Memoptimized Write uses a buffer in the SGA to speed up the ingestion process.

Answer

Flash cache

Answer

Undo tablespace

Answer

Redo log

Question 18

Which TWO features of 23ai help improve performance of high-concurrency workloads?

Accepted Answer

Lock-Free Reservations. Lock-Free Reservations and Memoptimized Write are specifically for high-concurrency improvements.

Answer

Wide tables

Answer

Blockchain tables

Answer

JSON Duality

Question 19

What is the main requirement for an existing table to be converted into a Blockchain table?

Accepted Answer

Tables cannot be converted to Blockchain. A table cannot be converted to a Blockchain table; it must be created as such.

Answer

The table must have an index

Answer

The table must be partitioned

Answer

The table must be empty

Question 20

In True Cache, how is consistency maintained with the primary database?

Accepted Answer

Asynchronous replication. True Cache uses the database's internal replication mechanisms to stay consistent.

Answer

Manual refreshes

Answer

Polling

Answer

Synchronous writes