单选题Oracle9i offers the ability to monitor the dynamic use of the SGA through the DB_CACHE_ADVICE parameter. When this parameter is set to READY， what is its effect？ （）A The Advisory is on and will capture both CPU and memory overhead.B The Advisory is on 

第1题：

Which statement about Automatic Memory Management with Oracle 11g is true？（）  

• A、 You cannot specify MEMORY_TARGET if you explicitly specify SGA_TARGET or  PGA_AGGREGATE_ TARGET values that are greater than zero in your parameter file.
• B、 Oracle can reallocate memory between the SGA and PGA automatically as needed.
• C、 To use Automatic Memory Management， you must explicitly set both the MEMORY_TARGET and MEMORY_MAX_TARGET parameters in your parameter file.
• D、 You can set the MEMORY_TARGET parameter to a maximum value of the current SGA size plus the current PGA size.

第2题：

In your running instance， some of the initialization parameters are set as shown below： SGA_MAX_SIZE = 14GB  DB_CACHE_SIZE = 1GB  SHARED_POOL_SIZE = 3GB  STATISTICS_LEVEL = BASIC  PGA_AGGREGATE_TARGET = 0  You plan to enable Automatic Shared Memory Management but you are not able to set SGA_TARGET to a nonzero value. What could be the reason？（）

• A、The STATISTICS_LEVEL initialization parameter is set to BASIC
• B、The PGA_AGGREGATE_TARGET initialization parameter is set to zero.
• C、The SGA_MAX_SIZE initialization parameter is set to less than 20 GB
• D、The DB_CACHE_SIZE initialization parameter is set to less than 5 GB
• E、The SHARED_POOL_SIZE initialization parameter is set to a nonzero value.

第3题：

You create an Oracle 10g database and configure the SPFILE as follows：   SGA_TARGET=2G   DB_CACHE_SIZE=512M  LOG_BUFFER=50M   DB_KEEP_CACHE_SIZE=128M   You modify the SGA_TARGET initialization parameter using the following statement：   SQL>ALTER SYSTEM SET SGA_TARGET = 1G SCOPE = BOTH；   Which entity does this statement affect？（） 

• A、 only the auto-tuned memory components
• B、 only the memory components that are not auto-tuned
• C、 both the auto-tuned memory components and the non-auto-tuned memory components
• D、 neither the auto-tuned memory components nor the non-auto-tuned memory components

第4题：

You set the following parameters in the parameter file and restarted the database：MEMORY_MAX_TARGET=0MEMORY_TARGET=500M PGA_AGGREGATE_TARGET=90MSGA_TARGET=270M Which two statements are true about these parameters after the database instance is restarted（）

• A、The MEMORY_MAX_TARGET parameter is automatically set to 500 mb.
• B、The pga_AGGREGATE_TARGET and sga_TARGET parameters are automatically set to zero.
• C、The value of the MEMORY_MAX_TARGET parameter remains zero until it is changed manually.
• D、The lower bounds of pga_AGGREGATE_TARGET and sga_TARGET parameters are set to 90 nb and270 mb， respectively

第5题：

You are configuring the PROD database to use an internal tuning algorithm to monitor the performance of the workload. To achieve this configuration， you specify the following parameter settings in the SPFILE://        SGA_TARGET = 512M        SHARED_POOL_SIZE = 256M   Which two statements are true when modifying the SHARED_POOL_SIZE initialization parameter in the SPFILE？ （）

• A、 Modifying the SHARED_POOL_SIZE initialization parameter cannot be accomplished if the SGA_TARGET initialization parameter is set to a non-zero value.
• B、 Modifying the value of the SHARED_POOL_SIZE initialization parameter to zero is not allowed if the SGA_TARGET initialization parameter is set to a nonzero value.
• C、 Increasing the value of the SHARED_POOL_SIZE initialization parameter does not increase the shared pool component size. It sets the lower limit for the size of this component.
• D、 Decreasing the value of the SHARED_POOL_SIZE initialization parameter does not reduce the size of the shared pool component immediately. It sets the lower limit for the size of this component.
• E、 Increasing the value of the SHARED_POOL_SIZE initialization parameter immediately increases the shared pool  component to the desired size by reallocating the additional memory from the auto-tuned memory components.
• F、 Decreasing the value of the SHARED_POOL_SIZE initialization parameter immediately shrinks the shared pool component to the desired size while reallocating the released memory to the memory components that are not auto-tuned.

