You database operates in ARCHIVELOG mode and user-managed consistent backups are performed every Sunday night. On Tuesday， at 9：00 a.m. the current log sequence number was 369. Also， on Tuesday you lost the data file belonging to the SYSTEM tablespace and

第1题：

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

第2题：

You are working on a database that must be functioning 24 hours a day， 7 days a week. The databaseis configured in ARCHIVELOG mode.  Which two options do you have for performing user-managed backups（）

• A、You can perform consistent backups only.
• B、You can perform a complete database backup without shutting down the database instance.
• C、You can back up data files only when all data files have the same SCN recorded in the control file.
• D、You can back up only those data files whose headers are frozen by using ALTER TABLESPACE BEGINBACKUP or ALTER DATABASE BEGIN BACKUP commands.

第3题：

Examine the following scenario：   -Database is running in ARCHIVELOG mode.  -Complete consistent backup is taken every Sunday.  -On Tuesday the instance terminates abnormally because the disk on which control files are located gets corruptedThe disk having active online redo log files is also corrupted.  The hardware is repaired and the paths for online redo log files and control files are still valid.  Which option would you use to perform the recovery of database till the point of failure？（）  

• A、 Restore the latest whole backup，perform complete recovery，and open the database normally 
• B、 Restore the latest whole backup，perform incomplete recovery，and open the database with the  RESETLOGS option.
• C、 Restore the latest backups control file，perform complete recovery，and open the database with the RESETLOGS option.
• D、 Restore the latest backup control file，perform incomplete recovery using backup control file，and open the database with the RESETLOG option.

第4题：

You are maintaining your database in Oracle10g. You perform a full user-managed backup every Sunday at 8：00 P.M. Your database is running in ARCHIVELOG mode. On Monday， at 9：00 A.M.， a tablespace is dropped. You decide to perform incomplete recovery to recover the dropped tablespace.  Which two clauses can you use with the RECOVER command？（）

• A、 UNTIL SEQUENCE
• B、 UNTIL SCN
• C、 UNTIL CHANGE
• D、 UNTIL CANCEL

第5题：

You lost a data file that belongs to an index tablespace in your database， which operates in ARCHIVELOG mode. Loss of the data file resulted in increased response time on your queries. Which two options would you use to solve this problem？ （）

• A、 Restore the lost data file from the backup， and then flash back the database.
• B、 Restore the data file pertaining to index tablespace， and then recover the tablespace.
• C、 Restore all the data files， and then perform an incomplete recovery to get the tablespace back.
• D、 Restore all the data files， and then perform an incomplete recovery using the backup control file.
• E、 Drop and re-create the index tablespace， and then re-create all of the indexes in that tablespace.

第6题：

Your database operates in ARCHIVELOG mode. User-managed 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-00942： 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

第7题：

Your database is set in NOARCHIVELOG mode and is backed up every night. There are 10 redo log groups on the database， each with three members， making a total of 30 redo log files. At lunchtime the server unexpectedly gets shut down. Upon restarting you notice that the data file belonging to the SYSTEM tablespace has become corrupted. You also notice that there have been 15 log switches during the day. Which solution should you use to recover as much committed data as possible？（）

• A、Restore the data file for the SYSTEM tablespace then open the database. 
• B、Restore all redo logs form last night's backup, then restart the database. 
• C、Perform a complete restore of all files from last night's backup. Data entered into the database today must be reentered. 
• D、Mount the instance, take the SYSTEM tablespace offline, open the database, and then restore the data file, recover it, and bring the tablespace online. 

第8题：

第9题：

第10题：

第11题：

第12题：

Your database is running in NOARCHIVELOG mode with two online redo log files. The SALES table contains sales information for the organization. The SALES table belongs to the SALESTB tablespace.  On Monday， you insert 10 rows into the SALES table. The current log sequence number is 14. You change the tablespace status from READ WRITE to READ ONLY for the SALESTB tablespace. You shut down the database and take a backup of the SALESTB tablespace.   On Tuesday， you start the database. You change the status for the SALESTB tablespace from READ ONLY to READ WRITE. You insert 10 more rows into the SALES table and shut down the database. The current log sequence number is 15.   When you try to open the database on Wednesday morning， you discover that the SALESTB tablespace was lost because of a media failure. Which of the following options is true about recovering the SALES table？（）

