多选题Data files of which three tablespaces can be recovered by performing an open recovery？（）ATEMPBUNDOCINDEXDSYSAUXESYSTEM

第1题：

Which three data components are needed for point-in-time recovery?（）

• A、The error log
• B、The backup log
• C、The general query log
• D、Binary logs
• E、The data backup
• F、Configuration files

第2题：

Data files of which three tablespaces can be recovered by performing an openrecovery？（）

• A、TEMP
• B、UNDO
• C、INDEX
• D、SYSAUX
• E、SYSTEM

第3题：

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

After performing a clean shut down of the database instance for maintenance， you mount the database andthen execute a command to open the database：SQL> ALTER DATABASE OPEN； Which two statements are true（）

• A、The online redo log files and online data files are opened.
• B、All the online data file headers are checked for consistency.
• C、Instance recovery is performed before opening the database.
• D、The path and existence of all the log file members are checked

第6题：

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）

第7题：

Which statement is true about the loss of system/x7fcritical data files in ARCHIVELOG mode？（）

• A、The data files can be recovered till the last committed transaction.
• B、The data files can be recovered without shutting down the database.
• C、The data file is taken offline automatically; the database remains open.
• D、The data files can be recovered to the time of the most recent backup.

第8题：

第9题：

Which options must you configure while performing an automated Tablespace Point-in-Time Recovery(TSPITR) by using Recovery Manager (RMAN)?（）

• A、New channels for restore and recovery tasks
• B、New name for the data files of the tablespace
• C、Auxiliary name for the data files of the tablespace
• D、Auxiliary destinations for an auxiliary set of data files

第10题：

Which three statements are true about the stages of database startup？（）

• A、Data files and redo log files can be renamed at the MOUNT stage.
• B、Control files are read at the OPEN stage for the location of data files.
• C、Control files are required to bring the database to the NOMOUNT stage.
• D、Data files and redo log files are made available to users at the OPEN stage.
• E、Data files and online redo log files are checked for consistency while opening the database