多选题Which two statements are true about Block Media Recovery （BMR）？（）ABMR increases the Mean Time To Recover （MTTR）.BBMR can only be implemented using Recovery Manager （RMAN）.CThe blocks that need to be recovered are accessible during BMR.DBMR cannot be pe

题目
多选题
Which two statements are true about Block Media Recovery （BMR）？（）
A

BMR increases the Mean Time To Recover （MTTR）.

B

BMR can only be implemented using Recovery Manager （RMAN）.

C

The blocks that need to be recovered are accessible during BMR.

D

BMR cannot be performed using cumulative incremental backups.

E

The datafile must be restored if most of the blocks in the datafile are corrupt.

相似考题

1.You want to take a complete database backup using RMAN. The backup should consist only the used blocks from your database.Which two statements are true about this backup operation?()A. Backup compression should be enabledB. Parallelism for the channel should be set to 2C. All the files must be backed up as backup setsD. The backup may be stored either on disk or on media with media manager

2.To enable faster incremental backups, you enabled block change tracking for the database.Which two statements are true about the block change tracking file? ()(Choose two.)A. Multiple change tracking files can be created for a database.B. The change tracking file must be created after the first level 0 backup.C. RMAN does not support backup and recovery of the change tracking file.D. The database clears the change tracking file and starts tracking changes again, after whole database restore and recovery operations.

3.You need to perform a block media recovery on the tools01.dbf data file in the SALES database by using Recovery Manager (RMAN).Which two are the prerequisites to perform this operation? ()(Choose two)A. You must configure block change tracking fileB. You must have first level 1 backups for RMAN to restore blocksC. You must ensure that the SALES database is mounted or openD. You must have full or level 0 backups for RMAN to restore blocksE. You must take the tools01.dbf data file offline before you start a block media recovery

4.You need to perform a block media recovery on the tools01.dbf data file in the SALES database by using Recovery Manager (RMAN).Which two are the prerequisites to perform this operation?()A. You must configure block change tracking fileB. You must have first level 1 backups for RMAN to restore blocksC. You must ensure that the SALES database is mounted or openD. You must have full or level 0 backups for RMAN to restore blocksE. You must take the tools01.dbf data file offline before you start a block media recovery

