题目内容（请给出正确答案）

[主观题]

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.

查看答案

如搜索结果不匹配，请联系老师获取答案

您可能会需要：

重置密码查看订单联系客服

安装赏学吧APP，拍照搜题省时又省心！

更多“When executing a SQL workload,…”相关的问题

第1题

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

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.

点击查看答案

第2题

Your database supports a DSS workload that involves the execution of complex queries: Curr

ently, 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.

点击查看答案

第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

点击查看答案

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

B. the execution plan

C. the execution context

D. the execution frequency

E. the system change number (SCN)

点击查看答案

第5题

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.

点击查看答案

第6题

Your database supports an online transaction processing （OLTP) application.The application

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

点击查看答案

第7题

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.