[单选]
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 toy manufacturing customer wants to run Microsoft SQL Server. Which category is applicable for such a solution？（） E-mail。 Database。 Network Infrastructure。 Systems Management。资产评估的特点主要有（）。市场性。强制性。公正性。咨询性。专业性。 Which of the following commands can an operator use to view disk performance details?（） topas -D。 topas -R。 topas -C。 topas -d。 During reboot， the system hangs with an LED 0554 message that means， "The boot device could not be opened or a read failed." Which of the following recovery procedures should be taken （） Boot in maintenance mode and use fsck to check hd5.。 Boot in maintenance mode， access the rootvg and check the /etc/inittab for corruption.。 Boot in maintenance mode， access the rootvg and rebuild the boot image using the bosboot command.。 Boot in maintenance mode， and reset the root password.。 When defining shipping for a store using WebSphere Commerce Accelerator a seller must create：（） shipping jurisdictions for each fulfillment center。 shipping codes for each set of shipping charges to be applied to products。 shipping methods for each carrier and service offered by the carrier。 shipping zones for each geographical region where goods will be shipped。

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? （）

参考答案：

● 参考解析

本题暂无解析

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

相关题目: