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

Which component does the SQL Tuning Advisor NOT analyze for 

题目
单选题
Which component does the SQL Tuning Advisor NOT analyze for the SQL statements？（）
A

ADDM

B

AWR

C

Cursor Cache

D

SQL Tuning Sets

E

Flash Recovery Area

参考答案和解析
正确答案： A
解析： 暂无解析
如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

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

第2题：

Which of the following identifies and creates an index to minimize the DB time for a particular SQL statement？（）  

  • A、 The SGA Tuning Advisor
  • B、 The SQL Access Advisor
  • C、 The SQL Tuning Advisor
  • D、 The Memory Advisor

正确答案:C

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

Which component does the SQL Tuning Advisor NOT analyze for the SQL statements？（）  

  • A、ADDM
  • B、AWR
  • C、Cursor Cache
  • D、SQL Tuning Sets
  • E、Flash Recovery Area

正确答案:E

第5题：

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

第6题：

You accepted the recommended SQL Profile by executing the following code：   DECLARE   sqlprofile_name varchar2（30）；  BEGIN   sqlprofile_name ：= DBMS_SQLTUNE.ACCEPT_SQL_PROFILE（  task_name => ’my_task’，   profile_name => ’my_profile’）；   END；   Which advisor will analyze this profile？（）  

  • A、 SQL Access Advisor
  • B、 Undo Advisor
  • C、 Segment Advisor
  • D、 SQL Tuning Advisor

正确答案:D

第7题：

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

第8题：

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

第9题：

To view the results of the most recent Automatic SQL Tuning Advisor task，which sequence should you follow？（）  

  • A、 EM Database home page，Software and Support，SQL Advisors，Automatic SQL Tuning Advisor
  • B、 EM Database home page，Software and Support，Advisor Central，SQL Advisors，Automatic SQL Tuning Advisor
  • C、 EM Database home page，Software and Support，Support Workbench，Advisor Central，SQL Advisors，Automatic SQL Tuning Advisor
  • D、 Either B or C
  • E、 All of the above

正确答案:D

第10题：

You are creating a SQL Tuning Set to allow a group of SQL statements to be passed into the SQL Tuning Advisor. Which packages will you use to create the SQL Tuning Set？（）

  • A、 DBMS_WORKLOAD_REPOSITORY
  • B、 DBMS_RESOURCE_MANAGER
  • C、 DBMS_SQLTUNE
  • D、 DBMS_ADVISOR

正确答案:C

更多相关问题
相关内容