You are using the control file t

第1题：

You have discovered that one of three control files has been lost. What steps would you follow to recover that control file？（）   a. Shut down the database.  b. Restore a control-file copy from backup media.  c. Use the create control file command to create a new control file.  d. Copy the backup control file into place.  e. Create a new copy of the control file from one of the surviving control files.  f. Recover the database using the recover database using backup control file command.  g. Start up the database. 

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

第2题：

You executed the following command to back up the control file： ALTER DATABASE BACKUP CONTROLFILE TO TRACE； What do you find in the trace file？（）

• A、Image of the control file
• B、Location of the control file
• C、Contents of the control file in text format
• D、SQL command to re-create the database
• E、SQL command to re-create the control file
• F、Contents of the control file in binary format

第3题：

第4题：

You were recently hired by Certkiller .com as a database administrator. You are asked to find out whether the currently functional listener process， named L1， has been password protected or not. You are not familiar with the file system of the new organization. How would you accomplish the task？（）

• A、 by using the STATUS command of the Listener control utility
• B、 by using the STATUS L1 command of the Listener control utility
• C、 by using the SHOW RULES command of the Listener control utility
• D、 by using the SET PASSWORD command of the Listener control utility
• E、 by searching for the PASSWORD_LISTENER entry in the listener.ora file

第5题：

You are maintaining your database in Oracle10g. You are not using the recovery catalog to maintain the backup metadata information. You want to enable the reusable section of the control file to expand itself if the oldest record cannot be reused， and whenever a new record is added to the reusable section of the control file. Which value will you set for the CONTROL_FILE_RECORD_KEEP_TIME parameter？（）

• A、 Zero
• B、 One or more
• C、 NONE
• D、 DEFAULT

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

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.

第8题：

When you are performing media recover， and an archived log is lost or corrupt， which type of recover must you perform？（）

• A、Until SCN
• B、Until time
• C、Until cancel
• D、Recover using backup control file.

第9题：

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

第10题：

You used the following command in Recovery Manager （RMAN） as part of the recovery process： RESTORE CONTROLFILE FROM AUTOBACKUP；   How does RMAN find the control file autobackup？（）

• A、 By using the trace file.
• B、 By using the alert log file.
• C、 By using the database ID
• D、 By using the server parameter file.
• E、 By using the V$CONTROLFILE view.
• F、 By using the autobackup format configuration setting.