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 [email protected];
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\’;
Answer:A
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 [email protected]; 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\’;