单选题Which of the following identifies and creates an index to minimize the DB time for a particular SQL statement?（）A The SGA Tuning AdvisorB The SQL Access AdvisorC The SQL Tuning AdvisorD The Memory Advisor

第1题：

You have a very large table that your users access frequently. Which of the following advisors will recommend any indexes to improve the performance of queries against this table?（）

• A、The Automatic Memory Manager (AMM)
• B、The SQL Tuning Advisor
• C、The Segment Advisor
• D、The SQL Access Advisor SQL

第2题：

You observe that database performance has degraded over a period of time. While investigating the reason， you find that the size of the database buffer cache is not large enough to cache all the needed data blocks.  Which advisory component would you refer to， in order to determine the required size of the database buffer cache？（） 

• A、Memory Advisor
• B、Segment Advisor
• C、SQL Tuning Advisor
• D、SQL Access Advisor
• E、Automatic Database Diagnostic Monitor （ADDM）

第3题：

第4题：

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 Advisor
• B、SQL Optimizer
• C、SQL Access Advisor
• D、SQL Tuning Advisor

第5题：

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

第6题：

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 Advisor
• B、 Undo Advisor
• C、 Segment Advisor
• D、 SQL Tuning Advisor

第7题：

Which of the following identifies and creates an index to minimize the DB time for a particular SQL statement？（）  

• A、 The SGA Tuning Advisor
• B、 The SQL Access Advisor
• C、 The SQL Tuning Advisor
• D、 The Memory Advisor

第8题：

第9题：

While running long running queries， you receive the Snapshot too old error. Which advisor can help you to avoid the Snapshot too old error？（）

• A、 Memory Advisor
• B、 Segment Advisor
• C、 Undo Advisor
• D、 SQL Tuning Advisor

第10题：

Which tuning tool recommends how to optimize materialized views so that these views can take advantage of the general query rewrite feature？（）  

• A、 Segment Advisor
• B、 SQL Access Advisor
• C、 Undo Advisor
• D、 SQL Tuning Advisor