OCP 23ai New Features Practice Test 4 — 15 Questions

Question 1

What allows Memoptimized Write to perform so quickly?

Accepted Answer

Avoiding synchronous redo writing. It avoids writing to the redo log synchronously.

Answer

Skipping index updates

Answer

Using NVMe storage

Answer

Disabling constraints

Question 2

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 3

When using parallel DML, which system parameter limits the degree of parallelism?

Accepted Answer

PARALLEL_DEGREE_LIMIT. PARALLEL_DEGREE_LIMIT restricts the degree of parallelism.

Answer

MAX_PARALLEL_THREADS

Answer

DB_PARALLEL_LIMIT

Answer

SESSION_PARALLEL_MAX

Question 4

What is the primary characteristic of a Blockchain table in 23ai?

Accepted Answer

It is immutable. It is an insert-only, immutable table.

Answer

It is for temporary data

Answer

It allows row deletion

Answer

It can be updated

Question 5

Which of these is a requirement for using True Cache?

Accepted Answer

Support from the connection pool. True Cache requires a connection pool that supports True Cache features.

Answer

An exclusive server

Answer

Special SQL syntax

Answer

A manual cache update script

Question 6

When migrating to 23ai, what is the impact of switching to the VECTOR data type for existing applications?

Accepted Answer

Code updates for vector handling. Applications need to be updated to use the new native vector support.

Answer

No code changes required

Answer

Requires a new driver

Answer

Complete rewrite of SQL

Question 7

Which THREE features are enabled in 23ai to simplify database management?

Accepted Answer

AI Vector Search. JSON Duality, Lock-Free Reservations, and Vector Search are key 23ai management/performance features.

Answer

Flashback Data Archive

Answer

Tablespace encryption

Question 8

How does Memoptimized Write affect data integrity?

Accepted Answer

It maintains ACID compliance. Memoptimized Write is fully compliant with ACID properties.

Answer

It bypasses ACID compliance

Answer

It uses eventual consistency

Answer

It is only for non-critical data

Question 9

What is the result of a 'vector similarity' search?

Accepted Answer

Rows sorted by similarity distance. It returns rows sorted by distance.

Answer

The average value

Answer

A random sample

Answer

A list of exact matches

Question 10

When configuring parallel DML, what is the effect of setting 'FORCE' on a statement?

Accepted Answer

It forces parallel execution. The FORCE hint forces the statement to run in parallel regardless of the cost optimizer's decision.

Answer

It disables parallel DML

Answer

It runs sequentially

Answer

It causes an error

Question 11

In 23ai, what does 'Wide Tables' refer to?

Accepted Answer

Tables with more than 1000 columns. Wide Tables allow for a significantly increased number of columns.

Answer

Tables with large rows

Answer

Tables with long text

Answer

Tables across multiple disks

Question 12

Which component is responsible for the verification of Blockchain tables?

Accepted Answer

DBMS_BLOCKCHAIN_TABLE. The DBMS_BLOCKCHAIN_TABLE package is the interface for verification.

Answer

RMAN

Answer

The Database Vault

Answer

The SQL optimizer

Question 13

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 14

Which THREE configuration steps are required to implement True Cache?

Accepted Answer

Update the connection pool. True Cache requires a connection, configuration, and a compatible application driver.

Answer

Manual data refresh scripts

Answer

Disable Data Guard

Question 15

What is the main benefit of JSON Duality Views?

Accepted Answer

Simplified data access. It provides a bidirectional view of the data, both as JSON and as relational rows.

Answer

Automatic translation

Answer

Lower licensing costs

Answer

Faster storage