首页计算机考试Oracle认证
(多选题)

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

ADisable automatic checkpoint tuning.

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

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

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

正确答案

来源:www.examk.com

答案解析

相似试题

  • (多选题)

    You are working on an Oracle Database 10g database. You enabled the Flashback Database feature. Which two statements regarding flashback logs are true? ()

    答案解析

  • (多选题)

    Which two initialization parameters would you set to enable Automatic Shared Memory Management?()

    答案解析

  • (单选题)

    You can control instance recover performance by setting parameters to define targets for()

    答案解析

  • (多选题)

    You want to migrate your existing non/x7fASM files to ASM files for the database PROD. Which method or command would you use to accomplish this task?()

    答案解析

  • (单选题)

    Assume that you would like to clone an existing WebLogic Domain and enable some  customizations. What scenario would you choose?()

    答案解析

  • (多选题)

    You noticed that the index tablespace in your database requires a recovery. However, instead of performing a media recovery, you decided to re-create the indexes in a new tablespace. Which two options would you use to reduce the time it takes to re-create the indexes?()

    答案解析

  • (单选题)

    Which tool in the layout model could you use to create an external boiler plate object?()

    答案解析

  • (单选题)

    You want to use the automatic management of backup and recovery operations features for your database. Which configuration must you set?()

    答案解析

  • (单选题)

    You have 100 segments in the USERS tablespace. You realize that the USERS tablespace is running low on space. You can use Segment Advisor to().

    答案解析

快考试在线搜题