单选题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 informa

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

相似考题

1.In the instance of the PROD database， the checkpoint （CKPT） process runs after every minute. A database user updates the rows of the ORDERS table. Because of the configuration， the CKPT process gets initiated before the user commits the transaction. What would happen to the modified blocks when the CKPT process is started？（）A、The modified blocks would be written to the data files.B、The modified blocks would be written to the temp files.C、The modified blocks would be written to the control file.D、The modified blocks would be written to the redo log files.E、The modified blocks would be written to the archived redo log files.F、The modified blocks would be retained in the database buffer cache.

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

3.The database is currently running in the NOARCHIVELOG mode. What would be the first step to configure Flashback Database？（）A、 Enable flashback logging.B、 Start the database in the ARCHIVELOG mode.C、 Issue the ALTER DATABASE FLASHBACK ON； command.D、 Set the FAST_START_MTTR_TARGET initialization parameter.

4.You are working on the 24X7 database with high transaction volume， to ensure faster instance recovery on your database you set the FAST_START_MTTR_TARGET initialization parameter to a very low value. What effect it will have on the database？（）A、The database performance would be enhanced.B、The redo log files would be get filled more frequently.C、The overall database performance would be degraded.D、The mean time to recover （MTTR） would be increased.

更多“单选题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 informa”相关问题

  • 第1题：

    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.

    正确答案:A

  • 第2题：

    You notice that the performance of the database has degraded because of frequent checkpoints.  Which twoactions 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 eachredo log group.

    正确答案:B,C

  • 第3题：

    Automatic Shared Memory Management is disabled for your database instance. You realize that there arecases of SQL statements performing poorly because of repeated parsing activity， resulting in degradation ofperformance.  What would be your next step to improve performance（）

    • A、Run the SQL Access Advisor.
    • B、Run the Memory Advisor for the sga
    • C、Run the Memory Advisor for the pga.
    • D、Run the Memory Advisor for the shared pool.
    • E、Run the Memory Advisor for the buffer cache

    正确答案:D

  • 第4题：

    Your database performance has degraded due to frequent checkpointing. What would you do in this scenario？（）

    • A、make redo log files smaller
    • B、increase the size of the checkpoint file
    • C、make the changes as per the advice given by MTTR Advisor
    • D、make the changes as per the advice given by Checkpoint Advisor

    正确答案:C

  • 第5题：

    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

  • 第6题：

    多选题
    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
    解析： 暂无解析

  • 第7题：

    单选题
    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
    解析： 暂无解析

  • 第8题：

    单选题
    Your database is started by using the server parameter file （SPFILE）. You issued this command to change the value of the LOG_BUFFER initialization parameter：  ALTER SYSTEM SET LOG_BUFFER=24M SCOPE=BOTH;  What would be the outcome of this command？（）
    A

    The command would return an error because LOG_BUFFER is a static parameter.

    B

    The parameter value would be changed and it would come into effect immediately.

    C

    You need to restart the database so that parameter changes can come into effect.

    D

    The command would succeed only if initialization parameter LOG_ARCHIVE_MAX_PROCESS is set to value 2.


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

  • 第9题：

    单选题
    Automatic Shared Memory Management is disabled for your database instance. You realize that thereare cases of SQL statements performing poorly because of repeated parsing activity， resulting indegradation of performance.  What would be your next step to improve performance？ （）
    A

    Run the SQL Access Advisor.

    B

    Run the Memory Advisor for the sga.

    C

    Run the Memory Advisor for the pga.

    D

    Run the Memory Advisor for the shared pool.

    E

    Run the Memory Advisor for the buffer cache.


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

  • 第10题：

    单选题
    Your database performance has degraded due to frequent checkpointing. What would you do in this scenario？（）
    A

    make redo log files smaller

    B

    increase the size of the checkpoint file

    C

    make the changes as per the advice given by MTTR Advisor

    D

    make the changes as per the advice given by Checkpoint Advisor


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

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

    单选题
    You are working on the 24X7 database with high transaction volume， to ensure faster instance recovery on your database you set the FAST_START_MTTR_TARGET initialization parameter to a very low value. What effect it will have on the database？（）
    A

    The database performance would be enhanced.

    B

    The redo log files would be get filled more frequently.

    C

    The overall database performance would be degraded.

    D

    The mean time to recover （MTTR） would be increased.


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

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

    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

  • 第15题：

    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

  • 第16题：

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

    • A、The command would return an error because LOG_BUFFER is a static parameter.
    • B、The parameter value would be changed and it would come into effect immediately.
    • C、You need to restart the database so that parameter changes can come into effect.
    • D、The command would succeed only if initialization parameter LOG_ARCHIVE_MAX_PROCESS is set to value 2.

    正确答案:A

  • 第17题：

    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

  • 第18题：

    单选题
    In the instance of the PROD database， the checkpoint （CKPT） process runs after every minute. A database user updates the rows of the ORDERS table. Because of the configuration， the CKPT process gets initiated before the user commits the transaction. What would happen to the modified blocks when the CKPT process is started？（）
    A

    The modified blocks would be written to the data files.

    B

    The modified blocks would be written to the temp files.

    C

    The modified blocks would be written to the control file.

    D

    The modified blocks would be written to the redo log files.

    E

    The modified blocks would be written to the archived redo log files.

    F

    The modified blocks would be retained in the database buffer cache.


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

  • 第19题：

    单选题
    The database is currently running in the NOARCHIVELOG mode. What would be the first step to configure Flashback Database？（）
    A

     Enable flashback logging.

    B

     Start the database in the ARCHIVELOG mode.

    C

     Issue the ALTER DATABASE FLASHBACK ON； command.

    D

     Set the FAST_START_MTTR_TARGET initialization parameter.


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

  • 第20题：

    单选题
    Automatic Shared Memory Management is disabled for your database instance. You realize that there arecases of SQL statements performing poorly because of repeated parsing activity， resulting in degradation ofperformance.  What would be your next step to improve performance（）
    A

    Run the SQL Access Advisor.

    B

    Run the Memory Advisor for the sga

    C

    Run the Memory Advisor for the pga.

    D

    Run the Memory Advisor for the shared pool.

    E

    Run the Memory Advisor for the buffer cache


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

  • 第21题：

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


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

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

    单选题
    Automatic Shared Memory Management is disabled for your database instance. You realize that there arecases of SQL statements performing poorly because of repeated parsing activity， resulting in degradation ofperformance.  What would be your next step to improve performance（）
    A

    Run the SQL Access Advisor

    B

    Run the Memory Advisor for the sga.

    C

    Run the Memory Advisor for the pga.

    D

    Run the Memory Advisor for the shared pool.

    E

    Run the Memory Advisor for the buffer cache


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

  • 第24题：

    多选题
    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
    解析： 暂无解析

相关内容