单选题Consider the recovery steps in each of the cases given below：  Case 1：  Shut down the database and perform a backup.  Restore all the data files.  Mount the database.  Recover the database.  Without applying all the redo log files， open the database us

第1题：

Which two statements are true regarding the database in ARCHIVELOG mode？（）

• A、You have to shut down the database to perform the backups.
• B、Archiving information is written to the data files and redo log files.
• C、You can perform complete database backups without closing the database.
• D、Online redo log files have to be multiplexed before putting the database in ARCHIVELOG mode.
• E、All the previous database backups become invalid after you configure the database to ARCHIVELOG mode.

第2题：

After performing a clean shut down of the database instance for maintenance， you mount thedatabase and then 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

第3题：

Consider the recovery steps in each of the cases given below：  Case 1：  Shut down the database and perform a backup.  Restore all the data files.  Mount the database.  Recover the database.  Without applying all the redo log files， open the database using the RESETLOGS option.  Back up the database.  Case 2：  Shut down the database and perform a backup.  Restore only the data files of the tablespace where user error damaged the data.  Mount the database.  Recover the database.  Open the database with the RESETLOGS option.  Back up the database.  Case 3： Shut down the database  Restore the data files  Open the database  Perform recovery to the current point in time.  Which case has the correct steps for an incomplete recovery？（）

• A、only case 1
• B、only case 2
• C、only case 3
• D、case 1 and 2
• E、case 2 and 3
• F、case 1 and 3
• G、all cases： case 1， case 2 and case 3

第4题：

You are using Recovery Manager (RMAN) with a recovery catalog to back up your production database. Thebackups and the archived redo log files are copied to a tape drive on a daily basis. Because of media failure,you lost your production database completely along with the recovery catalog database.You want to recover the target database and make it functional. You consider performing the following steps to accomplish the task: 1) Restore an autobackup of the server parameter file. 2) Restore the control file 3) Start the target database instance 4) Mount the database 5) Restore the data files 6) Open the database with RESETLOGS option 7) Recover the data files 8) Set DBID for the target database Which option illustrates the correct sequence that you must use?（）

• A、8，1，3，2，4，5，7，6
• B、1，8，3，4，2，5，7，6
• C、1，3，4，2，8，5，6，7
• D、1，3，2，4，6，5，7，8

第5题：

You are using recovery Manager (RMAN) with a recovery catalog to backup up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. The database was open and transactions were recorded in the redo logs. Because of fire in the building you lost your servers having the production database and the recovery catalog database. The archive log files generated after the last backup are intact on one of the remote locations. While performing a disaster recovery of the production database what is the next step that you must perform after restoring the data files and applying archived redo logs?（）

• A、Open the database in NORMAL mode
• B、Open the database in read-only mode
• C、Open the database in RESTRICTED mode
• D、Open the database with the RESETLOGS option

第6题：

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

第7题：

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

第8题：

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

第9题：

Case 1：  1. Shut down the database and perform a backup.  2. Restore all the data files.  3. Mount the database.  4. Recover the database.  5. Without applying all the redo log files， open the database using the RESETLOGS option.  6. Back up the database.  Case 2：  1. Shut down the database and perform a backup.  2. Restore only the data files of the tablespace where user error damaged the data.  3. Mount the database. 4. Recover the database.  5. Open the database with the RESETLOGS option.  6. Back up the database.  Case 3：  1. Shut down the database.  2. Restore the data files.  3. Open the database.  4. Perform recovery to the current point in time.  Which case has the correct steps for an incomplete recovery？（）

• A、 Only case 1
• B、 Only case 2
• C、 Only case 3
• D、 Case 1 and 2
• E、 Case 2 and 3
• F、 Case 1 and 3
• G、 All cases， case 1， case 2， case 3

第10题：

Which are the correct steps， in order， to deal with the loss of an online redo log if the database has not yet crashed？（）   a. Issue a checkpoint.  b. Shut down the database.  c. Issue an alter database open command to open the database.  d. Startup mount the database.  e. Issue an alter database clear logfile command.  f. Recover all database datafiles.

• A、a， b， c， d
• B、b， d， e， c
• C、a， b， d， e， c
• D、b， f， d， f， c
• E、b， d， a， c