多选题Which two activities are NOT supported by the Data Recovery Advisor?（）ADiagnose and repair a data file corruption offline.BDiagnose and repair a data file corruption online.CDiagnose and repair failures on a standby database.DRecover from failures in t

题目
多选题
Which two activities are NOT supported by the Data Recovery Advisor?（）
A

Diagnose and repair a data file corruption offline.

B

Diagnose and repair a data file corruption online.

C

Diagnose and repair failures on a standby database.

D

Recover from failures in the Real Application Cluster (RAC) environment.

相似考题

1.Examine the following RMAN script:Which statement describes the purpose of the script?()A. The data file is checked for physical corruption and backed up if found clean.B. The backup of data file 5 is performed and the interactive messages during the backup are suppressed.C. The existing backup for the data file is checked and the backup is performed if there are changes in the data file after the last backup.D. The backup of data file 5 is performed and all SQL statements that are executed during RMAN compilation and their results are displayed

2.Which two activities are NOT supported by the Data Recovery Advisor?()A. Diagnose and repair a data file corruption offline.B. Diagnose and repair a data file corruption online.C. Diagnose and repair failures on a standby database.D. Recover from failures in the Real Application Cluster (RAC) environment.

3.Which two kinds of failures make the Data Recovery Advisor (DRA)generate a manual checklist? ()A. failures because a data file is renamed by errorB. failures when no standby database is configuredC. failures that require no archive logs to be applied for recoveryD. failures due to loss of connectivity-for example, an unplugged disk cable

4.View the Exhibit to examine the error while executing the REPAIR FAILURE command in an RMAN session.What is the reason for this error?()A. Another repair session is running concurrently.B. The failure ID has not been mentioned in the command for data file 5.C. There are new failures recorded in the Automatic Diagnostic Repository (ADR).D. The ADVISE FAILURE command has not been issued before the REPAIR FAILURE command.

