多选题You are working on a test database where instance recovery takes a considerable amount of time.How can reduce the recovery time？（）ABy multiplexing the control filesBBy multiplexing the redo log filesCBy decreasing the size of redo log filesDBy configur

题目
多选题
You are working on a test database where instance recovery takes a considerable amount of time.How can reduce the recovery time？（）
A

By multiplexing the control files

B

By multiplexing the redo log files

C

By decreasing the size of redo log files

D

By configuring mean time to recover （MTTR） to a lower value

E

By setting the UNDO_RETENTION parameter to a higher value

相似考题

1.The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each.One of the redo log groups has become corrupted. You have issued the following command during the recovery of a damaged redo log file:ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3;Which action should you perform immediately after using this command?（）A. You should perform a log switchB. You should make a backup of the databaseC. You should switch the database to the NONARCHIVELOG modeD. You should shut down the database instance and perform a complete database recovery

2.Which statement is true regarding the Archiver （ARCn） process，archived log files，and recovery？ （）A、A database backup, combined with archived redo log files, guarantees that all committed data can be recovered to the point of failure. B、During recovery the ARCn background process copies its redo entries identified for recovery by the control file to the data files. C、After each write to an archived log, the mandatory background process ARCn writes its log sequence number and the first and last SCN number within the log sequence to the control file. D、At database recover time, and archived redo log is uniquely identified for recovery use by its redo thread number and destination ID number retrieved from the control file.

3.You can control instance recover performance by setting parameters to define targets for（）A、The size of the redo buffer in SGA. B、The instance that will perform recovery in Real Application Cluster database. C、The number of blocks to be read during instance recovery, or the time needed to complete instance recovery. D、The number of passes through the redo logs made by the recovery process to identify blocks needing recovery.

4. The instance abnormally terminates because of a power outage.  Which statement is true about redo log filesduring instance recovery（）A、Inactive and current redo log files are required to accomplish recovery.B、Online and archived redo log files are required to accomplish instance recovery.C、All redo log entries after the last checkpoint are applied from redo log files to data files.D、All redo log entries recorded in the current redo log file until the checkpoint position are applied to data files

