单选题You want to enable automatic PGA memory management in your database. Which setting is required to achieve this?（）A Set MEMORY_TARGET to zeroB Set the STATISTICS_LEVEL parameter to BASICC Set the WORKAREA_SIZE_POLICY parameter to MANUALD Set the PGA_AGG

题目内容(请给出正确答案)

单选题

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

Set MEMORY_TARGET to zero

Set the STATISTICS_LEVEL parameter to BASIC

Set the WORKAREA_SIZE_POLICY parameter to MANUAL

Set the PGA_AGGREGATE_TARGET parameter to nonzero value

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

更多相关问题

第1题

单选题Which statement about Automatic Memory Management with Oracle 11g is true？（）AYou cannot specify MEMORY_TARGET if you explicitly specify SGA_TARGET or PGA_AGGREGATE_ TARGET values that are greater than zero in your parameter file.BOracle can reallocate memory between the SGA and PGA automatically as needed.CTo use Automatic Memory Management， you must explicitly set both the MEMORY_TARGET and MEMORY_MAX_TARGET parameters in your parameter file.DYou can set the MEMORY_TARGET parameter to a maximum value of the current SGA size plus the current PGA size.

点击查看答案
第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_SIZEB The database instance starts, and Oracle automatically tunes memory and allocates 60 percent to the SGA and 40 percent to the PGAC The database instance starts, but Automatic Memory Management is disabledD The database instance will not start because you did not specify the PGA_AGGREGATE_TARGET or SGA_TARGET parameter

点击查看答案
第3题

单选题To implement Automatic Management (AMM), you set the following parameters: When you try to start the database instance with these parameter settings, you receive the following error message: SQL > startup ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings, see alert log for more information. Identify the reason the instance failed to start.（）A The PGA_AGGREGATE_TARGET parameter is set to zero.B The STATISTICS_LEVEL parameter is setto basic.C Both the SGA_TARGETandMEMORY_TARGET paramete rsareset.D The SGA_MAX_SIZEandSGA_TARGET parameter value sare note qual.

点击查看答案
第4题

单选题You want to enable automatic PGA memory management in your database. Which setting is required to achieve this？（）ASet MEMORY_TARGET to zeroBSet the STATISTICS_LEVEL parameter to BASICCSet the WORKAREA_SIZE_POLICY parameter to MANUALDSet the PGA_AGGREGATE_TARGET parameter to nonzero value

点击查看答案
第5题

单选题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.

点击查看答案
第6题

单选题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

点击查看答案
第7题

单选题You want to enable automatic PGA memory management in your database. Which setting is required to achieve this?（）A Set MEMORY_TARGET to zeroB Set the STATISTICS_LEVEL parameter to BASICC Set the WORKAREA_SIZE_POLICY parameter to MANUALD Set the PGA_AGGREGATE_TARGET parameter to nonzero value

点击查看答案

单选题You want to enable automatic PGA memory management in your database. Which setting is required to achieve this?（）A Set MEMORY_TARGET to zeroB Set the STATISTICS_LEVEL parameter to BASICC Set the WORKAREA_SIZE_POLICY parameter to MANUALD Set the PGA_AGG

题目内容(请给出正确答案)

更多相关问题

第1题

第2题

第3题

第4题

第5题

第6题

第7题

相关内容