更多“多选题Which two activities are NOT supported by the Data Recovery Advisor?（）ADiagnose and repair a data file corruption offline.BDiagnose and repair a data file corruption online.CDiagnose and repair failures on a standby database.DRecover from failures in t”相关问题

  • 第1题：

    Which  kinds of failures make the Data Recovery Advisor （DRA） generate a manual checklist？（）

    • A、Failure when no standby database is configured
    • B、Failure because a data file is renamed accidentally
    • C、Failure that requires no archive logs to be applied for recovery
    • D、Failure due to loss of connectivity-for example， an unplugged disk cable

    正确答案:B,D

  • 第2题：

    A client has been unable to fix corruption of system files and does not have a backup or an Automated System Recovery (ASR) disk. Which of the following is the BEST action to take next? （）

    • A、Copy the missing file from another computer and reboot.
    • B、Execute a Windows repair from the Windows setup media.
    • C、Boot into the Recovery Console and execute FIXBOOT.
    • D、Reboot and press the F2 key when prompted.

    正确答案:B

  • 第3题：

    Your database is open and running in ARCHIVELOG mode. You take RMAN full backups every Sunday night. On Monday morning， while querying the user1.employees table， you receive the following error message：  01578： ORACLE data block corrupted （file # 5， block # 51） ORA-01110： data file 5：  ’/u01/app/oracle/oradata/orcl/example01.dbf’  You need to rectify the corruption while ensuring the following： The data file should remain online.  The mean time to recover （MTTR） should be minimal.  You are not using a backup control file， and all the archived logs are accessible.   Which option would you choose？（）

    • A、flash back the corrupted blocks
    • B、use the DBMS_REPAIR package
    • C、use the RMAN TSPITR command
    • D、use the RMAN BLOCKRECOVER command
    • E、use the RESTORE DATABASE and RECOVER DATABASE commands
    • F、investigate the time at which the corruption occurred and perform a point-in-time recovery

    正确答案:D

  • 第4题：

    Which two kinds of failures make the Data Recovery Advisor （DRA） generate a manual checklist（）

    • A、failure when no standby database is configured
    • B、failure because a data file is renamed accidentally
    • C、failure that requires no archive logs to be applied for recovery
    • D、failure due to loss of connectivity-for example， an unplugged disk cable

    正确答案:B,D

  • 第5题：

    You issued the following command to analyze the SCOTT.EMP table for block corruption：   ANALYZE TABLE SCOTT.EMP VALIDATE STRUCTURE；  You received the following error：   ORA-01578： ORACLE data block corrupted  （file # %s， block # %s）   How will you resolve the block corruption problem？（）

    • A、 by using the DBMS_REPAIR package
    • B、 by using the DB_BLOCK_CHECKING parameter
    • C、 by using the DBVERIFY utility
    • D、 will not be completely resolved until the hardware fault is corrected

    正确答案:D

  • 第6题：

    Which two kinds of failures make the Data Recovery Advisor (DRA)generate a manual checklist? （）

    • A、failures because a data file is renamed by error
    • B、failures when no standby database is configured
    • C、failures that require no archive logs to be applied for recovery
    • D、failures due to loss of connectivity-for example, an unplugged disk cable

    正确答案:A,D

  • 第7题：

    Which two activities are NOT supported by the Data Recovery Advisor （DRA）（）

    • A、Recover from failures in the RAC environment.
    • B、Diagnose and repair a data file corruption online.
    • C、Diagnose and repair a data file corruption offline.
    • D、Diagnose and repair failures on a standby database

    正确答案:A,D

  • 第8题：

    单选题
    You issue the following statement：   SQL> SELECT FIRSTNAME， LASTNAME FROM HR.EMPLOYEE；  You receive the following error：         01578： ORACLE data block corrupted （file# 6， block # 54）        ORA-01110 ： data file 6： ’u01/oracle/oradata/data1.dbf’   How will you resolve this problem of data block corruption by reducing the mean time to recover （MTTR）？（）
    A

     by using the DBMS_REPAIR package

    B

     by using the DBVERIFY utility

    C

     by using Block Media Recovery

    D

     by issuing the ANALYZE TABLE HR.EMPLOYEES VALIDATE STRUCTURE command


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

  • 第9题：

    多选题
    Which  kinds of failures make the Data Recovery Advisor （DRA） generate a manual checklist？（）
    A

    Failure when no standby database is configured

    B

    Failure because a data file is renamed accidentally

    C

    Failure that requires no archive logs to be applied for recovery

    D

    Failure due to loss of connectivity-for example， an unplugged disk cable


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

  • 第10题：

    单选题
    A data file become corrupted in your database due to bad sectors on the disk. Because of corruption， you lost all the important tables in that data file. Which method would you use for recovery？（）
    A

     Flash back all the tables in the data file， one by one.

    B

     Restore the data file to a new location and perform a media recovery.

    C

     Flash back the database， there is no need to restore the data file.

    D

     Restore the data file from the most recent backup and flash the database.


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

  • 第11题：

    多选题
    Which two activities are NOT supported by the Data Recovery Advisor DRA（）
    A

    Recover from failures in the RAC environment.

    B

    Diagnose and repair a data file corruption online.

    C

    Diagnose and repair a data file corruption offline.

    D

    Diagnose and repair failures on a standby database


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

  • 第12题：

    多选题
    While querying the EMPLOYEES table， you receive an ORA-01578 message indicating block corruption in File# 1201 and Block# 1968. You analyze the table and the corruption is verified.  Which RMAN command do you use to perform BMR and repair the corrupt block？（）
    A

    RECOVER FILE=1201 BLOCK=1968

    B

    RECOVER CORRUPTION LIST

    C

    RECOVER DATAFILE 1201 BLOCK 1968

    D

    RECOVER BLOCK CORRUPTION LIST

    E

    None of the above


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

  • 第13题：

    A data file became corrupted in your database due to bad sectors on the disk. Because of corruption， you lost all the important tables in that data file. Which method would you use for recovery？（）

    • A、flash back all the tables in the data file， one by one
    • B、restore the data file to a new location and perform a media recovery
    • C、flash back the database; there is no need to restore the data file
    • D、restore the data file from the most recent backup and flash back the database

    正确答案:B

  • 第14题：

    Which two activities are NOT supported by the Data Recovery Advisor?（）

    • A、Diagnose and repair a data file corruption offline.
    • B、Diagnose and repair a data file corruption online.
    • C、Diagnose and repair failures on a standby database.
    • D、Recover from failures in the Real Application Cluster (RAC) environment.

    正确答案:C,D

  • 第15题：

    You work as a database administrator at Certkiller .com. Your database is open and running in ARCHIVELOGmode. You take RMANfull backups every Sunday night. On Monday morning， while querying the user1.employeestable， you receive the following error message：  01578： ORACLE data block corrupted （file # 5， block # 51）  ORA-01110： data file 5：’/u01/app/oracle/oradata/orcl/example01.dbf’  You need to rectify the corruption while ensuring the following：  The data file should remain online.  The mean time to recover （MTTR） should be minimal.  You are not using a backup control file and all the archived logs are accessible.  Which option would you choose？（）

    • A、 flash back the corrupted blocks
    • B、 use the DBMS_REPAIR package
    • C、 use the RMAN TSPITR command
    • D、 use the RMAN BLOCKRECOVER command
    • E、 use the RESTORE DATABASE and RECOVER DATABASE commands
    • F、 investigate the time at which the corruption occurred and perform a point-in-time recovery

    正确答案:D

  • 第16题：

    A data file become corrupted in your database due to bad sectors on the disk. Because of corruption， you lost all the important tables in that data file. Which method would you use for recovery？（）

    • A、 Flash back all the tables in the data file， one by one.
    • B、 Restore the data file to a new location and perform a media recovery.
    • C、 Flash back the database， there is no need to restore the data file.
    • D、 Restore the data file from the most recent backup and flash the database.

    正确答案:B

  • 第17题：

    While querying the EMPLOYEES table， you receive an ORA-01578 message indicating block corruption in File# 1201 and Block# 1968. You analyze the table and the corruption is verified.  Which RMAN command do you use to perform BMR and repair the corrupt block？（）  

    • A、 RECOVER FILE=1201 BLOCK=1968
    • B、 RECOVER CORRUPTION LIST
    • C、 RECOVER DATAFILE 1201 BLOCK 1968
    • D、 RECOVER BLOCK CORRUPTION LIST
    • E、 None of the above

    正确答案:B,C

  • 第18题：

    You issue the following statement：   SQL> SELECT FIRSTNAME， LASTNAME FROM HR.EMPLOYEE；  You receive the following error：         01578： ORACLE data block corrupted （file# 6， block # 54）        ORA-01110 ： data file 6： ’u01/oracle/oradata/data1.dbf’   How will you resolve this problem of data block corruption by reducing the mean time to recover （MTTR）？（）

    • A、 by using the DBMS_REPAIR package
    • B、 by using the DBVERIFY utility
    • C、 by using Block Media Recovery
    • D、 by issuing the ANALYZE TABLE HR.EMPLOYEES VALIDATE STRUCTURE command

    正确答案:C

  • 第19题：

    多选题
    Which two kinds of failures make the Data Recovery Advisor （DRA） generate a manual checklist（）
    A

    failure when no standby database is configured

    B

    failure because a data file is renamed accidentally

    C

    failure that requires no archive logs to be applied for recovery

    D

    failure due to loss of connectivity-for example， an unplugged disk cable


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

  • 第20题：

    多选题
    The database is running in NOARCHIVELOG mode. A data file is lost. Which two are valid options for recover？（）
    A

    Restore the data file and perform incomplete recovery.

    B

    Restore the data file and perform point-in-time recover.

    C

    Drop the tablespace and lose all data in the tablespace.

    D

    Restore the database and lose all data since the last backup.


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

  • 第21题：

    多选题
    Which four actions are possible during an Online Data file Move operation?（）
    A

    Creating and dropping tables in the data file being moved

    B

    Performing file shrink of the data file being moved

    C

    Querying tables in the data file being moved

    D

    Performing Block Media Recovery for a data block in the data file being moved

    E

    Flashing back the database

    F

    Executing DML statements on objects stored in the data file being moved


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

  • 第22题：

    多选题
    You lost a data file that belongs to an index tablespace in your database， which operates in ARCHIVELOG mode. Loss of the data file resulted in increased response time on your queries. Which two options would you use to solve this problem？ （）
    A

    Restore the lost data file from the backup， and then flash back the database.

    B

    Restore the data file pertaining to index tablespace， and then recover the tablespace.

    C

    Restore all the data files， and then perform an incomplete recovery to get the tablespace back.

    D

    Restore all the data files， and then perform an incomplete recovery using the backup control file.

    E

    Drop and re-create the index tablespace， and then re-create all of the indexes in that tablespace.


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

  • 第23题：

    单选题
    You issued the following command to analyze the SCOTT.EMP table for block corruption：   ANALYZE TABLE SCOTT.EMP VALIDATE STRUCTURE；  You received the following error：   ORA-01578： ORACLE data block corrupted  （file # %s， block # %s）   How will you resolve the block corruption problem？（）
    A

     by using the DBMS_REPAIR package

    B

     by using the DB_BLOCK_CHECKING parameter

    C

     by using the DBVERIFY utility

    D

     will not be completely resolved until the hardware fault is corrected


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

相关内容