Oracle Database Administration II — Question 170

A container database, CDB1, contains a pluggable database PDB1.

Another container database is called CDB2.

You want to relocate PDB1 from CDB1 to CDB2 with near-zero down time.

Which three are required? (Choose three.)

Answer options

• A. CDB2 must be in archivelog mode.
• B. CDB1 and CDB2 must both be in local UNDO mode.
• C. CDB2 must be in shared UNDO mode only.
• D. CDB1 must be in shared UNDO mode only.
• E. CDB1 must be in archivelog mode.
• F. CDB1 and CDB2 must be in shared UNDO mode.

Correct answer: A, B, E

Explanation

The correct answer includes options A, B, and E because CDB2 must be in archivelog mode to support the relocation and both CDBs need to be in local UNDO mode. Options C, D, and F are incorrect as they do not meet the requirements for a near-zero downtime relocation.