多选题Identify two situations in which you can use Data Recovery Advisor for recovery.（）AThe user has dropped an important table that needs to be recovered.BThe database files are corrupted when the database is open.CYou are not able to start up the database

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

相似考题

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

2.Every Sunday， consistent backups are performed on your database. Because of a user error， you performed an incomplete recovery on Tuesday and opened the database with the RESETLOGS option. A user error occurs again on Thursday， which necessitates an incomplete recovery. Sunday’s backup is the most recent backup available. What would you do in this scenario？（）A、recovery cannot be performed because a backup was not performed after the last incomplete recoveryB、restore all the files from Sunday’s backup， and then perform an incomplete recovery up to the point in time when the user error occurred on ThursdayC、restore all the files from Sunday’s backup， and then recover up to the point in time when the RESETLOGS operation was performed on TuesdayD、restore all the files from Sunday’s backup， and open the database to reset the database to the point in time when the backup was performed on Sunday

3.Your database operates in ARCHIVELOG mode and all the tablespaces are online. Due to a user error， you decided to perform an incomplete recovery. Which two tasks would you be required to perform in the recovery process？（）A、 open the database with the RESTRICTED optionB、 open the database with the RESETLOGS optionC、 recover to the required SCN only that data file in which the error occurredD、 recover all the data files to the same system change number （SCN）

4.You have only two redo log groups and these groups get overwritten several times in a day. Your database operates in NOARCHIVELOG mode and user-managed consistent backups are performed every Sunday night. On Thursday morning， you find that an important table has been dropped and purged. With reference to this scenario， up to what point in time can the data be recovered？（）A、 until Thursday morningB、 until that point in time when the database is openedC、 until that point in time when the recovery is performedD、 until last Sunday’s backupE、 until that point in time when the table is dropped and purgedF、 until Wednesday evening

