单选题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?（）AIt performs parallel recompilation of only the stored PL/SQL code.BIt performs sequential recompilation of only the stored PL/SQL code.CIt performs parallel recompilation of any stored PL/SQL as well as Java code.DIt performs sequential recompilation of any stored PL/SQL as well as Java code.
单选题
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.
参考解析
解析：
暂无解析
相关考题：
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.sqlWhat 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.
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.sqlWhich 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.
Your computer runs Microsoft Windows XP Professional. The computer also runs 20 third- party applications. You plan to upgrade your computer to Microsoft Windows Vista. The functionality of the existing applications must be maintained even after you upgrade your computer. You need to ascertain whether the hardware and software on the Windows XP Professional computer will support the upgrade.What should you do?（）A.AB.BC.CD.D
You work as a database administrator for Certkiller .com. 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 ControlB、Oracle Management ServiceC、Oracle Enterprise Manager RepositoryD、Oracle Enterprise Manager Database Control
Which two are needed components when designing and implementing a security solution？（）A、detailed VLAN informationB、an incident response planC、results of testing the new network configurationD、an existing hierarchical network topologyE、a security policy for your organization
You are running Linux 2.0.36 and you need to add a USB mouse to your system. Which of the following statements is true？（）A、 You need to rebuild the kernel.B、 You need to upgrade the kernelC、 You need to load the USB modules for your existing modular kernel.D、 USB support is not available in Linux.
What do you need to upgrade the DXOS? （）A、an upgrade .gz file placed on your FTP serverB、an upgrade .tar file placed on your SCP serverC、an upgrade .pac file placed on your TFTP or SCP serverD、an upgrade CD provided by your Juniper Networks representative
You work as a database administrator for Supportcenter.cn. In your Oracle database 10g installation you have set ORACLE_BASE to /u01/app/oracle. Which objective will be achieved by this setting？（）A、The Oracle kernel will be placed in this location.B、The Oracle software will be placed in this location.C、The server parameter file （SPFILE） will be placed in this location.D、The database files will be placed in this location， if not specified explicitly.E、The location will be considered for the base of Oracle Managed Files （OMF）.F、The location will be considered for the base of Optimal Flexible Architecture （OFA）.
You have a domain that was created and configured with WebLogic 10.3.5. You want to upgrade the domain to use WebLogic 12c. Which Oracle tool must you use to upgrade your domain?（）A、Oracle WebLogic Domain Upgrade toolB、Smart Update C、Smart Upgrade D、No tool required, just install WebLogic 12c, update the domain to point to the new WebLogic installation and start your domain.E、JDeveloper
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*PlusB、iSQL*PlusC、Management ServerD、Management RepositoryE、Oracle Enterprise Manager 10g Database Control
You upgraded Oracle Database 10g to Oracle Database 11g. How would this affect the existing users’ passwords？（） A、 All passwords automatically become case-sensitive.B、 All passwords remain non-case-sensitive till they are changed.C、 All passwords remain non-case-sensitive and cannot be changed.D、 All passwords remain non-case-sensitive until their password attribute in the profile is altered.
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
单选题You are running Linux 2.0.36 and you need to add a USB mouse to your system. Which of the following statements is true？（）A You need to rebuild the kernel.B You need to upgrade the kernelC You need to load the USB modules for your existing modular kernel.D USB support is not available in Linux.
单选题What do you need to upgrade the DXOS? （）Aan upgrade .gz file placed on your FTP serverBan upgrade .tar file placed on your SCP serverCan upgrade .pac file placed on your TFTP or SCP serverDan upgrade CD provided by your Juniper Networks representative
多选题Identify three scenarios in which you would recommend the use of SQL Performance Analyzer to analyzeimpact on the performance of SQL statements.（）AChange in the Oracle Database versionBChange in your network infrastructureCChange in the hardware configuration of the database serverDMigration of database storage from non-ASM to ASM storageEDatabase and operating system upgrade
单选题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.
单选题You work as a database administrator for Supportcenter.cn. In your Oracle database 10g installation you have set ORACLE_BASE to /u01/app/oracle. Which objective will be achieved by this setting？（）AThe Oracle kernel will be placed in this location.BThe Oracle software will be placed in this location.CThe server parameter file （SPFILE） will be placed in this location.DThe database files will be placed in this location， if not specified explicitly.EThe location will be considered for the base of Oracle Managed Files （OMF）.FThe location will be considered for the base of Optimal Flexible Architecture （OFA）.
单选题Your computer runs Microsoft Windows XP Professional. The computer also runs 20 third-party applications. You plan to upgrade your computer to Microsoft Windows Vista. The functionality of the existing 20 applications must be maintained even after you upgrade your computer. You need to ascertain whether the hardware and software on the Windows XP Professional computer will support the upgrade. What should you do？（）ARun the mbsacli.exe command.BRun the winnt32.exe /checkupgradeonly command.CRun the Microsoft Windows Vista Upgrade Advisor application.DCompare the Microsoft Windows XP Professional system hardware against the Microsoft Windows Vista Hardware Compatibility List （HCL）.
单选题One of your customers has decided to deploy location-based services in addition to existing wireless services. The customer requires that the additional access points to be deployed in monitor-only mode. The most likely reason for this requirement is that the customer has which of these existing wireless devices？（）A802.11b/g VoIPBData CollectionC802.11b and g clientsDRFID tags
单选题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.
单选题You have a domain that was created and configured with WebLogic 10.3.5. You want to upgrade the domain to use WebLogic 12c. Which Oracle tool must you use to upgrade your domain?（）AOracle WebLogic Domain Upgrade toolBSmart Update CSmart Upgrade DNo tool required, just install WebLogic 12c, update the domain to point to the new WebLogic installation and start your domain.EJDeveloper
单选题Your company decided to start using RMAN in its backup strategy. Previously your company used operating system file copies. Which command is used to make RMAN aware of existing backups made by copying files at the operating system？（）ACHANGEBRESYNCCCATALOGDCROSSCHECK
单选题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? （）Ato minimize plan regression due to the use of a new optimizer versionBto completely avoid the use of new plans generated by a new optimizer versionCto prevent plan capturing when the SQL statement is executed after the database upgradeDto keep the plan in the plan history so that it can be used when the older version of the optimizer is used
单选题One of your customers has decided to deploy location-based services in addition to existing wireless services. the customer requires that the additional access points to be deployed in monitor-only modE. The most likely reason for this requirement is that the customer has which of these existing wireless devices？（）Adata collectionB802.11b/g voipC802.11b and g clientsDrfid tags
单选题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.
多选题Which two are needed components when designing and implementing a security solution？（）Adetailed VLAN informationBan incident response planCresults of testing the new network configurationDan existing hierarchical network topologyEa security policy for your organization