Oracle Database Administration II — Question 143

A container database called CDB1 is OMF-enabled.
PDB_FILE_NAME_CONVERT is not configured in CDB1.
PDB1 was unplugged from CDB1 earlier in the week.
Examine this command, which will be executed in CDB1:

CREATE PLUGGABLE DATABASE pdb1 -
USING `˜/u01/app/oracle/oradata/pdb1.xml'
SOURCE_FILE_NAME_CONVERT =
(`˜/u01/app/oracle/oradata/', `˜/u02/app/oracle/oradata/');
Which two are true? (Choose two.)

Answer options

• A. PDB1 data files already exist in the correct location.
• B. DBMS_PDB.CHECK_PLUG_COMPATIBILITY must be run in CDB1 before executing the command.
• C. PDB_FILE_NAME_CONVERT must be set before executing the command.
• D. /u01/app/oracle/oradata/pdb1.xml does not contain the current locations of data files for PDB1.
• E. PDB1 must be dropped from CDB1.

Correct answer: D, E

Explanation

The correct answer D is true because the XML file does not have the current locations of the data files for PDB1, which need to be updated for the database to be created successfully. Answer E is also correct as PDB1 must be dropped from CDB1 since it is not currently part of the database. The other options are incorrect because they do not pertain to the requirements for creating the pluggable database in this scenario.