Identify two situations in which you can use Data Recovery A

第1题：

第2题：

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.

第3题：

第4题：

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.

第5题：

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.

第6题：

You are in the middle of a transaction and very crucial data has been modified. Because of a hardware failure， the instance has shut down before synchronizing all the database files. Which two statements are true？（）

• A、On startup， SMON coordinates instance recovery.
• B、On startup， CKPT coordinates instance recovery.
• C、On startup， use RMAN to perform instance recovery.
• D、Uncommitted changes will be rolled back after the database is opened.
• E、On startup， perform media recovery and then instance recovery.
• F、On startup， all the files will be synchronized and you get both committed and uncommitted data.

第7题：

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

第8题：

第9题：

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. 

第10题：

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.