Which three statements are true about the upgrade process?

As part of a manual upgrade of your database to Oracle Database 12c, you plan to issue the command:
SQL> STARTUP UPGRADE
Which three statements are true about the upgrade process? (Choose three.)

As part of a manual upgrade of your database to Oracle Database 12c, you plan to issue the command:
SQL> STARTUP UPGRADE
Which three statements are true about the upgrade process? (Choose three.)

A.
All system triggers are disabled during the upgrade process.

B.
Only queries on fixed views execute without errors until you run the catctl.pl script.

C.
The COMPATIBLE parameter must be set to at least 12.1.0 before issuing the command.

D.
All job queues remain active during the upgrade process.

E.
Only connections AS SYSDBA are allowed during the upgrade process.

Show Hint

Leave a Reply 3

Your email address will not be published. Required fields are marked *

Mike

Mike

ABE
https://docs.oracle.com/database/121/UPGRD/intro.htm#BHCJHGFA

The UPGRADE keyword enables you to open a database based on an earlier Oracle Database release. It also restricts logons to AS SYSDBA sessions, disables system triggers, and performs additional operations that prepare the environment for the upgrade.

Once the database is started in upgrade mode, only queries on fixed views execute without errors until after you run the catctl.pl script. Before running an upgrade script, queries on any other view or the use of PL/SQL returns an error.

C is not correct:

Before upgrading to Oracle Database 12c, the COMPATIBLE initialization parameter must be set to at least 11.0.0, which is the minimum setting for Oracle Database 12c.

Oracle recommends increasing the COMPATIBLE parameter only after complete testing of the upgraded database has been performed. After the upgrade is complete, you can increase the setting of the COMPATIBLE initialization parameter to the maximum level for Oracle Database 12c.

Reply

Richard

Richard

The correct answers should be A B and E. You can confirm the answers in the Oracle released upgrade guide.
– You wouldn’t want to set the COMPATIBLE parameter to 12.1.0 so early because you wouldn’t be able to downgrade the database back to its original version if you find problems after the upgrade.

Reply