You have configured Automatic Shared Memory Management. Whic

第1题：

You configured the large pool for Oracle backup and restore operations. As a result， which component would require less memory？（）

• A、 streams pool
• B、 shared pool
• C、 log buffer
• D、 keep buffer cache
• E、 recycle buffer cache

第2题：

Your database is configured in shared server mode. However， your senior DBA asks you to modifythe value of the PRIVATE_SGA limit in the profile of the users.  What could be the reason for this（）

• A、to limit the User Global Area （UGA） memory allocated to a session from the SGA
• B、to limit the amount of memory to be used for the dispatcher queue of a session in SGA
• C、to limit the amount of memory to be used for the request pool in System Global Area （SGA）
• D、to control the amount of memory allocated in SGA for the local variables for each shared server process

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

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

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

A senior DBA asked you to execute the following command to improve performance: SQL> ALTER TABLE subscribe log STORAGE (BUFFER_POOL recycle); You checked the data in the SUBSCRIBE_LOG table and found that it is a large table containing one million rows. What could be a reason for this recommendation?（）

• A、The keep pool is not configured.
• B、Automatic Workarea Management is not configured.
• C、Automatic Shared Memory Management is not enabled.
• D、The data blocks in the SUBSCRIBE_LOG table are rarely accessed.
• E、All the queries on the SUBSCRIBE_LOG table are rewritten to a materialized view

第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