Oracle Database 12c: Installation and Administration — Question 228

Identify three valid options for adding a pluggable database (PDB) to an existing multitenant container database (CDB).

Answer options

• A. Use the CREATE PLUGGABLE DATABASE statement to create a PDB using the files from the SEED.
• B. Use the CREATE DATABASE . . . ENABLE PLUGGABLE DATABASE statement to provision a PDB by copying file from the SEED.
• C. Use the DBMS_PDB package to clone an existing PDB.
• D. Use the DBMS_PDB package to plug an Oracle 12c non-CDB database into an existing CDB.
• E. Use the DBMS_PDB package to plug an Oracle 11 g Release 2 (11.2.0.3.0) non-CDB database into an existing CDB.

Correct answer: A, C, D

Explanation

Option A is correct because it directly uses the CREATE PLUGGABLE DATABASE statement with SEED files to create a PDB. Option C is also valid as it utilizes the DBMS_PDB package for cloning an existing PDB. Option D is correct as it describes plugging in an Oracle 12c non-CDB database. Options B and E are incorrect because B inaccurately describes the command needed to enable PDBs, and E pertains to an outdated version of Oracle that is not applicable in this context.