多选题When executing a SQL workload，you choose to generate execution plans only， without collecting execution statistics. Which two statements describe the implications of this？（）AIt produces less accurate results of the comparison analysis.BIt automatically calls the SQL Tuning Advisor for recommendations.CIt shortens the time of execution and reduces the impact on system resources.DOnly the changes in the execution plan，and not performance regression，are detected.
多选题
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.
参考解析
解析：
暂无解析
相关考题：
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.
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)
To generate recommendations to improve the performance of a set of SQL queries in an application, you execute the following blocks of code:The blocks of code execute successfully; however, you do not get the required outcome. What could be the reason?（）A. A template needs to be associated with the task.B.A workload needs to be associated with the task.C. The partial or complete workload scope needs to be associated with the task.D. The type of structures (indexes, materialized views, or partitions) to be recommended need to be specified for the task.
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.
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.
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
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.
In which two situations should you run the command sync group?（） (Choose two.)A、when you enable Unified FailoverB、when you create an ActiveN groupC、when you synchronize the sticky tableD、when you require synchronization of the 3G Cache objects
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.
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.
You are maintaining the PROD database of NetFx Corporation. You set the value of the SQL_TRACE parameter to TRUE. What will be the impact of this setting？（） A、 The SQL trace facility will generate the performance statistics for all the SQL statements for an instance and write them in the USER_DUMP_DEST directory.B、 The SQL trace facility will generate the performance statistics for all the SQL statements for a session and write them in the USER_DUMP_DEST directory.C、 The SQL trace facility will generate the performance statistics for all the SQL statements for an instance and write them in the BACKGROUND_DUMP_DEST directory.D、 The SQL trace facility will generate the performance statistics for all the SQL statements for a session and write them in the BACKGROUND_DUMP_DEST directory.
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.
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）
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 work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. The server hosts databases for several mission-critical applications. Microsoft SQL Server Management Studio executes queries and it has some effect. Now you intend to limit the effect by using the Resource Governor. You must make sure that queries initiated through SQL Server Management Studio is less than 20 percent of CPU utilization, besides this, you must make sure that queries initiated by the mission-critical applications can consume 100 percent of CPU utilization when required. So what action should you perform to achieve this goal? （）A、You should alter the default resource pool and set the MAX_CPU_PERCENT option to 80. Then assign this resource pool to the workload group used by SQL Server Management Studio. B、First, you should create a new resource pool and set the MAX_CPU_PERCENT option to 20. Then assign this resource pool to the workload group used by SQL Server Management Studio. C、You should alter the default resource pool and set the MAX_CPU_PERCENT option to 20. Then assign this resource pool to the workload group used by the mission-critical applications. D、First, you should create a new resource pool and set the MAX_CPU_PERCENT option to 80. Then assign this resource pool to the workload group used by the mission-critical applications.
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 serverD、You should recapture the workload to a trace file by using SQL Profiler.
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 company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. The server hosts databases for several mission-critical applications. Microsoft SQL Server Management Studio executes queries and it has some effect. Now you intend to limit the effect by using the Resource Governor. You must make sure that queries initiated through SQL Server Management Studio is less than 20 percent of CPU utilization, besides this, you must make sure that queries initiated by the mission-critical applications can consume 100 percent of CPU utilization when required. So what action should you perform to achieve this goal? （）AYou should alter the default resource pool and set the MAX_CPU_PERCENT option to 80. Then assign this resource pool to the workload group used by SQL Server Management Studio. BFirst, you should create a new resource pool and set the MAX_CPU_PERCENT option to 20. Then assign this resource pool to the workload group used by SQL Server Management Studio. CYou should alter the default resource pool and set the MAX_CPU_PERCENT option to 20. Then assign this resource pool to the workload group used by the mission-critical applications. DFirst, you should create a new resource pool and set the MAX_CPU_PERCENT option to 80. Then assign this resource pool to the workload group used by the mission-critical applications.
单选题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 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？（）AYou should recapture the workload by using the data collector.BYou should enable the XP_MSVER stored procedure on the local server.CYou should enable the XP_MSVER stored procedure on the remote serverDYou should recapture the workload to a trace file by using SQL Profiler.
多选题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）
单选题You are creating an application using Visual Studio 2010. The application consumes a Windows Communication Foundation (WCF) service.You are adding a service reference to the WCF service. You need to ensure that the generated proxy does not block the calling thread when executing a service method. What should you do when adding the service reference? （）ASet the Collection type to ObservableCollection.BSelect the Reuse types in all referenced assemblies option.CSelect the Generate asynchronous operations option.DSelect the Always generate message contracts option.
多选题Which three statements about performance analysis by SQL Performance Analyzer are true? （）(Choose three.)AIt detects changes in SQL execution plans.BIt produces results that can be used to create the SQL plan baseline.CThe importance of SQL statements is based on the size of the objects accessed.DIt generates recommendations to run SQL Tuning Advisor to tune regressed SQLs.EIt shows only the overall impact on workload and not the net SQL impact on workload.
单选题You are maintaining the PROD database of NetFx Corporation. You set the value of the SQL_TRACE parameter to TRUE. What will be the impact of this setting？（）A The SQL trace facility will generate the performance statistics for all the SQL statements for an instance and write them in the USER_DUMP_DEST directory.B The SQL trace facility will generate the performance statistics for all the SQL statements for a session and write them in the USER_DUMP_DEST directory.C The SQL trace facility will generate the performance statistics for all the SQL statements for an instance and write them in the BACKGROUND_DUMP_DEST directory.D The SQL trace facility will generate the performance statistics for all the SQL statements for a session and write them in the BACKGROUND_DUMP_DEST directory.
单选题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