网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)
单选题
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.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

考题 下面不属于Oracle 10g产品系列的是()。 A.Oracle数据库10g标准版B.Oracle数据库10g企业版C.Oracle数据库10g网络版

考题 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

考题 下面不属于Oracle 10g产品系列的是()。A、Oracle数据库10g标准版B、Oracle数据库10g企业版C、Oracle数据库10g网络版

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

考题 多选题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?()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).

考题 单选题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?()A Run the mbsacli.exe command.B Run the winnt32.exe /checkupgradeonly command.C Run the Microsoft Windows Vista Upgrade Advisor application.D Compare 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?()A 802.11b/g VoIPB Data CollectionC 802.11b and g clientsD RFID 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?()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

考题 单选题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?()A CHANGEB RESYNCC CATALOGD CROSSCHECK

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

考题 单选题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?()A data collectionB 802.11b/g voipC 802.11b and g clientsD rfid 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