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

Identity two advantages of using a recovery catalog in-load of the control File of the target database Recovery Manager （RMAN）.（）

• A、 You can use RMAN stored scripts.
• B、 Recovery is faster if data is stored in catalog in addition to the control file.
• C、 You can store backup Information of all registered databases in one place.
• D、 Database backups are automatically deleted when they are older than the specified time period.

第2题：

Which two statements are correct regarding the Flashback Versions Query feature？（）

• A、 You can use this feature to identify the committed versions of the rows， but not the uncommitted versions.
• B、 You can use this feature to identify the versions of V$ views.
• C、 You can use this feature to identify the inserts， deletes， and updates performed on a particular row but not the data definition language （DDL） operations performed on the table.
• D、 You can use this feature for a table only if row movement is enabled for the table.
• E、 You can use this feature to identify the versions of external and fixed tables.

第3题：

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.

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

第5题：

Indentify two advantages of using recovery catalog instead of the control file of the database in RecoveryManager (RMAN).（）(Choose two.)

• A、You can use RMAN stored scripts
• B、Recovery is faster if data is stored in catalog in addition to the control file
• C、You can store backup information of all registered databases in one place
• D、Database backups are automatically deleted when they are older than the specified time period

第6题：

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.

第7题：

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.

第8题：

You have an enterprise subordinate certification authority （CA） configured for key archival. Three key  recovery agent certificates are issued.   The CA is configured to use two recovery agents.   You need to ensure that all of the recovery agent certificates can be used to recover all new private keys.   What should you do（）

• A、Add a data recovery agent to the Default Domain Policy.
• B、Modify the value in the Number of recovery agents to use box.
• C、Revoke the current key recovery agent certificates and issue three new key recovery agent certificates.
• D、Assign the Issue and Manage Certificates permission to users who have the key recovery agent  certificates.

第9题：

第10题：

第11题：

第12题：

第13题：

On which three can you use Recovery Manager （RMAN） to perform incremental backup？（）

• A、data files
• B、control files
• C、tablespaces
• D、password file
• E、parameter file
• F、whole database
• G、flashback log file
• H、archived log files
• I、change tracking file

第14题：

You can use Oracle Flashback to look at past activity in your database. What are two other characteristics of Oracle Flashback？（）

• A、Oracle Flashback uses undo information to construct consistent data. 
• B、You can use a cursor opened while using an Oracle Flashback image to perform DML once you deactivate Oracle Flashback in your session. 
• C、You can only use Oracle Flashback view of the data if the required records are still in the online redo log files. 
• D、Oracle Flashback lists the DML that was executed during the period you identify when initiating your session. 

第15题：

You are using the control file to maintain information about the database backups that are being performed by Recovery Manager (RMAN).Identify two scenarios is which you must have a recovery catalog. （）(Choose two.)

• A、To store the backup information of multiple database
• B、To restrict the amount of space that is used by the backups
• C、To maintain a backup for a certain time is set by the CONTROL_FILE_RECORD_KEEP_TIME parameter.
• D、To list the data files that were in a target database at a given time by using the AT option of REPORT SCHEMA command.

第16题：

Which two statements are true regarding the usage of the SQL*Loader utility（）

• A、You can load data into multiple tables during the same load session.
• B、You can load data from multiple files to a table during the same load session.
• C、You cannot perform selective data loading based on the values available in the records.
• D、You can use an export file generated by the EXPDP utility as an input data file to load the data.
• E、You can load data only if the input file is available on the disk and tape but not in a named pipes.

第17题：

You work as a database administrator at Certkiller .com. You are working in an online transaction processing （OLTP） environment. You realize that the salary for an employee， John， has been accidentally modified in the EMPLOYEEStable. Two days ago， the data was in the correct state. Flashback logs generated during last two days are available in the flash recovery area. Which option would you choose to bring the data to the correct state while ensuring that no other data in the same table is affected？（）

• A、 perform point-in-time recovery
• B、 perform a Flashback Table operation to restore the table to the state it was in two days ago
• C、 perform a Flashback Database operation to restore the database to the state it was in two days ago
• D、 perform Flashback Versions Query and Flashback Transaction Query to determine all the necessary undo SQL statements， and then use them for recovery

第18题：

Indentify two advantages of using recovery catalog instead of the control file of the database in Recovery Manager （RMAN）.（）

• A、 You can use RMAN stored scripts
• B、 Recovery is faster if data is stored in catalog in addition to the control file
• C、 You can store backup information of all registered databases in one place
• D、 Database backups are automatically deleted when they are older than the specified time period

第19题：

Your database is functioning in ARCHIVELOG mode. In which two situations would you perform a cancel-based recovery？ （）

• A、 You find that one of the redo log members in each redo log group is lost.
• B、 You find that a data file that belongs to the USERS tablespace is damaged.
• C、 You find that a data file that belongs to the SYSTEM tablespace is damaged.
• D、 You find that the current redo log group is damaged and is not available for recovery.
• E、 You realized while performing a recovery that an archived redo log file needed for recovery is lost.

第20题：

第21题：

第22题：

第23题：