OCP Practice Test 5 — 25 Questions

Question 1

Which THREE actions can be performed on an HNSW vector index in 23ai?

Accepted Answer

ALTER INDEX ... REBUILD. HNSW indexes support building, rebuilding, and usage in similarity search.

Answer

DROP INDEX

Answer

PARTITION

Question 2

You are monitoring parallel DML performance. Which view provides the best insight into current parallel server activity?

Accepted Answer

V$PX_SESSION. V$PX_SESSION provides real-time information on parallel sessions.

Answer

V$DATABASE

Answer

V$SESSION

Answer

V$PARALLEL_DEGREE

Question 3

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 4

You are using Block Change Tracking (BCT). Where is the BCT file stored?

Accepted Answer

In the Fast Recovery Area (FRA).. The BCT file is managed by the database and typically stored in the FRA or as defined by the DB_BLOCK_CHANGETRACKING_FILE parameter.

Answer

In the SYSTEM tablespace.

Answer

In the control file.

Answer

In the redo log files.

Question 5

Which THREE steps are involved in an RMAN-based cross-platform migration of a data file using CONVERT?

Accepted Answer

Transport the converted file to the target.. The process requires the file to be backed up, converted, and moved to the destination.

Answer

Run the RECOVER DATABASE command on the source.

Answer

Disable Archivelog mode on the target.

Question 6

You are performing a cross-platform transportable tablespace migration from Linux to Windows. Which RMAN command is required to convert the datafiles for the destination platform?

Accepted Answer

CONVERT TABLESPACE ... TO PLATFORM 'Microsoft Windows x86 64-bit';. The CONVERT TABLESPACE command is used to change the endian format for cross-platform migrations.

Answer

ALTER TABLESPACE ... CONVERT;

Answer

RMAN TRANSPORT ...

Answer

RMAN COPY ...

Question 7

Which TWO of the following statements about True Cache are correct?

Accepted Answer

It resides in the application tier. True Cache is read-only and is deployed in the application tier.

Answer

It replaces Data Guard

Answer

It requires a dedicated database

Answer

It supports DML operations

Question 8

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 9

Which TWO statements are true regarding the use of a Recovery Catalog?

Accepted Answer

It can be used to store backup scripts.. A recovery catalog provides history beyond the control file limit and centralizes metadata for multiple databases.

Answer

It is required to perform RMAN backups.

Answer

It is physically located inside the target database.

Answer

It eliminates the need for control file autobackups.

Question 10

Which SQL function is used to calculate the similarity between two vectors?

Accepted Answer

VECTOR_DISTANCE(). VECTOR_DISTANCE is the standard operator for similarity search in 23ai.

Answer

COSINE_SIM()

Answer

DIST()

Answer

SIMILARITY()

Question 11

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 12

You are configuring a recovery catalog in Oracle 23ai. Which command must you execute first to ensure the catalog is ready to register the target database?

Accepted Answer

CREATE CATALOG;. The CREATE CATALOG command must be executed to initialize the schema before registration.

Answer

REGISTER DATABASE;

Answer

CONNECT CATALOG;

Answer

UPGRADE CATALOG;

Question 13

What is the primary purpose of the Flashback Database feature?

Accepted Answer

To revert the entire database to a point in time. Flashback Database allows you to return the entire database to a previous point in time without restoring from a backup.

Answer

To restore individual corrupted datafiles

Answer

To recover dropped tables

Answer

To undo a specific transaction

Question 14

You are restoring a database and need to use a backup control file. Which clause is mandatory in the recover command?

Accepted Answer

USING BACKUP CONTROLFILE. The 'USING BACKUP CONTROLFILE' clause is required when you are not using the current control file.

Answer

WITH EXTERNAL CONTROLFILE

Answer

RECOVER CONTROLFILE

Answer

USING OLD CONTROLFILE

Question 15

Which TWO parameters are critical for PDB resource management?

Accepted Answer

MAX_PDB_CPU. PDB_SGA_TARGET and CPU_COUNT (or PDB_CPU_COUNT) control PDB resources.

Answer

MEMORY_MAX_TARGET

Answer

SGA_MAX_SIZE

Answer

PDB_DATA_LIMIT

Question 16

Which THREE parameters can be set at the PDB level?

Accepted Answer

SGA_TARGET. SGA_TARGET, UNDO_TABLESPACE, and DB_FILE_NAME_CONVERT can be PDB-specific.

Answer

PROCESSES

Answer

DB_NAME

Question 17

You are migrating a non-CDB database to a PDB in a 23ai CDB using the remote cloning method. Which condition must be met for the non-CDB to be successfully plugged in?

Accepted Answer

The non-CDB must be in READ ONLY mode. When plugging in a non-CDB, it must be opened in READ ONLY mode to ensure consistency during the cloning process, and the non-CDB must be at a version compatible with the CDB.

Answer

The non-CDB must be in MOUNTED state

Answer

The non-CDB must be in ARCHIVELOG mode

Answer

The non-CDB must have an identical DBID to the CDB

Question 18

You are migrating an Oracle 23ai database to a different platform with different endianness. Which RMAN command is used to convert the datafiles to the target platform format?

Accepted Answer

RMAN> CONVERT DATAFILE '...' TO PLATFORM '...' FROM PLATFORM '...';. The CONVERT DATAFILE command is required when the source and destination platforms have different endian formats.

Answer

RMAN> CONVERT DATABASE ON TARGET PLATFORM;

Answer

RMAN> RESTORE DATAFILE FROM PLATFORM;

Answer

ALTER DATABASE CONVERT TO PLATFORM;

Question 19

You want to perform a point-in-time recovery to a specific timestamp. Which RMAN command is used to set the target time?

Accepted Answer

SET UNTIL TIME '2023-10-10:10:00:00'. SET UNTIL TIME is the standard way to define the recovery point.

Answer

FLASHBACK DATABASE TO TIME '2023-10-10:10:00:00'

Answer

SET TIME '2023-10-10 10:00:00'

Answer

RECOVER DATABASE TO '2023-10-10:10:00:00'

Question 20

When managing local and common users in a 23ai CDB, which TWO of the following statements are correct?

Accepted Answer

Common users can only be created in the root container.. Common users must be created in the root (CDB$ROOT) and local users are specific to individual PDBs.

Answer

Local users are automatically created in all PDBs by default.

Answer

Common users can grant local roles to other common users.

Answer

Local users can grant privileges to common users.