违法和不良信息举报 联系客服
免费注册 登录

Automatic PGA Memory Management eliminates the need to manua

题目
多选题
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

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

第1题：

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.

正确答案:B,D

第2题：

SORT_AREA SIZE and HASH_AREA_SIZE parameters are ignored in some of the user sessions. What could be the reason？（）

  • A、The User Global Area （UGA） is not configured.
  • B、The sessions were started using the login name SYS.
  • C、The sessions are running in the Automatic Shared Memory Management mode.
  • D、The sessions are running in the automatic Program Global Area （PGA） memory management mode.

正确答案:D

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

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 Management
  • B、 Automatic SGA Memory Management
  • C、 Automatic Shared Memory Management
  • D、 Automatic Memory Management
  • E、 Manual SGA Memory Management
  • F、 None of the above

正确答案:C

第5题：

Which of the following Oracle features is enabled by setting a nonzero value for the MEMORY_TARGET initialization parameter？（）  

  • A、 Automatic PGA Memory Management
  • B、 Automatic SGA Memory Management
  • C、 Automatic Shared Memory Management
  • D、 Automatic Memory Management
  • E、 Manual SGA Memory Management
  • F、 None of the above

正确答案:D

第6题：

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

第7题：

For Oracle 11g， Oracle strongly recommends that you configure your database to use which of the following memory-management features？（）  

  • A、 Automatic PGA Memory Management
  • B、 Automatic SGA Memory Management
  • C、 Automatic Shared Memory Management
  • D、 Automatic Memory Management
  • E、 Manual SGA Memory Management
  • F、 None of the above

正确答案:D

第8题：

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

第9题：

In Oracle 11g，by default which one of the following conditions implicitly enables Automatic PGA Memory Management？（）  

  • A、 Setting a nonzero value for SGA_TARGET
  • B、 Configuring Automatic Shared Memory Management
  • C、 Configuring Automatic Memory Management
  • D、 Setting a nonzero value for SGA_MAX_SIZE and PGA_AGGREGATE_TARGET
  • E、 None of the above

正确答案:B

第10题：

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


正确答案： D,C
解析： 暂无解析

更多相关问题
相关内容