多选题The Automatic Shared Memory Management feature is enabled for the PROD database. Currently， a lot of insert activity is taking place in the database， and the memory structures are allocated according to the database workload. As the workload reduces， y

第1题：

You use the Memory Advisor to tune the memory structures of your database. What is the prerequisite to use the Memory Advisor？（）

• A、 The database must be in the ARCHIVELOG mode.
• B、 The automatic memory tuning must be enabled.
• C、 The change tracking feature must be enabled.
• D、 The automatic memory tuning must be disabled.

第2题：

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

第3题：

第4题：

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

第5题：

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.

第6题：

In an Oracle 10g database， the in-memory statistics are gathered at regular intervals and used to perform growth-trend analysis and capacity planning of the database. Which component stores these statistics？（）

• A、 Recovery catalog
• B、 Oracle Enterprise Manager Repository
• C、 Automatic Workload Repository （AWR）
• D、 Oracle 10g Enterprise Manager Grid Control
• E、 Automatic Database Diagnostic Monitor （ADDM）

第7题：

Automatic Shared Memory Management （ASMM） has been enabled for your database instance.  Theinitialization parameters for the components that are managed by ASMM are not set. After observing theeffects of ASSM， you executed the following command： SQL> ALTER SYSTEM SET DB_CACHE_SIZE = 100M；  Which statement is true in this scenario（）

• A、The minimum memory size for the database buffer cache is set to 100 mb.
• B、The maximum memory size that can be obtained by the database buffer cache during ASMM is set to100 mb
• C、The minimum memory size allocated for a server process in the database buffer cache in dedicatedmode is set to 100 mb.
• D、The maximum memory size from the database buffer cache that can be released for dynamicdistribution during ASMM is set to 100 mb

第8题：

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

第9题：

Identify the memory component from which memory may be allocated for: （） 1: Session memory for the shared server  2: Buffers for I/O slaves  3: Oracle Database Recovery Manager (RMAN) backup and restore operations 

• A、Large Pool
• B、Redo Log Buffer
• C、Database Buffer Cache
• D、Program Global Area （PGA）

第10题：

The Automatic Shared Memory Management feature is enabled for the PROD database. Currently， a lot of insert activity is taking place in the database， and the memory structures are allocated according to the database workload. As the workload reduces， you decide to perform batch jobs in the database. Which of the following initialization parameters are NOT automatically resized according to the new workload and continue to remain unchanged？（）

• A、 LOG_BUFFER
• B、 DB_CACHE_SIZE
• C、 JAVA_POOL_SIZE
• D、 LARGE_POOL_SIZE
• E、 SHARED_POOL_SIZE
• F、 STREAMS_POOL_SIZE