多选题Which three features are provided by Recovery Manager and NOT provided by user-managed backup and recovery？（）AOnline backups.BSkipping unused block.CPartial database backups.DIncremental block-level backup.EDetection of corrupted blocks during backup.

题目
多选题
Which three features are provided by Recovery Manager and NOT provided by user-managed backup and recovery？（）
A

Online backups.

B

Skipping unused block.

C

Partial database backups.

D

Incremental block-level backup.

E

Detection of corrupted blocks during backup.

相似考题

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.You work as a database administrator for Supportcenter.cn. You are using Recovery Manager （RMAN） to perform backups in your databases. Which four backup operations can be performed using RMAN？（）A、A backup of the target database when it is mountedB、A backup of online redo log files when the database is openC、A backup of only used data blocks in the file beingbeingbackup upD、A backup of online， read/write data files when the database is openE、A backup of only those data blocks that have changed since a previous backupF、A backup of online， read/write data files when the database is in the NOMOUNT state.

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

4.Examine the following scenario:-Database is running in ARCHIVELOG mode.-Complete consistent backup is taken every Sunday.-On Tuesday the instance terminates abnormally because the disk on which control files are located gets corrupted-The disk having active online redo log files is also corrupted.-The hardware is repaired and the paths for online redo log files and control files are still valid.Which option would you use to perform the recovery of database till the point of failure?（）A. Restore the latest whole backup, perform complete recovery, and open the database normallyB. Restore the latest whole backup, perform incomplete recovery, and open the database with the RESETLOGS optionC. Restore the latest backups control file, perform complete recovery, and open the database with the RESETLOGS optionD. Restore the latest backup control file, perform incomplete recovery using backup control file, and open the database with the RESETLOG option