参考答案和解析
正确答案： C,B
解析： 暂无解析
更多“多选题You are working on a test database where instance recovery takes a considerable amount of time.How can reduce the recovery time？（）ABy multiplexing the control filesBBy multiplexing the redo log filesCBy decreasing the size of redo log filesDBy configur”相关问题

  • 第1题：

    The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each. One of the redo log groups has become corrupted. You have issued the following command during the recovery of a damaged redo log file：   ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3；   Which action should you perform immediately after using this command？（）  

    • A、 You should perform a log switch
    • B、 You should make a backup of the database
    • C、 You should switch the database to the NONARCHIVELOG mode
    • D、 You should shut down the database instance and perform a complete database recovery

    正确答案:B

  • 第2题：

    In which two cases would you perform only consistent backup？（）

    • A、You are working on a database where downtime is not tolerated.
    • B、You are working on a database where downtime can be tolerated.
    • C、You are working on a database that operates in ARCHIVELOG mode.
    • D、You are working on a database that operates in NOARCHIVELOG mode.
    • E、You are working on a database where all the tablespaces are locally managed.
    • F、You are working on a database where control files and redo log files are multiplexed.
    • G、You are working on a database where control files and redo log files are not multiplexed.

    正确答案:B,D

  • 第3题：

    In the parameter file of your production database， the FAST_START_MTTR_TARGET parameter is set to 300 to optimize instance recovery. While observing the performance of the database during instance recovery， you find that the redo log files are not sized properly to support this activity. Which two sources could you use to determine the optimal size of the redo log files？（）

    • A、the V$LOG view
    • B、the V$DBFILE view
    • C、the V$LOGFILE view
    • D、the V$INSTANCE_RECOVERY view
    • E、Oracle Enterprise Manager Database Control

    正确答案:D,E

  • 第4题：

    You have configured the flash recovery area to store online redo log files， control files， archived redo logs and RMAN backups. Which of the following files can you successfully delete from the flash recovery area if you want to reclaim the space within it？（）

    • A、 multiplexed control files
    • B、 RMAN obsolete backups
    • C、 multiplexed online redo log files
    • D、 archived redo logs that have not been copied to tape

    正确答案:B

  • 第5题：

    You configured the Flash Recovery Area （FRA） for your database. The database instance is runningin ARCHIVELOG mode. The default location for the archived redo log files is the Flash Recovery Area.  Which two files are removed automaticallyif the space is required in the FRA as per the retention policy（）

    • A、flashback log files
    • B、backups that have become obsolete
    • C、copies of the data files and control files
    • D、archived redo log files that have multiple copies in a different archive location and not backed up

    正确答案:A,B

  • 第6题：

    You are working as a DBA on Oracle Database 9i. You plan to upgrade your 9i database to Oracle 10g. To be familiar with the new database technology， you decide to install Oracle Database 10g on your workstation at home. You create a general purpose database.   After the installation， you make the following changes in your initialization parameter file：LOG_ARCHIVE_DEST_1=’LOCATION=USE_DB_RECOVERY_FILE_DEST’   DB_RECOVERY_FILE_DEST =    ’LOCATION=d：/product/10.1.0/flash_recovery_area’  DB_RECOVERY_FILE_DEST_SIZE=10g   Where are the archived redo logs stored for your database？（）

    • A、 The archived redo logs are stored in an operating system-dependent location.
    • B、 The archived redo logs are stored in the location specified by LOG_ARCHIVE_DEST_1.
    • C、 The archived redo logs are stored in the location specified by DB_RECOVERY_FILE_DEST.
    • D、 The archived redo logs are stored in the locations specified by both LOG_ARCHIVE_DEST_1 and  DB_RECOVERY_FILE_DEST.

    正确答案:C

  • 第7题：

    You are working on a test database where instance recovery takes a considerable amount of time. How can reduce the recovery time？（）

    • A、By multiplexing the control files
    • B、By multiplexing the redo log files
    • C、By decreasing the size of redo log files
    • D、By configuring mean time to recover （MTTR） to a lower value
    • E、By setting the UNDO_RETENTION parameter to a higher value

    正确答案:C,D

  • 第8题：

    单选题
    You have configured the flash recovery area to store online redo log files， control files， archived redo logs and RMAN backups. Which of the following files can you successfully delete from the flash recovery area if you want to reclaim the space within it？（）
    A

     multiplexed control files

    B

     RMAN obsolete backups

    C

     multiplexed online redo log files

    D

     archived redo logs that have not been copied to tape


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

  • 第9题：

    单选题
    The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each. Oneof the redo log groups has become corrupted. You have issued the following command during the recovery of a damaged redo log file:ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3; Which action should you perform immediately after using this command?（）
    A

    You should perform a log switch

    B

    You should make a backup of the database

    C

    You should switch the database to the NONARCHIVELOG mode

    D

    You should shut down the database instance and perform a complete database recovery


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

  • 第10题：

    多选题
    You are working on a test database where instance recovery takes a considerable amount of time. How can reduce the recovery time？（）
    A

    By multiplexing the control files

    B

    By multiplexing the redo log files

    C

    By decreasing the size of redo log files

    D

    By configuring mean time to recover （MTTR） to a lower value

    E

    By setting the UNDO_RETENTION parameter to a higher value


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

  • 第11题：

    单选题
    You want to use the automatic management of backup and recovery operations features for your database. Which configuration must you set？（）
    A

     Enable the flash recovery area and specify it as the archived redo log destination.

    B

     Disable the flash recovery area and start the database instance in ARCHIVELOG mode.

    C

     Enable the flash recovery area but do not specify it as the archived redo log destination. 

    D

     Disable the flash recovery area and start the database instance in NOARCHIVELOG mode.


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

  • 第12题：

    多选题
    In the parameter file of your production database， the FAST_START_MTTR_TARGET parameter is set to 300 to optimize instance recovery. While observing the performance of the database during instance recovery， you find that the redo log files are not sized properly to support this activity. Which two sources could you use to determine the optimal size of the redo log files？（）
    A

    the V$LOG view

    B

    the V$DBFILE view

    C

    the V$LOGFILE view

    D

    the V$INSTANCE_RECOVERY view

    E

    Oracle Enterprise Manager Database Control


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

  • 第13题：

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

    • A、Enable the flash recovery area and specify it as the archived redo log destination.
    • B、Disable the flash recovery area and start the database instance in ARCHIVELOG mode.
    • C、Enable the flash recovery area but do not specify it as the archived redo log destination.
    • D、Disable the flash recovery area and start the database instance in NOARCHIVELOG mode

    正确答案:A

  • 第14题：

    You are working on a test database where instance recovery takes a considerable amount of time.How can reduce the recovery time？（）

    • A、By multiplexing the control files
    • B、By multiplexing the redo log files
    • C、By decreasing the size of redo log files
    • D、By configuring mean time to recover （MTTR） to a lower value
    • E、By setting the UNDO_RETENTION parameter to a higher value

    正确答案:C,D

  • 第15题：

    You are maintaining your database in Oracle10g. You have set the value of the STATISTICS_LEVEL initialization parameter to TYPICAL and the value of the FAST_START_MTTR_TARGET parameter to 900 seconds. To increase the performance of the database， you want to determine the log file size that should equal the minimum size of all the online redo log files. Which column will enable you to perform the desired task？（）

    • A、 the WRITES_LOGFILE_SIZE column of the V$INSTANCE_RECOVERY view
    • B、 the column of the V$INSTANCE_RECOVERY view
    • C、 the OPTIMAL_LOGFILE_SIZE column of the V$INSTANCE_RECOVERY view
    • D、 the LOG_FILE_SIZE_REDO_BLKS column of the V$INSTANCE_RECOVERY view

    正确答案:C

  • 第16题：

    In a situation where no multiplexing of redo logs takes place, what happens when Oracle cannot read data from the online redo log group for archiving?（）

    • A、Nothing happens
    • B、Oracle will automatically switch redo logs when detected 
    • C、Oracle eventually won't allow new records to be added to the database 
    • D、The instance crashes

    正确答案:C

  • 第17题：

    A redo log file is corrupted while the database is open； as a consequence， database operations are stopped because archiving cannot continue. What would you do to solve the problem？（）

    • A、 clear the redo log group
    • B、 perform redo log file import
    • C、 perform an incomplete recovery
    • D、 perform a redo log recovery using Recovery Manager （RMAN）
    • E、 shut down the database and open the database in the NOARCHIVELOG mode

    正确答案:A

  • 第18题：

    You are working on a database， where you have three redo log groups. When the database is down for a backup， an operating system （OS） user deletes all the redo log files in a group. What will happen when you open your database？（）

    • A、 The instance starts， the database is mounted， but efforts to open the database fail， and an error about the missing redo log group is displayed.
    • B、 Before the instance starts， you receive an error about the missing redo log files of a group.
    • C、 The instance starts and the database opens with an error message written to the alert log file.
    • D、 The instance starts and the database opens because two redo log groups still exist.
    • E、 The instance starts and the database opens， but every attempt to write to redo log files fails with an error.

    正确答案:A

  • 第19题：

    多选题
    You are working on a test database where instance recovery takes a considerable amount of time.How can reduce the recovery time？（）
    A

    By multiplexing the control files

    B

    By multiplexing the redo log files

    C

    By decreasing the size of redo log files

    D

    By configuring mean time to recover （MTTR） to a lower value

    E

    By setting the UNDO_RETENTION parameter to a higher value


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

  • 第20题：

    多选题
    You configured the Flash Recovery Area （FRA） for your database. The database instance is running inARCHIVELOG mode. The default location for the archived redo log files is the Flash Recovery Area.  Which twofiles are removed automatically if the space is required in the FRA as per the retention policy（）
    A

    Flashback log files

    B

    Backups that have become obsolete

    C

    User managed backups of the data files and control files

    D

    Archived redo log files that have multiple copies in a different archive location and not backed up


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

  • 第21题：

    单选题
    You can control instance recover performance by setting parameters to define targets for（）
    A

    The size of the redo buffer in SGA. 

    B

    The instance that will perform recovery in Real Application Cluster database. 

    C

    The number of blocks to be read during instance recovery, or the time needed to complete instance recovery. 

    D

    The number of passes through the redo logs made by the recovery process to identify blocks needing recovery.


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

  • 第22题：

    单选题
    You are working on a database， where you have three redo log groups. When the database is down for a backup， an operating system （OS） user deletes all the redo log files in a group. What will happen when you open your database？（）
    A

     The instance starts， the database is mounted， but efforts to open the database fail， and an error about the missing redo log group is displayed.

    B

     Before the instance starts， you receive an error about the missing redo log files of a group.

    C

     The instance starts and the database opens with an error message written to the alert log file.

    D

     The instance starts and the database opens because two redo log groups still exist.

    E

     The instance starts and the database opens， but every attempt to write to redo log files fails with an error.


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

  • 第23题：

    单选题
    A redo log file is corrupted while the database is open； as a consequence， database operations are stopped because archiving cannot continue. What would you do to solve the problem？（）
    A

     clear the redo log group

    B

     perform redo log file import

    C

     perform an incomplete recovery

    D

     perform a redo log recovery using Recovery Manager （RMAN）

    E

     shut down the database and open the database in the NOARCHIVELOG mode


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

  • 第24题：

    多选题
    In which two cases would you perform only consistent backup？（）
    A

    You are working on a database where downtime is not tolerated.

    B

    You are working on a database where downtime can be tolerated.

    C

    You are working on a database that operates in ARCHIVELOG mode.

    D

    You are working on a database that operates in NOARCHIVELOG mode.

    E

    You are working on a database where all the tablespaces are locally managed.

    F

    You are working on a database where control files and redo log files are multiplexed.

    G

    You are working on a database where control files and redo log files are not multiplexed.


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

相关内容