Which statements about the MEMORY_TARGET initialization parameter are true？（） A、 MEMORY_TARGET can be increased up to the value of MEMORY_MAX_TARGET， if MEMORY_MAX_TARGET is set to a value greater than zeroB、 MEMORY_MAX_TARGET defaults to a value of zero

第1题：

第2题：

Which two statements are true regarding the SGA_TARGET initialization parameter（）

• A、It can be increased up to the value of the SGA_MAX_SIZE parameter.
• B、Increasing the value of the SGA_TARGET parameter distributes the increased memory among all the Autotuned components.
• C、Reducing the value of the SGA_TARGET parameter deallocates memory from both autotuned and Manually sized components.
• D、Increasing the value of SGA_TARGET up to the value of SGA_MAX_SIZE disables the automatic shared Memory management feature.

第3题：

Which two statements are true about setting the FAST_START_MTTR_TARGET initialization parameter to anonzero value（）

• A、The MTTR advisor will be disabled.
• B、Automatic checkpoint tuning will be enabled.
• C、The value for the LOG_CHECKPOINT_INTERVAL initialization parameter will be override the value forFAST_START_MTTR_TARGET.
• D、The time taken to recover the instance after the crash is always exactly the same as the value given for theinitialization parameter.

第4题：

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.

第5题：

Which of the following statements is true regarding the initialization parameter DIAGNOSTIC_DEST？（）   The default value is the value of the environment variable $ORACLE_HOME； if $ORACLE_HOME isn’t set  

• A、 then the default is set to $ORACLE_BASE  The default value is the value of the environment variable $ORACLE_BASE； if $ORACLE_BASE isn’t set，
• B、 then it is set to $ORACLE_HOME
• C、 DIAGNOSTIC_DEST is always equal to $ORACLE_HOME
• D、 DIAGNOSTIC_DEST is always equal to $ORACLE_BASE

第6题：

Which of the following Oracle features is enabled by setting a nonzero value for the MEMORY_TARGET initialization parameter？（）  

• 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

第7题：

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.

第8题：

Which two statements are true about setting the FAST_START_MTTR_TARGET initializationparameter to a nonzero value（）

• A、The MTTR advisor will be disabled.
• B、Automatic checkpoint tuning will be enabled.
• C、The value for the LOG_CHECKPOINT_INTERVAL initialization parameter will be override the value forFAST_START_MTTR_TARGET.
• D、The time taken to recover the instance after the crash is always exactly the same as the value given forthe FAST_START_MTTR_TARGET initialization parameter.

第9题：

第10题：

第11题：

第12题：

第13题：

第14题：

You specify a nonzero value for the MEMORY_TARGET initialization parameter，but do not set the PGA_AGGREGATE_TARGET or the SGA_TARGET parameters. You restart your database instance.  Which statement about the result is true？（）

• A、 The database instance starts，and Oracle sets the default value of SGA_TARGET to the same value as SGA_MAX_SIZE
• B、 The database instance starts，and Oracle automatically tunes memory and allocates 60 percent to the  SGA and 40 percent to the PGA
• C、 The database instance starts，but Automatic Memory Management is disabled
• D、 The database instance will not start because you did not specify the PGA_AGGREGATE_TARGET or SGA_TARGET parameter

第15题：

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.

第16题：

You want to enable automatic PGA memory management in your database. Which setting is required to achieve this?（）

• A、Set MEMORY_TARGET to zero
• B、Set the STATISTICS_LEVEL parameter to BASIC
• C、Set the WORKAREA_SIZE_POLICY parameter to MANUAL
• D、Set the PGA_AGGREGATE_TARGET parameter to nonzero value

第17题：

Examine the exhibit to view the parameters set in your parameter file. (Click the Exhibit(s) button.) You restart the instance. To what value will the MEMORY_MAX_TARGET parameter be set by default?（）

• A、120M
• B、320M
• C、480M
• D、600M

第18题：

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

第19题：

By setting the value of MEMORY_TARGET to zero and setting the value of SGA_TARGET to a nonzero value， you will enable which of the following memory-management options？（）  

• 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

第20题：

第21题：

第22题：

第23题：