多选题Identify three scenarios in which you would recommend the use of SQL Performance Analyzer to analyzeimpact on the performance of SQL statements.（）AChange in the Oracle Database versionBChange in your network infrastructureCChange in the hardware config

第1题：

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.

第2题：

You are using flat files as the data source for one of your data warehousing applications. To optimize the application performance， you plan to move the data from the flat files to clustered tables in an Oracle database.While migrating the data， you want to have minimal impact on the database performance and optimize the dataload operation.  Which method would you use to load data into the Oracle database（）

• A、Use the external table population.
• B、Use the Oracle Data Pump export and import utility.
• C、Use the conventional path data load of the SQL*Loader utility.
• D、Use the INSERT INTO...SELECT command to load the data

第3题：

第4题：

You are using flat files as the data source for one of your data warehousing applications. To optimizethe application performance， you plan to move the data from the flat files toclustered tablesin an Oracle database.  While migrating the data， you want to have minimal impact on the database performance and optimize thedata load operation. Which method would you use to load data into the Oracle database（）

• A、Use the external table population.
• B、Use the Oracle Data Pump export and import utility.
• C、Use the conventional path data load of the SQL*Loader utility.
• D、Use the INSERT INTO...SELECT command to load the data.

第5题：

Your system has been upgraded from Oracle Database 10g to Oracle Database 11g. You imported SQL Tuning Sets （STS） from the previous version. After changing the  OPTIMIZER_FEATURE_ENABLE parameter to 10.2.0.4 and running the SQL Performance Analyzer， you observed performance regression for a few SQL statements.  What would you do with these SQL statements？（）

• A、 Set OPTIMIZER_USE_PLAN_BASELINES to FALSE to prevent the use of regressed plans.
• B、 Capture the plans from the previous version using STS and then load them into the stored outline.
• C、 Capture the plans from the previous version using STS and then load them into SQL Management Base （SMB）
• D、 Set OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES to FALSE to prevent the plans from being loaded to the SQL plan baseline.

第6题：

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.

第7题：

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 Advisor
• B、 Undo Advisor
• C、 ADDM
• D、 Memory Advisor

第8题：

第9题：

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

第10题：

You are using flat files as the data source for one of your data warehousing applications. You plan to move the data from the flat file structures to an Oracle database to optimize the application performance. In your database you have clustered tables. While migrating the data， you want to have minimal impact on the database performance and optimize the data load operation. Which method would you use to load data into Oracle database？（）

• A、use the external table population
• B、use the Oracle Data Pump export and import utility
• C、use the conventional path data load of SQL*Loader utility
• D、use the direct path data load of Oracle export and import utility