OCP Practice Test 3 — 10 Questions

Question 1

When reviewing an AWR report, you notice a high value for 'db time'. What does this indicate?

Accepted Answer

The total time spent by sessions in the database. 'DB time' in an AWR report represents the cumulative time spent by all foreground sessions in database calls — essentially the total amount of work the database performed, including CPU and wait time. A high DB time relative to elapsed time indicates sessions are spending significant time waiting or consuming CPU, signaling potential performance pressure.

Answer

The time spent on disk I/O only

Answer

The time spent on instance background processes

Answer

The time the database was open

Question 2

Which view displays the current settings for the AWR retention period?

Accepted Answer

DBA_HIST_WR_CONTROL. DBA_HIST_WR_CONTROL contains the snapshot settings including retention and interval.

Answer

DBA_SNAPSHOTS

Answer

V$DATABASE

Answer

V$INSTANCE

Question 3

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 4

You are configuring a PDB. What happens to the PDB if you drop the CDB?

Accepted Answer

All PDBs are dropped. All PDBs are automatically removed when the CDB is dropped.

Answer

PDBs remain as standalone

Answer

PDBs become unusable orphans

Answer

PDBs are migrated to another CDB

Question 5

Which command allows you to change the state of a PDB to READ ONLY?

Accepted Answer

ALTER PLUGGABLE DATABASE OPEN READ ONLY. ALTER PLUGGABLE DATABASE [PDB_NAME] OPEN READ ONLY is the correct syntax.

Answer

OPEN PDB READ ONLY

Answer

ALTER PDB READ ONLY

Answer

ALTER DATABASE PDB OPEN READ ONLY

Question 6

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?

Accepted Answer

V$SQL_PLAN. V$SQL_PLAN shows the execution plan for statements currently in the library cache.

Answer

V$SESSION

Answer

V$SQLAREA

Answer

V$SYSSTAT

Question 7

When using the VECTOR data type, what is the maximum number of dimensions supported?

Accepted Answer

2048. Oracle 23ai supports up to 2048 dimensions for the vector data type.

Answer

512

Answer

1024

Answer

4096

Question 8

Which file stores the metadata for a PDB being unplugged?

Accepted Answer

XML file. The unplug process generates an XML file to describe the PDB.

Answer

TXT file

Answer

JSON file

Answer

SQL file

Question 9

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 10

What is the consequence of not running the 'catupgrd.sql' script after a major version upgrade?

Accepted Answer

Data dictionary remains in old version format. The data dictionary will be inconsistent, and many objects will be invalid, leading to database failure.

Answer

Only performance is affected

Answer

The database will run in read-only mode

Answer

The database will not start