• A、 The SALES table cannot be recovered because the database is running in NOARCHIVELOG mode.
• B、 The SALES table can be recovered by restoring the SALESTB tablespace from the backup and performing a media recovery.
• C、 The SALES table can be recovered by restoring the SALESTB tablespace from the backup without performing any media recovery.
• D、 The SALES table can be recovered by restoring the SALESTB tablespace from the backup， but the rows inserted on Tuesday need to be inserted again.

第13题：

Your database operates in ARCHIVELOG mode. The redo log files are not multiplexed and one of the online redo logs is missing. The missing redo log sequence， 230， is not archived， and it contained information from 10：35 a.m. onwards.  The current time is 11：00 a.m. Because of a disk crash， you executed the following command to perform an incomplete recovery：  RMAN> RUN {  2> SET UNTIL SEQUENCE 230 THREAD 1;  3> ALTER DATABASE MOUNT;  4> RESTORE DATABASE;  5> RECOVER DATABASE;  6> ALTER DATABASE OPEN RESETLOGS; 7> };  With reference to this scenario， which statement is true？（）

• A、RMAN recovers up to log sequence 230， but not including 230.
• B、RMAN returns an error because the log sequence number mentioned in the command should be 229.
• C、RMAN returns an error because the log sequence number mentioned in the command may never be missing.
• D、RMAN recovers up to and including log sequence 229 but then returns an error because log sequence 230 is missing.

第14题：

Your database is functioning in ARCHIVELOG mode. In which two situations would you perform a cancel/x7fbased recovery？（）

• A、You find that one of the redo log members in each redo log group is lost.
• B、You find that a data file that belongs to the USERS tablespace is damaged.
• C、You find that a data file that belongs to the SYSTEM tablespace is damaged.
• D、You find that the current redo log group is damaged and is not available for recovery.
• E、You realized while performing a recovery that an archived redo log file needed for recovery is lost.

第15题：

Your database has a backup that was taken yesterday （Tuesday） between 13：00 and 15：00 hours. This is the only backup you have. You have lost all the archived redo logs generatedsince the previous Monday， but you have archived redo logs available from the previous Sunday and earlier. You now need to restore your backup due to database loss.  To which point can you restore your database？（）  

• A、 13：00 on Tuesday.
• B、 15：00 on Tuesday.
• C、 Up until the last available archived redo log on Sunday.
• D、 To any point； all the redo should still be available in the online redo logs.
• E、 The database is not recoverable.

第16题：

You are maintaining your database in Oracle10g. On Tuesday at 8：00 A.M.， while starting the database， you discover that all the control files are missing. The backup of the full database was performed on Sunday at 6：00 P.M. Which type of recovery will you perform？（）

• A、 incomplete recovery
• B、 complete recovery
• C、 recovery using the Flashback Database feature
• D、 recovery using the export/import utility

第17题：

You work as a database administrator for Supportcenter.cn. 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 perform tablespace recovery
• 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

第18题：

You take backups of your hard drives every night. On Thursday morning you see that the hard  disk has crashed. The backup log shows:   * Friday normal backup completed  * Saturday incremental backup completed      * Sunday incremental backup completed * Monday incremental backup completed * Tuesday incremental backup incomplete * Wednesday incremental backup completed.   What should you do to restore your data to the update state?（　）

• A、Restore using the tapes from Friday， Saturday， Sunday， Monday and Wednesday.
• B、Restores using only Fridays tape
• C、Restore using the tapes from Thursday， Friday， Saturday， Sunday and Tuesday.
• D、Restore using the tapes from Friday and Tuesday.
• E、Restore using the tapes from Tuesday and Thursday.

第19题：

第20题：

第21题：

第22题：