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

多选题Which three functions are performed by the SQL Tuning Advisor?（）ABuilding and implementing SQL profilesBRecommending the optimization of materialized viewsCChecking query objects for missing and stale statisticsDRecommending bitmap, function-based, and

题目
多选题
Which three functions are performed by the SQL Tuning Advisor?（）
A

Building and implementing SQL profiles

B

Recommending the optimization of materialized views

C

Checking query objects for missing and stale statistics

D

Recommending bitmap, function-based, and B-tree indexes

E

Recommending the restructuring of SQL queries that are using bad plans

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

第1题：

Which three statements about performance analysis by SQL Performance Analyzer are true? ()(Choose three.)

A. It detects changes in SQL execution plans.

B. It produces results that can be used to create the SQL plan baseline.

C. The importance of SQL statements is based on the size of the objects accessed.

D. It generates recommendations to run SQL Tuning Advisor to tune regressed SQLs.

E. It shows only the overall impact on workload and not the net SQL impact on workload.


参考答案：A, B, D

第2题：

Which three functions are performed by the SQL Tuning Advisor?() (Choose three.)

A. Building the SQL profile

B. Recommending optimization of materialized views

C. Checking query objects for missing and stale statistics

D. Recommending bitmap, function-based, and B-tree indexes

E. Recommending restructuring SQL queries that are using bad plans


参考答案：A, C, E

第3题：

Which three functions are performed by the SQL Tuning Advisor? ()

A. Building the SQL profile

B. Recommending optimization of materialized views

C. Checking query objects for missing and stale statistics

D. Recommending bitmap, function-based, and B-tree indexes

E. Recommending restructuring SQL queries that are using bad plans


参考答案：A, C, E

第4题：

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

第5题：

Which three functions are performed by the SQL Tuning Advisor?（）

  • A、Building and implementing SQL profiles
  • B、Recommending the optimization of materialized views
  • C、Checking query objects for missing and stale statistics
  • D、Recommending bitmap, function-based, and B-tree indexes
  • E、Recommending the restructuring of SQL queries that are using bad plans

正确答案:A,C,E

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

Which three functions are performed by the SQL Tuning Advisor?（） (Choose three.)

  • A、Building the SQL profile
  • B、Recommending optimization of materialized views
  • C、Checking query objects for missing and stale statistics
  • D、Recommending bitmap, function-based, and B-tree indexes
  • E、Recommending restructuring SQL queries that are using bad plans

正确答案:A,C,E

第8题：

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

第9题：

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

第10题：

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

更多相关问题
相关内容