244.Which two statements are true regarding the starting of the database instance using the following
command? (Choose two.)
SQL>STARTUP UPGRADE
A. It enables all system triggers.
B. It allows only SYSDBA connections.
C. It ensures that all job queues remain active during the upgrade process.
D. It sets system initialization parameters to specific values that are required to enable database upgrade scripts to be run.
Answer: BD
答案解析:
参考:http://docs.oracle.com/cd/E11882_01/server.112/e23633/upgrade.htm#UPGRD12408
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.
UPGRADE
Starts the database in OPEN UPGRADE mode and sets system initialization parameters to specific values required to enable database upgrade scripts to be run. UPGRADE should only be used when a database is first started with a new version of the Oracle Database Server.
See the Oracle Database Upgrade Guide for details about preparing for, testing and implementing a database version upgrade.
When run, upgrade scripts transform an installed version or release of an Oracle database into a later version, for example, to upgrade an Oracle9i database to Oracle Database 10g. Once the upgrade completes, the database should be shut down and restarted normally.