Oracle Database Administration II — Question 166

You must migrate a non-CDB Oracle 11g Database to a CDB without first performing an upgrade to the non-CDB.

User-defined objects are stored in several tablespaces in the non-CDB.

Which three methods can you use? (Choose three.)

Answer options

• A. the DBMS_PDB package
• B. Data Pump full database export and import
• C. Data Pump transportable tablespaces
• D. replication using GoldenGate
• E. cloning the non-CDB as a PDB
• F. Data Pump full transportable database

Correct answer: A, C, E

Explanation

The correct answers are A, C, and E. The DBMS_PDB package allows for the creation of a PDB from a non-CDB, while Data Pump transportable tablespaces can migrate specific tablespaces without needing an upgrade. Cloning the non-CDB creates a PDB directly. Options B and F involve full database exports or transportable databases, which are not suitable for the requirement of migrating without an upgrade, and option D relates to data replication, not migration.