多选题Which two statements are true about setting the FAST_START_MTTR_TARGET initialization parameter to anonzero value（）AThe MTTR advisor will be disabled.BAutomatic checkpoint tuning will be enabled.CThe value for the LOG_CHECKPOINT_INTERVAL initialization

题目
多选题
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.

相似考题

1.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 if MEMORY_TARGET is not setC、 MEMORY_TARGET represents the total amount of memory that can be allocated to SGA and PGA memory structures.D、 MEMORY_TARGET is static and cannot be modified without shutting down the instance

2.You are maintaining an OLTP database in Oracle10g. You have configured the Flash Recovery Area in your database. The Flash Recovery Area is full because you have set the retention policy to NONE. What will you do to resolve the problem？（）A、 Increase the value of the FAST_START_MTTR_TARGET initialization parameter.B、 Increase the value of the DB_RECOVERY_FILE_DEST_SIZE parameter.C、 Increase the value of the PGA_AGGREGATE_TARGET initialization parameter.D、 Increase the value of the SGA_TARGET initialization parameter.

3.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.

4. Given： String value = getServletContext（）.getInitParameter（"foo"）； in an HttpServlet and a web applicationdeployment descriptor that contains： foo frodo Which two are true？（）A、The foo initialization parameter CANNOT be set programmatically.B、Compilation fails because getInitParameter returns type Object.C、The foo initialization parameter is NOT a servlet initialization parameter.D、Compilation fails because ServletContext does NOT have a getInitParameter method.E、The foo parameter must be defined within the  element of the deployment descriptor.

