OCP Practice Test 2 — 10 Questions

Question 1

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. RECOVER TABLE is an RMAN command that performs a table-level point-in-time recovery by leveraging an auxiliary instance and a temporary auxiliary destination. Option B is correct because RMAN restores the tablespace(s) containing the target table to an auxiliary location (the auxiliary destination) rather than to the production datafiles. Option D is correct because RMAN automatically creates an auxiliary instance (spawned from the target database) to perform the recovery work. Option A is correct because, after the table is recovered in the auxiliary instance, RMAN uses Data Pump to export the table and then imports it into the target database. Option C is incorrect because RECOVER TABLE does not delete backups older than the restore point; backup retention is governed by the configured retention policy, not by this command. Option E is incorrect because RMAN never automatically converts the database to NOARCHIVELOG mode; ARCHIVELOG mode is required for this operation and is not changed by RECOVER TABLE.

Answer

Automatic deletion of all backups older than the restore point

Answer

Automatic conversion of the database to NOARCHIVELOG mode

Question 2

You are performing a cross-platform data migration from a Linux-based Oracle 23ai source database to a Solaris target. You intend to use RMAN CONVERT DATABASE. Which prerequisite must be met to ensure the migration succeeds?

Accepted Answer

The source and target platforms must have the same endian format.. When converting a database using RMAN, the source and target platforms must have the same endian format, or the conversion must be done via transportable tablespaces if the endianness differs. RMAN CONVERT DATABASE requires the platforms to share endianness.

Answer

The source database must use Automatic Storage Management (ASM).

Answer

The target database must be in ARCHIVELOG mode before starting the conversion.

Answer

The source database must be in restricted mode.

Question 3

Which report provides a summary of SQL statements that have the highest 'Elapsed Time'?

Accepted Answer

AWR Report. The AWR (Automatic Workload Repository) Report includes a section titled 'SQL ordered by Elapsed Time' that lists SQL statements ranked by total elapsed time, making it the correct choice. This report aggregates performance statistics over a snapshot interval, capturing the cumulative impact of each SQL statement. The Alert Log and Listener Log do not provide SQL-level performance summaries, and ADDM focuses on diagnostic findings rather than raw SQL timing.

Answer

Alert Log

Answer

Listener Log

Answer

ADDM Report

Question 4

Which THREE types of information are contained in the PDB XML metadata file?

Accepted Answer

Datafile locations. The PDB XML metadata file (the XML file generated alongside a PDB, e.g., by the PDB metadata API or DBMS_PDB.DESCRIBE) records structural and configuration details of the pluggable database, not its business data. Option B is correct because the file lists the datafile locations (the paths of the PDB's datafiles, such as the SYSTEM, SYSAUX, and user tablespaces) so the PDB can be plugged in or cloned on another CDB. Option C is correct because the PDB GUID (the globally unique identifier assigned to the PDB) is stored in the metadata so the CDB can uniquely identify and track the plugged-in database. Option E is correct because the database character set (and national character set) of the PDB is captured in the XML, which is essential for compatibility checks when plugging the PDB into a new CDB. Option A is not part of the XML metadata — user credentials are stored in the data dictionary (e.g., SYS.USER$), not in the PDB description file. Option D is also incorrect because the XML contains only metadata about the PDB's structure and configuration, never the actual table rows, which reside in the datafiles.

Answer

User passwords

Answer

Full table data

Question 5

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. JSON Relational Duality in Oracle 23ai provides automatic bidirectional synchronization between JSON documents and their underlying relational tables. When a JSON document is updated through a duality view, the database automatically propagates the changes to the base tables using the defined mappings. No manual re-synchronization, triggers, or stored procedures are required.

Answer

Only allowed via stored procedures

Answer

Manual re-synchronization

Answer

Requires a trigger

Question 6

Which command is used to start the AutoUpgrade process?

Accepted Answer

java -jar autoupgrade.jar. AutoUpgrade is Oracle's command-line utility for automating database upgrades, and it is invoked as a Java executable: 'java -jar autoupgrade.jar'. The tool then reads a config file specifying source and target homes, databases, and modes (analyze, fixups, deploy, upgrade).

Answer

sqlplus / as sysdba

Answer

opatch

Answer

dbua

Question 7

In True Cache, how is consistency maintained with the primary database?

Accepted Answer

Asynchronous replication. True Cache maintains consistency with the primary database through asynchronous replication of redo/change data. The True Cache instance applies changes from the primary's redo stream in near real-time, so it is not transactionally synchronous but is kept current with low lag. This design lets True Cache serve read-only queries without blocking on the primary.

Answer

Manual refreshes

Answer

Polling

Answer

Synchronous writes

Question 8

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. In Oracle Blockchain Tables, rows are immutable and cannot be updated or deleted until the 'no drop' period expires. After the no-drop period, the default behavior is that rows remain immutable until explicitly deleted by a user—they are not automatically purged. This preserves the tamper-evident nature of the blockchain table while allowing administrative cleanup.

Answer

Rows are moved to archive storage

Answer

Rows are automatically purged

Answer

Rows become updateable

Question 9

When using SQL Tuning Advisor, what is a 'SQL Tuning Set' (STS)?

Accepted Answer

A container for SQL statements and their metadata. An STS is a collection of SQL statements with their associated execution context.

Answer

A backup set of the database

Answer

A list of database users

Answer

A set of database indexes

Question 10

Which type of operation is ideal for Blockchain tables?

Accepted Answer

Audit logs and financial records. Blockchain tables are designed for insert-only, tamper-evident records where each row is cryptographically hashed and chained to the previous row. Audit logs and financial records are the ideal use case because they require an immutable, verifiable history that can be used for compliance and auditing. These tables prevent updates and deletions, ensuring data integrity and non-repudiation.

Answer

General configuration tables

Answer

Transient cache data

Answer

High-frequency temporary storage