Oracle Database 12c: Installation and Administration — Question 5

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.)

Answer options

• 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.

Correct answer: A, D, E

Explanation

During the upgrade to Oracle Database 12c, all system triggers are indeed disabled, preventing them from interfering with the upgrade process. Additionally, only connections made as SYSDBA are permitted, ensuring that only privileged actions can be taken. In contrast, job queues are deactivated during the upgrade, and the COMPATIBLE parameter should already be set to the required version before the upgrade command is issued.