参考答案和解析
正确答案： A,D
解析： 暂无解析
更多“多选题Which two statements are true about setting the FAST_START_MTTR_TARGET initialization parameter to anonzero value（）AThe MTTR advisor will be disabled.BAutomatic checkpoint tuning will be enabled.CThe value for the LOG_CHECKPOINT_INTERVAL initialization”相关问题

  • 第1题：

    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.

    正确答案:B,C

  • 第2题：

    Examine the values for the following initialization parameters： FAST_START_MTTR_TARGET = 0LOG_CHECKPOINT_INTERVAL = 0 Which two will be the implications of these values in your database（）

    • A、The SGA advisor will be disabled.
    • B、The MTTR advisor will be disabled.
    • C、Automatic checkpoint tuning will be disabled.
    • D、Checkpoint information will not be written to the alert log file.

    正确答案:B,C

  • 第3题：

    An RMAN backup job fails， displaying the following error：  ORA/x7f19809： limit exceeded for recovery files  Your analysis shows that the Flash Recovery area is full. Which two actions could you take to resolve the error and avoid this error in future？（）

    • A、take the backup of the flash recovery area less frequently
    • B、increase the value of the UNDO_RETENTION initialization parameter
    • C、change the value of the WORKAREA_SIZE_POLICY initialization parameter to AUTO
    • D、change the backup retention policy to retain the backups for a smaller period of time 
    • E、increase the value of the DB_RECOVERY_FILE_DEST_SIZE initialization parameter
    • F、increase the value of the CONTROL_FILE_RECORD_KEEP_TIME initialization parameter

    正确答案:D,E

  • 第4题：

    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.

    正确答案:D,E

  • 第5题：

    多选题
    An RMAN backup job fails， displaying the following error：  ORA/x7f19809： limit exceeded for recovery files  Your analysis shows that the Flash Recovery area is full. Which two actions could you take to resolve the error and avoid this error in future？（）
    A

    take the backup of the flash recovery area less frequently

    B

    increase the value of the UNDO_RETENTION initialization parameter

    C

    change the value of the WORKAREA_SIZE_POLICY initialization parameter to AUTO

    D

    change the backup retention policy to retain the backups for a smaller period of time

    E

    increase the value of the DB_RECOVERY_FILE_DEST_SIZE initialization parameter

    F

    increase the value of the CONTROL_FILE_RECORD_KEEP_TIME initialization parameter


    正确答案： C,F
    解析： 暂无解析

  • 第6题：

    多选题
    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 zero

    B

    MEMORY_MAX_TARGET defaults to a value of zero if MEMORY_TARGET is not set

    C

    MEMORY_TARGET represents the total amount of memory that can be allocated to SGA and PGA memory structures.

    D

    MEMORY_TARGET is static and cannot be modified without shutting down the instance


    正确答案： C,A
    解析： 暂无解析

  • 第7题：

    多选题
    Which three initialization parameters are no longer needed when FAST_START_MTTR_TARGET is defined？（）
    A

    TARGET_REDO_BLKS

    B

    FAST_START_IO_TARGET

    C

    LOG_CHECKPOINT_TIMEOUT

    D

    RECOVERY_ESTIMATED_IOS

    E

    LOG_FILE_SIZE_REDO_BLKS

    F

    LOG_CHECKPOINT_INTERVAL


    正确答案： A,B
    解析： 暂无解析

  • 第8题：

    多选题
    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.


    正确答案： B,A
    解析： 暂无解析

  • 第9题：

    单选题
    You have included the following parameter settings in your SPFILE://    SGA_MAX_SIZE=8G   SGA_TARGET=6G   DB_CACHE_SIZE=2G   SHARED_POOL_SIZE=1G   LOG_BUFFER=64M   DB_KEEP_CACHE_SIZE=960M   Which statement is true if you modify the SGA_TARGET initialization parameter？（）
    A

    The SGA_TARGET initialization parameter cannot be set to a value greater than 8G

    B

     The DB_CACHE_SIZE initialization parameter cannot be set to a value less than 2G

    C

     The DB_CACHE_SIZE initialization parameter cannot be set to a value greater than 2G

    D

     The DB_KEEP_CACHE_SIZE initialization parameter cannot be set to a value greater than 960M 

    E

     The DB_KEEP_CACHE_SIZE initialization parameter cannot be set to a value less than 960M


    正确答案： C
    解析： 暂无解析

  • 第10题：

    多选题
    Given: Which two statements are true about the result if the default locale is Locale.US?（）
    A

    The value of b is 2.

    B

    The value of a is 3.14.

    C

    The value of b is 2.00.

    D

    The value of a is 3.141.

    E

    The value of a is 3.1415.

    F

    The value of a is 3.1416.

    G

    The value of b is 2.0000.


    正确答案： G,D
    解析： 暂无解析

  • 第11题：

    多选题
    Examine the values for the following initialization parameters： FAST_START_MTTR_TARGET = 0LOG_CHECKPOINT_INTERVAL = 0 Which two will be the implications of these values in your database（）
    A

    The SGA advisor will be disabled.

    B

    The MTTR advisor will be disabled.

    C

    Automatic checkpoint tuning will be disabled.

    D

    Checkpoint information will not be written to the alert log file.


    正确答案： C,A
    解析： 暂无解析

  • 第12题：

    多选题
    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.


    正确答案： B,C
    解析： 暂无解析

  • 第13题：

    You notice that the performance of the database has degraded because of frequent checkpoints. Which two actions resolve the issue（）

    • A、Disable automatic checkpoint tuning.
    • B、Check the size of the redo log file size and increase the size if it is small.
    • C、Set the FAST_START_MTTR_TARGET parameter as per the advice given by the MTTR Advisor. 
    • D、Decrease the number of redo log members if there are more than one redo log members available in each redo log group.

    正确答案:B,C

  • 第14题：

    Which three initialization parameters are no longer needed when FAST_START_MTTR_TARGET is defined？（）

    • A、TARGET_REDO_BLKS
    • B、FAST_START_IO_TARGET
    • C、LOG_CHECKPOINT_TIMEOUT
    • D、RECOVERY_ESTIMATED_IOS
    • E、LOG_FILE_SIZE_REDO_BLKS
    • F、LOG_CHECKPOINT_INTERVAL

    正确答案:B,C,F

  • 第15题：

    What is the implication of setting the initialization parameter FAST_START_MTTR_TARGET to 0 in your database？（）

    • A、MTTR Advisor would be disabled.
    • B、Redo Log Advisor would be disabled.
    • C、Automatic tuning of checkpoint would be disabled.
    • D、Checkpoint information would not be written to the alert log file.

    正确答案:C

  • 第16题：

    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.

    正确答案:B,C

  • 第17题：

    多选题
    An RMAN backup job fails， displaying the following error：  ORA-19809： limit exceeded for recovery files  Your analysis shows that the Flash Recovery area is full.  Which two actions could you take to resolve the error and avoid this error in the future？ （）
    A

    take the backup of the flash recovery area less frequently

    B

    increase the value of the UNDO_RETENTION initialization parameter

    C

    change the value of the WORKAREA_SIZE_POLICY initialization parameter to AUTO

    D

    change the backup retention policy to retain the backups for a smaller period of time

    E

    increase the value of the DB_RECOVERY_FILE_DEST_SIZE initialization parameter

    F

    increase the value of the CONTROL_FILE_RECORD_KEEP_TIME initialization parameter


    正确答案： C,B
    解析： 暂无解析

  • 第18题：

    多选题
    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.


    正确答案： A,D
    解析： 暂无解析

  • 第19题：

    单选题
    What is the implication of setting the initialization parameter FAST_START_MTTR_TARGET to 0 in your database？（）
    A

    MTTR Advisor would be disabled.

    B

    Redo Log Advisor would be disabled.

    C

    Automatic tuning of checkpoint would be disabled.

    D

    Checkpoint information would not be written to the alert log file.


    正确答案： A
    解析： 暂无解析

  • 第20题：

    多选题
    Given： String value = getServletContext（）.getInitParameter（"foo"）； in an HttpServlet and a web applicationdeployment descriptor that contains： foo frodo Which two are true？（）
    A

    The foo initialization parameter CANNOT be set programmatically.

    B

    Compilation fails because getInitParameter returns type Object.

    C

    The foo initialization parameter is NOT a servlet initialization parameter.

    D

    Compilation fails because ServletContext does NOT have a getInitParameter method.

    E

    The foo parameter must be defined within the  element of the deployment descriptor.


    正确答案： C,E
    解析： 暂无解析

  • 第21题：

    多选题
    Given： String value = getServletContext（）.getInitParameter（"foo"）； in an HttpServlet and a web applicationdeployment descriptor that contains： foo frodo Which two are true？（）
    A

    The foo initialization parameter CANNOT be set programmatically.

    B

    Compilation fails because getInitParameter returns type Object.

    C

    The foo initialization parameter is NOT a servlet initialization parameter.

    D

    Compilation fails because ServletContext does NOT have a getInitParameter method.

    E

    The foo parameter must be defined within the  element of the deployment descriptor.


    正确答案： A,C
    解析： 暂无解析

  • 第22题：

    多选题
    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.


    正确答案： C,D
    解析： 暂无解析

  • 第23题：

    多选题
    You notice that the performance of the database has degraded because of frequent checkpoints. Which two actions resolve the issue（）
    A

    Disable automatic checkpoint tuning.

    B

    Check the size of the redo log file size and increase the size if it is small.

    C

    Set the FAST_START_MTTR_TARGET parameter as per the advice given by the MTTR Advisor.

    D

    Decrease the number of redo log members if there are more than one redo log members available in each redo log group.


    正确答案： A,B
    解析： 暂无解析

  • 第24题：

    单选题
    You are maintaining an OLTP database in Oracle10g. You have configured the Flash Recovery Area in your database. The Flash Recovery Area is full because you have set the retention policy to NONE. What will you do to resolve the problem？（）
    A

     Increase the value of the FAST_START_MTTR_TARGET initialization parameter.

    B

     Increase the value of the DB_RECOVERY_FILE_DEST_SIZE parameter.

    C

     Increase the value of the PGA_AGGREGATE_TARGET initialization parameter.

    D

     Increase the value of the SGA_TARGET initialization parameter.


    正确答案： B
    解析： 暂无解析

相关内容