1Z0-062 · Question #307
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.)
The correct answer is 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.. During an Oracle Database 12c upgrade using STARTUP UPGRADE, system triggers are disabled, only fixed views are reliably accessible, and the COMPATIBLE parameter must be pre-set to at least 12.1.0.
Question
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.)
Options
- AAll system triggers are disabled during the upgrade process.
- BOnly queries on fixed views execute without errors until you run the catctl.pl script.
- CThe COMPATIBLE parameter must be set to at least 12.1.0 before issuing the command.
- DAll job queues remain active during the upgrade process.
- EOnly connections AS SYSDBA are allowed during the upgrade process.
How the community answered
(29 responses)- A62% (18)
- D24% (7)
- E14% (4)
Why each option
During an Oracle Database 12c upgrade using `STARTUP UPGRADE`, system triggers are disabled, only fixed views are reliably accessible, and the COMPATIBLE parameter must be pre-set to at least 12.1.0.
During the `STARTUP UPGRADE` process, Oracle automatically disables all system triggers to prevent them from interfering with the execution of upgrade scripts and to ensure a controlled upgrade environment.
When a database is started in `UPGRADE` mode, most database objects are in an inconsistent state or are being modified, making only queries on fixed views (e.g., V$ views) guaranteed to execute without errors until the `catctl.pl` script completes the upgrade.
The `COMPATIBLE` initialization parameter must be set to at least '12.1.0' prior to issuing the `STARTUP UPGRADE` command to enable Oracle Database 12c features and ensure successful upgrade completion.
Job queues are typically disabled or quiesced during a database upgrade to prevent background jobs from running and interfering with the upgrade process, which could cause errors or data corruption.
While `SYSDBA` connections are primarily used for database upgrades, the statement 'only connections AS SYSDBA are allowed' is an oversimplification; the database is in a restricted state, but the restriction is more about schema objects than connection type.
Concept tested: Oracle database upgrade process with STARTUP UPGRADE
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/upgrd/upgrading-oracle-database.html#GUID-E5365511-A512-4467-93C0-EC9542031023
Topics
Community Discussion
No community discussion yet for this question.