Why would you execute the report obsolete command？（）  

第1题：

The backup retention policy is configured as RECOVERY WINDOW 2. You executed the following command in Recovery Manager （RMAN） against your database： RMAN> REPORT OBSOLETE； What would you see in the output？（）

• A、 a list of all those files that have been deleted in the last two days
• B、 a list of all those files that have been recovered within the last two days
• C、 a list of all the expired backups and copies
• D、 a list of backups and copies that are outside the range covered by the current retention policy

第2题：

Which command would you use to determine what database backups are currently available for restore?（）

• A、list database backup
• B、report database backup  
• C、list backup of database
• D、list summary backup
• E、report backup of database

第3题：

第4题：

In your Automatic Storage Management （ASM） instance， one of the nonempty disk groups， DGROUP1， is no longer required and you want this disk group to be removed. You execute the following command to achieve this objective：  DROP DISKGROUP dgroup1 EXCLUDING CONTENTS；  What would be the result of this command？（）

• A、 This command would result in an error because the disk group is not empty.
• B、 The command would distribute the contents of the specified disk group among all other disk groups and then drop the specified disk group.
• C、 The command would result in the contents being moved to the parent disk group and dropping of the disk group.
• D、 The command would result in the disk group being marked as INVALID because it cannot be dropped.
• E、 The command would drop the disk group， ignoring the EXCLUDING CONTENTS option.

第5题：

You defined the Recovery Manager （RMAN） retention policy to recovery window of 7 days by executing the following command：  RMAN> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS；  When a backup is performed， what would be the status of this backup after seven days？（）

• A、 The backup would be marked as invalid.
• B、 The backup would be marked as obsolete.
• C、 The backup would be removed from the media.
• D、 The backup would be removed from the RMAN repository.

第6题：

The character mode sales report is stored on the network drive as a .REX. You need to make changes to the report layout. Using the report builder how would you change this file?（）

• A、Open the file using the menu option file->open make the changes and recompile the report. 
• B、Convert the file into .REP file using the report compiler make the changes and convert the file back to a .REX file. 
• C、Execute the R30CONV command to convert the file to a .RDF file, make the changes and convert the file back to a .REX file. 
• D、Choose file -> administration->compile. Convert the file to a .REP file, make the changes and convert the file back to a .REX file. 
• E、Execute the R30CONV command to convert the file to a .REP file, make the changes and convert the file back to a .REX file.

第7题：

Why would you run the delete obsolete command？（）  

• A、 To remove missing backup set pieces physically from disk
• B、 To remove metadata related to backup set pieces in the control file and the recovery catalog
• C、 To mark as deleted records in the control file and the recovery catalog associated with obsolete backup sets
• D、 To delete backup set pieces associated with backups that are no longer needed due to retention criteria
• E、 To remove old versions of RMAN backups

第8题：

You are working in an online transaction processing （OLTP） environment. You used the FLASHBACK TABLE command to flash back the CUSTOMERS table. Before executing the FLASHBACK TABLE command， the System Change Number （SCN） was 663571. After flashing back the CUSTOMERS table，you realize that the table is not in the correct state and the resultant changes are not what you had desired. So， you need to reverse the effects of the FLASHBACK TABLE command while ensuring that：  a） No other user data in the database is affected.  b） The operation takes the minimum possible time.  Which option would you choose？（） 

• A、use the ROLLBACK command with SCN 663571
• B、perform Flashback Transaction Query with SCN 663571
• C、execute the FLASHBACK DATABASE statement to retrieve the CUSTOMERS table as it was at SCN 663571
• D、execute another FLASHBACK TABLE statement to retrieve the CUSTOMERS table as it was at SCN 663571

第9题：

Using the reports server how would you force the orders report in the orders entry application to run every six hours?（）

• A、Schedule the report's execution in the queue manager. 
• B、Schedule the reports execution using the R30RQM command line with scheduled parameter. 
• C、Create a trigger in the application to execute the report every six hours. 
• D、You cannot schedule a reports execution.

第10题：

Which command would you use to determine what database backups are currently available for restore？（）  

• A、 list database backup
• B、 report database backup
• C、 list backup of database
• D、 list summary backup
• E、 report backup of database