1Z0-060
多选题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)?（）ALOG_BUFFERBSOR
题目
LOG_BUFFER
SORT_AREA_SIZE
JAVA_POOL_SIZE
STREAMS_POOL_SIZE
DB_16K_CACHE_SZIE
DB_KEEP_CACHE_SIZE
参考答案和解析
相似问题和答案
第1题：
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
第2题：
Automatic PGA Memory Management eliminates the need to manually configure which of the following initialization parameters？（）
- A、 SORT_AREA_SIZE
- B、 HASH_AREA_SIZE
- C、 BITMAP_MERGE_AREA_SIZE
- D、 CREATE_BITMAP_AREA_SIZE
- E、 PGA_AGGREGATE_TARGET
正确答案:A,B,C,D
第3题：
A. Automatic memory management is disabled because PGA_AGGREGATE_TARGET and SGA_TARGET are not set
B. The instance is started but the database will not be opened until PGA_AGGREGATE_TARGET and SGA_TARGET are set
C. The database is opened but users cannot perform transactions until PGA_AGGREGATE_TARGET and SGA_TARGET are set
D. Automatic memory management is enabled and, as per policy, 60% of the memory for System Global Area (SGA) and 40% of the memory for Program Global Area (PGA) will be distributed at startup
第4题：
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
正确答案:A,E,F
第5题：
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
正确答案:B
第6题：
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 > startupORA-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.
第7题：
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
正确答案:B
第8题：
A. The MEMORY_MAX_TARGET parameter is automatically set to 500 MB
B. The value of the MEMORY_MAX_TARGET parameter remains zero till it is changed manually
C. The PGA_AGGREGATE_TARGET and SGA_TARGET parameters are automatically set to zero
D. The lower bounds of PGA_AGGREGATE_TARGET and SGA_TARGET parameters are set to 90 MB and 270 MB, respectively
第9题：
Automatic Shared Memory Management （ASMM） has been enabled for your database instance. Theinitialization parameters for the components that are managed by ASMM are not set. After observing theeffects of ASSM， you executed the following command： SQL> ALTER SYSTEM SET DB_CACHE_SIZE = 100M； Which statement is true in this scenario（）
- A、The minimum memory size for the database buffer cache is set to 100 mb.
- B、The maximum memory size that can be obtained by the database buffer cache during ASMM is set to100 mb
- C、The minimum memory size allocated for a server process in the database buffer cache in dedicatedmode is set to 100 mb.
- D、The maximum memory size from the database buffer cache that can be released for dynamicdistribution during ASMM is set to 100 mb
正确答案:A
第10题：
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.
正确答案:B