Oracle Database 12c: Installation and Administration — Question 23

You plan to upgrade your Oracle Database 9i to Oracle Database 12c.
Which two methods can you use? (Choose two.)

Answer options

• A. Perform a rolling upgrade.
• B. Perform a direct upgrade by running the Database Upgrade Assistant (DBUA).
• C. Perform a direct upgrade by manually running the catctl.pl and catupgrd.sql scripts before issuing the STARTUPUPGRADE command.
• D. Install the Oracle Database 12c software, create a new Oracle 12c database, and then use the Oracle Data Pump to import data from the source Oracle 9i database to the target Oracle 12c database.
• E. Upgrade your current database to Oracle Database release 10.2.0.5, and then upgrade to Oracle Database 12c.

Correct answer: C, D

Explanation

Options C and D are valid methods for upgrading from Oracle Database 9i to 12c. Option C involves manually running necessary scripts, while Option D entails creating a new database and using Oracle Data Pump for data migration. Options A, B, and E are incorrect as they do not represent the supported upgrade paths from 9i to 12c.