OCP-1Z0-053-V12.02-244题

最新推荐文章于 2022-04-11 22:00:00 发布

原创最新推荐文章于 2022-04-11 22:00:00 发布 · 6.2k 阅读

0 ·

CC 4.0 BY-SA版权

OCP11g解析同时被 2 个专栏收录

870 篇文章

订阅专栏

OCP-1Z0-053

796 篇文章

订阅专栏

本文深入探讨使用SQL>STARTUP UPGRADE命令进行数据库升级时的关键参数设置，包括如何启用系统触发器、限制连接权限及确保升级过程中作业队列保持活动状态。提供详细步骤及注意事项，帮助数据库管理员顺利执行升级操作。

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.

参考： http://docs.oracle.com/cd/E11882_01/server.112/e16604/ch_twelve045.htm#SQPUG128

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.