多选题Your database is in NOARCHIVELOG mode. After which two operations you should take the backup of control file？（）Aadding a new user to the databaseBdropping a user from the databaseCdropping a table from the databaseDdropping a data file from a tablespac

第1题：

A data file became corrupted in your database due to bad sectors on the disk. Because of corruption， you lost all the important tables in that data file. Which method would you use for recovery？（）

• A、flash back all the tables in the data file， one by one
• B、restore the data file to a new location and perform a media recovery
• C、flash back the database; there is no need to restore the data file
• D、restore the data file from the most recent backup and flash back the database

第2题：

You lost a temporary file that belongs to the default temporary tablespace in your database. From the options provided， which approach would you take to solve the problem？ （）

• A、flash back the database
• B、import the temporary tablespace from the last export
• C、restore all the data files and temporary files from the last full database backup and perform a recovery
• D、not perform a recovery， but create a new temporary tablespace， make it the default temporary tablespace and then drop the old tablespace

第3题：

第4题：

You have a read-only tablespace on read-only media. You want to perform a media recovery on the existing data files， but using a backup control file. The backup control file indicates that the status of the read-only tablespace was read/write when the control file was backed up. What should you consider？（）

• A、 take data files from the read-only tablespace offline before performing a recovery
• B、 recovery using backup control file is not possible， so restore all the files from the last full database backup， and then open the database
• C、 drop the read-only tablespace and re-create the tablespace after recovery
• D、 perform a recovery； status of the tablespace in control file will be changed automatically

第5题：

Your database operates in ARCHIVELOG mode. User/x7fmanaged consistent backups are performed every Sunday night.  On Tuesday， client A drops a table at 8：00 a.m. as follows：  SQL> DROP TABLE cust_ord PURGE;  Table dropped.  Client B executes a query at 9：00 a.m. on the same table as follows：  SQL> SELECT * FROM cust_ord; SELECT * FROM cust_ord *  ERROR at line 1：  ORA/x7f00942： table or view does not exist  Client B needs the dropped table and reports the problem to you. With reference to this scenario， which action should you take？（）

• A、retrieve the table by using the flashback feature
• B、restore all the data files from last Sunday’s backup， and then perform a time­based recovery
• C、restore all the data files from last Sunday’s backup， and then perform a log sequence recovery
• D、restore all the data files from last Sunday’s backup， and then perform a cancel­based recovery
• E、restore from last Sunday’s backup only data files that belong to the tablespace in which the table was stored， and then perform a complete recovery

第6题：

In Recovery Manager （RMAN）， you have set control file autobackup to ON by using the following command：  CONFIGURE CONTROLFILE AUTOBACKUP ON;  Which two events would cause the control file to be backed up automatically？ （）

• A、a tablespace is taken offline
• B、the database instance is restarted
• C、a new data file is added to an existing tablespace
• D、a successful backup is recorded in the RMAN repository
• E、the RMAN connection is disconnected from the target database

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

Your database is in NOARCHIVELOG mode and a logswitch happens every 20 minutes. On Thursday morning，media failure resulted in corruption of a data file belonging to the TOOLS tablespace. Backups are taken on every Sunday.  What would you do in this situation？（）

• A、recover using Oracle Flashback Database technology
• B、restore the data files from backup and perform a complete recovery
• C、restore only the corrupted data file and perform tablespace recovery
• D、restore the data files from backup and perform cancel-based recovery
• E、restore the entire database from the most recent backup and start the instance and open the database

第10题：

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.