OCP 23ai New Features Practice Test 5 — 15 Questions

Question 1

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 2

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

Accepted Answer

AI Vector Search. AI Vector Search (B) is correct because Oracle 23ai introduces native VECTOR data type, vector indexes, and vector_distance functions, letting DBAs store and query embeddings directly in the database without a separate vector store, which simplifies AI-driven management and search workloads. JSON Duality (C) is correct because 23ai provides JSON Relational Duality Views, allowing the same underlying relational data to be accessed as JSON documents or as relational tables, eliminating the need to maintain duplicate schemas and simplifying application and data management. Lock-Free Reservations (D) is correct because 23ai enables concurrent transactions to reserve row capacity without blocking on row locks, reducing lock contention and deadlocks and thereby simplifying high-concurrency transaction management. Flashback Data Archive (A) is not one of the three new 23ai simplification features highlighted here, as it is a long-established Total Recall capability for tracking historical data, and Tablespace encryption (E) is likewise a pre-existing Transparent Data Encryption feature for data-at-rest protection, not a new 23ai management-simplification feature.

Answer

Flashback Data Archive

Answer

Tablespace encryption

Question 3

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 4

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 5

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

Accepted Answer

It forces parallel execution. The FORCE keyword in a parallel DML statement (e.g., ALTER SESSION FORCE PARALLEL DML) overrides session- or object-level restrictions and forces the statement to execute in parallel even if the optimizer would otherwise choose serial execution. It is an explicit directive to the SQL engine to use parallel DML.

Answer

It disables parallel DML

Answer

It runs sequentially

Answer

It causes an error

Question 6

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 7

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

Accepted Answer

Use standard UPDATE. Lock-Free Reservations in Oracle 23ai are designed to work transparently with standard DML. The database automatically detects when a column has a reservation column defined and uses the reservation mechanism to avoid row-level lock contention, so developers simply issue a normal UPDATE statement. No special API, procedure, or trigger is required — the optimization is applied by the database engine itself.

Answer

Disable row locking

Answer

Call a special procedure

Answer

Use a trigger

Question 8

Which THREE configuration steps are required to implement True Cache?

Accepted Answer

Update the connection pool. To implement True Cache, you must update the connection pool (A) so the application can route read-only queries to the True Cache instance via the appropriate connection descriptor, which is essential for directing traffic to the cache. You must also configure the True Cache instance (B) itself, which involves creating it with the True Cache-specific initialization parameters and associating it with the primary database so it can automatically receive and cache data. Additionally, you must enable on the application side (C), meaning the application must be configured to use the True Cache connection and set to read-only mode where appropriate, allowing it to leverage the cached data. Manual data refresh scripts (D) are not required because True Cache automatically refreshes data from the primary database, and disabling Data Guard (E) is not required since True Cache can coexist with Data Guard and does not depend on disabling it.

Answer

Manual data refresh scripts

Answer

Disable Data Guard

Question 9

An Oracle Database 23ai administrator supports an application that frequently runs ad hoc queries against a large JSON collection stored in an Oracle JSON column. Developers complain that every query must be rewritten to match the document structure, and they want the relational and JSON views of the same data to stay in sync without duplicating storage. The DBA enables JSON Relational Duality Views. Which statement correctly describes how the application benefits from this feature?

Accepted Answer

The duality view exposes relational tables as JSON documents that can be queried and updated with standard JSON and SQL, without duplicating data.. JSON Relational Duality Views let applications interact with relational data as JSON documents while the database continues to store the data relationally. The view is a definition, not a copy, so there is no duplicated storage and no synchronization job to manage. Reads and writes through the view are translated into operations on the base tables, keeping relational and JSON access consistent for ad hoc query workloads.

Answer

The duality view stores a second physical copy of the JSON documents, which the database keeps synchronized automatically.

Answer

The duality view can only be queried, not updated, so developers must use stored procedures for any data changes.

Answer

The duality view requires the base tables to be converted to a document-only storage model before it can be used.

Question 10

A financial services company runs an Oracle Database 23ai application that performs high-volume, concurrent inserts into a transaction history table. The DBA observes significant buffer busy waits and wants to reduce contention without changing the application. Which 23ai feature should be implemented?

Accepted Answer

Memoptimized Rowstore – Fast Ingest. Memoptimized Rowstore – Fast Ingest is specifically designed to handle high-volume, concurrent inserts by buffering them in memory and writing to disk asynchronously, thereby reducing buffer busy waits. The other options do not directly address the insert contention issue described.

