网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)
多选题
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.


参考答案

参考解析
解析: 暂无解析
更多 “多选题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 performed using cumulative incremental backups.EThe datafile must be restored if most of the blocks in the datafile are corrupt.” 相关考题
考题 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

考题 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

考题 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.

考题 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

考题 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.

考题 Which two statements are true about L2TP tunnels?() (Choose two.)A、Traffic is clear textB、Traffic is encryptedC、They are initiated by the LNSD、They are initiated by the LAC

考题 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.

考题 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.

考题 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.

考题 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.

考题 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_CORRUPTIONB、 V$COPY_CORRUPTIONC、 V$DATABASE_BLOCK_CORRUPTIOND、 RC_BACKUP_CORRUPTION

考题 Which of the following are correct about block media recovery?()A、 Physical and logical block corruption is recorded automatically in V$DATABASE_BLOCK_ CORRUPTIONB、 Logical corruptions are repairable by BMRC、 Physical corruptions are repairable by BMRD、 RMAN can use any backup for a BMR restoreE、 ARCHIVELOG mode is not required if you have both a full and incremental backup for restore

考题 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 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

考题 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.

考题 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.

考题 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.

考题 多选题Which two statements are true about L2TP tunnels?() (Choose two.)ATraffic is clear textBTraffic is encryptedCThey are initiated by the LNSDThey are initiated by the LAC

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

考题 多选题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?()ABackup compression should be enabledBParallelism for the channel should be set to 2CAll the files must be backed up as backup setsDThe backup may be stored either on disk or on media with media manager

考题 多选题To enable faster incremental backups, you enabled block change tracking for the database.Which two statements are true about the block change tracking file?()AMultiple change tracking files can be created for a database.BThe change tracking file must be created after the first level 0 backup.CRMAN does not support backup and recovery of the change tracking file.DThe database clears the change tracking file and starts tracking changes again, after whole database restore and recovery operations.

考题 多选题What are the two advantages of RMAN Block Media Recovery (BMR) over file-level recovery?()ABMR lowers the mean time to recover (MTTR).BBMR supports point-in-time recovery of individual data blocks.CBMR enables you to use incremental backups for block recovery.DBMR enables recovery even when the database is not mounted or open.EBMR enables you to use proxy backups to perform block media recovery.FBMR enables increased availability of data during recovery because the data file requires a recovery can remain online.

考题 多选题Which two statements are true about the RMAN validate database command?()AIt checks the database for intrablock corruptions.BIt can detect corrupt pfiles.CIt can detect corrupt spfiles.DIt checks the database for interblock corruptions.EIt can detect corrupt block change tracking files.

考题 多选题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.)ABackup compression should be enabledBParallelism for the channel should be set to 2CAll the files must be backed up as backup setsDThe backup may be stored either on disk or on media with media manager

考题 多选题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)AYou must configure block change tracking fileBYou must have first level 1 backups for RMAN to restore blocksCYou must ensure that the SALES database is mounted or openDYou must have full or level 0 backups for RMAN to restore blocksEYou must take the tools01.dbf data file offline before you start a block media recovery

考题 多选题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?()AYou must configure block change tracking fileBYou must have first level 1 backups for RMAN to restore blocksCYou must ensure that the SALES database is mounted or openDYou must have full or level 0 backups for RMAN to restore blocksEYou must take the tools01.dbf data file offline before you start a block media recovery

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

考题 多选题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.)AMultiple change tracking files can be created for a database.BThe change tracking file must be created after the first level 0 backup.CRMAN does not support backup and recovery of the change tracking file.DThe database clears the change tracking file and starts tracking changes again, after whole database restore and recovery operations.