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

多选题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？ （）AA maximu

题目
多选题
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 maximum of 3 GB can be allocated to shared pool

B

The value for SGA_TARGET can be increased up to a maximum of 15 GB

C

A total of 14 GB memory will be allocated to the automatically tuned memory components.

D

Increasing the value for SGA_TARGET will automatically increase the memory allocated for STREAMS_POOL_SIZE

E

Increasing the value for SGA_TARGET to 12 GB will automatically increase the memory allocated to autotuned parameters

F

Reducing the value for SGA_TARGET to 9 GB will automatically decrease the memory allocated to shared pool from 3 GB to 2 GB

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

第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


参考答案：B

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

第3题：

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

第4题：

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

第5题：

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 components
  • B、 Reducing the value for SGA_TARGET to 9 GB will automatically decrease the memory allocated to shared pool from 3 GB to 2 GB
  • C、 The value for SGA_TARGET can be increased up to a maximum of 14 GB
  • D、 A maximum of 3 GB can be allocated to shared pool
  • E、 Increasing the value for SGA_TARGET to 12 GB will automatically increase the memory allocated to autotuned parameters
  • F、 Increasing the value for SGA_TARGET will automatically increase the memory allocated for  STREAMS_POOL_SIZE

正确答案:C,E

第6题：

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.

正确答案:A,B

第7题：

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 parameter
  • B、modify the PGA_AGGREGATE_TARGET initialization parameter
  • C、modify the WORK_AREASIZE_POLICY initialization parameter
  • D、increase the value of the SGA_TARGET initialization parameter
  • E、increase the value of the SGA_MAX_SIZE initialization parameter
  • F、increase the value of the SORT_AREA_SIZE initialization parameter

正确答案:B

第8题：

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

第9题：

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 maximum of 3 GB can be allocated to shared pool
  • B、 The value for SGA_TARGET can be increased up to a maximum of 15 GB
  • C、 A total of 14 GB memory will be allocated to the automatically tuned memory components.
  • D、 Increasing the value for SGA_TARGET will automatically increase the memory allocated for STREAMS_POOL_SIZE
  • E、 Increasing the value for SGA_TARGET to 12 GB will automatically increase the memory allocated to autotuned parameters
  • F、 Reducing the value for SGA_TARGET to 9 GB will automatically decrease the memory allocated to shared pool from 3 GB to 2 GB

正确答案:B,E

第10题：

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 BASIC
  • B、The PGA_AGGREGATE_TARGET initialization parameter is set to zero.
  • C、The SGA_MAX_SIZE initialization parameter is set to less than 20 GB
  • D、The DB_CACHE_SIZE initialization parameter is set to less than 5 GB
  • E、The SHARED_POOL_SIZE initialization parameter is set to a nonzero value.

正确答案:A

更多相关问题
相关内容