多选题In which three situations is incomplete recovery required？（）AAfter a shutdown abort.BWhen recovering to an SCN.CWhen recovering until a specific time.DWhen a required archived log is missing.

第1题：

When performing incomplete recovery using UNTIL SEQUENCE with RMAN， which two pieces of information are required？（）

• A、Thread number.
• B、Log Sequence number.
• C、Control file sequence number.
• D、Name of the last archived log.

第2题：

In which scenario will you perform a user-managed incomplete recovery？（）

• A、 when a table is dropped and stored in the Recycle Bin
• B、when a table is dropped and purged from the Recycle Bin
• C、 when you are required to recover an existing table to its previous state
• D、 when you are required to view all the versions of a row of an existing table between a specific time period

第3题：

Which statement about recovering from the loss of a redo log group is true?（）

• A、If the lost redo log group is ACTIVE, you should first attempt to clear the log file.
• B、If the lost redo log group is CURRENT, you must clear the log file.
• C、If the lost redo log group is ACTIVE, you must restore, perform cancel-based incomplete recovery, and open the database using the RESETLOGS option.
• D、If the lost redo log group is CURRENT, you must restore, perform cancel-based incomplete recovery, and open the database using the RESETLOGS option.

第4题：

The instance abnormally terminates because of a power outage. Which statement is true about redolog files during instance recovery（）

• A、Inactive and current redo log files are required to accomplish recovery.
• B、Online and archived redo log files are required to accomplish instance recovery.
• C、All redo log entries after the last checkpoint are applied from redo log files to data files.
• D、All redo log entries recorded in the current redo log file until the checkpoint position are applied to datafiles.

第5题：

In which scenario will you perform an incomplete recovery？（）

• A、 when a table is dropped and stored in the Recycle Bin
• B、 when all the control files are deleted
• C、 when a member of a multiplexed redo log group is dropped
• D、 when you are required to recover a table to its previous state

第6题：

In which situation are you NOT required to perform an incomplete recovery？（）

• A、 when all the control files are lost
• B、 when all the members of a redo log group are lost
• C、 when a table is dropped and purged from the Recycle Bin
• D、 when a temporary file of the default temporary tablespace is lost

第7题：

In which scenario is a Database Administrator NOT required to perform an incomplete recovery？（）

• A、 when all the online redo log groups are multiplexed and one of the members of a group is missing
• B、 when all the online redo log groups are not multiplexed and one log group is missing
• C、 when all the control files are missing
• D、 when some important tables are deleted from the database and purged from the Recycle Bin

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

Which two operations require undo data？（）

• A、committing a transaction
• B、rolling back a transaction
• C、recovering from failed transactions
• D、recording a transaction to redo log files
• E、rolling forward during instance recovery

第14题：

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.

第15题：

You configured the Flash Recovery Area （FRA） for your database. The database instance is runningin ARCHIVELOG mode. The default location for the archived redo log files is the Flash Recovery Area.  Which two files are removed automaticallyif the space is required in the FRA as per the retention policy（）

• A、flashback log files
• B、backups that have become obsolete
• C、copies of the data files and control files
• D、archived redo log files that have multiple copies in a different archive location and not backed up

第16题：

While performing the backup of the flash recovery area, you notice that one of the archived redo log files is missing. You have multiple destinations for archived redo log files. What implications does it have on the backup of the flash recovery area?（）

• A、The backup fails because one of the archived redo log files is missing. 
• B、The backup succeeds but it would be without the missing archived log. 
• C、During backup, you are prompted for the alternative destination for the missing archived redo log file. 
• D、The backup succeeds because it fails over to one of the alternative archived redo log destinations. 

第17题：

In which of the following scenarios is a tablespace recovery required？（）

• A、 when recovering a lost read-only tablespace from a read-only tablespace backup
• B、 when recovering a lost read-only tablespace from a read-write tablespace backup when the database is running in  ARCHIVELOG mode
• C、 when recovering a lost read-only tablespace from a read-write tablespace backup when the database is running in  NOARCHIVELOG mode and the changes in the online redo log files have been overwritten
• D、 when recovering a lost read-only tablespace from a read-only tablespace backup using the backup of the control file， the control file was created using the ALTER DATABASE BACKUP CONTROLFILE TO TRACE statement， and this statement was issued when the tablespace was read-only

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

第19题：

In which three situations is incomplete recovery required？（）

• A、After a shutdown abort.
• B、When recovering to an SCN.
• C、When recovering until a specific time.
• D、When a required archived log is missing.

第20题：

第21题：

第22题：

第23题：