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

Question 1

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 2

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 3

When using 'Snapshot Carousel', how many snapshots can a single PDB retain?

Accepted Answer

Defined by MAX_PDB_SNAPSHOTS. The number is managed by the MAX_PDB_SNAPSHOTS parameter.

Answer

Fixed at 8

Answer

Controlled by the OS

Answer

Unlimited

Question 4

What is the primary benefit of using a 'Proxy PDB'?

Accepted Answer

Accessing remote PDB data. A Proxy PDB allows access to a PDB in a remote CDB.

Answer

Speeding up local backups

Answer

Bypassing security

Answer

Increasing local storage

Question 5

You need to ensure that the PDB name is unique in your network. Which parameter should you check?

Accepted Answer

DB_UNIQUE_NAME. DB_UNIQUE_NAME must be unique across the CDB infrastructure.

Answer

INSTANCE_NAME

Answer

DB_NAME

Answer

PDB_NAME

Question 6

Which command is used to display the current container you are connected to?

Accepted Answer

SHOW CON_NAME. SHOW CON_NAME shows the current container name in SQL*Plus.

Answer

SHOW CDB_NAME

Answer

SHOW CURRENT_PDB

Answer

SELECT CONTAINER FROM DUAL

Question 7

Which component is responsible for managing background processes across all containers in a CDB?

Accepted Answer

CDB Instance. The instance (CDB root) manages background processes for all containers.

Answer

Shared Service Layer

Answer

Global Process Manager

Answer

PDB Instance

Question 8

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 9

What is the standard tool to manage CDB/PDB configuration in 23ai?

Accepted Answer

SQL*Plus. SQL*Plus or SQLcl are the standard interfaces for managing CDBs.

Answer

SQL Developer

Answer

Net Manager

Answer

OEM

Question 10

When a PDB is in 'RESTRICTED' mode, which sessions are allowed?

Accepted Answer

Only users with RESTRICTED SESSION. Only users with RESTRICTED SESSION privilege are allowed.

Answer

All users

Answer

No users

Answer

Only SYSDBA

Question 11

Which TWO tasks are required to successfully unplug a PDB?

Accepted Answer

Generate an XML metadata file. To unplug a PDB, you must first close the PDB with ALTER PLUGGABLE DATABASE ... CLOSE, because a PDB must be in MOUNTED (or closed) state before its data files can be described and detached — this is why option E is correct. You must then generate an XML metadata file (typically via ALTER PLUGGABLE DATABASE ... UNPLUG INTO '<file>.xml'), which captures the PDB's datafile paths and metadata needed to plug it into another CDB — this is why option D is correct. Option A (convert to non-CDB) is a separate, unrelated operation and is not part of unplugging. Option B (drop the PDB) deletes the PDB and its datafiles, which is the opposite of preserving it for transport. Option C (shut down the CDB) is unnecessary and would disrupt all other PDBs; the CDB instance remains open during an unplug.

Answer

Convert to non-CDB

Answer

Drop the PDB

Answer

Shut down the CDB

Question 12

Which THREE components are shared between a CDB and its PDBs?

Accepted Answer

Background processes. In a multitenant architecture, the CDB and all its PDBs share a single set of background processes (C), such as DBWn, LGWR, CKPT, SMON, and PMON, because there is only one Oracle instance serving the entire container database. They also share the redo log files (D), since all changes across the CDB and its PDBs are recorded in the same online redo logs to support a single instance-level recovery stream. The SGA (E) is likewise shared, as one instance means one memory area containing the buffer cache, shared pool, and other components used by all PDBs. Undo tablespace (A) is not shared in the same way, because each PDB can have its own local undo tablespace (or use the CDB's shared undo depending on configuration), so it is not inherently a shared component. Datafiles (B) are not shared either, since each PDB has its own dedicated datafiles, while the CDB has its own separate datafiles for the root and PDB$SEED.

Answer

Undo tablespace

Answer

Datafiles

Question 13

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 14

Which THREE characteristics are unique to PDBs?

Accepted Answer

Dedicated local users. In a multitenant architecture, each pluggable database (PDB) can have its own dedicated local users (Option A), meaning user accounts created inside a PDB are scoped to that PDB and are not visible in other PDBs or the root, which is a defining characteristic of PDBs. Each PDB also owns its own independent datafiles (Option C), stored in its own tablespace set, so its physical storage is isolated from other PDBs even though they share the same instance. Additionally, each PDB is exposed through its own individual services (Option E), allowing clients to connect directly to a specific PDB by service name rather than to the container database as a whole. By contrast, shared redo logs (Option B) and shared background processes (Option D) are not unique to PDBs; in a multitenant container database, all PDBs share the same redo logs and the same set of background processes of the single instance, so these are characteristics of the CDB rather than distinguishing features of individual PDBs.

Answer

Shared redo logs

Answer

Shared background processes

Question 15

Which TWO actions are required when performing a 'Unplug and Plug' operation of a PDB between two different CDBs to ensure data integrity?

Accepted Answer

An XML metadata file must be created during the unplug process. Option B is correct because the unplug operation generates an XML metadata file (the PDB description file) that captures the PDB's datafiles, tablespaces, and metadata, which is essential for plugging the PDB into the target CDB and preserving data integrity. Option C is correct because the PDB must be closed (or placed in MOUNT state) before unplugging; you cannot unplug an open PDB, and closing it ensures a consistent state and proper generation of the XML manifest. Option A is wrong because upgrade mode is only used for running upgrade scripts, not for unplugging. Option D is wrong because the source CDB does not need to be dropped; only the PDB is unplugged. Option E is wrong because restricted mode is unrelated to unplug/plug operations.

Answer

The PDB must be opened in upgrade mode before unplugging

Answer

The source CDB must be dropped after the operation

Answer

The CDB must be in restricted mode