单选题You want the ability to recovery any time within the last seven days and therefore you configured the recovery window retention policy using the command： RMAN CONFIGURE RETENTIOH POLICY TO RKCOVFRY WINDOW OF 7 DAYS； After configuring the recovery window， you performed the database backup as follows：（）A Backup RB1 at log sequence number 12871 on 5th JanB Backup RB2 at log sequence number 15622 on 12th JanC Backup RB3 at log sequence 16721 on 15th JanD On 20th Jan when the log sequence number was 18112 you realize that there Is a need to a point in time at the beginning of the recovery window. You have all an hived redo log files to date.
单选题
You want the ability to recovery any time within the last seven days and therefore you configured the recovery window retention policy using the command： RMAN> CONFIGURE RETENTIOH POLICY TO RKCOVFRY WINDOW OF 7 DAYS； After configuring the recovery window， you performed the database backup as follows：（）
A
Backup RB1 at log sequence number 12871 on 5th Jan
B
Backup RB2 at log sequence number 15622 on 12th Jan
C
Backup RB3 at log sequence 16721 on 15th Jan
D
On 20th Jan when the log sequence number was 18112 you realize that there Is a need to a point in time at the beginning of the recovery window. You have all an hived redo log files to date.
参考解析
解析：
暂无解析
相关考题：
If you have any questions, please feel free to interrupt at any time.This sentence means if you have something that you don’t understand,you can make a break in at any time.() 此题为判断题(对，错)。
“你们可以按我指定的时间把礼物送到吗?” 翻译错误的是( )。A.Can you deliver my present the time I want?B.Can you deliver my present at time I want?C.Can you deliver present at the time I want?D.Can you deliver my present at the time I want?
If you have any questions, please feel free to interrupt at any time. This sentence means if you have something that you don’t understand, you can make a break in at any time.A对B错
If you have any questions, please feel free to interrupt at any time. This sentence means if you have something that you don’t understand, you can make a break in at any time.
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
In which scenario will you use the Flashback Transaction Query feature？（）A、 when you want to restore an important table that is dropped from the Recycle BinB、 when you want to obtain the SQL statements to undo the deletion of some important records from a table by a transactionC、when you want to restore a dropped user’s schemaD、 when a row of a table is updated many times within a specific time period and you want all the versions of the row in the specified time period
Which of the following restrictions are not true with respect to tablespace point-in-time recovery？（）A、 The target database must be in NOARCHIVELOG mode.B、 No backup is required of the database before you perform a TSPITR.C、 You must have all archived redo logs generated since the last backup up to the point to which you want to restore the transport set.D、 If you rename a tablespace， you can not perform a TSPITR to any point in time before that rename operation occurred.E、 If you have tables in tablespace_1 that have associated constraints in tablespace_2，then you must transport both tablespaces.
If you back up a database without connecting to the recovery catalog， which operations will cause the recovery catalog to be updated？（）A、 The next time you back up the database when you are also connected to the recovery catalog and the target databaseB、 The next time you are connected to the target database and the recovery catalog database and issue the resync commandC、 The next time you connect RMAN to just the recovery catalogD、 The next time you connect to the recovery catalog and the target database with RMANE、 Connecting to the recovery catalog and issuing the resync all databases command
You have configured the flash recovery area to store online redo log files， control files， archived redo logs and RMAN backups. Which of the following files can you successfully delete from the flash recovery area if you want to reclaim the space within it？（）A、 multiplexed control filesB、 RMAN obsolete backupsC、 multiplexed online redo log filesD、 archived redo logs that have not been copied to tape
The current time is 12：00 noon. You want to recover the USERS tablespace from a failure that occurred at 11：50 a.m. You discover that the only member of an unarchived redo log group containing information from 11：40 a.m. onwards is corrupt. With reference to this scenario， if you are not using Recovery Manager （RMAN）， which recovery method would you use？（）A、timebased recoveryB、log sequence recoveryC、cancelbased recoveryD、changebased recovery
What is the purpose of the until change option of the restore command？（） A、 It allows you to select the SCN that you want to restore to.B、 It allows you to select the log sequence number you want to restore to.C、 It allows you to select the timestamp you want to restore to.D、 It allows you to manually stop the restore at any time as online redo logs are applied.E、 None of the above.
单选题What is the purpose of the until change option of the restore command？（）A It allows you to select the SCN that you want to restore to.B It allows you to select the log sequence number you want to restore to.C It allows you to select the timestamp you want to restore to.D It allows you to manually stop the restore at any time as online redo logs are applied.E None of the above.
单选题Because of a logical corruption in your production database, you wanted to perform Tablespace Point in Time Recovery (TSPITR). But before you start the recovery, you queried the TS_PITR_OBJECTS_TO_BE_DROPPED view and realized that there are a large number of objects that would be dropped when you start the recovery by using this method. You want to preserve these objects. Which option must you use to perform TSPITR and preserve the object?（）APerform Export before TSPITR and Import after TSPITRBMove objects to another schema that has the same tablespace assignedCPerform Incomplete Recovery before TSPITR with the Log Sequence Number (LSN)DPerform Incomplete Recovery before TSPITR with the System Change Number (SCN)
多选题If you back up a database without connecting to the recovery catalog， which operations will cause the recovery catalog to be updated？（）AThe next time you back up the database when you are also connected to the recovery catalog and the target databaseBThe next time you are connected to the target database and the recovery catalog database and issue the resync commandCThe next time you connect RMAN to just the recovery catalogDThe next time you connect to the recovery catalog and the target database with RMANEConnecting to the recovery catalog and issuing the resync all databases command
单选题The current time is 12：00 noon. You want to recover the USERS tablespace from a failure that occurred at 11：50 a.m. You discover that the only member of an unarchived redo log group containing information from 11：40 a.m. onwards is corrupt. With reference to this scenario， if you are not using Recovery Manager （RMAN）， which recovery method would you use？（）A time-based recoveryB log sequence recoveryC cancel-based recoveryD change-based recovery
单选题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
单选题You have configured the flash recovery area to store online redo log files， control files， archived redo logs and RMAN backups. Which of the following files can you successfully delete from the flash recovery area if you want to reclaim the space within it？（）A multiplexed control filesB RMAN obsolete backupsC multiplexed online redo log filesD archived redo logs that have not been copied to tape
单选题You database operates in ARCHIVELOG mode and user-managed consistent backups are performed every Sunday night. On Tuesday， at 9：00 a.m. the current log sequence number was 369. Also， on Tuesday you lost the data file belonging to the SYSTEM tablespace and an achivelog file （sequence number 356） that contained redo entries between 8：00 a.m. and 8.30 a.m. With reference to this scenario， what would you do to recover the database？（）A Restore all the data files from last Sunday’s backup， and then perform a time-based recovery.B Restore all the data files from last Sunday’s backup， and then perform a cancel-based recovery.C Restore all the data files from last Sunday’s backup， and then perform a change-based recovery.D Restore only data files that belong to the SYSTEM tablespace from last Sunday’s backup， and then perform a complete recovery.
单选题Because of a logical corruption in your production database， you wanted to perform Tablespace Point in Time Recovery （TSPITR）. But before you start the recovery，you queried the TS_PITR_OBJECTS_TO_BE_DROPPED view and realized that there are a large number of objects that would be dropped when you start the recovery by using this method. You want to preserve these objects. Which option must you use to perform TSPITR and preserve the object？（）A Perform Export before TSPITR and Import after TSPITRB Move objects to another schema that has the same tablespace assignedC Perform Incomplete Recovery before TSPITR with the Log Sequence Number （LSN）D Perform Incomplete Recovery before TSPITR with the System Change Number （SCN）
单选题You want to perform in incomplete recovery of your database. You plan to use these commands to recover your database： SET UNTIL TIME = ’2000-12-09：11：44：00’； RESTORE DATABASE； RECOVER DATABASE； How should the commands be executed？ （）AOnly the SET command must be within a RUN block.BAll commands should be executed at the RMAN prompt.CAll three commands must be within a single RUN block.DOnly the RESTORE and RECOVER commands must be within a single RUN block.
单选题The current time is 12：00 noon. You want to recover the USERS tablespace from a failure that occurred at 11：50 a.m. You discover that the only member of an unarchived redo log group containing information from 11：40 a.m. onwards is corrupt. With reference to this scenario， if you are not using Recovery Manager （RMAN）， which recovery method would you use？（）Atimebased recoveryBlog sequence recoveryCcancelbased recoveryDchangebased recovery
多选题Which of the following restrictions are not true with respect to tablespace point-in-time recovery？（）AThe target database must be in NOARCHIVELOG mode.BNo backup is required of the database before you perform a TSPITR.CYou must have all archived redo logs generated since the last backup up to the point to which you want to restore the transport set.DIf you rename a tablespace， you can not perform a TSPITR to any point in time before that rename operation occurred.EIf you have tables in tablespace_1 that have associated constraints in tablespace_2，then you must transport both tablespaces.
单选题In your production database, users report that they are unable to generate reports on an important table because it does not contain any data. While investigating the reason, you realize that another user executed the TRUNCATE TABLE command, which accidentally caused the data to be lost. Now you want to recover the lost data of the table without affecting objects in other schemas. Which method must you use to recover the lost data?（）AComplete Recovery with online redo logBComplete Recovery with archived redo logCTablespace Point-in-Time Recovery (TSPITR)DIncomplete Recovery with system change number (SCN)
单选题In your production database， users report that they are unable to generate reports on an important table because it does not contain any data. While investigating the reason， you realize that another user executed the TRUNCATE TABLE command， which accidentally caused the data to be lost. Now you want to recover the lost data of the table without affecting objects in other schemas. Which method must you use to recover the lost data？（）A Complete Recovery with online redo logB Complete Recovery with archived redo logC Tablespace Point-in-Time Recovery （TSPITR）D Incomplete Recovery with system change number （SCN）
单选题In which scenario will you use the Flashback Transaction Query feature？（）A when you want to restore an important table that is dropped from the Recycle BinB when you want to obtain the SQL statements to undo the deletion of some important records from a table by a transactionCwhen you want to restore a dropped user’s schemaD when a row of a table is updated many times within a specific time period and you want all the versions of the row in the specified time period
单选题If the Charterer sends the vessel on her last voyage at a time when there is no expectation that she will be redelivered within a reasonable time of the end of the period of the Charterparty，and she is in fact redelivered late，he（）.Ahas properly fulfilled the contractBis not guilty of a breach of contractCis entitled a right to take legal action against any loss or damage he suffered in this connectionDis guilty of a breach of contract
判断题If you have any questions, please feel free to interrupt at any time. This sentence means if you have something that you don’t understand, you can make a break in at any time.A对B错