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.

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.

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

A. the SQL text SQL

B. the execution plan

C. the execution context

D. the execution frequency

E. the system change number (SCN)

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.

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

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.

When you ______, you will certainly choose the Excite Inbox.

A．need free voicemail

B．want to receive faxes

C．need free web-based e-mail

D．all of the above