Practice Test GeeksOCM - Oracle Certified Master Practice Test
← All OCM Flashcard Decks

Oracle Multitenant Architecture Flashcards

7 cards from real OCM practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.

Read the first 7 Oracle Multitenant Architecture flashcards as text

  1. What is a Snapshot PDB in Oracle Multitenant?

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

    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.

  2. What is a Proxy PDB in Oracle Multitenant?

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

    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.

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

    Answer: .xml file

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

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

    Answer: DBMS_PDB.CHECK_PLUG_COMPATIBILITY

    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.

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

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

    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.

  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?

    Answer: noncdb_to_pdb.sql

    The $ORACLE_HOME/rdbms/admin/noncdb_to_pdb.sql script must be executed inside the plugged PDB to remove non-CDB-specific dictionary objects and complete the multitenant conversion.

  7. What does a Refreshable PDB provide in Oracle Multitenant?

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

    A Refreshable PDB is a thin clone that periodically replicates data changes from the source PDB via redo log shipping, providing a near-real-time read-only copy for reporting or dev/test use.