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.
|
Download Printable PDF. VALID exam to help you PASS. |
 |
“…..or you must choose an alternative upgrade method such as export/import”, does it mean that I must use exp/imp to update my Oracle Database 9i to 12c INSTEAD OF Data Pump?
In the other word, can I use Data Pump in Oracle Database 9i ?
CORRECT ANSWERS: DE
Reference: https://docs.oracle.com/database/121/UPGRD/intro.htm#UPGRD60047
1.3 Oracle Database Releases That Support Direct Upgrade
You may perform a direct upgrade to Oracle Database 12c if your current Oracle Database is release 10.2.0.5, 11.1.0.7, or release 11.2.0.2 or later. If your current Oracle Database is earlier than release 10.2.0.5, or is release 11.2.0.1, then directly upgrading to Oracle Database 12c is not supported. In this case, you are required to upgrade to an intermediate release before upgrading to the new Oracle Database 12c release, or you must choose an alternative upgrade method such as export/import.
C answer cannot be correct as it refers to “Direct Upgrade” and because during “Manually Upgrading a Non-CDB Oracle Database”, startup upgrade is executed in step 10, whereas catctl.pl and catupgrd.sql scripts are executed in step 12.
see: https://docs.oracle.com/database/121/UPGRD/upgrade.htm#UPGRD52869
“…..or you must choose an alternative upgrade method such as export/import”, does it mean that I must use exp/imp to update my Oracle Database 9i to 12c INSTEAD OF Data Pump?
In the other word, can I use Data Pump in Oracle Database 9i ?