单选题Records from the data dictionary information are stored in which of the following database memory areas?（）A Library cache B Row cache C Session UGA D Buffer cache

第1题：

Which Coherence caching pattern matches the sequence of events ？（）  1. Data is requested from cache  2. The requested data does not exist in the cache （cache miss）  3. The Coherence cache store is used to red data from the back-end persistent data source， and placed in ther cache  4. Data requested from the cache is returned to the caller

• A、 read through
• B、 write through
• C、 refresh ahead
• D、 write behind

第2题：

You observe that database performance has degraded over a period of time. While investigating the reason， you find that the size of the database buffer cache is not large enough to cache all the needed data blocks.  Which advisory component would you refer to， in order to determine the required size of the database buffer cache？（） 

• A、Memory Advisor
• B、Segment Advisor
• C、SQL Tuning Advisor
• D、SQL Access Advisor
• E、Automatic Database Diagnostic Monitor （ADDM）

第3题：

第4题：

You are analyzing how Oracle processes user statements. SQL and PL/SQL parse information is stored in which of the following database memory areas? （）

• A、Library cache 
• B、Row cache
• C、Dictionary cache 
• D、Large area 
• E、Buffer cache

第5题：

The Log Writer （LGWR） process reads information from the （）and writes it to the online logs.

• A、large pool
• B、shared pool
• C、data buffer cache
• D、redo log buffer
• E、data dictionary cache

第6题：

A database application is installed on a server. The AIX default filesystem cache is not being re-used by the database. Which of the following should be used to fix this problem?（）

• A、vmo to adjust the maxperm value
• B、schedo to adjust the mempool size
• C、ioo to modify the maxpgahead value
• D、bosboot to reassign the memory cache size

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

In your database， the RESULT_CACHE_MODE parameter has been set to MANUAL in the initialization parameter file. You issued the following command：   SQL>SELECT /*+ RESULT_CACHE */ sale_category， sum（sale_amt） FROM sales  GROUP BY sale_category；   Where would the result of this query be stored（）？  

• A、 database buffer cache
• B、 shared pool
• C、 PGA
• D、 large pool

第9题：

Why can setting too low a value for the FAST_START_MTTR_TARGET parameter reduce your overall database performance？（）

• A、Data blocks have to be written more frequently by DBWR. 
• B、Redo blocks have to be written more frequently by LGWR. 
• C、You need to substantially increase the size of your database buffer cache to hold the additional checkpoint records. 
• D、You need to substantially increase the size of your redo buffer cache to hold the additional checkpoint records.

第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