Automatic PGA Memory Management eliminates the need to manually configure which of the following initialization parameters？（） 

相似题目

• Your database is running on 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

  查看最佳答案

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

  查看最佳答案

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

  查看最佳答案

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

  查看最佳答案

• You have configured Automatic Shared Memory Management. Which four memory structures would be automatically tuned？ （）

  A .  log buffer B .  Java pool C .  Large pool D .  Fixed SGA E .  Shared pool F .  Streams pool G .  Keep buffer cache H .  Database buffer cache

  查看最佳答案

• 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

  查看最佳答案

• 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

  查看最佳答案

• 在高尔夫术语中，“PGA”的意思是（）。

  A . 职业高尔夫协会 B . 女子高尔夫协会 C . 业余高尔夫协会 D . 中国高尔夫协会

  查看最佳答案

• You configure your database Instance to support shared server connections.Which two memory areas that are part of PGA are stored in SGA instead, for shared server connection?（）

  A . User session data B . Stack space C . Private SQL area D . Location of the runtime area for DML and DDL Statements E . Location of a part of the runtime area for SELECT statement

  查看最佳答案

• 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

  查看最佳答案

• 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

  查看最佳答案

• 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

  查看最佳答案

• 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

  查看最佳答案

• Which routing protocol best fits these requirements？（） - Supported by multiple router vendors  - Requires minimum router CPU and memory resources  - Uses a simple routing metric  - Supports manual or automatic route summarization

  A .  EIGRP B .  OSPF C .  IS-IS D .  RIPv2

  查看最佳答案

• Which routing protocol best fits these requirements?（） - Supported by multiple router vendors - Requires minimum router CPU and memory resources - Uses a simple routing metric - Supports manual or automatic route summarization

  A . EIGRP B . OSPF C . IS-IS D . RIPv2

  查看最佳答案

• PGA调速器的速度设定可采用（）。

  A . A．气压设定 B . B．液压设定 C . C．手动设定 D . D．A＋C

  查看最佳答案

• When tuning Automatic PGA Memory Management， which of the following views will provide the information specified？（）  

  A .  The V$PGA_TARGET_ADVICE view shows the predicted cache hit-ratio improvement if you increase PGA_AGGREGATE_TARGET B .  The V$PGA_TARGET_ADVICE view shows how the V$SQL_WORKAREA histogram will change if you change the value of PGA_AGGREGATE_TARGET C .  The V$PGA_TARGET_ADVICE_HISTOGRAM view shows how the V$SQL_WORKAREA_HISTOGRAM will change if you switch between Manual and Automatic PGA Memory Management D .  The V$PGA_TARGET_ADVICE view shows how performance will improve for the different work areas if you switch from Manual to Automatic PGA Memory Management

  查看最佳答案

• 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

  查看最佳答案

• 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

  查看最佳答案

• PGA内存区域不包括（）。

  A . 会话内存 B . 专用SQL区 C . 工作区 D . 大池

  查看最佳答案

• 下列属于制备PGA的方法有（）

  A . 一氧化碳甲醛共聚法 B . NCA法 C . 活性脂法 D . 发酵法

  查看最佳答案

• 1916年（）职业高尔夫选手协会成立，15年前，英国的PGA已经建立。当年10月，（）赢得第一届PGA锦标赛冠军，获得500美元的冠军奖金。

  查看最佳答案

• 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

  查看最佳答案

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

  查看最佳答案