违法和不良信息举报 联系客服
免费注册 登录

多选题In Oracle 11g, which recommendations does the SQL Access Advisor generate? （）(Choose all that apply.)Apartitioning recommendationsBstatistics collection recommendationsCindex creation recommendationsDmaterialized view recommendationsEmaterialized view

题目
多选题
In Oracle 11g, which recommendations does the SQL Access Advisor generate? （）(Choose all that apply.)
A

partitioning recommendations

B

statistics collection recommendations

C

index creation recommendations

D

materialized view recommendations

E

materialized view log recommendations

如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

What recommendations does the SQL Access Advisor provide for optimizing SQL queries?()

A. selection of SQL plan baselines

B. partitioning of tables and indexes

C. creation of index-organized tables

D. creation of bitmap, function-based, and B-tree indexes

E. optimization of materialized views for maximum query usage and fast refresh


参考答案：B, D, E

第2题：

What recommendations does the SQL Access Advisor provide for optimizing SQL queries? ()(Choose all that apply.)

A. selection of SQL plan baselines

B. partitioning of tables and indexes

C. creation of index-organized tables

D. creation of bitmap, function-based, and B-tree indexes

E. optimization of materialized views for maximum query usage and fast refresh


参考答案：B, D, E

第3题：

View the Exhibit to examine the Automatic SQL Tuning result details.Which action would you suggest for the selected SQL statement in the Exhibit?()

A. Accept the recommended SQL profile.

B.Collect statistics for the related objects.

C. Run the Access Advisor for the SQL statement.

D. Run the Segment Advisor for recommendations.


参考答案：C

第4题：

To view the results of a manual SQL Tuning Advisor task, which steps should the DBA take?（）

  • A、From the Advisor Central home page, select the tuning task from the Advisor Tasks section.
  • B、From Advisor Central, choose SQL Advisors, SQL Tuning Advisors, Manual Tuning Task Results.
  • C、From Advisor Central, choose SQL Advisors, Manual SQL Tuning Advisors, Tuning Task Results.
  • D、Either B or C

正确答案:A

第5题：

You want to use the SQL Tuning Advisor to generate recommendations for badly written SQL statements in your development environment. Which three sources can you select for the advisor to analyze？（）

  • A、 Top SQL
  • B、 snapshots
  • C、 SQL Tuning sets
  • D、 index access path
  • E、 optimizer statistics
  • F、 materialized view logs

正确答案:A,C,D

第6题：

To view the results of a manual SQL Tuning Advisor task, which steps should the DBA take?()

A. From the Advisor Central home page, select the tuning task from the Advisor Tasks section.

B. From Advisor Central, choose SQL Advisors, SQL Tuning Advisors, Manual Tuning Task Results.

C. From Advisor Central, choose SQL Advisors, Manual SQL Tuning Advisors, Tuning Task Results.

D. Either B or C


参考答案：A

第7题：

In Oracle 11g, which recommendations does the SQL Access Advisor generate? ()(Choose all that apply.)

A. partitioning recommendations

B. statistics collection recommendations

C. index creation recommendations

D. materialized view recommendations

E. materialized view log recommendations


参考答案：A, C, D, E

第8题：

In Oracle 11g, which recommendations does the SQL Access Advisor generate?()

A. partitioning recommendations

B. statistics collection recommendations

C. index creation recommendations

D. materialized view recommendations

E. materialized view log recommendations


参考答案：A, C, D, E

第9题：

Which of the following advisors within the Oracle advisory framework will analyze a single SQL statement and make recommendations for performance improvement?（）

  • A、SQL Repair Advisor
  • B、SQL Optimizer
  • C、SQL Access Advisor
  • D、SQL Tuning Advisor

正确答案:D

第10题：

Which of the following cannot be used as input to the SQL Tuning Advisor?（） (Choose all that apply.)

  • A、A single SQL statement provided by a user
  • B、An existing SQL Tuning Set (STS)
  • C、A preprocessed Database Replay workload
  • D、A schema name
  • E、SQL statement identified in EM as using excessive resources

正确答案:C,D

更多相关问题
相关内容