OCP 23ai New Features Practice Test 2 — 15 Questions

Question 1

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 2

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 3

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 4

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 5

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

Question 6

When using the VECTOR data type, what is the maximum number of dimensions supported?

Accepted Answer

2048. Oracle 23ai supports up to 2048 dimensions for the vector data type.

Answer

512

Answer

1024

Answer

4096

Question 7

You are configuring Parallel DML and want to ensure the session uses the maximum available resources. Which hint should you use?

Accepted Answer

/*+ PARALLEL(table, n) */. The PARALLEL hint allows you to specify the degree of parallelism for a statement.

Answer

/*+ MAX_PARALLEL */

Answer

/*+ SERIAL */

Answer

/*+ DML_PARALLEL */

Question 8

Which type of operation is ideal for Blockchain tables?

Accepted Answer

Audit logs and financial records. Blockchain tables are designed for audit trails where history must be preserved.

Answer

General configuration tables

Answer

Transient cache data

Answer

High-frequency temporary storage

Question 9

Which parameter controls the behavior of the Memoptimized Write buffer size?

Accepted Answer

MEMOPTIMIZE_POOL_SIZE. The MEMOPTIMIZE_POOL_SIZE parameter manages the memory allocated for the fast ingest buffer.

Answer

DB_BUFFER_CACHE

Answer

LARGE_POOL_SIZE

Answer

FAST_INGEST_BUFFER

Question 10

Which THREE operations are permitted on Blockchain tables?

Accepted Answer

VERIFY. You can insert, select, and verify rows in a Blockchain table.

Answer

DELETE

Answer

UPDATE

Question 11

What is the primary function of the 'JSON relational duality' feature?

Accepted Answer

To map relational data to JSON. It provides a unified way to work with JSON and relational data simultaneously.

Answer

To compress JSON data

Answer

To encrypt JSON data

Answer

To index JSON data

Question 12

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

Accepted Answer

It is transparent to the application. Developers can offload read operations to True Cache without changing their application logic.

Answer

They must write special SQL

Answer

They must use a specific driver

Answer

They must flag read queries

Question 13

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 14

Which of the following is true regarding Vector embeddings in 23ai?

Accepted Answer

They are stored as arrays of floats. Vectors are typically generated by AI models and stored as arrays of floats.

Answer

They are stored as metadata

Answer

They are stored as images

Answer

They are stored as text

Question 15

When running parallel DML in 23ai, what happens to the data if the transaction fails?

Accepted Answer

The entire transaction is rolled back. Parallel DML operations are fully atomic and follow standard rollback procedures.

Answer

Partial data is committed

Answer

Only the DML part is rolled back

Answer

Requires a manual cleanup