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

多选题In Oracle 11g, which recommendations does the SQL Access Advisor generate?（）Apartitioning recommendationsBstatistics collection recommendationsCindex creation recommendationsDmaterialized view recommendationsEmaterialized view log recommendations

题目
多选题
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

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

第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题：

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

第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题：

What happens when you run the SQL Tuning Advisor with limited scope?（）

  • A、Access path analysis is not performed for SQL statements.
  • B、SQL structure analysis is not performed for SQL statements.
  • C、SQL Profile recommendations are not generated for SQL statements.
  • D、Staleness and absence of statistics are not checked for the objects in the SQL Tuning Advisor. In this case, SQL Tuning Advisor produces recommendations based on statistical checks, access path analysis, and SQL structure analysis. SQL profile recommendations are not generated.

正确答案:B,C

第5题：

Which statement is true when you run the SQL Tuning Advisor with limited scope？（）

  • A、Access path analysis is not performed for the SQL statements.
  • B、SQL structure analysis is not performed for the SQL statements.
  • C、SQL Profile recommendations are not generated for the SQL statements.
  • D、The staleness and absence of the statistics are not checked for the objects in the query supplied to the SQL Tuning Advisor.

正确答案:C

第6题：

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

第7题：

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

第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 statement most accurately describes the implementation of a SQL Access Advisor recommendation？（）  

  • A、 SQL Access Advisor recommendations are automatically implemented.
  • B、 Individual SQL Access Advisor recommendations can be scheduled for implementation.
  • C、 All SQL Access Advisor recommendations for a specific task must be implemented at the same time.
  • D、 SQL Access Advisor recommendations are automatically scheduled for implementation during the maintenance window.
  • E、 None of the above.

正确答案:B

更多相关问题
相关内容