OCP Exam Questions and Answers

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?

To improve performance, you suspect an index is missing. Which advisor should you invoke to get recommendations for new indexes?

You have a query that is performing poorly due to a stale execution plan. You want to lock the current optimal plan to prevent the optimizer from changing it during subsequent runs. What should you do?

You notice that Automatic SQL Plan Management is not evolving your plans as expected. What is the most likely cause?

An application query is failing to use a newly created index. You suspect the optimizer statistics are inaccurate. Which package should you use to gather statistics for this specific table?

You are tuning a complex SQL statement. You want to see the execution plan that the optimizer is currently choosing. Which dynamic performance view is most useful?

You are implementing AI Vector Search in Oracle Database 23ai. Which data type is mandatory for storing vector embeddings?

You are migrating a legacy application to use Wide Tables in 23ai. What is the maximum number of columns supported by a Wide Table?

To enable lock-free reservations on a table, which clause must be used in the CREATE or ALTER TABLE statement?

When using Blockchain Tables, what is the default behavior for rows that have reached their 'no drop' period?

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

When configuring Parallel DML in 23ai, which parameter must be set to 'ALWAYS' to ensure parallel execution for DML statements without hints?

Which view provides information about the open status of all PDBs in a CDB?

What is the default state of a PDB after creating it using the CREATE PLUGGABLE DATABASE command?

A PDB is in 'READ WRITE' mode. You need to perform a maintenance task that requires the PDB to be in 'RESTRICTED' mode. Which command achieves this?

You need to migrate a non-CDB to a PDB in an existing CDB. Which package should you use to check for compatibility issues before starting the migration?

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

You need to migrate a non-CDB database to a PDB in a 23ai CDB. Which utility is the recommended tool to assess compatibility before migration?

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

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?

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

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?

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?

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?

Which view should you query to verify the encryption status of tablespaces in 23ai?

Which component is required to implement Transparent Data Encryption (TDE) in 23ai?

When using AutoUpgrade to move to 23ai, which file format is required for the configuration?

What is the primary benefit of using Unified Auditing in 23ai?

You need to perform a Rolling Upgrade using Data Guard. What is the minimum required configuration?

You are upgrading from 19c to 23ai and need to identify incompatible parameters before the upgrade. Which tool should you use?