Question 42:
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?
Answer options:
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