Oracle Database 12c: Installation and Administration — Question 82

You are about to plug a multi-terabyte non-CDB into an existing multitenant container database (CDB) as a pluggable database (PDB).
The characteristics of the non-CDB are as follows:
Version: Oracle Database 12c Releases 1 64-bit
Character set: WE8ISO8859P15
National character set: AL16UTF16
O/S: Oracle Linux6 64-bit
The characteristics of the CDB are as follows:
Version: Oracle Database 12c Release 1 64-bit
Character set: AL32UTF8
O/S: Oracle Linux 6 64-bit
Which technique should you use to minimize down time while plugging this non-CDB into the CDB?

Answer options

• A. Transportable database
• B. Transportable tablespace
• C. Data Pump full export / import
• D. The DBMS_PDB package
• E. RMAN

Correct answer: C

Explanation

The correct answer is C because using Data Pump full export/import allows for efficient migration of large databases while minimizing downtime. Options A and B are not suitable in this scenario due to compatibility issues with the character sets. Option D requires additional steps that can lead to increased downtime, and option E (RMAN) is not designed for plugging in non-CDBs directly.