You use the Memory Advisor to tune the memory structures of your database. What is the prerequisite to use the Memory Advisor？（）A、 The database must be in the ARCHIVELOG mode.B、 The automatic memory tuning must be enabled.C、 The change tracking feature mu

第1题：

You are shrinking the SCOTT.EMP table by executing the ALTER TABLE SCOTT.EMP SHRINK SPACE CASCADE statement. What is a prerequisite for shrinking the SCOTT.EMP table？（）

• A、 You must enable the block change tracking feature.
• B、 You must have enable the flashback feature.
• C、 You must use the OMF in your database.
• D、 You must define the tablespace of the SCOTT.EMP table for automatic segment space management.

第2题：

Which statement about Automatic Memory Management with Oracle 11g is true？（）  

• A、 You cannot specify MEMORY_TARGET if you explicitly specify SGA_TARGET or  PGA_AGGREGATE_ TARGET values that are greater than zero in your parameter file.
• B、 Oracle can reallocate memory between the SGA and PGA automatically as needed.
• C、 To use Automatic Memory Management， you must explicitly set both the MEMORY_TARGET and MEMORY_MAX_TARGET parameters in your parameter file.
• D、 You can set the MEMORY_TARGET parameter to a maximum value of the current SGA size plus the current PGA size.

第3题：

Automatic Shared Memory Management is disabled for your database instance. You realize that there arecases of SQL statements performing poorly because of repeated parsing activity， resulting in degradation ofperformance.  What would be your next step to improve performance（）

• A、Run the SQL Access Advisor.
• B、Run the Memory Advisor for the sga
• C、Run the Memory Advisor for the pga.
• D、Run the Memory Advisor for the shared pool.
• E、Run the Memory Advisor for the buffer cache

第4题：

Automatic Shared Memory Management is disabled for your database instance. You realize that there arecases of SQL statements performing poorly because of repeated parsing activity， resulting in degradation ofperformance.  What would be your next step to improve performance（）

• A、Run the SQL Access Advisor
• B、Run the Memory Advisor for the sga.
• C、Run the Memory Advisor for the pga.
• D、Run the Memory Advisor for the shared pool.
• E、Run the Memory Advisor for the buffer cache

第5题：

You create a table in your database that contains 50，000 rows approximately. The queries performed on the table are complex and performed on the table frequently. Which advisor helps you achieve the best performance of database for queries by recommending the appropriate indexes？（）  

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

第6题：

You are performing flashback of the ORDERS table in the Scott’s schema because some important data is deleted in the table by mistake. The SCN number was 771513 at the time of deletion. You issued the following statement to perform Flashback Table：  SQL> FLASHBACK TABLE ORDERS TO SCN 771513；   What is the prerequisite to perform Flashback Table？（）

• A、 You must configure OMF in your database.
• B、 You must enable block change tracking feature in your database.
• C、 You must enable ROW MOVEMENT feature on the ORDERS table.
• D、 You must use the Flashback Version Query before using the Flashback Table feature.

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

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

第14题：

You are enabling the Automatic Shared Memory Management feature in the Oracle Database 10g to ensure that the important memory structures of the System Global Area （SGA） are automatically adjusted depending on the database workload. You are using Enterprise Manager 10g to enable this feature. You are currently on the Administration tab page.  Which two links should you click to go to the Memory Advisor page？（）

• A、 Advisor Central
• B、 Global Attributes
• C、 Resource Monitors
• D、 Memory Parameters
• E、 Database Usage Statistics
• F、 All Initialization Parameters
• G、 Automatic Workload Repository

第15题：

Automatic Shared Memory Management is disabled for your database instance. You realize that thereare cases of SQL statements performing poorly because of repeated parsing activity， resulting indegradation of performance.  What would be your next step to improve performance？ （）

• A、Run the SQL Access Advisor.
• B、Run the Memory Advisor for the sga.
• C、Run the Memory Advisor for the pga.
• D、Run the Memory Advisor for the shared pool.
• E、Run the Memory Advisor for the buffer cache.

第16题：

For Oracle 11g， Oracle strongly recommends that you configure your database to use which of the following memory-management features？（）  

• A、 Automatic PGA Memory Management
• B、 Automatic SGA Memory Management
• C、 Automatic Shared Memory Management
• D、 Automatic Memory Management
• E、 Manual SGA Memory Management
• F、 None of the above

第17题：

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

第18题：

第19题：

第20题：

第21题：

第22题：

第23题：