更多“Which two statements are true about Block Media Recovery （BM”相关问题

  • 第1题：

    Which two statements are true about the RMAN validate database command?()

    A. It checks the database for intrablock corruptions.

    B. It can detect corrupt pfiles.

    C. It can detect corrupt spfiles.

    D. It checks the database for interblock corruptions.

    E. It can detect corrupt block change tracking files.


    参考答案：A, C

  • 第2题：

    Which two statements are true about the RMAN validate database command?（）

    • A、It checks the database for intrablock corruptions.
    • B、It can detect corrupt pfiles.
    • C、It can detect corrupt spfiles.
    • D、It checks the database for interblock corruptions.
    • E、It can detect corrupt block change tracking files.

    正确答案:A,C

  • 第3题：

    You are in the middle of a transaction and very crucial data has been modified. Because of a hardware failure， the instance has shut down before synchronizing all the database files. Which two statements are true？（）

    • A、On startup， SMON coordinates instance recovery.
    • B、On startup， CKPT coordinates instance recovery.
    • C、On startup， use RMAN to perform instance recovery.
    • D、Uncommitted changes will be rolled back after the database is opened.
    • E、On startup， perform media recovery and then instance recovery.
    • F、On startup， all the files will be synchronized and you get both committed and uncommitted data.

    正确答案:A,D

  • 第4题：

    You are using the Block Media Recovery feature to recover the blocks that are marked corrupt since the last backup. Which view will you query to display information about the data blocks that are marked corrupt since the last backup？（）

    • A、 V$BACKUP_CORRUPTION
    • B、 V$COPY_CORRUPTION
    • C、 V$DATABASE_BLOCK_CORRUPTION
    • D、 RC_BACKUP_CORRUPTION

    正确答案:C

  • 第5题：

    You want to take a complete database backup using RMAN. The backup should consist only the used blocks from your database. Which two statements are true about this backup operation? （）(Choose two.)

    • A、Backup compression should be enabled
    • B、Parallelism for the channel should be set to 2
    • C、All the files must be backed up as backup sets
    • D、The backup may be stored either on disk or on media with media manager

    正确答案:C,D

  • 第6题：

    Which two statements about Flashback Query are true？（）

    • A、It is generated by using the redo log files. 
    • B、It helps in row-level recovery from user errors.
    • C、It can be performed to recover ALTER TABLE statements 
    • D、It fails when undo data pertaining to the transaction is overwritten.
    • E、The database has to be opened with the resetlogs option after performing Flashback Query.

    正确答案:B,D

  • 第7题：

    多选题
    Which two statements are true about L2TP tunnels?（） (Choose two.)
    A

    Traffic is clear text

    B

    Traffic is encrypted 

    C

    They are initiated by the LNS

    D

    They are initiated by the LAC


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

  • 第8题：

    多选题
    You want to take a complete database backup using RMAN. The backup should consist only the used blocks from your database.Which two statements are true about this backup operation?（）
    A

    Backup compression should be enabled

    B

    Parallelism for the channel should be set to 2

    C

    All the files must be backed up as backup sets

    D

    The backup may be stored either on disk or on media with media manager


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

  • 第9题：

    多选题
    To enable faster incremental backups, you enabled block change tracking for the database.Which two statements are true about the block change tracking file?（）
    A

    Multiple change tracking files can be created for a database.

    B

    The change tracking file must be created after the first level 0 backup.

    C

    RMAN does not support backup and recovery of the change tracking file.

    D

    The database clears the change tracking file and starts tracking changes again, after whole database restore and recovery operations.


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

  • 第10题：

    多选题
    Which two statements are true about the RMAN validate database command?（）
    A

    It checks the database for intrablock corruptions.

    B

    It can detect corrupt pfiles.

    C

    It can detect corrupt spfiles.

    D

    It checks the database for interblock corruptions.

    E

    It can detect corrupt block change tracking files.


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

  • 第11题：

    多选题
    You need to perform a block media recovery on the tools01.dbf data file in the SALES database by using Recovery Manager (RMAN). Which two are the prerequisites to perform this operation? （）(Choose two)
    A

    You must configure block change tracking file

    B

    You must have first level 1 backups for RMAN to restore blocks

    C

    You must ensure that the SALES database is mounted or open

    D

    You must have full or level 0 backups for RMAN to restore blocks

    E

    You must take the tools01.dbf data file offline before you start a block media recovery


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

  • 第12题：

    单选题
    While working on the database， you receive the following error：        01578： ORACLE data block corrupted （file# 6， block # 54）        ORA-01110 ： data file 6： ’u01/oracle/oradata/data1.dbf’   You decide to recover the corrupted data block by using the Block Media Recovery feature. Which option is NOT a disadvantage of using block media recovery？（）
    A

     Block Media Recovery must be used with RMAN.

    B

     You must perform complete recovery of individual blocks.

    C

     You must have a full RMAN backup， not an incremental backup.

    D

     You must use the DBVERIFY utility before using the Block Media Recovery feature.


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

  • 第13题：

    Which two statements are true about L2TP tunnels?（） (Choose two.)

    • A、Traffic is clear text
    • B、Traffic is encrypted 
    • C、They are initiated by the LNS
    • D、They are initiated by the LAC

    正确答案:A,D

  • 第14题：

    Which of the following statements is NOT true about RMAN？（）

    • A、It improves usability by enabling you to reuse the scripts to perform recovery operations.
    • B、It detects block corruption while restoration and recovery operations.
    • C、It enables you to perform block media recovery.
    • D、It is capable to recover through unrecoverable operations， with only full database backups.

    正确答案:A

  • 第15题：

    Which two statements are true about precedence values in policy?（） (Choose two.)

    • A、1 is the default precedence.
    • B、A lower number is preferred.
    • C、A higher number is preferred.
    • D、100 is the default precedence.

    正确答案:B,D

  • 第16题：

    Which of the following are correct about block media recovery？（）

    • A、 Physical and logical block corruption is recorded automatically in V$DATABASE_BLOCK_ CORRUPTION
    • B、 Logical corruptions are repairable by BMR
    • C、 Physical corruptions are repairable by BMR
    • D、 RMAN can use any backup for a BMR restore
    • E、 ARCHIVELOG mode is not required if you have both a full and incremental backup for restore

    正确答案:A,C

  • 第17题：

    To enable faster incremental backups， you enabled block change tracking for the database. Which two statements are true about the block change tracking file？（） 

    • A、 Multiple change tracking files can be created for a database.
    • B、 The change tracking file must be created after the first level 0 backup.
    • C、 RMAN does not support backup and recovery of the change tracking file.
    • D、 The database clears the change tracking file and starts tracking changes again，after whole database restore and recovery operations.

    正确答案:C,D

  • 第18题：

    You are performing a block media recovery on the tools01.dbf data file in the SALES database by using RMAN.   Which two statements are correct in this scenario？（）

    • A、You must ensure that the SALES database is mounted or open.
    • B、You must restore a backup control file to perform a block media recovery.
    • C、You must take the tools01.dbf data file offline before you start a block media recovery.
    • D、You must put the database in NOARCHIVELOG mode to perform a block media recovery.
    • E、You can perform only a complete media recovery of individual blocks； point-in-time recovery of  individual data blocks is not supported.

    正确答案:A,E

  • 第19题：

    单选题
    Which of the following statements is NOT true about RMAN？（）
    A

    It improves usability by enabling you to reuse the scripts to perform recovery operations.

    B

    It detects block corruption while restoration and recovery operations.

    C

    It enables you to perform block media recovery.

    D

    It is capable to recover through unrecoverable operations， with only full database backups.


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

  • 第20题：

    多选题
    Which two statements are true about Block Media Recovery （BMR）？（）
    A

    BMR increases the Mean Time To Recover （MTTR）.

    B

    BMR can only be implemented using Recovery Manager （RMAN）.

    C

    The blocks that need to be recovered are accessible during BMR.

    D

    BMR cannot be performed using cumulative incremental backups.

    E

    The datafile must be restored if most of the blocks in the datafile are corrupt.


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

  • 第21题：

    多选题
    What are the two advantages of RMAN Block Media Recovery （BMR） over file-level recovery？（）
    A

    BMR lowers the mean time to recover （MTTR）.

    B

    BMR supports point-in-time recovery of individual data blocks.

    C

    BMR enables you to use incremental backups for block recovery.

    D

    BMR enables recovery even when the database is not mounted or open.

    E

    BMR enables you to use proxy backups to perform block media recovery.

    F

    BMR enables increased availability of data during recovery because the data file requires a recovery can remain online.


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

  • 第22题：

    多选题
    You want to take a complete database backup using RMAN. The backup should consist only the used blocks from your database. Which two statements are true about this backup operation? （）(Choose two.)
    A

    Backup compression should be enabled

    B

    Parallelism for the channel should be set to 2

    C

    All the files must be backed up as backup sets

    D

    The backup may be stored either on disk or on media with media manager


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

  • 第23题：

    多选题
    You need to perform a block media recovery on the tools01.dbf data file in the SALES database by using Recovery Manager (RMAN).Which two are the prerequisites to perform this operation？（）
    A

    You must configure block change tracking file

    B

    You must have first level 1 backups for RMAN to restore blocks

    C

    You must ensure that the SALES database is mounted or open

    D

    You must have full or level 0 backups for RMAN to restore blocks

    E

    You must take the tools01.dbf data file offline before you start a block media recovery


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

  • 第24题：

    多选题
    To enable faster incremental backups, you enabled block change tracking for the database.Which two statements are true about the block change tracking file? （）(Choose two.)
    A

    Multiple change tracking files can be created for a database.

    B

    The change tracking file must be created after the first level 0 backup.

    C

    RMAN does not support backup and recovery of the change tracking file.

    D

    The database clears the change tracking file and starts tracking changes again, after whole database restore and recovery operations.


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

相关内容