可学答题网 > 问答 > 1Z0-053题库
目录: 标题| 题干| 答案| 搜索| 相关
问题

Your system has been&e


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.
参考答案
参考解析:
分类:1Z0-053题库
相关推荐

1、Your company has two&e

Your company has two branch offices that connect by using a WAN link. Each office contains...

2、Your company has two&e

Your company has two main offices named Main1 and Main2.An Active Directory site exists for&ens...

3、表达式10>5&&6%3的值是()

表达式10>5&&6%3的值是()A-1B非零值C0D1

4、Your company has 300&e

Your company has 300 portable computers that run Microsoft Office Enterprise 2007. The company ...

5、Your company has 300&e

Your company has 300 portable computers that run Microsoft Office Enterprise 2007. The company ...

6、“频段0”的CDMA2000-1X系统沿用了AMPS的信道编号,一个AMPS

“频段0”的CDMA2000-1X系统沿用了AMPS的信道编号,一个AMPS的信道编号对应的频谱宽度是多少?()A200KHzB30KHzC25KHzD150KHz