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

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


参考答案:B

第2题:

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

第3题:

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.


参考答案:A

第4题:

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

第5题:

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

第6题:

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

第7题:

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

第8题:

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

第9题:

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

第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

更多相关问题