OCP Practice Test 2 — 25 Questions

Question 1

Which TWO RMAN settings significantly improve performance during backup operations on an Exadata system?

Accepted Answer

CONFIGURE BACKUP OPTIMIZATION ON;. Backup optimization and parallelism settings directly impact throughput on high-performance storage.

Answer

CONFIGURE CHANNEL ... RATE 10M;

Answer

CONFIGURE MAXSETSIZE UNLIMITED;

Answer

CONFIGURE CONTROLFILE AUTOBACKUP OFF;

Question 2

Which THREE conditions must be met to perform a successful RMAN cross-platform transportable tablespace migration?

Accepted Answer

The RMAN CONVERT command must be used if endianness differs.. The databases must be at compatible levels, endian formats must be checked, and the tablespace must be read-only.

Answer

The source platform must be the same endian as the target.

Answer

The source and destination databases must have the same DBID.

Question 3

You need to identify the top SQL statements consuming the most CPU resources in an Oracle 23ai database over the last hour. Which tool provides the most direct analysis of this performance issue?

Accepted Answer

Automatic Workload Repository (AWR) report. AWR reports provide aggregated data over a specific time range, making them ideal for identifying resource consumers.

Answer

SQL Tuning Advisor

Answer

Active Session History (ASH) report

Answer

SQL Plan Management

Question 4

How is AI Vector Search integrated into SQL?

Accepted Answer

Using standard SQL syntax. Vector search uses standard SQL operators like VECTOR_DISTANCE.

Answer

Via external API calls

Answer

Via a new programming language

Answer

Via PL/SQL only

Question 5

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 6

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 7

If you are in ARCHIVELOG mode, what is the primary benefit of having a multiplexed control file?

Accepted Answer

Redundancy against disk failure.. Multiplexing control files provides fault tolerance against disk failure of the control file location.

Answer

Faster backup performance.

Answer

Ability to perform point-in-time recovery.

Answer

Automatic database tuning.

Question 8

You have a vector index and notice search performance is slow. Which index type should you use to optimize similarity search?

Accepted Answer

HNSW. HNSW (Hierarchical Navigable Small World) index is the standard for efficient vector similarity search in 23ai.

Answer

Inverted Index

Answer

B-tree

Answer

Bitmap

Question 9

A user accidentally dropped a critical table. You decide to use Flashback Table. What is the mandatory prerequisite before this command can execute?

Accepted Answer

Row movement must be enabled on the table.. Row movement must be enabled for the table to move rows back to their original IDs, and flashback must be enabled.

Answer

The table must have a Primary Key.

Answer

The database must be in ARCHIVELOG mode.

Answer

The Recycle Bin must be disabled.

Question 10

You need to perform a table-level point-in-time recovery. Which RMAN command syntax is correct?

Accepted Answer

RECOVER TABLE HR.EMPLOYEES UNTIL SCN 12345;. RECOVER TABLE ... UNTIL SCN is the syntax for table-level recovery.

Answer

RESTORE TABLE ...

Answer

FLASHBACK TABLE ...

Answer

IMPORT TABLE ...

Question 11

You need to perform a Table Point-in-Time Recovery (TPITR) to restore a table to a state before a mistaken DROP TABLE operation. Which RMAN command performs this operation while minimizing impact to other tablespaces?

Accepted Answer

RECOVER TABLE ... UNTIL SCN ...;. The RECOVER TABLE command is specifically designed for table-level recovery, which creates an auxiliary instance automatically to extract the table data.

Answer

FLASHBACK TABLE ... TO SCN ...;

Answer

IMPORT FROM BACKUPSET ...;

Answer

RESTORE TABLE ... UNTIL SCN ...;

Answer

null

Question 12

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 13

You are configuring a PDB to use Local Undo. What requirement must be met before setting the UNDO_TABLESPACE parameter?

Accepted Answer

The PDB must be closed. The CDB must be in local undo mode, and the PDB must be open in restricted mode or closed.

Answer

The CDB must be in read-only mode

Answer

The CDB must be in ARCHIVELOG mode

Answer

The PDB must be a proxy PDB

Question 14

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 15

Which Oracle feature allows for verifying the integrity of Blockchain rows?

Accepted Answer

DBMS_BLOCKCHAIN_TABLE. The DBMS_BLOCKCHAIN_TABLE package provides verification functions.

Answer

Audit Vault

Answer

Data Guard

Answer

Flashback Query

Question 16

You need to ensure that the PDB$SEED template is updated with the latest patch level from the CDB. How should you proceed?

Accepted Answer

Apply the patch to the CDB and let the system handle synchronization. The PDB$SEED is read-only. To update it, you must apply the patch to the CDB home, and the seed will be automatically synchronized during the next CDB startup or via the execution of the datapatch utility.

Answer

Run 'ALTER PLUGGABLE DATABASE PDB$SEED SYNC'

Answer

Drop and recreate PDB$SEED using the CREATE PLUGGABLE DATABASE command

Answer

Open PDB$SEED in READ WRITE mode and apply patches

Question 17

You want to clear all configured RMAN settings back to their default values. Which command do you use?

Accepted Answer

CONFIGURE [parameter] CLEAR. CONFIGURE [parameter] CLEAR resets a specific setting to its default.

Answer

DELETE CONFIGURATION

Answer

RESET ALL

Answer

CONFIGURE ALL CLEAR

Question 18

You need to ensure that RMAN automatically deletes archived redo logs after they have been backed up twice to tape. Which configuration command should you use?

Accepted Answer

CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 2 TIMES TO DEVICE TYPE SBT;. The CONFIGURE ARCHIVELOG BACKUP COPIED command with the TO DEVICE TYPE and num_copies parameters defines the retention policy for archived logs.

Answer

CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 2 DAYS;

Answer

SET ARCHIVELOG DELETION POLICY TO 2 COPIES;

Answer

CONFIGURE ARCHIVELOG DELETION POLICY TO NONE;

Question 19

Which TWO of the following are valid RMAN backup types?

Accepted Answer

Cumulative. Full and incremental are the standard types.

Answer

Sequential

Answer

Transactional

Question 20

Which THREE operations are automatically performed by RMAN when executing the 'RECOVER TABLE' command?

Accepted Answer

Exporting the recovered table to the target database using Data Pump. The RECOVER TABLE command creates an auxiliary instance, performs a partial restore and recovery of the tablespace containing the table, and then exports the table metadata to the target database.

Answer

Automatic deletion of all backups older than the restore point

Answer

Automatic conversion of the database to NOARCHIVELOG mode