OCP Practice Test 14 — 15 Questions

Question 1

Which TWO of the following are valid methods to move a database across platforms using RMAN?

Accepted Answer

Transportable Tablespaces. Transportable Tablespaces and RMAN CONVERT DATABASE are the two primary supported methods for moving data across platforms.

Answer

RMAN DUPLICATE DATABASE FROM ACTIVE DATABASE

Answer

Data Pump Export/Import with Full Database mode

Answer

RMAN BACKUP AS COPY

Question 2

You notice that a specific query is performing very slowly due to excessive 'direct path read' waits. What is the most likely cause?

Accepted Answer

The query is performing a full table scan. Direct path reads often occur during full table scans when the data is not in the buffer cache.

Answer

The library cache is too small

Answer

The PGA is too large

Answer

The redo logs are too small

Question 3

You need to ensure that the PDB name is unique in your network. Which parameter should you check?

Accepted Answer

DB_UNIQUE_NAME. DB_UNIQUE_NAME must be unique across the CDB infrastructure.

Answer

INSTANCE_NAME

Answer

DB_NAME

Answer

PDB_NAME

Question 4

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 5

Which of these is a benefit of using JSON Duality Views?

Accepted Answer

Unified JSON and relational access. It allows developers to work with JSON while maintaining relational data integrity.

Answer

Mandatory schema changes

Answer

Improved backup speeds

Answer

Increased storage size

Question 6

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 7

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 8

What is the default behavior when a session is set to use True Cache?

Accepted Answer

Transparent read routing. The session automatically routes queries to the cache if valid.

Answer

Manual route selection

Answer

Requires a DB restart

Answer

Error if cache is empty

Question 9

When configuring Lock-Free Reservations, what must be done to the column being updated?

Accepted Answer

It must be numeric. The column must be a numeric type enabled for reservations.

Answer

It must be a primary key

Answer

It must be in a partitioned table

Answer

It must be indexed

Question 10

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 11

Which TWO RMAN configurations are recommended to optimize backup performance in a high-transaction environment?

Accepted Answer

CONFIGURE DEVICE TYPE DISK PARALLELISM 4;. Parallelism and block change tracking are primary performance tuners.

Answer

CONFIGURE COMPRESSION ALGORITHM 'MEDIUM';

Answer

CONFIGURE MAXSETSIZE TO 10G;

Answer

CONFIGURE CONTROLFILE AUTOBACKUP OFF;

Question 12

Which THREE tasks are performed by the 'RECOVER' command during a data file restore?

Accepted Answer

Applying archived redo logs.. It applies logs, verifies file status, and marks files as online.

Answer

Restoring the datafiles from backup.

Answer

Creating new control files.

Question 13

You are performing a tablespace recovery. What is the first thing that must happen to the tablespace before recovery can start?

Accepted Answer

The tablespace must be taken offline.. The tablespace must be taken offline to perform recovery on its constituent datafiles.

Answer

The tablespace must be set to read-only.

Answer

The database must be shut down.

Answer

The database must be in restricted mode.

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

Which TWO parameters are essential for configuring the environment for Wide Tables?

Accepted Answer

DB_BLOCK_SIZE. Wide tables rely on specific database settings to handle the large number of columns.

Answer

SQL_TRACE

Answer

PARALLEL_MAX_SERVERS

Answer

MAX_COLUMNS