OCP Practice Test 1 — 30 Questions

Question 1

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 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

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 4

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 5

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 6

When configuring Memoptimized Write, what is the role of the 'flush' operation?

Accepted Answer

It moves data to the data files. The flush operation moves data from the memory buffer to the physical data blocks.

Answer

It validates data constraints

Answer

It clears the cache

Answer

It deletes the data

Question 7

Which THREE of the following are benefits of the JSON Duality feature?

Accepted Answer

Simplified application development. Duality simplifies coding, maintains consistency, and supports native SQL access.

Answer

Automatic data encryption

Answer

No indexing required

Question 8

How does 23ai handle vector distance calculations at scale?

Accepted Answer

Using optimized native SQL execution. 23ai optimizes these calculations in the SQL engine.

Answer

By offloading to external servers

Answer

By caching every result

Answer

Using a temporary tablespace

Question 9

Which TWO of the following are benefits of using an RMAN recovery catalog?

Accepted Answer

Stores backup metadata for multiple databases.. Centralization and extended retention are key benefits.

Answer

Automatically encrypts all backups.

Answer

Eliminates the need for archivelogs.

Answer

Provides faster database performance.

Question 10

Which THREE actions are performed during the 'RESTORE DATABASE' command?

Accepted Answer

Restoring datafiles to the disk.. Restoring files, updating the control file, and verifying existence are key.

Answer

Opening the database with RESETLOGS.

Answer

Performing media recovery.

Question 11

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 12

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 13

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 14

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 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

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 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

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 19

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 20

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