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’;
|
Download Printable PDF. VALID exam to help you PASS. |
 |