You plan to upgrade your Oracle Database 9i to Oracle Database 12c.
Which two methods can you use? (Choose two.)
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.
The answers should be D and E.
– Direct upgrade is not supported for 9i. You must first upgrade it to an intermediate oracle database release before upgrading it to 12c.
– You can use Data Pump to perform the data migration.
The correct answers should be D and E.
– The path that you must take to upgrade to the latest release of Oracle Database 12c depends on the release number of your current database. You may perform a direct upgrade to the new release if your current Oracle Database is release 10.2.0.5, 11.1.0.7, or release 11.2.0.2 or later. You may directly upgrade from release 12.1.0.1 to 12.1.0.2.
– If your current Oracle Database is a release earlier than 10.2.0.5, or is release 11.2.0.1, then directly upgrading your current release of Oracle Database to the latest release is not supported. In this case, you are required to upgrade to an intermediate release before upgrading to Oracle Database 12c.