Oracle Database Administration II — Question 68

Your container database, CDB1, has an application container, HR_ROOT, with an application PDB, HR_PDB1.
You have the required privilege to clone HR_PDB1 to container database CDB2, which does not contain HR_ROOT.
Which two are always true? (Choose two.)

Answer options

• A. CDB1 and CDB2 must be in shared undo mode.
• B. A common user must exist in CDB2 with the CREATE PLUGGABLE DATABASE privilege.
• C. All transactions in HR_PDB1 of CDB1 must commit before the cloning process starts.
• D. Cloning HR_ROOT automatically clones HR_PDB1.
• E. The HR_PDB1 clone created in CDB2 will be in mount state when cloning ends.

Correct answer: B, D

Explanation

Option B is correct because a common user with appropriate privileges is necessary for the creation of a pluggable database in CDB2. Option D is also correct as cloning HR_ROOT inherently includes the cloning of HR_PDB1. The other options are incorrect as they either imply requirements that are not mandatory or describe states that do not apply to the cloning process.