第6题：

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

You work as a database administrator for Certkiller .com. Users complain that their query is taking a long time to complete. You suspect the database buffer cache size to be the reason， and you define an alert to be generated when the buffer cache hit metric goes below 85%. When you observe the dynamic performance views， you find that the buffer cache hit ratio is 81% but no alerts are being generated.  What could be the reason for this problem？（）

• A、The advisory memory has been turned off.
• B、The DB_CACHE_ADVICE parameter has been set to OFF in the parameter file.
• C、The STATISTICS_LEVEL parameter has been set to BASIC in the parameter file.
• D、The TIMED_STATISTICS parameter has been set to FALSE in the parameter file.
• E、The STATISTICS_LEVEL parameter has been set to TYPICAL in the parameter file.

第14题：

Your database instance is started using the server parameter file （SPFILE）. You executed acommand to change the value of the LOG_BUFFER initialization parameter： ALTER SYSTEM SET LOG_BUFFER=32M SCOPE=BOTH；  What would be the outcome of this command（）

• A、The command succeeds only if Automatic Memory Management is not enabled.
• B、The command succeeds， but you need to restart the database for changes to take effect.
• C、The command returns an error because the size of the redo log buffer cannot be changed dynamically.
• D、The parameter value is changed and it comes into effect as soon as space becomes available in the System Global Area （SGA）.

第15题：

Oracle9i offers the ability to monitor the dynamic use of the SGA through the DB_CACHE_ADVICE parameter. When this parameter is set to READY， what is its effect？ （）

• A、The Advisory is on and will capture both CPU and memory overhead.
• B、The Advisory is on but the memory for the Advisory is not allocated.
• C、The Advisory is off and the memory for the Advisory is not allocated.
• D、The Advisory is off but the memory for the Advisory remains allocated.

第16题：

Your SPFILE contains the following parameter settings：   SGA_TARGET = 8G   DB_CACHE_SIZE = 4G   SHARED_POOL_SIZE = 2G   LARGE_POOL_SIZE = 512M   JAVA_POOL_SIZE = 512M   LOG_BUFFER = 100M   SGA_MAX_SIZE = 10G   You query the V$SGA_DYNAMIC_COMPONENTS dynamic performance view and discover that the large pool component is currently sized at 1G. You want the value of the SGA_TARGET initialization parameter to 10G， but instead of specifying a value of 10G for the SGA_TARGET initialization parameter， you erroneously execute the following statement：   SQL>ALTER SYSTEM SET SGA_TARGET = 0 SCOPE = BOTH；   What is the result of this statement？（）  

• A、 The database crashes.
• B、 The large pool releases 512M of memory.
• C、 The large pool retains 1G of allocated memory.
• D、 The large pool increases to 1，512M of memory.

第17题：

You are a network administrator for your company.A Windows Server 2003 computer named Server1 is exhibiting connectivity problems. You monitor Server1 by using System Monitor and Network Monitor. While monitoring， you notice that Server1 has approximately 4 MB of available memory， and the average CPU utilization is running at 95 percent. When you investigate the Network Monitor capture， you notice that some network packets sent to Server1 during the capture have not been captured. You need to ensure that the impact of monitoring on Server1 is reduced and that all packets sent to the computer are captured.   What should you do？（）

• A、From a command prompt， run the diskperf command.
• B、Run Network Monitor in dedicated capture mode.
• C、Configure a Network Monitor capture filter.
• D、Increase the buffer size in Network Monitor.

第18题：

第19题：

第20题：

第21题：

第22题：

第23题：