Which statement about Automatic Memory Management with Oracl

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

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

第1题:

Which two statements are true regarding an Automatic Storage Management (ASM) instance?() (Choosetwo.)

A. As ASM instance mounts an ASM control file

B. An ASM instance uses the ASMB process for rebalancing of disks within a disk group

C. Automatic Memory Management is enabled in an ASM instance even when the MEMORY_TARGET parameter is not set explicitly

D. An RDBMS instance gets connected to an ASM instance using ASMB as a foreground process when the database instance is started


参考答案:C, D

第2题:

You are upgrading to the Oracle 10g Database and will use the Automatic Shared Memory Management feature of the Oracle 10g Database. Which background process serves as the SGA memory broker that  coordinates the sizing of the memory components?()  

  • A、 MMAN
  • B、 PMON
  • C、 MMON
  • D、 MMNL

正确答案:A

第3题:

Which two statements are true regarding an Automatic Storage Management (ASM) instance? ()

A. As ASM instance mounts an ASM control file

B. An ASM instance uses the ASMB process for rebalancing of disks within a disk group

C. Automatic Memory Management is enabled in an ASM instance even when the MEMORY_TARGET parameter is not set explicitly

D. An RDBMS instance gets connected to an ASM instance using ASMB as a foreground process when the database instance is started


参考答案:C, D

第4题:

Which statement is true about the Manageability Monitor (MMON) background proces()

  • A、It transfers statistics from memory to disk at regular intervals.
  • B、It coordinates the rebalance activity for disk groups when ASM is used.
  • C、It communicates with the Automatic Storage Management (ASM) instance on behalf of the databaseinstance.
  • D、It performs dynamic memory management when Automatic Shared Memory Management is enabledfor the database instance.

正确答案:A

第5题:

Which two statements are true regarding an Automatic Storage Management (ASM) instance? ()

  • A、As ASM instance mounts an ASM control file
  • B、An ASM instance uses the ASMB process for rebalancing of disks within a disk group
  • C、Automatic Memory Management is enabled in an ASM instance even when the MEMORY_TARGET parameter is not set explicitly
  • D、An RDBMS instance gets connected to an ASM instance using ASMB as a foreground process when the database instance is started

正确答案:C,D

第6题:

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

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

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

Which background process does Automatic Shared Memory Management use to coordinate the sizing of memory components?()

  • A、PMON
  • B、SMON
  • C、MMNL
  • D、MMAN
  • E、MMON

正确答案:D

第10题:

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

更多相关问题