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.
The question has changed. The new question says “Identify Two valid options (not three)
So the correct answers are A, D. (C is incorrect because for clone an existing PDB (I assume within the same CDB) you cannot use de dbms_pdb package you clone it using create pluggable database clone_pdb from existing_pdb;
Agree with “A”, “D” answer
ACD
ADC
A C and D
In question you can choose only two options, not there. So I also thing A and D
c is correct : you can clone/plug/create new pdb from exist pdb on same CDB as long as source pdb is read only during cloning with new pdb name.
ACD – OK
AD
AD
B: Incorrect. You use ….”enable pluggable ..” option only when you create a CDB.
E: Incorrect. Using DBMS_PDB package presupposes that the non-CDB is 12c and not 11g.
A: is definitel correct.
C: is definitely correct. use DBMS_PDB package to construct an XML file describing the non-CDB data files to plug the non-CDB into the CDB as a PDB. This method presupposes that the non-CDB is an Oracle 12c database.
D: is also correct. You can use DBMS_PDB to describe an exisiting 12c non-CDB, create a XML file, ans use that file to plug it as a PDB into a CDB.
B: Incorrect. You use ….”enable pluggable ..” option only when you create a CDB.
E: Incorrect. Using DBMS_PDB package presupposes that the non-CDB is 12c and not 11g.
A: is definitely correct.
C: is incorrect. You cannot use DBMS_PDB to clone a PDB.
D: correct. You can use DBMS_PDB to describe an exisiting 12c non-CDB, create a XML file, and use that file to plug it as a PDB into a CDB.
So there are only 2 Correct answers:
A, D
I agree.
AD
AD for sure – see the comment of rsv1999. DBMS_PDB can’t clone PDBs.
only A is right.
B is creating CDB.
C and D and E are not right, because DBMS_PDB can only describe db, gererate XML file, it can’t clone PDB or plug PDB.
clode pdb has to use “create pluggable database …..from …. “.
plug pdb has to use “CREATE PLUGGABLE DATABASE …. USING …. “.
http://docs.oracle.com/cloud/latest/db121/ARPLS/d_pdb.htm#ARPLS73527
The DBMS_PDB package provides an “interface” to examine and manipulate data about pluggable databases.
D is correct:
Create a PDB by moving a non-CDB into a PDB. You can use the DBMS_PDB package to create an unplugged PDB from an Oracle Database 12c non-CDB. You can then plug the unplugged PDB into the CDB.
https://docs.oracle.com/database/121/ADMIN/cdb_plug.htm
A,D correct