nerdexam
Oracle

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.

Performing Database Maintenance

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)
  • A
    62% (18)
  • D
    24% (7)
  • E
    14% (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.

AAll system triggers are disabled during the upgrade process.Correct

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.

BOnly queries on fixed views execute without errors until you run the catctl.pl script.Correct

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.

CThe COMPATIBLE parameter must be set to at least 12.1.0 before issuing the command.Correct

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.

DAll job queues remain active during the upgrade process.

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.

EOnly connections AS SYSDBA are allowed during the upgrade process.

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

#database upgrade#STARTUP UPGRADE#system triggers#COMPATIBLE parameter

Community Discussion

No community discussion yet for this question.

Full 1Z0-062 Practice