更多“多选题Identify two situations in which you can use Data Recovery Advisor for recovery.（）AThe user has dropped an important table that needs to be recovered.BThe database files are corrupted when the database is open.CYou are not able to start up the database”相关问题

  • 第1题：

    In which scenario do you use the Flashback Database feature？（）

    • A、 when a table is dropped and you restore it from the Recycle Bin
    • B、 when a user’s schema is dropped and you recover the user’s schema
    • C、 when some incorrect data is inserted in the table and you retrieve the table to a state that was at a certain timestamp
    • D、 when a row of a table is updated frequently and committed， and you view all the versions of the row within a specific duration

    正确答案:B

  • 第2题：

    In which case would you use the Flashback Database feature to perform a recovery？（）

    • A、to recover a dropped tablespace
    • B、to recover data from a truncated table
    • C、to recover a data file that has been shrunk
    • D、to recover a database to the state that existed before the RESETLOGS operation

    正确答案:B

  • 第3题：

    In the parameter file of your production database， the FAST_START_MTTR_TARGET parameter is set to 300 to optimize instance recovery. While observing the performance of the database during instance recovery， you find that the redo log files are not sized properly to support this activity. Which two sources could you use to determine the optimal size of the redo log files？（）

    • A、the V$LOG view
    • B、the V$DBFILE view
    • C、the V$LOGFILE view
    • D、the V$INSTANCE_RECOVERY view
    • E、Oracle Enterprise Manager Database Control

    正确答案:D,E

  • 第4题：

    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

  • 第5题：

    Your database operates in ARCHIVELOG mode and all the tablespaces are online. Due to a user error， you decided to perform an incomplete recovery.  Which two tasks would you be required to perform in the recovery process？ （）

    • A、open the database with the RESETLOGS option
    • B、open the database with the RESTRICTED option
    • C、recover all the data files to the same system change number （SCN）
    • D、recover to the required SCN only that data file in which the error occurred

    正确答案:A,C

  • 第6题：

    Two data files have been deleted at the operating system level by accident. Your database is running in ARCHIVELOG mode and online backups are taken nightly. One of the data files that has been deleted belongs to the USERS tablespace on the other belongs to the SYSTEM tablespace. How can you recover from this situation？（）

    • A、Shut down the database, restore the two data files and then start up the database. 
    • B、Take the system and users tablespace offline, restore the two data files, recover the two datafiles, and then bring the SYSTEM and USERS tablespaces online. 
    • C、Shut down the database, restore the two data files, start up the database in MOUNT mode, recover the two data files, and then alter the database open. 
    • D、Take the SYSTEM and USERS tablespaces offline, recover the two datafiles and then bring the SYSTEM and USERS tablespaces online.

    正确答案:C

  • 第7题：

    多选题
    Your database operates in ARCHIVELOG mode and all the tablespaces are online. Due to a user error， you decided to perform an incomplete recovery.  Which two tasks would you be required to perform in the recovery process？ （）
    A

    open the database with the RESETLOGS option

    B

    open the database with the RESTRICTED option

    C

    recover all the data files to the same system change number （SCN）

    D

    recover to the required SCN only that data file in which the error occurred


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

  • 第8题：

    多选题
    You are working on a database that must be functioning 24 hours a day， 7 days a week. The database isconfigured in ARCHIVELOG mode. Which two options do you have for performing user-managed backups（）
    A

    You can perform consistent backups only.

    B

    You can perform a complete database backup without shutting down the database instance.

    C

    You can back up data files only when all data files have the same SCN recorded in the control file.

    D

    You can back up only those data files whose headers are frozen by using ALTER TABLESPACE BEGINBACKUP or ALTER DATABASE BEGIN BACKUP commands


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

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

    多选题
    Your database operates in ARCHIVELOG mode and all the tablespaces are online. Due to a user error， you decided to perform an incomplete recovery. Which two tasks would you be required to perform in the recovery process？（）
    A

    open the database with the RESTRICTED option

    B

    open the database with the RESETLOGS option

    C

    recover to the required SCN only that data file in which the error occurred

    D

    recover all the data files to the same system change number （SCN）


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

  • 第11题：

    单选题
    You are in the middle of a transaction updating a very important table. The machine on which a database wasrunning reboots because of power outage. This caused a database instance failure. Which statement is true inthis situation（）
    A

    The online redo log files and archived redo log files are required to accomplish the recovery.

    B

    The uncommitted transaction will be committed at the next startup of the database instance.

    C

    The uncommitted transaction is rolled back automatically at the next opening of the database.

    D

    The DBA has to perform the recovery on the database to recover the uncommitted transaction


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

  • 第12题：

    单选题
    If you create your database using Oracle Managed Files （OMF）， what is true？（）
    A

    You must use Oracle predefined names to identify raw partitions that will hold OMF structures. 

    B

    You must define directories for two online redo log groups and three copies of the control file. 

    C

    If your CREATE DATABASE command fails, any OMF database files that have already been created will be dropped automatically. 

    D

    You must use only OMF data files when adding new tablespaces or data files to your database in the future.


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

  • 第13题：

    If you create your database using Oracle Managed Files （OMF）， what is true？（）

    • A、You must use Oracle predefined names to identify raw partitions that will hold OMF structures. 
    • B、You must define directories for two online redo log groups and three copies of the control file. 
    • C、If your CREATE DATABASE command fails, any OMF database files that have already been created will be dropped automatically. 
    • D、You must use only OMF data files when adding new tablespaces or data files to your database in the future.

    正确答案:D

  • 第14题：

    You are working on a database that must be functioning 24 hours a day， 7 days a week. The databaseis configured in ARCHIVELOG mode.  Which two options do you have for performing user-managed backups（）

    • A、You can perform consistent backups only.
    • B、You can perform a complete database backup without shutting down the database instance.
    • C、You can back up data files only when all data files have the same SCN recorded in the control file.
    • D、You can back up only those data files whose headers are frozen by using ALTER TABLESPACE BEGINBACKUP or ALTER DATABASE BEGIN BACKUP commands.

    正确答案:B,D

  • 第15题：

    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

  • 第16题：

    A developer calls and reports that he accidentally dropped an important lookup table from a production database. He needs the table to be recovered. What action would you take？（）  

    • A、 Initiate an incomplete recovery operation using RMAN.
    • B、 Copy the table from a development database.
    • C、 Advise the user to rekey the data.
    • D、 Perform a Flashback Drop operation.
    • E、 Perform a Flashback Recovery operation.

    正确答案:D

  • 第17题：

    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

  • 第18题：

    单选题
    A developer calls and reports that he accidentally dropped an important lookup table from a production database. He needs the table to be recovered. What action would you take？（）
    A

     Initiate an incomplete recovery operation using RMAN.

    B

     Copy the table from a development database.

    C

     Advise the user to rekey the data.

    D

     Perform a Flashback Drop operation.

    E

     Perform a Flashback Recovery operation.


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

  • 第19题：

    单选题
    In which scenario do you use the Flashback Database feature？（）
    A

     when a table is dropped and you restore it from the Recycle Bin

    B

     when a user’s schema is dropped and you recover the user’s schema

    C

     when some incorrect data is inserted in the table and you retrieve the table to a state that was at a certain timestamp

    D

     when a row of a table is updated frequently and committed， and you view all the versions of the row within a specific duration


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

  • 第20题：

    多选题
    In which of the scenarios will the DBA perform recovery（）
    A

    The alert log file is corrupted.

    B

    A tablespace is accidentally dropped.

    C

    One of the redo log members is corrupted.

    D

    A database user terminates the session abnormally.

    E

    The hard disk on which the data file is stored is corrupted.


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

  • 第21题：

    多选题
    You are working on a database that must be functioning 24 hours a day， 7 days a week. The databaseis configured in ARCHIVELOG mode.  Which two options do you have for performing user-managed backups（）
    A

    You can perform consistent backups only.

    B

    You can perform a complete database backup without shutting down the database instance.

    C

    You can back up data files only when all data files have the same SCN recorded in the control file.

    D

    You can back up only those data files whose headers are frozen by using ALTER TABLESPACE BEGINBACKUP or ALTER DATABASE BEGIN BACKUP commands.


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

  • 第22题：

    单选题
    You have only two redo log groups and these groups get overwritten several times in a day. Your database operates in NOARCHIVELOG mode and user-managed consistent backups are performed every Sunday night. On Thursday morning， you find that an important table has been dropped and purged. With reference to this scenario， up to what point in time can the data be recovered？（）
    A

     until Thursday morning

    B

     until that point in time when the database is opened

    C

     until that point in time when the recovery is performed

    D

     until last Sunday’s backup

    E

     until that point in time when the table is dropped and purged

    F

     until Wednesday evening


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

  • 第23题：

    多选题
    In the parameter file of your production database， the FAST_START_MTTR_TARGET parameter is set to 300 to optimize instance recovery. While observing the performance of the database during instance recovery， you find that the redo log files are not sized properly to support this activity. Which two sources could you use to determine the optimal size of the redo log files？（）
    A

    the V$LOG view

    B

    the V$DBFILE view

    C

    the V$LOGFILE view

    D

    the V$INSTANCE_RECOVERY view

    E

    Oracle Enterprise Manager Database Control


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

相关内容