Oracle Database 12c: Advanced Administration — Question 62

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

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 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 DATABASE created PDB.
• B. 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.
• C. 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.
• D. 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: B

Explanation

Option B is correct because it describes the process of creating a PDB by copying data files from PDB$SEED and using data pump to load the data, which is a valid method. The other options are incorrect as they either involve incorrect methods of integration or require unnecessary upgrades that are not needed for adding an Oracle 11g database as a PDB.