Automatic Shared Memory Management （ASMM） has been enabled f

第1题：

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

第2题：

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.

第3题：

第4题：

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

第5题：

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

第6题：

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

第7题：

SORT_AREA SIZE and HASH_AREA_SIZE parameters are ignored in some of the user sessions. What could be the reason？（）

• A、The User Global Area （UGA） is not configured.
• B、The sessions were started using the login name SYS.
• C、The sessions are running in the Automatic Shared Memory Management mode.
• D、The sessions are running in the automatic Program Global Area （PGA） memory management mode.

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

Automatic Shared Memory Management (ASMM) has been enabled for your database instance. The initialization parameters for the components that are managed by ASMM are not set. After observing the effectsof ASMM, 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 to 100mb
• C、The minimum memory size allocated for a server process in the database buffer cache in dedicated modeis set to 100 mb.
• D、The maximum memory size from the database buffer cache that can be released for dynamic distributionduring ASMM is set to 100 mb

第10题：

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