[单选]
Your system has been upgraded from Oracle Database 10g to Oracle Database 11g. You imported SQL Tuning Sets (STS) from the previous version. After changing the OPTIMIZER_FEATURE_ENABLE parameter to 10.2.0.4 and running the SQL Performance Analyzer, you observed performance regression for a few SQL statements.
What would you do with these SQL statements?（）

A . Set OPTIMIZER_USE_PLAN_BASELINES to FALSE to prevent the use of regressed plans.
B . Capture the plans from the previous version using STS and then load them into the stored outline.
C . Capture the plans from the previous version using STS and then load them into SQL Management Base (SMB).
D . Set OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES to FALSE to prevent the plans from being loaded to the SQL plan baseline.

金融机构应当设立专门的反洗钱岗位，明确专人负责大额交易和可疑交易报告工作。前数中“金融机构”指下列哪项？（）金融机构总部。金融机构省级机构。金融机构分支机构。金融机构总部及各级分支机构。体育与健康课程的功能与价值是（）。根据我国反洗钱法的规定，洗钱的上游犯罪不包括：（）毒品犯罪。走私犯罪。贪污贿赂犯罪。抢劫罪。草地退化的特征和标志有哪些？在典型生长曲线中，代时最短的生长期是（）延滞期。对数期。稳定期。衰亡期。

Your system has been upgraded from Oracle Database 10g to Oracle Database 11g. You imported SQL Tuning Sets (STS) from the previous version. After changing the OPTIMIZER_FEATURE_ENABLE parameter to 10.2.0.4 and running the SQL Performance Analyzer, you observed performance regression for a few SQL statements.
What would you do with these SQL statements?（）

参考答案：

● 参考解析

本题暂无解析

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

相关题目: