单选题Your organization decided to upgrade the existing Oracle 10g database to Oracle 11g database in a multiprocessor environment. At the end of the upgrade, you observe that the DBA executes the following script: SQL> @utlrp.sql What is the significance of

题目
单选题
Your organization decided to upgrade the existing Oracle 10g database to Oracle 11g database in a multiprocessor environment. At the end of the upgrade, you observe that the DBA executes the following script: SQL> @utlrp.sql What is the significance of executing this script?（）
A

It performs parallel recompilation of only the stored PL/SQL code.

B

It performs sequential recompilation of only the stored PL/SQL code.

C

It performs parallel recompilation of any stored PL/SQL as well as Java code.

D

It performs sequential recompilation of any stored PL/SQL as well as Java code.

相似考题

1.You are in the process of creating a virtual private catalog in your Oracle Database 11g database. The PROD1, PROD2, and PROD3 Oracle Database 10g databases are registered in the base recovery catalog. The database user who owns the base recovery catalog is CATOWNER. CATOWNER executes the following command to grant privileges to a new user VPC1 using Oracle Database 11g RMAN executables:What is the outcome of the above commands?（）A. They execute and create a virtual catalog for pre-Oracle 11g clients.B. They produce an error because PROD1 and PROD2 databases belong to the older version.C. They produce an error because you need to connect as CATOWNER to execute this packaged procedure.D. They produce an error because you need to connect to the target database to execute this packaged procedure.

2.You are managing the APPPROD database as a DBA which is not using the Oracle-managed files. You plan to duplicate this database in the same system with the name DUPDB.You want to create the same directory structure for duplicate database files as of the target database.You executed the following RMAN commands:What are the implications of this command?（）A. It creates database files for the duplicate database under the Oracle base with a different directory for the duplicate database.B. It overwrites data files of the target database because a different location for data files is not mentioned for the duplicate database.C. It creates database files for the duplicate database under the same Oracle home as that of the target database with the same directory structure.D. It creates database files for the duplicate database under the same Oracle home as that of the target but with a different directory for the duplicate database.

3.Identify three scenarios in which you would recommend the use of SQL Performance Analyzer to analyzeimpact on the performance of SQL statements.()A. Change in the Oracle Database versionB. Change in your network infrastructureC. Change in the hardware configuration of the database serverD. Migration of database storage from non-ASM to ASM storageE. Database and operating system upgrade

4.You perform the following activities during the database upgrade from Oracle Database 10g to Oracle Database 11g:1. Capture plans for a SQL workload into a SQL Tuning Set (STS) before upgrade.2. Load these plans from the STS into the SQL plan baseline immediately after the upgrade.What is the reason for performing these activities? （）A. to minimize plan regression due to the use of a new optimizer versionB. to completely avoid the use of new plans generated by a new optimizer versionC. to prevent plan capturing when the SQL statement is executed after the database upgradeD. to keep the plan in the plan history so that it can be used when the older version of the optimizer is used

参考答案和解析
正确答案： B
解析： 暂无解析
更多“单选题Your organization decided to upgrade the existing Oracle 10g database to Oracle 11g database in a multiprocessor environment. At the end of the upgrade, you observe that the DBA executes the following script: SQL @utlrp.sql What is the significance of ”相关问题

  • 第1题：

    You upgrade your Oracle database in a multiprocessor environment. As a recommended you execute thefollowing script:SQL > @utlrp.sqlWhich two actions does the script perform?()

    A. Parallel compilation of only the stored PL/SQL code

    B. Sequential recompilation of only the stored PL/SQL code

    C. Parallel recompilation of any stored PL/SQL code

    D. Sequential recompilation of any stored PL/SQL code

    E. Parallel recompilation of Java code

    F. Sequential recompilation of Java code


    参考答案：C, E

  • 第2题：

    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.

    正确答案:C

  • 第3题：

    You want to administer your PROD database from a remote host machine using a Web-enabled interface. Which Oracle tool would you use to accomplish this task efficiently without using command-line interfaces？（）

    • A、SQL*Plus
    • B、iSQL*Plus
    • C、Management Server
    • D、Management Repository
    • E、Oracle Enterprise Manager 10g Database Control

    正确答案:E

  • 第4题：

    Your organization decided to upgrade the existing Oracle 10g database to Oracle 11g database in a multiprocessor environment. At the end of the upgrade，you observe that the DBA executes the following script：   SQL> @utlrp.sql   What is the significance of executing this script？（）  

    • A、 It performs parallel recompilation of only the stored PL/SQL code.
    • B、 It performs sequential recompilation of only the stored PL/SQL code.
    • C、 It performs parallel recompilation of any stored PL/SQL as well as Java code.
    • D、 It performs sequential recompilation of any stored PL/SQL as well as Java code.

    正确答案:C

  • 第5题：

    What are two benefits of installing Grid Infrastructure software for a stand-alone server before installing and creating an Oracle database?（）

    • A、Effectively implements role separation
    • B、Enables you to take advantage of Oracle Managed Files.
    • C、Automatically registers the database with Oracle Restart.
    • D、Helps you to easily upgrade the database from a prior release.
    • E、Enables the Installation of Grid Infrastructure files on block or raw devices.

    正确答案:C,E

  • 第6题：

    You are working as a DBA on Oracle Database 9i. You plan to upgrade your 9i database to Oracle 10g. To be familiar with the new database technology， you decide to install Oracle Database 10g on your workstation at home. You create a general purpose database.   After the installation， you make the following changes in your initialization parameter file：LOG_ARCHIVE_DEST_1=’LOCATION=USE_DB_RECOVERY_FILE_DEST’   DB_RECOVERY_FILE_DEST =    ’LOCATION=d：/product/10.1.0/flash_recovery_area’  DB_RECOVERY_FILE_DEST_SIZE=10g   Where are the archived redo logs stored for your database？（）

    • A、 The archived redo logs are stored in an operating system-dependent location.
    • B、 The archived redo logs are stored in the location specified by LOG_ARCHIVE_DEST_1.
    • C、 The archived redo logs are stored in the location specified by DB_RECOVERY_FILE_DEST.
    • D、 The archived redo logs are stored in the locations specified by both LOG_ARCHIVE_DEST_1 and  DB_RECOVERY_FILE_DEST.

    正确答案:C

  • 第7题：

    You plan to configure the new Oracle Database 11g installation by performing these tasks： - Use Automatic Storage Management （ASM） as the storage option.  - Use Oracle Enterprise Manager Database Control to manage the database.  - Provide the same password for SYS， SYSTEM， SYSMAN， and DBSNMP accounts during theinstallation. - Configure the database to send email notifications.  Some tools available to you for installation are：  1：Oracle Universal Installer （OUI）  2：Database Configuration Assistant （DBCA）  3：Database Upgrade Assistant （DBUA）  4：Oracle Net Configuration Assistant  Which tools would you use for this installation（）

    • A、2
    • B、3
    • C、1 and 2
    • D、3 and 4
    • E、1，2，and 4

    正确答案:E

  • 第8题：

    You upgrade your Oracle database in a multiprocessor environment. As a recommended you execute thefollowing script:SQL > @utlrp.sqlWhich two actions does the script perform?（）

    • A、Parallel compilation of only the stored PL/SQL code
    • B、Sequential recompilation of only the stored PL/SQL code
    • C、Parallel recompilation of any stored PL/SQL code
    • D、Sequential recompilation of any stored PL/SQL code
    • E、Parallel recompilation of Java code
    • F、Sequential recompilation of Java code

    正确答案:C,E

  • 第9题：

    单选题
    Your organization decided to upgrade the existing Oracle 10g database to Oracle 11g database in a multiprocessor environment. At the end of the upgrade，you observe that the DBA executes the following script：   SQL> @utlrp.sql   What is the significance of executing this script？（）
    A

     It performs parallel recompilation of only the stored PL/SQL code.

    B

     It performs sequential recompilation of only the stored PL/SQL code.

    C

     It performs parallel recompilation of any stored PL/SQL as well as Java code.

    D

     It performs sequential recompilation of any stored PL/SQL as well as Java code.


    正确答案： D
    解析： 暂无解析

  • 第10题：

    单选题
    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.


    正确答案： C
    解析： 暂无解析

  • 第11题：

    单选题
    Your organization decided to upgrade the existing Oracle 10g database to Oracle 11g database in a multiprocessor environment. At the end of the upgrade, you observe that the DBA executes the following script: SQL> @utlrp.sql What is the significance of executing this script?（）
    A

    It performs parallel recompilation of only the stored PL/SQL code.

    B

    It performs sequential recompilation of only the stored PL/SQL code.

    C

    It performs parallel recompilation of any stored PL/SQL as well as Java code.

    D

    It performs sequential recompilation of any stored PL/SQL as well as Java code.


    正确答案： A
    解析： 暂无解析

  • 第12题：

    单选题
    You plan to configure the new Oracle Database 11g installation by performing these tasks： - Use Automatic Storage Management （ASM） as the storage option.  - Use Oracle Enterprise Manager Database Control to manage the database.  - Provide the same password for SYS， SYSTEM， SYSMAN， and DBSNMP accounts during theinstallation. - Configure the database to send email notifications.  Some tools available to you for installation are：  1：Oracle Universal Installer （OUI）  2：Database Configuration Assistant （DBCA）  3：Database Upgrade Assistant （DBUA）  4：Oracle Net Configuration Assistant  Which tools would you use for this installation（）
    A

    2

    B

    3

    C

    1 and 2

    D

    3 and 4

    E

    1，2，and 4


    正确答案： B
    解析： 暂无解析

  • 第13题：

    What are two benefits of installing Grid Infrastructure software for a stand－alone server before installing and creating an Oracle database?()

    A. Effectively implements role separation

    B. Enables you to take advantage of Oracle Managed Files.

    C. Automatically registers the database with Oracle Restart.

    D. Helps you to easily upgrade the database from a prior release.

    E. Enables the Installation of Grid Infrastructure files on block or raw devices.


    参考答案：C, E

  • 第14题：

    You work as a database administrator for Supportcenter.cn. You want to administer your database servers， which are running on different host machines， using the Web-enabled grid control interface. You have configured the agent on the host machines. You have started the Oracle Database 10g Grid Control utility on your machine. Which two additional components would you configure to achieve this objective？（）

    • A、Application Server Control
    • B、Oracle Management Service
    • C、Oracle Enterprise Manager Repository
    • D、Oracle Enterprise Manager Database Control

    正确答案:C,D

  • 第15题：

    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.

    正确答案:C

  • 第16题：

    Oracle Grid Infrastructure for a stand-alone server is installed on your production host before installing the Oracle Database server. The database and listener are configured by using Oracle Restart. Examine the following command and its output: $ crsctl config has CRS-4622: Oracle High Availability Services auto start is enabled. What does this imply?（）

    • A、When you start an instance on a high with SQL *Plus dependent listeners and ASM disk groups are automatically started.
    • B、When a database instance is started by using the SRVCTL utility and listener startup fails, the instance is still started.
    • C、When a database is created by using SQL* Plus, it is automatically added to the Oracle Restart configuration.
    • D、When you create a database service by modifying the SERVICE_NAMES initialization parameter, it is automatically added to the Oracle Restart configuration.

    正确答案:A

  • 第17题：

    Your organization decided to upgrade the existing Oracle 10g database to Oracle 11g database in a multiprocessor environment. At the end of the upgrade, you observe that the DBA executes the following script: SQL> @utlrp.sql What is the significance of executing this script?（）

    • A、It performs parallel recompilation of only the stored PL/SQL code.
    • B、It performs sequential recompilation of only the stored PL/SQL code.
    • C、It performs parallel recompilation of any stored PL/SQL as well as Java code.
    • D、It performs sequential recompilation of any stored PL/SQL as well as Java code.

    正确答案:C

  • 第18题：

    Identify three scenarios in which you would recommend the use of SQL Performance Analyzer to analyzeimpact on the performance of SQL statements.（）

    • A、Change in the Oracle Database version
    • B、Change in your network infrastructure
    • C、Change in the hardware configuration of the database server
    • D、Migration of database storage from non-ASM to ASM storage
    • E、Database and operating system upgrade

    正确答案:A,C,E

  • 第19题：

    You perform the following activities during the database upgrade from Oracle Database 10g to Oracle Database 11g: 1. Capture plans for a SQL workload into a SQL Tuning Set (STS) before upgrade. 2. Load these plans from the STS into the SQL plan baseline immediately after the upgrade. What is the reason for performing these activities? （）

    • A、to minimize plan regression due to the use of a new optimizer version
    • B、to completely avoid the use of new plans generated by a new optimizer version
    • C、to prevent plan capturing when the SQL statement is executed after the database upgrade
    • D、to keep the plan in the plan history so that it can be used when the older version of the optimizer is used

    正确答案:A

  • 第20题：

    单选题
    You perform the following activities during the database upgrade from Oracle Database 10g to Oracle Database 11g: 1. Capture plans for a SQL workload into a SQL Tuning Set (STS) before upgrade. 2. Load these plans from the STS into the SQL plan baseline immediately after the upgrade. What is the reason for performing these activities? （）
    A

    to minimize plan regression due to the use of a new optimizer version

    B

    to completely avoid the use of new plans generated by a new optimizer version

    C

    to prevent plan capturing when the SQL statement is executed after the database upgrade

    D

    to keep the plan in the plan history so that it can be used when the older version of the optimizer is used


    正确答案： C
    解析： 暂无解析

  • 第21题：

    单选题
    You are working as a DBA on Oracle Database 9i. You plan to upgrade your 9i database to Oracle 10g. To be familiar with the new database technology， you decide to install Oracle Database 10g on your workstation at home. You create a general purpose database.   After the installation， you make the following changes in your initialization parameter file：LOG_ARCHIVE_DEST_1=’LOCATION=USE_DB_RECOVERY_FILE_DEST’   DB_RECOVERY_FILE_DEST =    ’LOCATION=d：/product/10.1.0/flash_recovery_area’  DB_RECOVERY_FILE_DEST_SIZE=10g   Where are the archived redo logs stored for your database？（）
    A

     The archived redo logs are stored in an operating system-dependent location.

    B

     The archived redo logs are stored in the location specified by LOG_ARCHIVE_DEST_1.

    C

     The archived redo logs are stored in the location specified by DB_RECOVERY_FILE_DEST.

    D

     The archived redo logs are stored in the locations specified by both LOG_ARCHIVE_DEST_1 and  DB_RECOVERY_FILE_DEST.


    正确答案： D
    解析： 暂无解析

  • 第22题：

    单选题
    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.


    正确答案： A
    解析： 暂无解析

  • 第23题：

    多选题
    Identify three scenarios in which you would recommend the use of SQL Performance Analyzer to analyzeimpact on the performance of SQL statements.（）
    A

    Change in the Oracle Database version

    B

    Change in your network infrastructure

    C

    Change in the hardware configuration of the database server

    D

    Migration of database storage from non-ASM to ASM storage

    E

    Database and operating system upgrade


    正确答案： A,E
    解析： 暂无解析

  • 第24题：

    单选题
    Oracle Grid Infrastructure for a stand-alone server is installed on your production host before installing the Oracle Database server. The database and listener are configured by using Oracle Restart. Examine the following command and its output: $ crsctl config has CRS-4622: Oracle High Availability Services auto start is enabled. What does this imply?（）
    A

    When you start an instance on a high with SQL *Plus dependent listeners and ASM disk groups are automatically started.

    B

    When a database instance is started by using the SRVCTL utility and listener startup fails, the instance is still started.

    C

    When a database is created by using SQL* Plus, it is automatically added to the Oracle Restart configuration.

    D

    When you create a database service by modifying the SERVICE_NAMES initialization parameter, it is automatically added to the Oracle Restart configuration.


    正确答案： C
    解析： 暂无解析

相关内容