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

Question 1

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

Accepted Answer

V$PDB_MEMORY. V$PDB_MEMORY and V$RESOURCE_LIMIT allow tracking PDB memory consumption.

Answer

V$SGA_DYNAMIC_COMPONENTS

Answer

V$PDB_WAIT_EVENTS

Answer

V$MEMORY_TARGET

Question 2

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 3

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

Accepted Answer

Background processes. The SGA, background processes, and redo logs are shared.

Answer

Undo tablespace

Answer

Datafiles

Question 4

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 5

Which TWO methods can be used to copy a PDB?

Accepted Answer

Cloning. Cloning and unplugging/plugging are standard methods.

Answer

Export/Import

Answer

SQL*Loader

Answer

Flashback

Question 6

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

Accepted Answer

Datafile locations. It contains file paths, GUIDs, and character set information.

Answer

User passwords

Answer

Full table data

Question 7

Which TWO views are used to check for plug-in compatibility?

Accepted Answer

V$PDB_COMPATIBILITY. PDB_PLUG_IN_VIOLATIONS and DBMS_PDB.CHECK_PLUG_COMPATIBILITY are standard.

Answer

V$PDB_STATUS

Answer

DBA_PDB_ERRORS

Answer

DBA_OBJECTS

Question 8

Which THREE characteristics are unique to PDBs?

Accepted Answer

Dedicated local users. PDBs have their own datafiles, their own users, and their own services.

Answer

Shared redo logs

Answer

Shared background processes

Question 9

Which TWO actions should be performed before dropping a PDB?

Accepted Answer

Close the PDB. Close the PDB and ensure no active sessions remain.

Answer

Perform a full backup

Answer

Shrink the datafiles

Answer

Export all tables

Question 10

Which TWO tools can be used to perform PDB point-in-time recovery?

Accepted Answer

RMAN. RMAN and SQL*Plus are used to manage PDB PITR operations.

Answer

Data Pump

Answer

Net Manager

Answer

DBCA

Question 11

Which THREE parameters can be set at the PDB level?

Accepted Answer

SGA_TARGET. SGA_TARGET, UNDO_TABLESPACE, and DB_FILE_NAME_CONVERT can be PDB-specific.

Answer

PROCESSES

Answer

DB_NAME

Question 12

Which THREE pieces of information are displayed when you run 'SHOW PDBS'?

Accepted Answer

Creation Time. It shows the PDB name, status, and creation time.

Answer

PDB GUID

Answer

SGA Usage

Question 13

Which TWO security features can be applied specifically to a PDB?

Accepted Answer

TDE (Encryption). Encryption and Auditing can be PDB-specific.

Answer

Instance Parameters

Answer

RMAN Backup Policy

Answer

Network ACLs

Question 14

Which THREE steps are involved in upgrading a PDB?

Accepted Answer

Check PDB_PLUG_IN_VIOLATIONS. Run the upgrade script, compile invalid objects, and check for errors.

Answer

Restart the CDB

Answer

Recreate all users

Question 15

You are configuring a new CDB and want to ensure that PDBs use only a specific subset of the CDB's total SGA memory while allowing individual PDBs to scale up when demand is high. Which parameter should you configure to enforce this?

Accepted Answer

PDB_SGA_MAX_SIZE. The SGA_TARGET parameter at the CDB level defines the total SGA, while PDB_SGA_MIN_SIZE and PDB_SGA_MAX_SIZE parameters allow for fine-grained control and resource capping within the multitenant environment.

Answer

DB_CACHE_SIZE

Answer

SGA_MIN_SIZE

Answer

MEMORY_TARGET