多选题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?（）AEvery SQL statement in the STS is co

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

相似考题

1.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 SQLB. the execution planC. the execution contextD. the execution frequencyE. the system change number (SCN)

2.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 userB. An existing SQL Tuning Set (STS)C. A preprocessed Database Replay workloadD. A schema nameE. SQL statement identified in EM as using excessive resources

3.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.

4.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 executionB.The SQL statements in the STS are executed concurrently to produce the execution plan and execution statisticsC.The execution plan and execution statistics are computed for each SQL statement in the STSD.The effects of DDL and DML are considered to produce the execution plan and execution statistics

更多“多选题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?（）AEvery SQL statement in the STS is co”相关问题

  • 第1题：

    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

  • 第2题：

    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

  • 第3题：

    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

  • 第4题：

    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

  • 第5题：

    Identify the activities performed as part of the Automatic SQL Tuning process in the maintenance window?（）

    • A、generating the SQL profile
    • B、testing and accepting the SQL profile
    • C、generating a list of candidate SQLs for tuning
    • D、adding tuned SQL plans into the SQL plan baseline
    • E、tuning each SQL statement in the order of importance
    • F、generating baselines that include candidate SQLs for tuning

    正确答案:A,B,C,E

  • 第6题：

    Which three statements about performance analysis by SQL Performance Analyzer are true？（）

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

    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

  • 第8题：

    多选题
    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)


    正确答案： B,A
    解析： 暂无解析

  • 第9题：

    多选题
    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.


    正确答案： B,E
    解析： 暂无解析

  • 第10题：

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


    正确答案： B
    解析： 暂无解析

  • 第11题：

    多选题
    Which three statements about performance analysis by SQL Performance Analyzer are true？（）
    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.


    正确答案： C,E
    解析： 暂无解析

  • 第12题：

    单选题
    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
    解析： 暂无解析

  • 第13题：

    Your database supports a DSS workload that involves the execution of complex queries: Currently, the library cache contains the ideal workload for analysis. You want to analyze some of the queries for an application that are cached in the library cache. What must you do to receive recommendations about the efficient use of indexes and materialized views to improve query performance?（）

    • A、Create a SQL Tuning Set (STS) that contains the queries cached in the library cache and run the SQL Tuning Advisor (STA) on the workload captured in the STS.
    • B、Run the Automatic Workload Repository Monitor (ADDM).
    • C、Create an STS that contains the queries cached in the library cache and run the SQL Performance Analyzer (SPA) on the workload captured in the STS.
    • D、Create an STS that contains the queries cached in the library cache and run the SQL Access Advisor on the workload captured in the STS.

    正确答案:D

  • 第14题：

    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

  • 第15题：

    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

  • 第16题：

    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

  • 第17题：

    Identify the activities performed as part of the Automatic SQL Tuning process in the maintenance window？（）

    • A、 generating the SQL profile
    • B、 testing and accepting the SQL profile
    • C、 generating a list of candidate SQLs for tuning
    • D、 adding tuned SQL plans into the SQL plan baseline
    • E、 tuning each SQL statement in the order of importance 
    • F、 generating baselines that include candidate SQLs for tuning

    正确答案:A,B,C,E

  • 第18题：

    Which of the following cannot be used as input to the SQL Tuning Advisor？（）

    • 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

  • 第19题：

    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

  • 第20题：

    多选题
    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,B
    解析： 暂无解析

  • 第21题：

    多选题
    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


    正确答案： E,C
    解析： 暂无解析

  • 第22题：

    多选题
    Identify the activities performed as part of the Automatic SQL Tuning process in the maintenance window?（）
    A

    generating the SQL profile

    B

    testing and accepting the SQL profile

    C

    generating a list of candidate SQLs for tuning

    D

    adding tuned SQL plans into the SQL plan baseline

    E

    tuning each SQL statement in the order of importance

    F

    generating baselines that include candidate SQLs for tuning


    正确答案： B,A
    解析： 暂无解析

  • 第23题：

    多选题
    Which of the following cannot be used as input to the SQL Tuning Advisor？（）
    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
    解析： 暂无解析

  • 第24题：

    多选题
    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.


    正确答案： D,B
    解析： 暂无解析

相关内容