Oracle Database 12c: Advanced Administration — Question 59

Which two methods can be used to add an Oracle 11g database to a multitenant container database (CDB) as a pluggable database (PDB)? (Choose two.)

Answer options

• A. Use the DBMS_PDB package to plug the Oracle 11g database into the existing CDB as a PDB.
• B. Use the CREATE DATABASE ... ENABLE PLUGGABLE DATABASE statement to create a PDB by copying data files from PDB$SEED and use data pump to load data from the Oracle 11g database into the newly created PDB.
• C. Pre-create a PDB in CDB and use data pump to load data from the complete database export of the Oracle 11g database into the newly created PDB.
• D. Pre-create a PDB in CDB and use the NETWORK_LINK and PARALLEL parameters with data pump import to import data from the Oracle 11g database to the newly created PDB.
• E. Upgrade the Oracle 11g database to a 12c non-CDB and use the DBMS_PDB.DESCRIBE procedure to plug the database as a new PDB into the CDB.

Correct answer: D, E

Explanation

Option D is correct because it allows for the import of data using data pump with specified parameters, facilitating efficient data transfer. Option E is also correct as it involves upgrading the database and using the DBMS_PDB.DESCRIBE procedure to plug it into the CDB. The other options either do not align with the requirements for creating a PDB or rely on methods that are not applicable for integrating an Oracle 11g database into a CDB.