Answer

Hybrid Columnar Compression

Answer

Automatic Indexing

Answer

Real Application Clusters (RAC) with services

Question 11

Your team maintains a large Oracle Database 23ai data warehouse. A new reporting application requires the ability to store and query JSON documents alongside relational data without duplicating the data or writing complex transformation logic. The application will issue both standard SQL queries and Oracle Database API for MongoDB (Oracle API for MongoDB) commands against the same underlying data. Which 23ai feature should you implement to satisfy this requirement?

Accepted Answer

JSON Relational Duality Views. JSON Relational Duality Views let you define a JSON document view over relational tables, so the same data can be queried with SQL and manipulated as JSON documents via Oracle API for MongoDB. This eliminates data duplication and transformation code, exactly matching the need for dual access in the data warehouse.

Answer

Blockchain Tables

Answer

Wide Tables

Answer

Memoptimized Rowstore

Question 12

A retail company uses Oracle Database 23ai and wants to enable real-time analytics on a high-volume OLTP table without impacting transaction performance. They decide to use the True Cache feature. Which statement correctly describes how True Cache achieves this?

Accepted Answer

True Cache is a memory-optimized cache that stores frequently accessed data and serves consistent reads, reducing load on the primary database.. True Cache is an in-memory read-only cache that offloads read traffic from the primary database by serving consistent reads. It automatically caches frequently accessed data and is transparent to applications, making it ideal for real-time analytics without impacting OLTP performance.

Answer

True Cache uses Oracle Active Data Guard to synchronize data and provides read-only access to the standby database.

Answer

True Cache automatically redirects all read queries to a read-only replica, ensuring zero impact on the primary database.

Answer

True Cache requires the application to explicitly route read queries to the cache using a connection pool.

Question 13

Your Oracle Database 23ai instance is running on an Exadata platform. You have a large table with a column of type VECTOR storing 768-dimensional embeddings. Users frequently run similarity searches using the VECTOR_DISTANCE function with the COSINE metric. To improve query performance, you create a vector index. After creation, you notice that some queries do not use the index and perform full table scans. What is the most likely reason for this behavior?

Accepted Answer

The queries are using a distance metric that differs from the one specified when the vector index was created, so the index cannot be used.. Vector indexes are created with a specific distance metric. If a query uses a different metric in VECTOR_DISTANCE, the optimizer cannot use the index and resorts to a full table scan. Ensuring that the query's metric matches the index's metric is essential for index usage.

Answer

The vector index is automatically disabled after any DML operation on the table and must be rebuilt before it can be used again.

Answer

The VECTOR column is defined with the FLOAT64 format, which is not supported by vector indexes.

Answer

The vector index is created with the default accuracy parameter, which may cause the optimizer to choose a full table scan for certain queries.

Question 14

A DBA is using Oracle Database 23ai and wants to implement a schema-level privilege analysis to monitor privileges used by applications. Which two statements are true about this feature? (Choose two.)

Accepted Answer

It can be scoped to a specific schema or the entire database.. Schema-level privilege analysis can capture privileges used by users or roles, including role-granted privileges, and can be scoped to a specific schema or the entire database. It does not require ARCHIVELOG mode, does not automatically revoke privileges, and does not require an additional license.

Answer

It requires the database to be in ARCHIVELOG mode.

Answer

It requires a separate license in addition to the Enterprise Edition license.

Answer

It automatically revokes unused privileges after the analysis period.

Question 15

You are designing a blockchain table in Oracle 23ai for an audit trail. You must ensure that the table provides tamper-evident storage and that users can verify the integrity of rows. Which two actions are required to set up and use a blockchain table correctly? (Choose two.)

Accepted Answer

Use the DBMS_BLOCKCHAIN_TABLE.VERIFY_ROWS procedure to validate the integrity of the blockchain.. To set up a blockchain table, you must use the BLOCKCHAIN clause with a retention period to ensure immutability. Verification of row integrity is performed using DBMS_BLOCKCHAIN_TABLE.VERIFY_ROWS, which checks the hash chain. Other options are either unnecessary or incorrect for blockchain table functionality.

Answer

Enable row-level security on the blockchain table to prevent unauthorized modifications.

Answer

Create a database trigger to compute a hash for each inserted row.

Answer

Grant the BLOCKCHAIN_ADMIN role to the schema owner.