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

You are creating a SQL Tuning Set to allow a group of SQL st

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

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

第1题：

You want to analyze a SQL Tuning Set (STS) using SQL Performance Analyzer in a test database. Which two statements are true regarding the activities performed during the test execution of SQLs in a SQL Tuning Set?（）

A.Every SQL statement in the STS is considered only once for execution

B.The SQL statements in the STS are executed concurrently to produce the execution plan and execution statistics

C.The execution plan and execution statistics are computed for each SQL statement in the STS

D.The effects of DDL and DML are considered to produce the execution plan and execution statistics


参考答案：A, C

第2题：

When creating a SQL tuning set，which of the following steps allows the DBA to reduce the size of the SQL set by selecting specific operators and values？（）

  • A、 Filter versions
  • B、 Filter loads
  • C、 Filter tasks
  • D、 Filter options

正确答案:D

第3题：

You plan to use SQL Performance Analyzer to analyze the SQL workload. You created a SQL Tuning Set as a part of the workload capturing. What information is captured as part of this process?()

A. the SQL text SQL

B. the execution plan

C. the execution context

D. the execution frequency

E. the system change number (SCN)


参考答案：A, C, D

第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 of the following cannot be used as input to the SQL Tuning Advisor?（） (Choose all that apply.)

  • A、A single SQL statement provided by a user
  • B、An existing SQL Tuning Set (STS)
  • C、A preprocessed Database Replay workload
  • D、A schema name
  • E、SQL statement identified in EM as using excessive resources

正确答案:C,D

第6题：

Which of the following cannot be used as input to the SQL Tuning Advisor?() (Choose all that apply.)

A. A single SQL statement provided by a user

B. An existing SQL Tuning Set (STS)

C. A preprocessed Database Replay workload

D. A schema name

E. SQL statement identified in EM as using excessive resources


参考答案：C, D

第7题：

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

第8题：

Your system has been upgraded from Oracle Database 10g to Oracle Database 11g. You imported SQL Tuning Sets (STS) from the previous version. After changing the OPTIMIZER_FEATURE_ENABLE parameter to 10.2.0.4 and running the SQL Performance Analyzer, you observed performance regression for a few SQL statements.What would you do with these SQL statements?（）

A. Set OPTIMIZER_USE_PLAN_BASELINES to FALSE to prevent the use of regressed plans.

B. Capture the plans from the previous version using STS and then load them into the stored outline.

C. Capture the plans from the previous version using STS and then load them into SQL Management Base (SMB).

D. Set OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES to FALSE to prevent the plans from being loaded to the SQL plan baseline.


参考答案：C

第9题：

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

第10题：

You plan to use SQL Performance Analyzer to analyze the SQL workload. You created a SQL Tuning Set as a part of the workload capturing.  What information is captured as part of this process？（）

  • A、 the SQL text
  • B、 the execution plan
  • C、 the execution context
  • D、 the execution frequency
  • E、 the system change number （SCN）

正确答案:A,C,D

更多相关问题
相关内容