OCM Oracle Multitenant Architecture 3

Question 1

What is a Snapshot PDB in Oracle Multitenant?

Accepted Answer

A thin, space-efficient PDB clone created from a storage-level snapshot

Answer

A point-in-time backup of a PDB stored in the flash recovery area

Answer

A PDB in READ ONLY mode used exclusively for reporting

Answer

A temporary PDB created automatically during upgrade procedures

Question 2

What is a Proxy PDB in Oracle Multitenant?

Accepted Answer

A local PDB that transparently forwards SQL to a remote PDB in a different CDB

Answer

A PDB template used to create other PDBs

Answer

A standby PDB in an Active Data Guard configuration

Answer

A PDB restricted to read-only access for auditing purposes

Question 3

When unplugging a PDB using ALTER PLUGGABLE DATABASE UNPLUG INTO, what type of file is created to store the PDB's metadata manifest?

Accepted Answer

.xml file

Answer

.pdb file

Answer

.dmp file

Answer

.plug file

Question 4

Which procedure in the DBMS_PDB package is used to verify compatibility before plugging a PDB into a target CDB?

Accepted Answer

DBMS_PDB.CHECK_PLUG_COMPATIBILITY

Answer

DBMS_PDB.DESCRIBE

Answer

DBMS_MULTITENANT.VALIDATE

Answer

DBMS_PDB.VERIFY_MANIFEST

Question 5

What is the primary purpose of Application Containers introduced in Oracle 19c Multitenant?

Accepted Answer

A CDB-level tier that groups related PDBs sharing a common application schema installed once

Answer

Docker containers used to deploy Oracle Application Express instances

Answer

WebLogic application server containers that connect to multiple PDBs

Answer

A set of PDBs managed centrally by Oracle Cloud Infrastructure

Question 6

After plugging a non-CDB into a CDB using CREATE PLUGGABLE DATABASE ... AS NON$CDB, which script must be run inside the new PDB to complete the conversion?

Accepted Answer

noncdb_to_pdb.sql

Answer

convert_noncdb.sql

Answer

pdb_migration.sql

Answer

multitenant_convert.sql

Question 7

What does a Refreshable PDB provide in Oracle Multitenant?

Accepted Answer

A PDB clone that automatically synchronizes changes from a source PDB on a scheduled basis using redo shipping

Answer

A PDB whose SGA and PGA memory are automatically refreshed under memory pressure

Answer

A PDB that auto-updates its optimizer statistics using DBMS_STATS scheduled jobs

Answer

A PDB with automatic patch application capabilities from Oracle Cloud