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?()

  • 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

相关考题:

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)

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

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.

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.

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.

You accepted the recommended SQL Profile by executing the following code:   DECLARE   sqlprofile_name varchar2(30);  BEGIN   sqlprofile_name := DBMS_SQLTUNE.ACCEPT_SQL_PROFILE(  task_name = ’my_task’,   profile_name = ’my_profile’);   END;   Which advisor will analyze this profile?()  A、 SQL Access AdvisorB、 Undo AdvisorC、 Segment AdvisorD、 SQL Tuning Advisor

You are maintaining the SALES database for eSoft Corporation. You have not configured ASMM on the database. You want to know what size of the SGA will provide the best performance.  Which advisor would you use to determine the suitable size of the SGA?()A、 SQL Tuning AdvisorB、 Undo AdvisorC、 ADDMD、 Memory Advisor

Which of the following advisors within the Oracle advisory framework will analyze a single SQL statement and make recommendations for performance improvement?()A、SQL Repair AdvisorB、SQL OptimizerC、SQL Access AdvisorD、SQL Tuning Advisor

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

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 textB、 the execution planC、 the execution contextD、 the execution frequencyE、 the system change number (SCN)

Which component does the SQL Tuning Advisor NOT analyze for the SQL statements?()  A、ADDMB、AWRC、Cursor CacheD、SQL Tuning SetsE、Flash Recovery Area

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_REPOSITORYB、 DBMS_RESOURCE_MANAGERC、 DBMS_SQLTUNED、 DBMS_ADVISOR

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)

You want to use the SQL Tuning Advisor to generate recommendations for badly written SQL statements in your development environment.   Which three sources can you select for the advisor to analyze? ()A、Top SQLB、snapshotsC、SQL Tuning setsD、index access pathE、optimizer statisticsF、materialized view logs

You use a SQL Server 2005 database named DB1, which is located on a server named SQL1. DB1 is in use 24 hours a day, 7 days a week. A recent copy of DB1 exists on a second server named SQLtest that also runs SQL Server 2005. You detect a high number of full scans on SQL1 and conclude that additional indexes in DB1 are needed. A workload file that is suitable for Database Engine Tuning Advisor (DTA) already exists.   You need to analyze the workload file by using DTA. You must ensure maximum performance on SQL1 during analysis. You must also ensure availability during the implementation of any recommendations suggested by the DTA. What should you do?()A、Store the workload file on SQL1. Start DTA on SQLtest and connect to SQL1. Specify all workload and tuning options as necessary. In the Advanced Tuning Options dialog box, select the Generate only online recommendations check box.B、Store the workload file on SQLtest. Start DTA on SQLtest and connect to SQLtest. Specify all workload and tuning options as necessary. In the Advanced Tuning Options dialog box,select the generate only online recommendations check box.C、Store the workload file on SQL1. Start DTA on SQL1 and connect to SQL1. Specify all workload and tuning options as necessary. In the Advanced Tuning Options dialog box,select the All recommendations are offline check box.D、Store the workload file on SQLtest. Start DTA on SQLtest and connect to SQLtest.Specify all workload and tuning options as necessary.In the Advanced Tuning Options dialog box,select the All recommendations are offline check box.

单选题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?()ARun the SQL Access Advisor.BRun the SQL Tuning Advisor (STA).CRun the Automatic Workload Repository (AWR) report.DRun the Automatic Database Diagnostic Monitor (ADDM).

单选题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_REPOSITORYB DBMS_RESOURCE_MANAGERC DBMS_SQLTUNED DBMS_ADVISOR

多选题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 considered only once for executionBThe SQL statements in the STS are executed concurrently to produce the execution plan and execution statisticsCThe execution plan and execution statistics are computed for each SQL statement in the STSDThe effects of DDL and DML are considered to produce the execution plan and execution statistics

多选题You want to use the SQL Tuning Advisor to generate recommendations for badly written SQL statements in your development environment.   Which three sources can you select for the advisor to analyze? ()ATop SQLBsnapshotsCSQL Tuning setsDindex access pathEoptimizer statisticsFmaterialized view logs

单选题You are maintaining the SALES database for eSoft Corporation. You have not configured ASMM on the database. You want to know what size of the SGA will provide the best performance.  Which advisor would you use to determine the suitable size of the SGA?()A SQL Tuning AdvisorB Undo AdvisorC ADDMD Memory Advisor

单选题Which of the following advisors within the Oracle advisory framework will analyze a single SQL statement and make recommendations for performance improvement?()ASQL Repair AdvisorBSQL OptimizerCSQL Access AdvisorDSQL Tuning Advisor SQL

多选题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?()Athe SQL textBthe execution planCthe execution contextDthe execution frequencyEthe system change number (SCN)

单选题Which of the following advisors within the Oracle advisory framework will analyze a single SQL statement and make recommendations for performance improvement?()A SQL Repair AdvisorB SQL OptimizerC SQL Access AdvisorD SQL Tuning Advisor

单选题You accepted the recommended SQL Profile by executing the following code:   DECLARE   sqlprofile_name varchar2(30);  BEGIN   sqlprofile_name := DBMS_SQLTUNE.ACCEPT_SQL_PROFILE(  task_name = ’my_task’,   profile_name = ’my_profile’);   END;   Which advisor will analyze this profile?()A SQL Access AdvisorB Undo AdvisorC Segment AdvisorD SQL Tuning Advisor

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

单选题Which component does the SQL Tuning Advisor NOT analyze for the SQL statements?()AADDMBAWRCCursor CacheDSQL Tuning SetsEFlash Recovery Area

单选题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 AdvisorB Run the SQL Tuning Advisor (STA)C Run the Automatic Workload Repository (AWR) reportD Run the SQL Access Advisor with a hypothetical workload

多选题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 considered only once for execution.BThe SQL statements in the STS are executed concurrently to produce the execution plan and execution statistics.CThe execution plan and execution statistics are computed for each SQL statement in the STS.DThe effects of DDL and DML are considered to produce the execution plan and execution statistics.