Which two options would accomplish this?

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?

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 COB;
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 salesdevUSING’ /tmp/salesprd.xml’;



Leave a Reply 3

Your email address will not be published. Required fields are marked *