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 Snapshot PDB is a thin clone leveraging copy-on-write storage snapshots, enabling rapid and space-efficient PDB provisioning ideal for dev/test environments.

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 Proxy PDB is a local database link-based construct that provides seamless connectivity to a PDB residing in a remote CDB, making the remote PDB appear local.

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

Unplugging a PDB generates an XML manifest file describing the PDB's tablespaces, datafiles, and configuration needed to plug it into another compatible CDB.

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.CHECK_PLUG_COMPATIBILITY evaluates the PDB's XML manifest against the target CDB's version, character set, and installed components to report any incompatibilities.

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

Application Containers introduce an additional hierarchy tier where multiple application PDBs share a master application schema defined at the application root, eliminating redundant schema deployment.

OCM - Oracle Certified Master Practice Test

OCM - Oracle Certified Master Practice Test

OCM Oracle Multitenant Architecture 3