Which three are true about Data Pump in an Oracle multitenant environment?

Question

Options

• AIt can be used to transport data from a non-CDB to a PDB.
• BIt can be used to clone a CDB.
• CIt can be used to transport data between PDBs.
• DIt can be used to transport data from a PDB to a non-CDB.
• EIt can be used to create a new PDB.

• A
  80% (33)
• B
  12% (5)
• E
  7% (3)

Explanation

Data Pump (expdp/impdp) is a logical data transport tool - it moves data across database boundaries regardless of whether the source or target is a CDB, PDB, or non-CDB. This makes A, C, and D correct: you can export from a non-CDB and import into a PDB (migration to multitenant), move data between any two PDBs (same or different CDB), and export from a PDB back into a non-CDB.

B is wrong because Data Pump has no mechanism to clone a CDB - CDB-level duplication requires RMAN or cold copy techniques that operate at the physical/structural level, not the logical data level.

E is wrong because PDBs are created via SQL (CREATE PLUGGABLE DATABASE), DBCA, or by plugging in a PDB archive - Data Pump cannot provision new containers, only populate existing ones with data.

Memory tip: Think of Data Pump as a "moving truck" - it can move contents (data) between any combination of non-CDB/PDB/PDB destinations, but it cannot build a new container (E) or duplicate the whole building (B). If the task involves creating or cloning structure, reach for RMAN or SQL DDL instead.

No community discussion yet for this question.