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

题目

单选题

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

You set the following parameters in the parameter file and restarted the database:Which two statements are true regarding these parameters after the database instance is restarted?()

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

参考答案：A, D

第2题：

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

参考答案：A

第3题：

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

A. Set MEMORY_TARGET to zero

B. Set the STATISTICS_LEVEL parameter to BASIC

C. Set the WORKAREA_SIZE_POLICY parameter to MANUAL

D. Set the PGA_AGGREGATE_TARGET parameter to nonzero value

参考答案：D

第4题：

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

第5题：

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

正确答案:A,B,C

第6题：

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

第7题：

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.

参考答案：B

第8题：

Which two initialization parameters would you set to enable Automatic Shared Memory Management?()

A. set SHARED_POOL_SIZE to zero

B. set STATISTICS_LEVEL to BASIC

C. set SGA_TARGET to a non-zero value

D. set DB_CACHE_SIZE to a non-zero value

E. set STATISTICS_LEVEL to TYPICAL or ALL

参考答案：A, C

第9题：

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

第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

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

题目

相似问题和答案

更多相关问题

相关内容