单选题If the sort heap threshold parameter SHEAPTHRES_SHR is set to a value of 0, what will happen?（）A All sorts will be done in a temporary table space.  B The shared sort memory allocation will be calculated by DB2C No shared memory is allocated for sortin

第1题：

If the sort heap threshold parameter SHEAPTHRES_SHR is set to a value of 0, what will happen?（）

• A、All sorts will be done in a temporary table space.  
• B、The shared sort memory allocation will be calculated by DB2
• C、No shared memory is allocated for sorting.  
• D、All sorts will be done in shared memory.

第2题：

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 parameter
• B、modify the PGA_AGGREGATE_TARGET initialization parameter
• C、modify the WORK_AREASIZE_POLICY initialization parameter
• D、increase the value of the SGA_TARGET initialization parameter
• E、increase the value of the SGA_MAX_SIZE initialization parameter
• F、increase the value of the SORT_AREA_SIZE initialization parameter

第3题：

第4题：

In your running instance， some of the initialization parameters are set as shown below： SGA_MAX_SIZE = 14GB  DB_CACHE_SIZE = 1GB  SHARED_POOL_SIZE = 3GB  STATISTICS_LEVEL = BASIC  PGA_AGGREGATE_TARGET = 0  You plan to enable Automatic Shared Memory Management but you are not able to set SGA_TARGET to a nonzero value. What could be the reason？（）

• A、The STATISTICS_LEVEL initialization parameter is set to BASIC
• B、The PGA_AGGREGATE_TARGET initialization parameter is set to zero.
• C、The SGA_MAX_SIZE initialization parameter is set to less than 20 GB
• D、The DB_CACHE_SIZE initialization parameter is set to less than 5 GB
• E、The SHARED_POOL_SIZE initialization parameter is set to a nonzero value.

第5题：

Your database is configured in shared server mode. However， your senior DBA asks you to modify the value ofthe 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

第6题：

Which two statements are true regarding the SGA_TARGET initialization parameter（）

• A、It can be increased up to the value of the SGA_MAX_SIZE parameter.
• B、Increasing the value of the SGA_TARGET parameter distributes the increased memory among all the Autotuned components.
• C、Reducing the value of the SGA_TARGET parameter deallocates memory from both autotuned and Manually sized components.
• D、Increasing the value of SGA_TARGET up to the value of SGA_MAX_SIZE disables the automatic shared Memory management feature.

第7题：

You enabled Automatic Shared Memory Management. The initialization parameters are set as shown below：  SGA_TARGET = 10GB SGA_MAX_SIZE = 14GB  STREAMS_POOL_SIZE = 1GB  SHARED_POOL_SIZE = 3GB  Which two statements are correct in this scenario？ （）

• A、 A total of 14 GB memory will be allocated to the automatically tuned memory components
• B、 Reducing the value for SGA_TARGET to 9 GB will automatically decrease the memory allocated to shared pool from 3 GB to 2 GB
• C、 The value for SGA_TARGET can be increased up to a maximum of 14 GB
• D、 A maximum of 3 GB can be allocated to shared pool
• E、 Increasing the value for SGA_TARGET to 12 GB will automatically increase the memory allocated to autotuned parameters
• F、 Increasing the value for SGA_TARGET will automatically increase the memory allocated for  STREAMS_POOL_SIZE

第8题：

Which statements about the MEMORY_TARGET initialization parameter are true？（） 

• A、 MEMORY_TARGET can be increased up to the value of MEMORY_MAX_TARGET， if  MEMORY_MAX_TARGET is set to a value greater than zero
• B、 MEMORY_MAX_TARGET defaults to a value of zero if MEMORY_TARGET is not set
• C、 MEMORY_TARGET represents the total amount of memory that can be allocated to SGA and PGA memory structures.
• D、 MEMORY_TARGET is static and cannot be modified without shutting down the instance

第9题：

Examine the following parameters for a database instance: MEMORY_MAX_TARGET=0 MEMORY_TARGET=0 SGA_TARGET=0 PGA_AGGREGATE_TARGET=500m Which three initialization parameters are not controlled by Automatic Shared Memory Management (ASMM)?（）

• A、LOG_BUFFER
• B、SORT_AREA_SIZE
• C、JAVA_POOL_SIZE
• D、STREAMS_POOL_SIZE
• E、DB_16K_CACHE_SZIE
• F、DB_KEEP_CACHE_SIZE

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