niusouti.com

单选题Which of the following is not an advantage of block media recovery （BMR）？（）AReduced MTTR.BDatafiles remain offline while corrupt blocks are repaired.CDatafiles remain online while corrupt blocks are repaired.DA and C

题目
单选题
Which of the following is not an advantage of block media recovery （BMR）？（）
A

 Reduced MTTR.

B

 Datafiles remain offline while corrupt blocks are repaired.

C

 Datafiles remain online while corrupt blocks are repaired.

D

 A and C

相似考题

1.Which of the following is not an advantage of block media recovery （BMR）？（）A、 Reduced MTTR.B、 Datafiles remain offline while corrupt blocks are repaired.C、 Datafiles remain online while corrupt blocks are repaired.D、 A and C

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

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

4.Which of the following best describes a full backup? （）A、All datafiles of a database B、All datafiles, archive logs, and control files C、All datafiles and control files D、All the used blocks in a datafile

更多“单选题Which of the following is not an advantage of block media recovery （BMR）？（）A  Reduced MTTR.B  Datafiles remain offline while corrupt blocks are repaired.C  Datafiles remain online while corrupt blocks are repaired.D  A and C”相关问题

  • 第1题：

    You execute the following Recovery Manager （RMAN） commands in he following order：   BACKUP VALIDATE DATABAE RECOVER CORRUPTION LIST；   Which two tasks are performed by these commands？（）  

    • A、 Repair the corrupted blocks. If any. In the backup created
    • B、 Populate VSCOPV_CORRUPTION with names of files that have corrupted blocks
    • C、 Back up the database after checking whether array of the files have corrupted blocks
    • D、 Discover any corrupt blocks that are viewable with the VSDATABASE_BI-OCK_CORBUPTION view
    • E、 Repair all corrupted blocks that have been logged in the VSDATABASE_BLOCK_ CORRUPTION

    正确答案:B,C

  • 第2题：

    What are the two advantages of RMAN Block Media Recovery （BMR） over file/x7flevel 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 that requires a recovery can remain online.

    正确答案:A,F

  • 第3题：

    You execute the following RMAN commands in the order shown below：  BACKUP VALIDATE DATABASE;  BLOCKRECOVER CORRUPTION LIST;  What will these commands do？（）

    • A、create a backup of the database and recover all corrupted blocks found in the backup
    • B、run a backup validation and list all the logically corrupt blocks as well as physically corrupt blocks in the database
    • C、run a backup validation to populate V$COPY_CORRUPTION view， and then list any corrupt blocks recorded in the view
    • D、run a backup validation to populate V$DATABASE_BLOCK_CORRUPTION view， and then repair any corrupt blocks recorded in the view
    • E、run a backup validation， repair any corrupt blocks found during the validation process， and then update V$DATABASE_BLOCK_CORRUPTION view to indicate which corrupt blocks have been repaired

    正确答案:D

  • 第4题：

    You executed the following code：   BACKUP VALIDATE DATABASE；   BLOCKRECOVER CORRUPTION LIST；  What will be the result of executing the above code？（）  

    • A、 The code will run a backup validation to populate the V$BACKUP_CORRUPTION view and repair corrupt blocks， if any， recorded in the view.
    • B、 The code will run a backup validate to populate the V$COPY_CORRUPTION view and then repair any corrupt blocks recorded in the view.
    • C、 The code will runs a backup validate to populate the V$DATABASE_BLOCK_CORRUPTION view and then repair corrupt blocks， if any， recorded in the view.
    • D、 The code will run a backup validate to populate the RC_BACKUP_CORRUPTION view and then repair corrupt blocks， if any， recorded in the view.

    正确答案:C

  • 第5题：

    You execute the following RMAN command in the order shown below： BACKUP VALIDATE DATABASE； BLOCKRECOVER CORRUPTION LIST； What will these commands do？（）

    • A、 Create a backup of the database and recover all corrupted blocks found in the backup.
    • B、 Run a backup validation and list all the logically corrupt blocks as well as physically corrupt blocks in the database.
    • C、 Run a backup validation to populate V$COPY_CORRUPTION view， and then list any corrupt blocks recorded in the view.
    • D、 Run a backup validation to populate V$DATABASE_BLOCK_CORRUPTION view， and then repair any corrupt blocks recorded in the view.
    • E、 Run a backup validation， repair any corrupt blocks found during the validation process， and then update V$DATABASE_BLOCK_CORRUPTION view to indicate which corrupt blocks have been repaired.

    正确答案:D

  • 第6题：

    If you find errors in the view V$DATABASE_BLOCK_CORRUPTION with a status of MEDIA_CORRUPT， what RMAN command would you run to correct the problem？（）

    • A、 recover lost blocks
    • B、 recover corrupt blocks
    • C、 recover media corrupt blocks from list
    • D、 recover corrupt blocks from list
    • E、 recover corruption list

    正确答案:E

  • 第7题：

    单选题
    Which of the following is not an advantage of block media recovery （BMR）？（）
    A

     Reduced MTTR.

    B

     Datafiles remain offline while corrupt blocks are repaired.

    C

     Datafiles remain online while corrupt blocks are repaired.

    D

     A and C


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

  • 第8题：

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

  • 第9题：

    单选题
    Which of the following statement is incorrect regarding RMAN？（）
    A

    It detects corrupt blocks.

    B

    It performs only offline database backups.

    C

    It omits empty blocks during backups.

    D

    It performs tablespace point-in-time recovery （TSPITR）.


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

  • 第10题：

    单选题
    Users complain SQL statements using a particular index fail. Using DBVERIFY， you find that two separate blocks in the index have become corrupt. The database data files for user data and index are very large.  What is the least disruptive recover strategy available in Oracle9i？（）
    A

    Rebuild the index using the online option. 

    B

    Take the individual data file offline (not the whole tablespace), restore and recover the data file from backup with RMAN, then set the data file online again. 

    C

    Without setting the individual data file offline, use RMAN with Block Media Recovery to restore and recover only those blocks. 

    D

    Take the individual data file (not the whole tablespace) offline, use RMAN with Block Media Recovery to restore and recover only those blocks, then set the data file online again.


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

  • 第11题：

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


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

  • 第12题：

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


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

  • 第13题：

    Which of the following statement is incorrect regarding RMAN？（）

    • A、It detects corrupt blocks.
    • B、It performs only offline database backups.
    • C、It omits empty blocks during backups.
    • D、It performs tablespace point-in-time recovery （TSPITR）.

    正确答案:B

  • 第14题：

    You are performing a block media recovery on the tools01.dbf data file in the SALES database 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

  • 第15题：

    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.

    正确答案:B,D

  • 第16题：

    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.

    正确答案:A,F

  • 第17题：

    Users complain SQL statements using a particular index fail. Using DBVERIFY， you find that two separate blocks in the index have become corrupt. The database data files for user data and index are very large.  What is the least disruptive recover strategy available in Oracle9i？（）

    • A、Rebuild the index using the online option. 
    • B、Take the individual data file offline (not the whole tablespace), restore and recover the data file from backup with RMAN, then set the data file online again. 
    • C、Without setting the individual data file offline, use RMAN with Block Media Recovery to restore and recover only those blocks. 
    • D、Take the individual data file (not the whole tablespace) offline, use RMAN with Block Media Recovery to restore and recover only those blocks, then set the data file online again.

    正确答案:C

  • 第18题：

    单选题
    You execute the following RMAN command in the order shown below： BACKUP VALIDATE DATABASE； BLOCKRECOVER CORRUPTION LIST； What will these commands do？（）
    A

     Create a backup of the database and recover all corrupted blocks found in the backup.

    B

     Run a backup validation and list all the logically corrupt blocks as well as physically corrupt blocks in the database.

    C

     Run a backup validation to populate V$COPY_CORRUPTION view， and then list any corrupt blocks recorded in the view.

    D

     Run a backup validation to populate V$DATABASE_BLOCK_CORRUPTION view， and then repair any corrupt blocks recorded in the view.

    E

     Run a backup validation， repair any corrupt blocks found during the validation process， and then update V$DATABASE_BLOCK_CORRUPTION view to indicate which corrupt blocks have been repaired.


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

  • 第19题：

    单选题
    Which of the following best describes a full backup? （）
    A

    All datafiles of a database 

    B

    All datafiles, archive logs, and control files 

    C

    All datafiles and control files 

    D

    All the used blocks in a datafile


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

  • 第20题：

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


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

  • 第21题：

    单选题
    You execute the following RMAN commands in the order shown below：  BACKUP VALIDATE DATABASE;  BLOCKRECOVER CORRUPTION LIST;  What will these commands do？（）
    A

    create a backup of the database and recover all corrupted blocks found in the backup

    B

    run a backup validation and list all the logically corrupt blocks as well as physically corrupt blocks in the database

    C

    run a backup validation to populate V$COPY_CORRUPTION view， and then list any corrupt blocks recorded in the view

    D

    run a backup validation to populate V$DATABASE_BLOCK_CORRUPTION view， and then repair any corrupt blocks recorded in the view

    E

    run a backup validation， repair any corrupt blocks found during the validation process， and then update V$DATABASE_BLOCK_CORRUPTION view to indicate which corrupt blocks have been repaired


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

  • 第22题：

    单选题
    You executed the following code：   BACKUP VALIDATE DATABASE；   BLOCKRECOVER CORRUPTION LIST；  What will be the result of executing the above code？（）
    A

     The code will run a backup validation to populate the V$BACKUP_CORRUPTION view and repair corrupt blocks， if any， recorded in the view.

    B

     The code will run a backup validate to populate the V$COPY_CORRUPTION view and then repair any corrupt blocks recorded in the view.

    C

     The code will runs a backup validate to populate the V$DATABASE_BLOCK_CORRUPTION view and then repair corrupt blocks， if any， recorded in the view.

    D

     The code will run a backup validate to populate the RC_BACKUP_CORRUPTION view and then repair corrupt blocks， if any， recorded in the view.


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

  • 第23题：

    单选题
    If you find errors in the view V$DATABASE_BLOCK_CORRUPTION with a status of MEDIA_CORRUPT， what RMAN command would you run to correct the problem？（）
    A

     recover lost blocks

    B

     recover corrupt blocks

    C

     recover media corrupt blocks from list

    D

     recover corrupt blocks from list

    E

     recover corruption list


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

  • 第24题：

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


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

相关内容