单选题If the sort heap threshold parameter SHEAPTHRES_SHR is set to a value of 0, what will happen?（）AAll sorts will be done in a temporary table space. BThe shared sort memory allocation will be calculated by DB2CNo shared memory is allocated for sorting. DAll sorts will be done in shared memory.
单选题
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.
参考解析
解析：
暂无解析
相关考题：
Which statements about the MEMORY_TARGET initialization parameter are true?() (Choose all that apply.) 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 zeroB. MEMORY_MAX_TARGET defaults to a value of zero if MEMORY_TARGET is not setC. 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
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 zeroB、 MEMORY_MAX_TARGET defaults to a value of zero if MEMORY_TARGET is not setC、 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
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 sorting. D、All sorts will be done in shared memory.
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.
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 parameterB、modify the PGA_AGGREGATE_TARGET initialization parameterC、modify the WORK_AREASIZE_POLICY initialization parameterD、increase the value of the SGA_TARGET initialization parameterE、increase the value of the SGA_MAX_SIZE initialization parameterF、increase the value of the SORT_AREA_SIZE initialization parameter
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 componentsB、 Reducing the value for SGA_TARGET to 9 GB will automatically decrease the memory allocated to shared pool from 3 GB to 2 GBC、 The value for SGA_TARGET can be increased up to a maximum of 14 GBD、 A maximum of 3 GB can be allocated to shared poolE、 Increasing the value for SGA_TARGET to 12 GB will automatically increase the memory allocated to autotuned parametersF、 Increasing the value for SGA_TARGET will automatically increase the memory allocated for STREAMS_POOL_SIZE
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 SGAB、To limit the amount of memory to be used for the dispatcher queue of a session in SGAC、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
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_BUFFERB、SORT_AREA_SIZEC、JAVA_POOL_SIZED、STREAMS_POOL_SIZEE、DB_16K_CACHE_SZIEF、DB_KEEP_CACHE_SIZE
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 BASICB、The PGA_AGGREGATE_TARGET initialization parameter is set to zero.C、The SGA_MAX_SIZE initialization parameter is set to less than 20 GBD、The DB_CACHE_SIZE initialization parameter is set to less than 5 GBE、The SHARED_POOL_SIZE initialization parameter is set to a nonzero value.
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.
Which of the following Oracle features is enabled by setting a nonzero value for the MEMORY_TARGET initialization parameter？（） A、 Automatic PGA Memory ManagementB、 Automatic SGA Memory ManagementC、 Automatic Shared Memory ManagementD、 Automatic Memory ManagementE、 Manual SGA Memory ManagementF、 None of the above
Oracle9i offers the ability to monitor the dynamic use of the SGA through the DB_CACHE_ADVICE parameter. When this parameter is set to READY， what is its effect？ （）A、The Advisory is on and will capture both CPU and memory overhead.B、The Advisory is on but the memory for the Advisory is not allocated.C、The Advisory is off and the memory for the Advisory is not allocated.D、The Advisory is off but the memory for the Advisory remains allocated.
You are configuring the PROD database to use an internal tuning algorithm to monitor the performance of the workload. To achieve this configuration， you specify the following parameter settings in the SPFILE:// SGA_TARGET = 512M SHARED_POOL_SIZE = 256M Which two statements are true when modifying the SHARED_POOL_SIZE initialization parameter in the SPFILE？ （）A、 Modifying the SHARED_POOL_SIZE initialization parameter cannot be accomplished if the SGA_TARGET initialization parameter is set to a non-zero value.B、 Modifying the value of the SHARED_POOL_SIZE initialization parameter to zero is not allowed if the SGA_TARGET initialization parameter is set to a nonzero value.C、 Increasing the value of the SHARED_POOL_SIZE initialization parameter does not increase the shared pool component size. It sets the lower limit for the size of this component.D、 Decreasing the value of the SHARED_POOL_SIZE initialization parameter does not reduce the size of the shared pool component immediately. It sets the lower limit for the size of this component.E、 Increasing the value of the SHARED_POOL_SIZE initialization parameter immediately increases the shared pool component to the desired size by reallocating the additional memory from the auto-tuned memory components.F、 Decreasing the value of the SHARED_POOL_SIZE initialization parameter immediately shrinks the shared pool component to the desired size while reallocating the released memory to the memory components that are not auto-tuned.
单选题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（）Ato limit the User Global Area （UGA） memory allocated to a session from the SGABto limit the amount of memory to be used for the dispatcher queue of a session in SGACto limit the amount of memory to be used for the request pool in System Global Area （SGA）Dto control the amount of memory allocated in SGA for the local variables for each shared server process
多选题You set the value of the SGA_TARGET initialization parameter to 1G to enable Oracle to automatically resize most of the memory components according to the current workload in the database. You issue the following statement： SQL SELECT name， value， isdefault 2 FROM v$parameter 3 WHERE name LIKE ’%size%’； The output of this statement displays that the DB_CACHE_SIZE， SHARED_POOL_SIZE， LARGE_POOL_SIZE， and JAVA_POOL_SIZE initialization parameters contain a zero value. What does this imply？（）AThe SGA_TARGET initialization parameter cannot be set to a value less than 1GBThe SGA_TARGET initialization parameter cannot be set to a value greater than 1GCThe Memory Advisor of the Oracle Enterprise Manager 10g cannot be used to obtain advice on the important memory components of the SGADThe values of the DB_CACHE_SIZE， SHARED_POOL_SIZE， LARGE_POOL_SIZE， and JAVA_POOL_SIZE initialization parameters cannot be set manually.ENo minimum limits are imposed on the DB_CACHE_SIZE， SHARED_POOL_SIZE， LARGE_POOL_SIZE， and JAVA_POOL_SIZE initialization parameters.FThe Automatic Shared Memory Management feature cannot be disabled unless you specify values for the DB_CACHE_SIZE， SHARED_POOL_SIZE， LARGE_POOL_SIZE， and JAVA_POOL_SIZE initialization parameters in the initialization parameter file.
单选题Oracle9i offers the ability to monitor the dynamic use of the SGA through the DB_CACHE_ADVICE parameter. When this parameter is set to READY， what is its effect？ （）AThe Advisory is on and will capture both CPU and memory overhead.BThe Advisory is on but the memory for the Advisory is not allocated.CThe Advisory is off and the memory for the Advisory is not allocated.DThe Advisory is off but the memory for the Advisory remains allocated.
单选题Which statements about the MEMORY_TARGET initialization parameter are true?（） (Choose all that apply.)AMEMORY_TARGET can be increased up to the value of MEMORY_MAX_TARGET, if MEMORY_MAX_TARGET is set to a value greater than zeroBMEMORY_MAX_TARGET defaults to a value of zero if MEMORY_TARGET is not setCMEMORY_TARGET represents the total amount of memory that can be allocated to SGA and PGA memory structures.DMEMORY_TARGET is static and cannot be modified without shutting down the instance
多选题Which statements about the MEMORY_TARGET initialization parameter are true？（）AMEMORY_TARGET can be increased up to the value of MEMORY_MAX_TARGET， if MEMORY_MAX_TARGET is set to a value greater than zeroBMEMORY_MAX_TARGET defaults to a value of zero if MEMORY_TARGET is not setCMEMORY_TARGET represents the total amount of memory that can be allocated to SGA and PGA memory structures.DMEMORY_TARGET is static and cannot be modified without shutting down the instance
多选题Which two statements are true regarding the SGA_TARGET initialization parameter（）AIt can be increased up to the value of the SGA_MAX_SIZE parameter.BIncreasing the value of the SGA_TARGET parameter distributes the increased memory among all the Autotuned components.CReducing the value of the SGA_TARGET parameter deallocates memory from both autotuned and Manually sized components.DIncreasing the value of SGA_TARGET up to the value of SGA_MAX_SIZE disables the automatic shared Memory management feature.
单选题If the sort heap threshold parameter SHEAPTHRES_SHR is set to a value of 0, what will happen?（）AAll sorts will be done in a temporary table space. BThe shared sort memory allocation will be calculated by DB2CNo shared memory is allocated for sorting. DAll sorts will be done in shared memory.
多选题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？ （）AThe WORK_AREASIZE_POLICY initialization parameter cannot be set to AUTO.BThe Oracle database automatically controls the amount of PGA memory allotted to SQL work areas.CSetting the value of the SGA_TARGET initialization parameter to 0 will disable the automatic PGA memory management.DThe SORT_AREA_SIZE parameter is ignored by all the sessions running in the automatic PGA memory management mode.
多选题You are configuring the PROD database to use an internal tuning algorithm to monitor the performance of the workload. To achieve this configuration， you specify the following parameter settings in the SPFILE:// SGA_TARGET = 512M SHARED_POOL_SIZE = 256M Which two statements are true when modifying the SHARED_POOL_SIZE initialization parameter in the SPFILE？ （）AModifying the SHARED_POOL_SIZE initialization parameter cannot be accomplished if the SGA_TARGET initialization parameter is set to a non-zero value.BModifying the value of the SHARED_POOL_SIZE initialization parameter to zero is not allowed if the SGA_TARGET initialization parameter is set to a nonzero value.CIncreasing the value of the SHARED_POOL_SIZE initialization parameter does not increase the shared pool component size. It sets the lower limit for the size of this component.DDecreasing the value of the SHARED_POOL_SIZE initialization parameter does not reduce the size of the shared pool component immediately. It sets the lower limit for the size of this component.EIncreasing the value of the SHARED_POOL_SIZE initialization parameter immediately increases the shared pool component to the desired size by reallocating the additional memory from the auto-tuned memory components.FDecreasing the value of the SHARED_POOL_SIZE initialization parameter immediately shrinks the shared pool component to the desired size while reallocating the released memory to the memory components that are not auto-tuned.
单选题You are specifying French case-insensitive sorts by using the NSL_SORT parameter for the user session of the user， Scott. Which value will you set for the NLS_SORT parameter？（）A FRENCH_AIB FRENCH_CIC AI_FRENCHD CI_FRENCH
单选题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？（）Amodify the HASH_AREA_SIZE initialization parameterBmodify the PGA_AGGREGATE_TARGET initialization parameterCmodify the WORK_AREASIZE_POLICY initialization parameterDincrease the value of the SGA_TARGET initialization parameterEincrease the value of the SGA_MAX_SIZE initialization parameterFincrease the value of the SORT_AREA_SIZE initialization parameter
单选题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 ManagementB Automatic SGA Memory ManagementC Automatic Shared Memory ManagementD Automatic Memory ManagementE Manual SGA Memory ManagementF None of the above
单选题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？（）AThe STATISTICS_LEVEL initialization parameter is set to BASICBThe PGA_AGGREGATE_TARGET initialization parameter is set to zero.CThe SGA_MAX_SIZE initialization parameter is set to less than 20 GBDThe DB_CACHE_SIZE initialization parameter is set to less than 5 GBEThe SHARED_POOL_SIZE initialization parameter is set to a nonzero value.
单选题Which of the following Oracle features is enabled by setting a nonzero value for the MEMORY_TARGET initialization parameter？（）A Automatic PGA Memory ManagementB Automatic SGA Memory ManagementC Automatic Shared Memory ManagementD Automatic Memory ManagementE Manual SGA Memory ManagementF None of the above
单选题Your database is running on 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 parameterB modify the PGA_AGGREGATE_TARGET initialization parameterC modify the WORK_AREASIZE_POLICY initialization parameterD increase the value of the SGA_TARGET initialization parameterE increase the value of the SGA_MAX_SIZE initialization parameterF increase the value of the SORT_AREA_SIZE initialization parameter