多选题What happens when you run the SQL Tuning Advisor with limited scope?（）AAccess path analysis is not performed for SQL statements.BSQL structure analysis is not performed for SQL statements.CSQL Profile recommendations are not generated for SQL statement

题目

多选题

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

Access path analysis is not performed for SQL statements.

SQL structure analysis is not performed for SQL statements.

SQL Profile recommendations are not generated for SQL statements.

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.

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

相似问题和答案

第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 two statements are true regarding the SQL Repair Advisor？（）

A、 The SQL Repair Advisor can be invoked to tune the performance of the regressed SQL statements.
B、 The SQL Repair Advisor can be invoked even when the incident is not active for a SQL statement crash.
C、 The SQL Repair Advisor is invoked by the Health Monitor when it encounters the problematic SQL statement.
D、 The DBA can invoke the SQL Repair Advisor when he or she receives an alert generated when a SQL statement crashes and an incident is created in the ADR.

正确答案:B,D

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

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

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

The SQL Tuning Advisor has been configured with default configurations in your database instance. Which recommendation is automatically implemented without the DBA’s intervention after the SQL Tuning Advisor is run as part of the AUTOTASK framework？（）

A、 statistics recommendations
B、 SQL profile recommendations
C、 index-related recommendations
D、 restructuring of SQL recommendations

正确答案:B

第7题：

You run the SQL Tuning Advisor (STA) to tune a SQL statement that is part of a fixed SQL plan baseline. The STA generates a SQL profile for the SQL statement, which recommends that you accept the profile. Which statement is true when you accept the suggested SQL profile?（）

A、The tuned plan is not added to the SQL plan baseline.
B、The tuned plan is added to the fixed SQL plan baseline as a fixed plan.
C、The tuned plan is added to the fixed SQL plan baseline as a nonfixed plan.
D、The tuned plan is added to a new nonfixed SQL plan baseline as a nonfixed plan.

正确答案:C

第8题：

The SQL Tuning Advisor has been configured with default configurations in your database instance.Which recommendation is automatically implemented without the DBA‘s intervention after the SQL Tuning Advisor is run as part of the AUTOTASK framework?（）

A. statistics recommendations

B. SQL profile recommendations

C. index-related recommendations

D. restructuring of SQL recommendations

参考答案：B

第9题：

You work with a newly created database. Presently, there is no application load on the database instance.You want to create a baseline for tuning the application, so you decide to collect recommendations that can be implemented to improve application performance.What action must you take to achieve this?（）

A、Run Segment Advisor
B、Run the SQL Tuning Advisor (STA)
C、Run the Automatic Workload Repository (AWR) report
D、Run the SQL Access Advisor with a hypothetical workload

正确答案:D

第10题：

The SQL Tuning Advisor configuration has default settings in your database instance. Which recommendation is automatically implemented after the SQL Tuning Advisor is run as part of the automatic maintenance task?（）

A、statistics recommendations
B、SQL Profile recommendations
C、Index-related recommendations
D、restructuring of SQL recommendations

正确答案:B

多选题What happens when you run the SQL Tuning Advisor with limited scope?（）AAccess pathanalysis is not performed for SQL statements.BSQL structure analysis is not performed for SQL statements.CSQL Profile recommendations are not generated for SQL statements

题目

相似问题和答案

更多相关问题

相关内容