单选题Why would you execute the report obsolete command？（）A To list all backups that were no longer available for restore operationsB To list all backups that had aged beyond the RMAN retention criteriaC To list all backup set pieces listed in control-file or recovery-catalog metadata that are not on the backup mediaD To list all datafiles that are no longer part of the database and thus do not need to be backed upE To list all archived redo logs that are no longer needed for any database recovery
单选题
Why would you execute the report obsolete command？（）
A
To list all backups that were no longer available for restore operations
B
To list all backups that had aged beyond the RMAN retention criteria
C
To list all backup set pieces listed in control-file or recovery-catalog metadata that are not on the backup media
D
To list all datafiles that are no longer part of the database and thus do not need to be backed up
E
To list all archived redo logs that are no longer needed for any database recovery
参考解析
解析：
暂无解析
相关考题：
Before a Flashback Table operation, you execute the following command:ALTER TABLE employees ENABLE ROW MOVEMENT;Why would you need this to be executed?() A. Because row IDs may change during the flashback operationB. Because the object number changes after the flashback operationC. Because the rows are retrieved from the recycle bin during the flashback operationD. Because the table is moved forward and back to a temporary during the flashback opertion
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 663571B、perform Flashback Transaction Query with SCN 663571C、execute the FLASHBACK DATABASE statement to retrieve the CUSTOMERS table as it was at SCN 663571D、execute another FLASHBACK TABLE statement to retrieve the CUSTOMERS table as it was at SCN 663571
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 daysB、 a list of all those files that have been recovered within the last two daysC、 a list of all the expired backups and copiesD、 a list of backups and copies that are outside the range covered by the current retention policy
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.
Which command would you use to determine what database backups are currently available for restore?（）A、list database backupB、report database backup C、list backup of databaseD、list summary backupE、report backup of database
Why would you run the delete obsolete command？（） A、 To remove missing backup set pieces physically from diskB、 To remove metadata related to backup set pieces in the control file and the recovery catalogC、 To mark as deleted records in the control file and the recovery catalog associated with obsolete backup setsD、 To delete backup set pieces associated with backups that are no longer needed due to retention criteriaE、 To remove old versions of RMAN backups
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.
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.
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.
Which command would you use to determine what database backups are currently available for restore？（） A、 list database backupB、 report database backupC、 list backup of databaseD、 list summary backupE、 report backup of database
You creating a report that will run in both character mode and bitmapped environments. You include some printer codes in your report. What will happen when you run the report in bitmapped mode? （）A、The report will not execute. B、The report will only accept destination type of previewer or printer. C、Printer codes will be ignored. D、Only the printer codes that apply will be processes.
The EMPLOYEES table is stored in the USERS tablespace. You need to check if the EMPLOYEES table is affected by the block corruption found in the USERS tablespace. Which option would you use？（） A、the DBNEWID utilityB、the ANALYZE commandC、the RMAN LIST commandD、the RMAN REPORT commandE、the RMAN CROSSCHECK commandF、the RMAN BLOCKRECOVER command
You issued the following statement： SQLALTER DATABASE ENABLE RESUMABLE TIMEOUT n； What will be the result of issuing the above statement？（）A、The command will not execute successfully because TIMEOUT is an invalid clause with the ALTER DATABASE ENABLE RESUMABLE command.B、 The command will not execute successfully because resumable space allocation is enabled at the session level.C、 The command will execute successfully and resumable space will be allocated at the session level.D、 The command will execute successfully and resumable space will be allocated at the instance level.
One of the users in the PROD database，Adams，complains that his update on the table，TRANS， is taking an unusually long time to complete. You find that the table gets locked by another database user before Adams starts his transactions，and you are unable to contact the user holding the table lock. As Adams is updating some crucial rows in the table， he should get the highest priority. Which method would you use to overcome this problem？（）A、execute the command， ALTER SESSION KILL ..， to kill the blocking sessionB、execute the DBMS_SESSION.KILL_SESSION procedure to kill the blocking sessionC、execute the command， ALTER SYSTEM KILL SESSION ..， to kill the blocking sessionD、execute the command， ALTER SESSION UNLOCK ..， to release the lock for the blocking sessionE、execute the command， ALTER SYSTEM UNLOCK SESSION ..， to release the lock for the blocking session
Why would you execute the report obsolete command？（） A、 To list all backups that were no longer available for restore operationsB、 To list all backups that had aged beyond the RMAN retention criteriaC、 To list all backup set pieces listed in control-file or recovery-catalog metadata that are not on the backup mediaD、 To list all datafiles that are no longer part of the database and thus do not need to be backed upE、 To list all archived redo logs that are no longer needed for any database recovery
多选题Why would you run the delete obsolete command？（）ATo remove missing backup set pieces physically from diskBTo remove metadata related to backup set pieces in the control file and the recovery catalogCTo mark as deleted records in the control file and the recovery catalog associated with obsolete backup setsDTo delete backup set pieces associated with backups that are no longer needed due to retention criteriaETo remove old versions of RMAN backups
单选题You creating a report that will run in both character mode and bitmapped environments. You include some printer codes in your report. What will happen when you run the report in bitmapped mode? （）AThe report will not execute. BThe report will only accept destination type of previewer or printer. CPrinter codes will be ignored. DOnly the printer codes that apply will be processes.
单选题Using the reports server how would you force the orders report in the orders entry application to run every six hours?（）ASchedule the report's execution in the queue manager. BSchedule the reports execution using the R30RQM command line with scheduled parameter. CCreate a trigger in the application to execute the report every six hours. DYou cannot schedule a reports execution.
单选题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 daysB a list of all those files that have been recovered within the last two daysC a list of all the expired backups and copiesD a list of backups and copies that are outside the range covered by the current retention policy
单选题Before a Flashback Table operation, you execute the following command: ALTER TABLE employees ENABLE ROW MOVEMENT; Why would you need this to be executed?（）ABecause row IDs may change during the flashback operationBBecause the object number changes after the flashback operationCBecause the rows are retrieved from the recycle bin during the flashback operationDBecause the table is moved forward and back to a temporary during the flashback operation
单选题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.
单选题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 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.
单选题Which command would you use to determine what database backups are currently available for restore？（）A list database backupB report database backupC list backup of databaseD list summary backupE report backup of database
单选题Before a Flashback Table operation，you execute the following command： ALTER TABLE employees ENABLE ROW MOVEMENT； Why would you need this to be executed？（）A Because row IDs may change during the flashback operationB Because the object number changes after the flashback operationC Because the rows are retrieved from the recycle bin during the flashback operationD Because the table is moved forward and back to a temporary during the flashback opertion
单选题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？（）AThe backup would be marked as invalid.BThe backup would be marked as obsolete.CThe backup would be removed from the media.DThe backup would be removed from the RMAN repository.
单选题You are using an Automatic Storage Management （ASM） instance to manage the database files of your production database. After adding a new disk group to the ASM instance， you execute the following command： ALTER DISKGROUP dg3 REBALANCE POWER 0； What would be the result of this command？（）AThe rebalancing of the disk group would be stopped.BThe rebalancing of the disk group would be completed as fast as possible.CThe command would result in an error because the value of POWER cannot be 0.DThe rebalancing of the disk group would be completed without affecting the disk group DG3.EThe command would result in an error because the disk groups cannot be manually rebalanced.
问答题Practice 3 ● Your manager is considering whether to purchase or to rent a new company premise. He has asked you to write a report concerning this. ● Write a report for your manager, including the following information: ● what you know about the premise, ● why it is good for you to take the relevant action, ● how your company would benefit from it. ● Write 200-250 words.
问答题Practice 7 ● Your company has planned three training courses：Foreign Language Development, Changes in Technology, Management Skills. ● You have been asked to write a report, recommending the course you think would be most useful for people who do the same kind of job as you. ● Write the report, saying which course you have chosen. ● Explain why you feel it would be the most useful and why the others are not so suitable. ● Write 200-250 words on your Answer Sheet．