Your customer has two CDBs: one for Production and one for development. You are asked to create a new
development PDB (salesdev) from an existing production PDB (salesprd). Which two options would accomplish
this?
A.
You copy all the PDBSSEEDdata files from the production CDB into the development CDB and execute this
on the development CDB;SQL> CREATE PLUGGABLE DATABASE salesdev ADMIN USER salesdm
IDENTIFIED by password;
B.
You alter the salesprd source database to open in read-only mode, and start cloning the source
database:SQL> ALTER PLUGGABLE DATABASE salesprd OPEN READ ONLY;SQL> CREATE
PLUGGABLE DATABASE salesdev FROM salesprd;
C.
You alter the salesprd source database to open in read-only mode:SQL> ALTER PLUGGABLE DATABASE
salesprd OPEN READ ONLY;In the development CDB, you create a databaselink “PRD” that connects to
the root of the source CDB, and start cloning the source PDB:SQL> CREATE PLUGGABLE DATABASE
salesdevFROM salesprd@prd;
D.
Connected as the salesprd local DBA, you create an XML using:SQL> ALTER PLUGGABLE DATABASE
salespdb UNPLUG INTO ‘ /tmp/salesprd-xml’ ;Copy the XML file and all salesprd-related files to the target
CDB and start plugging the copy into the development CDB using:SQL> CREATE PLUGGABLE
DATABASE salesdev USING’ /tmp/salesprd.xml’;
Explanation:
A: Creating a PDB Using the Seed
You can use the CREATE PLUGGABLE DATABASE statement to create a PDB in a CDB using the files of the
seed.
D: Plugging In an Unplugged PDB
To plug in an unplugged PDB, the following prerequisites must be met:
* Complete the prerequisites described in “Preparing for PDBs”.
* The XML file that describes the PDB must exist in a location that is accessible to the CDB.
The USING clause must specify the XML file.
Etc