Your database is running in the automatic Program Global Area （PGA） memory management and Shared Memory Management mode. You want to increase the memory available for the SQL work areas. What would you do？（）A、modify the HASH_AREA_SIZE initialization param

第1题：

Your database is configured in shared server mode. However， your senior DBA asks you to modifythe value of the PRIVATE_SGA limit in the profile of the users.  What could be the reason for this（）

• A、to limit the User Global Area （UGA） memory allocated to a session from the SGA
• B、to limit the amount of memory to be used for the dispatcher queue of a session in SGA
• C、to limit the amount of memory to be used for the request pool in System Global Area （SGA）
• D、to control the amount of memory allocated in SGA for the local variables for each shared server process

第2题：

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

第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 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.

第5题：

You have included the following parameter setting in your server parameter file：       PGA_AGGREGATE_TARGET = 800M        SORT_AREA_SIZE = 100M        HASH_AREA_SIZE = 100M        BITMAP_MERGE_AREA_SIZE = 100M        CREATE_BITMAP_AREA_SIZE = 100M   Which statement is true？（）  

• A、 All the *_AREA_SIZE parameters are ignored.
• B、 The Automatic PGA Memory Management feature cannot be disabled.
• C、 The total Program Global Area （PGA） memory cannot be manually increased above 800M.
• D、 The total memory for the PGA can automatically exceed 800M using the Automatic PGA Memory Management feature.

第6题：

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

第7题：

By setting the value of MEMORY_TARGET to zero and setting the value of SGA_TARGET to a nonzero value， you will enable which of the following memory-management options？（）  

• 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

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

SORT_AREA SIZE and HASH_AREA_SIZE parameters are ignored in some of the user sessions. What could be the reason？（）

• A、The User Global Area （UGA） is not configured.
• B、The sessions were started using the login name SYS.
• C、The sessions are running in the Automatic Shared Memory Management mode.
• D、The sessions are running in the automatic Program Global Area （PGA） memory management mode.

第14题：

You recently created a database and configured the SPFILE with the following parameter settings to ensure that Oracle automatically adjusts the memory for the Program Global Area （PGA）：   SORT_AREA_SIZE = 150M   HASH_AREA_SIZE = 150M   BITMAP_MERGE_AREA_SIZE = 150M   CREATE_BITMAP_AREA_SIZE = 150M   WORKAREA_SIZE_POLICY = AUTO   You have not included the PGA_AGGREGATE_TARGET initialization parameter in the SPFILE and the System Global Area （SGA） is currently sized at 4G.   What is the total PGA memory allocated across all database server processes？（）  

• A、 10M
• B、 400M
• C、 600M
• D、 800M

第15题：

You want to enable automatic PGA memory management in your database. Which setting is required to achieve this?（）

• A、Set MEMORY_TARGET to zero
• B、Set the STATISTICS_LEVEL parameter to BASIC
• C、Set the WORKAREA_SIZE_POLICY parameter to MANUAL
• D、Set the PGA_AGGREGATE_TARGET parameter to nonzero value

第16题：

You are working in a dedicated server environment. Your database is running in the automatic Program Global Area （PGA） memory management mode.   Which two statements are correct in this scenario？（）

• A、The WORK_AREASIZE_POLICY initialization parameter cannot be set to AUTO.
• B、The Oracle database automatically controls the amount of PGA memory allotted to SQL work areas.
• C、Setting the value of the SGA_TARGET initialization parameter to 0 will disable the automatic PGA  memory management.
• D、The SORT_AREA_SIZE parameter is ignored by all the sessions running in the automatic PGA  memory management mode.

第17题：

When tuning Automatic PGA Memory Management， which of the following views will provide the information specified？（）  

• A、 The V$PGA_TARGET_ADVICE view shows the predicted cache hit-ratio improvement if you increase PGA_AGGREGATE_TARGET
• B、 The V$PGA_TARGET_ADVICE view shows how the V$SQL_WORKAREA histogram will change if you change the value of PGA_AGGREGATE_TARGET
• C、 The V$PGA_TARGET_ADVICE_HISTOGRAM view shows how the V$SQL_WORKAREA_HISTOGRAM will change if you switch between Manual and Automatic PGA Memory Management
• D、 The V$PGA_TARGET_ADVICE view shows how performance will improve for the different work areas if you switch from Manual to Automatic PGA Memory Management

第18题：

You find that the database performance degrades while you backup the PROD database using Recovery Manager （RMAN）. The PROD database is running in shared server mode. The database instance is currently using 60% of total operating system memory. You suspect the shared pool fragmentation to be the reason. Which action would you consider to overcome the performance degradation？（）

• A、Configure Java Pool to cache the java objects.
• B、Configure Streams Pool to enable parallel processing.
• C、Increase Shared Pool size to cache more PL/SQL objects.
• D、Increase Database Buffer Cache size to increase cache hits.
• E、Configure Large Pool to be used by RMAN and shared server.
• F、Increase the total System Global Area （SGA） size to increase memory hits.

第19题：

You work as a database administrator for Certkiller .com. You find that the database performance degrades while you backup the Certkiller database using Recovery Manager （RMAN）. The Certkiller database is running in shared server mode. The database instance is currently using 60% of total operating system memory. You suspect the shared pool fragmentation to be the reason.  Which action would you consider to overcome the performance degradation？（）

• A、Configure Java Pool to cache the java objects.
• B、Configure Streams Pool to enable parallel processing.
• C、Increase Shared Pool size to cache more PL/SQL objects.
• D、Increase Database Buffer Cache size to increase cache hits.
• E、Configure Large Pool to be used by RMAN and shared server.
• F、Increase the total System Global Area （SGA） size to increase memory hits.

第20题：

第21题：

第22题：

第23题：