更多“多选题Which three features are provided by Recovery Manager and NOT provided by user-managed backup and recovery？（）AOnline backups.BSkipping unused block.CPartial database backups.DIncremental block-level backup.EDetection of corrupted blocks during backup.”相关问题

  • 第1题：

    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

  • 第2题：

    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

  • 第3题：

    Identify two situations in which you can use Data Recovery Advisor for recovery.（） 

    • A、 The user has dropped an important table that needs to be recovered.
    • B、 The database files are corrupted when the database is open.
    • C、 You are not able to start up the database instance because the required database files are missing.
    • D、 The archived log files are missing for which backup is not available.

    正确答案:B,C

  • 第4题：

    You work as a database administrator for Certkiller .com. According to your backup strategy， you performed an incremental level 0 backup of your database. Which statement regarding this backup is true？（）

    • A、The backup is similar to image copy.
    • B、The backup contains all used data blocks.
    • C、The backup contains only unused data blocks.
    • D、The backup contains all data blocks changed since the last incremental level 1 backup.

    正确答案:B

  • 第5题：

    For an incomplete recovery， which four backup types can be used by Recovery Manager （RMAN） to restore data files？（）

    • A、 RMAN image copies.
    • B、 RMAN database backups.
    • C、 RMAN tablespace backups.
    • D、 User-managed backups placed in the flash recovery area.
    • E、 User-managed backups that have been cataloged with RMAN.
    • F、 User-managed data file backups for which the pull path name is specified.

    正确答案:A,B,C,E

  • 第6题：

    According to your backup strategy， you performed an incremental level 0 backup of your database. Which statement regarding this backup is true？（）

    • A、The backup is similar to image copy.
    • B、The backup contains all used data blocks.
    • C、The backup contains only unused data blocks.
    • D、The backup contains all data blocks changed since the last incremental level 1 backup.

    正确答案:B

  • 第7题：

    多选题
    Which two are characteristics of user-managed backup and recovery operations？（）
    A

    Recovery is initiated using SQL*Plus.

    B

    Database files are backed up using SQL commands.

    C

    Database files are backed up with Recovery Manager.

    D

    Database files are restored using Recovery Manager.

    E

    Database files are backed up using operating system commands.


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

  • 第8题：

    单选题
    Examine the following scenario: -Database is running in ARCHIVELOG mode. -Complete consistent backup is taken every Sunday. -On Tuesday the instance terminates abnormally because the disk on which control files are located gets corrupted -The disk having active online redo log files is also corrupted. -The hardware is repaired and the paths for online redo log files and control files are still valid. Which option would you use to perform the recovery of database till the point of failure?（）
    A

    Restore the latest whole backup, perform complete recovery, and open the database normally

    B

    Restore the latest whole backup, perform incomplete recovery, and open the database with the RESETLOGS option

    C

    Restore the latest backups control file, perform complete recovery, and open the database with the RESETLOGS option

    D

    Restore the latest backup control file, perform incomplete recovery using backup control file, and open the database with the RESETLOG option


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

  • 第9题：

    多选题
    Identify two situations in which you can use Data Recovery Advisor for recovery. （）(Choose two.)
    A

    The user has dropped an important table that needs to be recovered.

    B

    The database files are corrupted when the database is open.

    C

    You are not able to start up the database instance because the required database files are missing.

    D

    The archived log files are missing for which backup is not available.


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

  • 第10题：

    多选题
    Which three features are provided by Recovery Manager and NOT provided by user-managed backup and recovery？（）
    A

    Online backups.

    B

    Skipping unused block.

    C

    Partial database backups.

    D

    Incremental block-level backup.

    E

    Detection of corrupted blocks during backup.


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

  • 第11题：

    单选题
    According to your backup strategy， you performed an incremental level 0 backup of your database. Which statement regarding this backup is true？（）
    A

    The backup is similar to image copy.

    B

    The backup contains all used data blocks.

    C

    The backup contains only unused data blocks.

    D

    The backup contains all data blocks changed since the last incremental level 1 backup.


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

  • 第12题：

    多选题
    Identify two situations in which you can use Data Recovery Advisor for recovery.（）
    A

    The user has dropped an important table that needs to be recovered.

    B

    The database files are corrupted when the database is open.

    C

    You are not able to start up the database instance because the required database files are missing.

    D

    The archived log files are missing for which backup is not available.


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

  • 第13题：

    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

  • 第14题：

    Which two are characteristics of user-managed backup and recovery operations？（）

    • A、Recovery is initiated using SQL*Plus.
    • B、Database files are backed up using SQL commands.
    • C、Database files are backed up with Recovery Manager.
    • D、Database files are restored using Recovery Manager.
    • E、Database files are backed up using operating system commands.

    正确答案:A,B

  • 第15题：

    Which three types of files can be automatically placed in the flash recovery area (fast recovery area in 11g Release 2)?（） (Choose three.)

    • A、Alert log file
    • B、Archived redo log files
    • C、Control file autobackups
    • D、Server Parameter file (SPFILE)
    • E、Recovery Manager (RMAN) backup piece

    正确答案:B,C,E

  • 第16题：

    Examine the following scenario：   -Database is running in ARCHIVELOG mode.  -Complete consistent backup is taken every Sunday.  -On Tuesday the instance terminates abnormally because the disk on which control files are located gets corruptedThe disk having active online redo log files is also corrupted.  The hardware is repaired and the paths for online redo log files and control files are still valid.  Which option would you use to perform the recovery of database till the point of failure？（）  

    • A、 Restore the latest whole backup，perform complete recovery，and open the database normally 
    • B、 Restore the latest whole backup，perform incomplete recovery，and open the database with the  RESETLOGS option.
    • C、 Restore the latest backups control file，perform complete recovery，and open the database with the RESETLOGS option.
    • D、 Restore the latest backup control file，perform incomplete recovery using backup control file，and open the database with the RESETLOG option.

    正确答案:D

  • 第17题：

    Which three features are provided by Recovery Manager and NOT provided by user-managed backup and recovery？（）

    • A、Online backups.
    • B、Skipping unused block. 
    • C、Partial database backups.
    • D、Incremental block-level backup.
    • E、Detection of corrupted blocks during backup.

    正确答案:B,D,E

  • 第18题：

    多选题
    You work as a database administrator for Supportcenter.cn. You are using Recovery Manager （RMAN） to perform backups in your databases. Which four backup operations can be performed using RMAN？（）
    A

    A backup of the target database when it is mounted

    B

    A backup of online redo log files when the database is open

    C

    A backup of only used data blocks in the file beingbeingbackup up

    D

    A backup of online， read/write data files when the database is open

    E

    A backup of only those data blocks that have changed since a previous backup

    F

    A backup of online， read/write data files when the database is in the NOMOUNT state.


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

  • 第19题：

    多选题
    Which three types of files can be automatically placed in the flash recovery area (fast recovery area in 11g Release 2)?（） (Choose three.)
    A

    Alert log file

    B

    Archived redo log files

    C

    Control file autobackups

    D

    Server Parameter file (SPFILE)

    E

    Recovery Manager (RMAN) backup piece


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

  • 第20题：

    多选题
    Which two statements about Recovery Manager （RMAN） backups are true？ （）
    A

    Online redo log files can be backed up.

    B

    Archived redo log files are backed up.

    C

    Only used data blocks can be backed up as backup sets.

    D

    Only consistent database backups can be performed.

    E

    RMAN backup can be taken only if the database is configured in ARCHIVELOG mode.


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

  • 第21题：

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


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

  • 第22题：

    多选题
    For an incomplete recovery， which four backup types can be used by Recovery Manager （RMAN） to restore data files？ （）
    A

    RMAN image copies

    B

    RMAN database backups

    C

    RMAN tablespace backups

    D

    user­managed backups placed in the flash recovery area

    E

    user­managed backups that have been cataloged with RMAN

    F

    user­managed data file backups for which the full path name is specified


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

  • 第23题：

    单选题
    You work as a database administrator for Certkiller .com. According to your backup strategy， you performed an incremental level 0 backup of your database. Which statement regarding this backup is true？（）
    A

    The backup is similar to image copy.

    B

    The backup contains all used data blocks.

    C

    The backup contains only unused data blocks.

    D

    The backup contains all data blocks changed since the last incremental level 1 backup.


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

  • 第24题：

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

相关内容