You are enabling the Automatic Shared Memory Management feat

第1题：

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

第2题：

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

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

第6题：

An application accesses a small lookup table frequently. You notice that the required data blocks are getting aged out of the default buffer cache. How would you guarantee that the blocks for the table never age out?（）

• A、Configure the KEEP buffer pool and alter the table with the corresponding storage clause.
• B、Increase the database buffer cache size.
• C、Configure the RECYCLE buffer pool and alter the table with the corresponding storage clause.
• D、Configure Automata Shared Memory Management.
• E、Configure Automatic Memory Management

第7题：

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.

第8题：

第9题：

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.

第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