OCP Core Administration And Cdb Pdb Architecture Practice Test 2 — 15 Questions

Question 1

You need to capture PDB performance data. Which feature allows you to capture an AWR snapshot for a specific PDB?

Accepted Answer

DBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT. DBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT is used for AWR snapshots at the container level.

Answer

ALTER PDB SNAPSHOT

Answer

AWR_PDB_SNAPSHOT

Answer

DBMS_PERF.CAPTURE

Question 2

What is the purpose of the 'CDB_ROOT'?

Accepted Answer

To store system metadata. The CDB root manages system-wide objects and metadata.

Answer

To store PDB$SEED

Answer

To store user data

Answer

To manage PDB recovery

Question 3

Which view displays the PDBs that are currently open in the CDB?

Accepted Answer

V$PDBS. V$PDBS shows the status of all PDBs in the instance.

Answer

V$CONTAINERS

Answer

DBA_PDB_STATUS

Answer

CDB_PDB_STATUS

Question 4

What happens to existing sessions when you issue 'ALTER PLUGGABLE DATABASE PDB1 CLOSE'?

Accepted Answer

Sessions are killed if IMMEDIATE is specified. By default, the command fails if sessions exist unless 'IMMEDIATE' is used.

Answer

Sessions are migrated

Answer

The database waits indefinitely

Answer

Sessions remain active

Question 5

Which dictionary view tracks the PDB creation time?

Accepted Answer

CDB_PDBS. CDB_PDBS contains the creation time of all PDBs in the CDB.

Answer

DBA_PDB_HISTORY

Answer

DBA_OBJECTS

Answer

V$PDBS

Question 6

You need to create a PDB from a remote PDB. Which clause must be included in the CREATE PLUGGABLE DATABASE command?

Accepted Answer

FROM ...@dblink. The FROM clause with a database link is required for remote cloning.

Answer

SOURCE ...@dblink

Answer

USING ...@dblink

Answer

REMOTE ...@dblink

Question 7

Which feature allows you to perform point-in-time recovery for a specific PDB without affecting others?

Accepted Answer

RMAN PDB PITR. RMAN PDB-level point-in-time recovery is supported.

Answer

Flashback Database

Answer

PDB Flashback

Answer

Full Database Recovery

Question 8

Which parameter defines the location of the PDB metadata files during a plug operation?

Accepted Answer

PDB_FILE_NAME_CONVERT. The file_name_convert parameter or explicit pathing is used.

Answer

DB_CREATE_FILE_DEST

Answer

DATA_FILE_DIR

Answer

FILE_NAME_DIR

Question 9

You need to monitor wait events for a specific PDB. Which view is most appropriate?

Accepted Answer

V$SESSION. V$SESSION filtered by CON_ID allows viewing PDB-specific sessions.

Answer

V$PDB_WAIT

Answer

V$SYSTEM_EVENT

Answer

DBA_WAIT_EVENTS

Question 10

Which TWO views are essential for monitoring PDB-specific memory usage?

Accepted Answer

V$PDB_MEMORY. V$PDB_MEMORY is correct because it is the dedicated dynamic performance view that reports memory consumption broken down per pluggable database, showing current and maximum SGA/PGA usage attributed to each PDB, which is exactly what PDB-specific memory monitoring requires. V$RESOURCE_LIMIT is also correct because it exposes the resource manager limits and current utilization (such as SGA and PGA limits) enforced for each PDB, letting you verify whether a PDB is approaching its configured memory caps. Together these two views give both the actual per-PDB memory footprint and the limits against which that usage should be judged. V$SGA_DYNAMIC_COMPONENTS shows dynamic SGA component resizing at the instance level, not per-PDB attribution, so it is not essential here. V$PDB_WAIT_EVENTS reports wait event statistics for PDBs and has nothing to do with memory usage. V$MEMORY_TARGET reflects the instance-wide memory target parameters and does not break memory down by PDB.

Answer

V$SGA_DYNAMIC_COMPONENTS

Answer

V$PDB_WAIT_EVENTS

Answer

V$MEMORY_TARGET

Question 11

Which THREE actions occur when you execute 'ALTER PLUGGABLE DATABASE PDB1 OPEN'?

Accepted Answer

The PDB enters READ WRITE mode. The PDB state changes, triggers run, and services are started.

Answer

All other PDBs are closed

Answer

The CDB is restarted

Question 12

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 13

In a 23ai CDB, which command enables the automatic creation of PDBs when a non-CDB is plugged in?

Accepted Answer

CREATE PLUGGABLE DATABASE ... AS CLONE. The ADAPTIVE_PDB_CLONING feature or specific metadata handling is used, but standard unplug/plug remains manual.

Answer

ENABLE_AUTO_PLUG

Answer

AUTOCREATE_PDB

Answer

CONFIGURE_AUTO_PDB

Question 14

Which THREE states can a PDB reside in?

Accepted Answer

MOUNTED. PDBs can be MOUNTED, READ WRITE, or READ ONLY.

Answer

SHUTDOWN

Question 15

Which TWO methods can be used to copy a PDB?

Accepted Answer

Cloning. Cloning (C) is correct because a PDB can be copied using CREATE PLUGGABLE DATABASE ... FROM ... via the local clone, remote clone, or cloning from a non-CDB, which duplicates the PDB's data files and metadata. Unplug/Plug (D) is correct because DBMS_PDB.UNPLUG_DB or ALTER PLUGGABLE DATABASE ... UNPLUG INTO creates an XML manifest, and the PDB can then be plugged into another CDB with CREATE PLUGGABLE DATABASE ... USING, effectively copying/moving the PDB. Export/Import (A) only moves schema-level data via Data Pump, not a full PDB copy, and SQL*Loader (B) loads data into existing tables, not a PDB. Flashback (E) restores a database or PDB to a prior point in time and does not create a copy.

Answer

Export/Import

Answer

SQL*Loader

Answer

Flashback