单选题Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERS tablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten sincethe last backup.  What would you do to recov

第1题：

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

第2题：

Your database is configured in NOARCHIVELOG mode. All the control files have been lost due to a hard disk failure but the data files are not lost. You have the closed whole database backup available to you.  Which two statements are true in this scenario？（）

• A、The instance aborts.
• B、The database cannot be recovered.
• C、The database can be recovered by restoring the control files from the backup.
• D、The database remains opened and you have to shut it down with the ABORT option.
• E、The database can be restored till the point of the last closed whole database backup.

第3题：

第4题：

Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERStablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten since the last backup.  What would you do to recover the data file（）

• A、Take the USERS tablespace offline and re-create the lost data file.
• B、Shut down the instance， restore the data file from the last consistent backup， and restart the databaseinstance.
• C、Shut down the instance， restore all the database files from the last consistent backup， and restart thedatabase instance.
• D、Take the USERS tablespace offline， restore all the data files of the USERS tablespace from the lastconsistent backup， and make the tablespace online.

第5题：

In your database， online redo log files are multiplexed and one of the members in a group is lost due to media failure？ How would you recover the lost redo log member？（）

• A、 import the database from the last export
• B、 restore all the members in the group from the last backup
• C、 drop the lost member from the database and then add a new member to the group
• D、 restore all the database files from the backup and then perform a complete recovery
• E、 restore all the database files from the backup and then perform an incomplete recovery

第6题：

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)? (Choose Three)

• 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

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

Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERS tablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten sincethe last backup.  What would you do to recover the data file（）

• A、Take the USERS tablespace offline and re-create the lost data file.
• B、Shut down the instance， restore the data file from the last consistent backup， and restart the databaseinstance.
• C、Shut down the instance， restore all the database files from the last consistent backup， and restart thedatabase instance.
• D、Take the USERS tablespace offline， restore all the data files of the USERS tablespace from the lastconsistent backup， and make the tablespace online

第9题：

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.

第10题：

You work as a database administrator for Certkiller .com. Your database is in NOARCHIVELOG mode. The database has been configured with three redo logs groups， and there have been five log switches. You lost one non-system-critical data file from your database.  Which method would you use to recover the data file？（）

• A、Restore all the data files and open the database
• B、Create the data file and performtablespacerecovery
• C、No need to restore any file， just recover the database
• D、Restore only the system data file and recover the database
• E、Restore only lost date file and performtablespacerecovery