For Oracle 11g， Oracle strongly recommends that you configure your database to use which of the following memory-management features？（）  A、 Automatic PGA Memory ManagementB、 Automatic SGA Memory ManagementC、 Automatic Shared Memory ManagementD、 Automatic 

第1题：

You are upgrading to the Oracle 10g Database and will use the Automatic Shared Memory Management feature of the Oracle 10g Database. Which background process serves as the SGA memory broker that  coordinates the sizing of the memory components？（）  

• A、 MMAN
• B、 PMON
• C、 MMON
• D、 MMNL

第2题：

You specify a nonzero value for the MEMORY_TARGET initialization parameter，but do not set the PGA_AGGREGATE_TARGET or the SGA_TARGET parameters. You restart your database instance.  Which statement about the result is true？（）

• A、 The database instance starts，and Oracle sets the default value of SGA_TARGET to the same value as SGA_MAX_SIZE
• B、 The database instance starts，and Oracle automatically tunes memory and allocates 60 percent to the  SGA and 40 percent to the PGA
• C、 The database instance starts，but Automatic Memory Management is disabled
• D、 The database instance will not start because you did not specify the PGA_AGGREGATE_TARGET or SGA_TARGET parameter

第3题：

第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题：

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.

第6题：

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 must be enabled.
• D、 The automatic memory tuning must be disabled.

第7题：

You specify a nonzero value for the MEMORY_TARGET initialization parameter, but do not set thePGA_AGGREGATE_TARGET or the SGA_TARGET parameters. You restart your database instance.Which statement about the result is true?（）

• A、The database instance starts, and Oracle sets the default value of SGA_TARGET to the same value as SGA_MAX_SIZE
• B、The database instance starts, and Oracle automatically tunes memory and allocates 60 percent to the SGA and 40 percent to the PGA
• C、The database instance starts, but Automatic Memory Management is disabled
• D、The database instance will not start because you did not specify the PGA_AGGREGATE_TARGET or SGA_TARGET parameter

第8题：

第9题：

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

第10题：

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.