Oracle Database 12c: Installation and Administration — Question 119

You are about to plug a multi-terabyte non-CDB into an existing multitenant container database (CDB).
The characteristics of the non-CDB are as follows:
Version: Oracle Database 11g Release 2 (11.2.0.2.0) 64-bit
Character set: AL32UTF8
National character set: AL16UTF16
O/S: Oracle Linux 6 64-bit
The characteristics of the CDB are as follows:
Version: Oracle Database 12c Release 1 64-bit
Character Set: AL32UTF8
National character set: AL16UTF16
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: B

Explanation

The correct answer is B, Transportable tablespace, as it allows you to move data while minimizing downtime, suitable for large databases. Options A and C involve more extensive operations that can lead to increased downtime, while D is for managing PDBs rather than non-CDBs, and E is primarily for backup and recovery, not for minimizing downtime during a plug-in operation.