You are using the control file to maintain information about

第1题：

Where do you find information about a missing redo log file？（）

• A、trace file
• B、audit trail
• C、control file
• D、alert log file
• E、event viewer

第2题：

Identity two advantages of using a recovery catalog in-load of the control File of the target database Recovery Manager （RMAN）.（）

• A、 You can use RMAN stored scripts.
• B、 Recovery is faster if data is stored in catalog in addition to the control file.
• C、 You can store backup Information of all registered databases in one place.
• D、 Database backups are automatically deleted when they are older than the specified time period.

第3题：

第4题：

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

第5题：

In which scenario， will you issue the following command？（） RMAN> REPORT NEED BACKUP DAYS 7；

• A、 to configure RMAN to maintain backup information in the RMAN repository for seven days
• B、 to configure RMAN to maintain backup information in the control file for at least seven days
• C、 to display the list of files that have not been backed up for the last seven days
• D、 to display the list of files that must be backed up within seven days

第6题：

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

第7题：

You are using the control file to maintain information about the database backups that are being performed by Recovery Manager (RMAN). Identify two scenarios is which you must have a recovery catalog.（）

• A、To store the backup information of multiple database
• B、To restrict the amount of space that is used by the backups
• C、To maintain a backup for a certain time is set by the CONTROL_FILE_RECORD_KEEP_TIME parameter.
• D、To list the data files that were in a target database at a given time by using the AT option of REPORT SCHEMA command.

第8题：

第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 are maintaining your database in Oracle10g. You are not using the recovery catalog to maintain the backup information of your database. Which file can be used as a repository to store information regarding the RMAN backup？（）

• A、 online redo log files
• B、 alert log files
• C、 control file
• D、 datafiles associated with the SYSTEM tablespace