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 context

题目
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)

相似考题

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.

2. You are analyzing the performance of a SQL Azure database.   You need to recommend an approach for identifying the indexes that should be added to improve database performance.  What should you recommend？（）A、 Use SQL Server Profiler to identify missing indexes.B、 Use the Database Engine Tuning Advisor to identify missing indexes.C、 Use a Dynamic Management View to analyze query plans.D、 Use a DynamicManagement View to ascertain the number of pending I/O requests.

3. A Windows Azure application connects to a SQL Azure database.  The database size has increased significantly.   Some queries in the application no longer complete.   You need to recommend an approach for identifying queries that do not complete.  What should you recommend？（）A、 Use the SQL Server Profiler to capture all SQL activities.B、 Use a Dynamic Management View to analyze performance.C、 Use the Database Engine Tuning Advisor to analyze the workload.D、 Use Microsoft SQL Server Management Studio to analyze the SQL logs.

4.Your database supports an online transaction processing (OLTP) application.The application is undergoing some major schema changes, such as addition of new indexes and materialized views.You want to check the impact of these changes on workload performance.What should you use to achieve this?（）A. Database replayB. SQL Tuning AdvisorC. SQL Access AdvisorD. SQL Performance AnalyzerE. Automatic Workload Repository compare reports

参考答案和解析
参考答案：A, C, D
更多“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?() ”相关问题

  • 第1题：

    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

  • 第2题：

    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

  • 第3题：

    Your database supports an online transaction processing (OLTP) application. The application is undergoing some major schema changes, such as addition of new indexes and materialized views. You want to check the impact of these changes on workload performance. What should you use to achieve this?（）

    • A、Database replay
    • B、SQL Tuning Advisor
    • C、SQL Access Advisor
    • D、SQL Performance Analyzer
    • E、Automatic Workload Repository compare reports

    正确答案:E

  • 第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 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

  • 第5题：

    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

  • 第6题：

    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

  • 第7题：

    You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a remote SQL Server 2008 instance. You notice that the application has a poor performance. On the remote SQL Server instance， you capture a workload of the remote instance to a trace table by using SQL Profiler. Now you have to use the Database Engine Tuning Advisor to analyze the workload of the remote SQL Server instance on a local SQL Server instance.  So what action should you perform to achieve this goal？（）

    • A、You should recapture the workload by using the data collector.
    • B、You should enable the XP_MSVER stored procedure on the local server.
    • C、You should enable the XP_MSVER stored procedure on the remote server
    • D、You should recapture the workload to a trace file by using SQL Profiler.

    正确答案:D

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

    单选题
    You work in a data warehouse environment that involves the execution of complex queries. The current content of the SQL cache holds the ideal workload for analysis. You want to analyze only few most resource-intensive statements. What would be your suggestion to receive recommendations on the efficient use of indexes and materialized views to improve query performance？（）
    A

    Run the SQL Access Advisor.

    B

    Run the SQL Tuning Advisor （STA）.

    C

    Run the Automatic Workload Repository （AWR） report.

    D

    Run the Automatic Database Diagnostic Monitor （ADDM）.


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

  • 第10题：

    单选题
    You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a remote SQL Server 2008 instance. You notice that the application has a poor performance. On the remote SQL Server instance， you capture a workload of the remote instance to a trace table by using SQL Profiler. Now you have to use the Database Engine Tuning Advisor to analyze the workload of the remote SQL Server instance on a local SQL Server instance.  So what action should you perform to achieve this goal？（）
    A

    You should recapture the workload by using the data collector.

    B

    You should enable the XP_MSVER stored procedure on the local server.

    C

    You should enable the XP_MSVER stored procedure on the remote server

    D

    You should recapture the workload to a trace file by using SQL Profiler.


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

  • 第11题：

    单选题
    A Windows Azure application connects to a SQL Azure database.  The database size has increased significantly.   Some queries in the application no longer complete.   You need to recommend an approach for identifying queries that do not complete.  What should you recommend？（）
    A

     Use the SQL Server Profiler to capture all SQL activities.

    B

     Use a Dynamic Management View to analyze performance.

    C

     Use the Database Engine Tuning Advisor to analyze the workload.

    D

     Use Microsoft SQL Server Management Studio to analyze the SQL logs.


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

  • 第12题：

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

  • 第13题：

    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

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

    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

  • 第16题：

    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

  • 第17题：

    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

  • 第18题：

    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

  • 第19题：

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


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

  • 第20题：

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

  • 第21题：

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


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

  • 第22题：

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


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

  • 第23题：

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

相关内容