Which is the source used by Automatic SQL Tuning that runs as part of the AUTOTASK framework？（）A、 SQL statements that are part of the AWR baseline onlyB、 SQL statements based on the AWR top SQL identificationC、 SQL statements that are part of the availabl

题目

Which is the source used by Automatic SQL Tuning that runs as part of the AUTOTASK framework？（）

A、 SQL statements that are part of the AWR baseline only
B、 SQL statements based on the AWR top SQL identification
C、 SQL statements that are part of the available SQL Tuning Set （STS） only
D、 SQL statements that are available in the cursor cache and executed by a user other than SYS

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

相似问题和答案

第1题：

Which two statements about the SQL Management Base (SMB) are true?()

A. It contains only SQL profiles generated by SQL Tuning Advisor.

B. It stores plans generated by the optimizer using a stored outline.

C. It is part of the data dictionary and stored in the SYSAUX tablespace.

D. It is part of the data dictionary and stored in the SYSTEM tablespace.

E. It contains the statement log, the plan history, plan baselines, and SQL profiles.

参考答案：C, E

第2题：

Which is the source used by Automatic SQL Tuning that runs as part of the AUTOTASK framework? （）

A、SQL statements that are part of the AWR baseline only
B、SQL statements based on the AWR top SQL identification
C、SQL statements that are part of the available SQL Tuning Set (STS) only
D、SQL statements that are available in the cursor cache and executed by a user other than SYS

正确答案:B

第3题：

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

第4题：

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

正确答案:B

第5题：

Which two statements about the SQL Management Base (SMB) are true? （）(Choose two.)

A、It contains only SQL profiles generated by SQL Tuning Advisor.
B、It stores plans generated by the optimizer using a stored outline.
C、It is part of the data dictionary and stored in the SYSAUX tablespace.
D、It is part of the data dictionary and stored in the SYSTEM tablespace.
E、It contains the statement log, the plan history, plan baselines, and SQL profiles.

正确答案:C,E

第6题：

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

第7题：

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

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

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

第10题：

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.

正确答案:B

Which is the source used by Automatic SQL Tuning that runs as part of the AUTOTASK framework？（）A、 SQL statements that are part of the AWR baseline onlyB、 SQL statements based on the AWR top SQL identificationC、 SQL statements that are part of the availabl

题目

相似问题和答案

更多相关问题

相关内容