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

When executing a SQL workload,

题目

When executing a SQL workload, you choose to generate execution plans only, without collecting execution statistics. Which two statements describe the implications of this?（）

  • A、It produces less accurate results of the comparison analysis.
  • B、It automatically calls the SQL Tuning Advisor for recommendations.
  • C、It shortens the time of execution and reduces the impact on system resources.
  • D、Only the changes in the execution plan, and not performance regression, are detected.
参考答案和解析
正确答案:A,C
如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

Identify the two direct sources from where SQL plans can be loaded into the SQL plan baselines.()

A. Cursor cache

B. Stored outline

C. SQL Tuning Set

D. Automatic Workload Repository (AWR) snapshots


参考答案：A, C

第2题：

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

第3题：

You have an SQL query that takes one minute to execute. You use the following code segment to execute theSQL query asynchronously.Dim ar As IAsyncResult = cmd.BeginExecuteReader()You need to execute a method named DoWork() that takes one second to run while the SQL query is executing.DoWork() must run as many times as possible while the SQL query is executing.Which code segment should you use?（）

A.

B.

C.

D.


参考答案：B

第4题：

A database administrator would like to examine repartitioning options for a partitioned database named PRODDB. A workload has been captured on the system (Windows) and is stored in a file named WORKLOAD.SQL. What is the proper command to run the Design Advisor so that it will evaluate the information stored in the file and give advice on re-partitioning?（）

  • A、db2advis -d proddb -i workload.sql -P  
  • B、db2advis -d proddb -i workload.sql -partitioning  
  • C、db2advis -d proddb -i workload.sql -m P  
  • D、db2advis -d proddb -i workload.sql -m ALL 

正确答案:C

第5题：

When executing a SQL workload，you choose to generate execution plans only， without collecting execution statistics.  Which two statements describe the implications of this？（）

  • A、 It produces less accurate results of the comparison analysis.
  • B、 It automatically calls the SQL Tuning Advisor for recommendations.
  • C、 It shortens the time of execution and reduces the impact on system resources.
  • D、 Only the changes in the execution plan，and not performance regression，are detected.

正确答案:A,C

第6题：

What is true about a background engine? ()(Choose two.)

A. It is a server-side PL/SQL procedure.

B. When executing a PL/SQL function activity, it will automatically ping (cache) the PL/SQL code.

C. It executes deferred activities in decreasing order of their Cost property value (activities with higher cost value are processed first).

D. It would fail if another background engine process is started to handle the same type of activities within the same item type.

E. During its single invocation, it processes activities that were stuck, deferred or timed out when the background engine was started.


参考答案：A, E

第7题：

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

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


参考答案：A, C, D

第9题：

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

第10题：

Which of the following best describes Simultaneous Multi-threading （SMT）？（）

  • A、A POWER5 microprocessor feature that allocates two processors to each application
  • B、A Workload Manager feature that allows two processing threads to be executing on a single processor
  • C、An AIX v5.2 feature that allows two processing threads to be executing on a single processor concurrently
  • D、A POWER5 microprocessor feature that allows two processing threads to be executing on a single processor concurrently

正确答案:D

更多相关问题
相关内容