Oracle Cloud Infrastructure 2019 Cloud Operations Associate — Question 1

You are migrating an Oracle Database 11.2.0.4 on-premise database to an Oracle Database Cloud Service (Database as a Service) that provides a pre-created
Oracle Database 12.1.0.2 database.
What four migration methods can be used?

Answer options

• A. conventional export/import
• B. Transportable Tablespace (TTS) with RMAN conversion
• C. Transportable Tablespace (TTS) by using Oracle Data Pump
• D. SQL *Loader
• E. RMAN image restore
• F. Data Pump Transportable Database (TDB) export/import

Correct answer: B, C, D, F

Explanation

The correct methods for migration are B, C, D, and F. Options B and C involve using Transportable Tablespaces which are effective for database migrations, while D (SQL *Loader) can also be used to load data. Options A and E are not suitable for this migration scenario, as conventional export/import and RMAN image restore don't align with the requirements of moving to a cloud service with a different database version.