当前位置:OCP 11G认证考试题库

问题:

[单选]

You installed Oracle Database 11g and are performing a manual upgrade of the Oracle9i database. As a part of the upgrade process, you execute the following script:
SQL>@utlu111i.sql
Which statement about the execution of this script is true?()

A . It must be executed from the Oracle Database 11g environment.
B . It must be executed only after the SYSAUX tablespace has been created.
C . It must be executed from the environment of the database that is being upgraded.
D . It must be executed only after AUTOEXTEND is set to ON for all existing tablespaces.
E . It must be executed from both the Oracle Database 11g and Oracle Database 9i environments.

In what order would you execute the following steps to create a recovery catalog?() a.Issue the create catalog command.  b.Create the recovery-catalog database.  c.Create the recovery-catalog user.  d.Grant the recovery_catalog_owner privilege to the recovery-catalog user.  e.Issue the register database command from the target database. a,b,c,d,e。 b,a,d,c,e。 b,c,d,a,e。 b,c,d,e,a。 b,d,c,a,e。 根据房地产价格形成基础的不同划分为()。 市场交易价格。 市场平均价格。 理论价格。 评估价格。 执行监理单位的指示,是承建单位应承担的()。 应尽义务。 合同义务。 法律义务。 首要义务。 You execute the following command in your Supportcenter.cn production database to change the width of the CUST_NAME column of the CUSTOMERS table:  ALTER TABLE customers   MODIFY (cust_nameVARCHAR2 (40))   /   When you execute the command, it displays the following error message:   ERROR at line 1:   ORA-00054: resource busy and acquire with NOWAIT specified   What could be the reason for the error message?() The database instance is not available.。 The ALTER TABLE command does not have WAIT option。 The table or a row in the table is currently locked by another user session.。 The database instance is busy processing other user sessions commands.。 The CUSTOMERS table has no long running query active at the time when this request is made.。 The server process executing the ALTER TABLE command is busy with another command executio。 View the Exhibits. You performed operations on the DEPT4 table as shown in the Exhibit. When you perform the FlashbackVersions Query, you find that the first two updates are not listed. What could be the reason?()  The row movement is not enabled on the table.。 The first two updates were not explicitly committed.。 The Flashback Versions Query lists only the most recent update.。 The Flashback Versions Query stops producing rows after it encounters a time in the past when the  table structure was changed.。

You installed Oracle Database 11g and are performing a manual upgrade of the Oracle9i database. As a part of the upgrade process, you execute the following script:
SQL>@utlu111i.sql
Which statement about the execution of this script is true?()

参考答案:

  参考解析

本题暂无解析

在线 客服