Which files are required for a full recovery of the database in ARCHIVELOG mode？（）A、 Database datafilesB、 Online redo logsC、 Archived redo logsD、 Backup control fileE、 Control file from a backup

第1题：

第2题：

Your database is running in ARCHIVELOG mode. One of the data files,USERDATA01.dbf, in the USERS tablespace is damaged and you need to recover the file until the point of failure. The backup for the datafile is available. Which three files would be used in the user-managed recovery process performed by the database administrator (DBA)?（）

• A、Redo logs
• B、Control file
• C、The latest backup of only the damaged data file
• D、The latest backup of all the data file in the USERS tablespace
• E、Temporary files of temporary tablespace
• F、Archive Logs since the latest backup to point of failure

第3题：

第4题：

You have recovered your Oracle Database 10g by using the control file backup because all copies of the current control file have been lost due to a media failure. You open your database by using the following statement：       SQL>ALTER DATABASE OPEN RESETLOGS；   Which of the following options is true about using the RESETLOGS option？（）

• A、 The log sequence is reset to 0.
• B、 All the online redo logs are deleted.
• C、 All the archived redo logs from a previous incarnation become useless.
• D、 The full database backup taken from a previous incarnation can be used in future.
• E、 Only the control file and online redo log files are updated with a new RESETLOGS SCN and time stamp.

第5题：

Your PROD database has been started using the server parameter file. In your PROD database you are using RMAN for backup and recovery operations. You issue the following commands from the RMAN prompt：     RMAN> CONFIGURE CONTROLFILE AUTOBACKUP OFF；   RMAN> BACKUP DATABASE；   Which files from the database will be backed up as a result of this BACKUP command？（）

• A、 control file
• B、 all datafiles
• C、 password file
• D、 online redo log file
• E、 archive redo log file
• F、 server parameter file
• G、 only the SYSTEM datafile

第6题：

Which statement is true regarding the Archiver （ARCn） process，archived log files，and recovery？ （）

• A、A database backup, combined with archived redo log files, guarantees that all committed data can be recovered to the point of failure. 
• B、During recovery the ARCn background process copies its redo entries identified for recovery by the control file to the data files. 
• C、After each write to an archived log, the mandatory background process ARCn writes its log sequence number and the first and last SCN number within the log sequence to the control file. 
• D、At database recover time, and archived redo log is uniquely identified for recovery use by its redo thread number and destination ID number retrieved from the control file.

第7题：

Your database is running In ARCIIIVELOG mode. One of the data files， USBRDATAOI. DBF， in the users tablespace is damaged and you need to recover the file until the point of failure. The backup for the data file is available.  Which three files would be used in the user-managed recovery process performed by the database administrator （DBA）？（） 

• A、 redo logs
• B、 control file
• C、 temporary files of temporary tablespace
• D、 the latest backup of only the damaged data file
• E、 the latest backup of all the data files In the USERS tablespace

第8题：

第9题：

The database is configured in ARCHIVELOG mode and regular complete database backups are taken. The loss of which two types of files may require a recovery with the RESETLOGS option？（）

• A、 Control files
• B、 Password files
• C、 Inactive online redo log file
• D、 Archived log files required to perform recovery
• E、 Newly created tablespace which is not backed up

第10题：

Which files will you need to perform a full recovery of a database backed up in NOARCHIVELOG mode？（） 

• A、 Database datafiles
• B、 Control files
• C、 Archived redo logs
• D、 Online redo logs
• E、 Flashback logs