OCP Practice Test 2 — 10 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

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 3

In the context of Wide Tables, what is a recommended best practice?

Accepted Answer

Maintain logical data grouping. Despite the high column limit, logical design should still be considered.

Answer

Only use for read-only data

Answer

Disable all indexes

Answer

Use as many columns as possible

Question 4

When creating a Wide Table, what is the physical storage impact compared to a standard table?

Accepted Answer

It is more space-efficient for sparse data. Wide tables are implemented to be space efficient, utilizing Oracle's storage engine enhancements.

Answer

It disables compression

Answer

Requires separate tablespaces

Answer

It uses more storage due to padding

Question 5

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 6

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 7

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 8

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

Accepted Answer

Use standard UPDATE. The application performs the update, and Oracle handles the non-blocking logic.

Answer

Disable row locking

Answer

Call a special procedure

Answer

Use a trigger

Question 9

What is the purpose of the 'no drop' clause in Blockchain table creation?

Accepted Answer

Prevent table deletion. It prevents the table from being dropped until the retention period expires.

Answer

Restrict access

Answer

Prevent data modification

Answer

Protect index integrity

Question 10

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