Identify three valid options for adding a pluggable database (PDB) to an existing multitenant
container database (CDB).
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.
Explanation:
Use the CREATE PLUGGABLE DATABASE statement to create a pluggable
database (PDB).
This statement enables you to perform the following tasks:
* (A) Create a PDB by using the seed as a template
Use the create_pdb_from_seed clause to create a PDB by using the seed in the multitenant
container database (CDB) as a template. The files associated with the seed are copied to a new
location and the copied files are then associated with the new PDB.
* (C) Create a PDB by cloning an existing PDB
Use the create_pdb_clone clause to create a PDB by copying an existing PDB (the source PDB)
and then plugging the copy into the CDB. The files associated with the source PDB are copied to a
new location and the copied files are associated with the new PDB. This operation is called
cloning a PDB.
The source PDB can be plugged in or unplugged. If plugged in, then the source PDB can be in the
same CDB or in a remote CDB. If the source PDB is in a remote CDB, then a database link is
used to connect to the remote CDB and copy the files.
* Create a PDB by plugging an unplugged PDB or a non-CDB into a CDB
Use the create_pdb_from_xml clause to plug an unplugged PDB or a non-CDB into a CDB, using
an XML metadata file.
only AD
A and D are only correct. To clone an existing PDB you dont need to use DBMS_PDB package, you simply use Alter database unplug into ‘file.xml’ and then create pluggable database using ‘file.xml’
there are four methods to provision new PDBs in a CDB:
1- create a new PDB from the seed
2- Plug non-CDBs in a CDB as PDBs, as part of migration strategy
3- Clone a PDB from another PDB of the same CDB
4- Plug an unplugged PDB into another CDB
answer A,C and D
A, C, D are correct.
B is incorrect because “CREATE DATABASE . . . ENABLE PLUGGABLE DATABASE” will create a CDB with the root and the seed. While the question is talking about adding PDB to existing CDB.
http://docs.oracle.com/database/121/ADMIN/cdb_create.htm
E is incorrect because “DBMS_PDB” will not work with 11g DB.
http://docs.oracle.com/database/121/ADMIN/cdb_plug.htm
DBMS_PDB helps create an unplugged PDB from an oracle DB 12c non-CDB.
So I don’t think “C” is correct. Perhaps the question should be rephrased/corrected to ask for “two correct” answers – A,D
ACD