itgle.com

多选题Which two kinds of failures make the Data Recovery Advisor (DRA)generate a manual checklist? （）Afailures because a data file is renamed by errorBfailures when no standby database is configuredCfailures that require no archive logs to be applied for rec

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

相似考题

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

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

3.Which  kinds of failures make the Data Recovery Advisor （DRA） generate a manual checklist？（）A、Failure when no standby database is configuredB、Failure because a data file is renamed accidentallyC、Failure that requires no archive logs to be applied for recoveryD、Failure due to loss of connectivity-for example， an unplugged disk cable

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

更多“多选题Which two kinds of failures make the Data Recovery Advisor (DRA)generate a manual checklist? （）Afailures because a data file is renamed by errorBfailures when no standby database is configuredCfailures that require no archive logs to be applied for rec”相关问题

  • 第1题：

    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

  • 第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.

    正确答案:C,D

  • 第3题：

    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

  • 第4题：

    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

  • 第5题：

    In Recovery Manager (RMAN), you are taking image copies of the data files of your production database and rolling them forward at regular intervals. You attempt to restart your database. After a regular maintenance task, you realize that one of the data files that belongs to the USERS tablespace is damaged and you need to recover the data file by using the image copy. Because a media failure caused the data file to be damaged, you want to place the data file in a different location while restoring the file. Which option must you consider for this task?（）

    • A、using only the RMAN SWITCH command to set the new location for the data file
    • B、placing the database in the MOUNT state for the restore and recovery operations.
    • C、using an RMAN RUN block with the SET NEWNAME and then the SWITCH command.
    • D、configuring two channels: one for the restore operation and the other for the recovery operation

    正确答案:C

  • 第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题：

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

  • 第9题：

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


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

  • 第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题：

    多选题
    What are three purposes of the RMAN “FROM” clause?（）
    A

    to support PUSH-based active database duplication

    B

    to support synchronization of a standby database with the primary database in a Data environment

    C

    To support PULL-based active database duplication

    D

    To support file restores over the network in a Data Guard environment

    E

    To support file recovery over the network in a Data Guard environment


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

  • 第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题：

    Your database is running in ARCHIVELOG mode. One of the data files,USERDATA01.dbf, in the USERS tablespace is damaged and you need to recover the file until the point of failure. The backup for the datafile is available. Which three files would be used in the user-managed recovery process performed by the database administrator (DBA)?（）

    • A、Redo logs
    • B、Control file
    • C、The latest backup of only the damaged data file
    • D、The latest backup of all the data file in the USERS tablespace
    • E、Temporary files of temporary tablespace
    • F、Archive Logs since the latest backup to point of failure

    正确答案:A,C,F

  • 第14题：

    Your production database is running in archivelog mode and you are using recovery manager （RMAN） with recovery catalog to perform the database backup at regular intervals. When you attempt to restart the database instance after a regular maintenance task on Sunday， the database fails to open displaying the message that the data file belonging to the users tablespace are corrupted.   The steps to recover the damaged data files are follows：   1. Mount the database  2. Open the database  3. Recover the data file  4. Restore the data file  5. Make the data file offline  6. Make the data file online   Which option identifies the correct sequence that you must use to recover the data files？（）

    • A、 2，4，3
    • B、 1，4，3，2
    • C、 2，5，4，3，6
    • D、 5，2，4，3，6
    • E、 1，5，4，3，6，2

    正确答案:E

  • 第15题：

    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.

    正确答案:C,D

  • 第16题：

    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

  • 第17题：

    The database is being restored from a closed backup. The data files， control files， password file， and parameter file are available， but the online redo logs are not. Because the online redo logs are not available， you must simulate recovery and alter the database open with the reset logs option so the online redo logs are created while the database opens. Which type of recover is used in this situation？（）

    • A、until SCN
    • B、until time
    • C、until cancel
    • D、using backup control file

    正确答案:C

  • 第18题：

    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

  • 第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题：

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

  • 第21题：

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


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

  • 第22题：

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

  • 第23题：

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

  • 第24题：

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

相关内容