多选题To manually configure the SGA components using Oracle Enterprise Manager Memory Advisor， you can set values for which of the following initialization parameters？（）ADB_CACHE_SIZEBSHARED_POOL_SIZECLARGE_POOL_SIZEDJAVA_POOL_SIZEESGA_MAX_SIZEFSORT_AREA_SIZ

第1题：

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.

第2题：

You work as a database administrator for Supportcenter.cn. You want to administer your database servers， which are running on different host machines， using the Web-enabled grid control interface. You have configured the agent on the host machines. You have started the Oracle Database 10g Grid Control utility on your machine. Which two additional components would you configure to achieve this objective？（）

• A、Application Server Control
• B、Oracle Management Service
• C、Oracle Enterprise Manager Repository
• D、Oracle Enterprise Manager Database Control

第3题：

第4题：

Examine the values for the following initialization parameters： FAST_START_MTTR_TARGET = 0LOG_CHECKPOINT_INTERVAL = 0 Which two will be the implications of these values in your database（）

• A、The SGA advisor will be disabled.
• B、The MTTR advisor will be disabled.
• C、Automatic checkpoint tuning will be disabled.
• D、Checkpoint information will not be written to the alert log file.

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

第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

第7题：

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.

第8题：

Using Oracle Enterprise Manager to set SGA pool values manually， for which of the following pools does Oracle EM offer advice to set the value appropriately？（） 

• A、 DB_CACHE_SIZE
• B、 SHARED_POOL_SIZE
• C、 LARGE_POOL_SIZE
• D、 JAVA_POOL_SIZE
• E、 SGA_MAX_SIZE
• F、 SORT_AREA_SIZE

第9题：

You are enabling the Automatic Shared Memory Management feature in the Oracle Database 10g to ensure that the important memory structures of the System Global Area （SGA） are automatically adjusted depending on the database workload. You are using Enterprise Manager 10g to enable this feature. You are currently on the Administration tab page.  Which two links should you click to go to the Memory Advisor page？（）

• A、 Advisor Central
• B、 Global Attributes
• C、 Resource Monitors
• D、 Memory Parameters
• E、 Database Usage Statistics
• F、 All Initialization Parameters
• G、 Automatic Workload Repository

第10题：

To manually configure the SGA components using Oracle Enterprise Manager Memory Advisor， you can set values for which of the following initialization parameters？（）

• A、 DB_CACHE_SIZE
• B、 SHARED_POOL_SIZE
• C、 LARGE_POOL_SIZE
• D、 JAVA_POOL_SIZE
• E、 SGA_MAX_SIZE
• F、 SORT_AREA_SIZE