What does the DB_FLASHBACK_RETENTION_TARGET parameter configure？（） A、 An upper limit on how far you can flash back the database，depending on the information in the redo logsB、 An upper limit on how far you can flash back the database，depending on the information in the undo tablespaceC、 The amount of time for which the flashback data is to be kept in the flash recovery area， provided that there is enough spaceD、 The amount of time for which the flashback data is guaranteed to be kept in the undo tablespace，provided that there is enough space
What does the DB_FLASHBACK_RETENTION_TARGET parameter configure？（）
- A、 An upper limit on how far you can flash back the database，depending on the information in the redo logs
- B、 An upper limit on how far you can flash back the database，depending on the information in the undo tablespace
- C、 The amount of time for which the flashback data is to be kept in the flash recovery area， provided that there is enough space
- D、 The amount of time for which the flashback data is guaranteed to be kept in the undo tablespace，provided that there is enough space
相关考题：
You can go out,()you promise to be back before 12 o'clock.A. so far asB. as far asC. as long as
there is no reason that they should limit how much vitamin you take ____ they can limit how much water you drink. A. any more thanB. no more thanC. much more thanD. no less than
You can go out, ____________ you promise to be back before 11 o’clock.A、as far asB、as long asC、as well asD、as soon as
On Friday at 11:30 am you decided to flash back the database because of a user error that occurred at 8:30 am. Which option must you use to check whether a flashback operation can recover the database to the specified time? （）A. Check the alert log fileB. Query the V$FLASHBACK_DATABASE_LOG viewC. Query the V$RECOVERY_FILE_DEST_SIZE viewD.Query the V$FLASHBACK_DATABASE_STAT viewE. Check the value assigned for the UNDO_RETENTION parameter
There is no reason they should limit how much vitamin you take,____they can limit how much water you drink.A.no less thanB.not any more thanC.no more thanD.much more or less
There is no reason they should limit how much vitamin you take，( )they can limit how much water you drink. A.much more than B.no more than C.no less than D.any more than
You are maintaining a database that is in ARCHIVELOG mode. You have configured the flash recovery area in your database. The database is in MOUNT EXCLUSIVE mode， and you want to configure the Flashback Database feature. Which two options are NOT required to configure the Flashback Database feature？ （）A、 Open the database in read-only mode.B、 Set the retention target with the DB_FLASHBACK_RETENTION_TARGET initialization parameter.C、 Enable the block change tracking feature.D、 Execute the ALTER DATABASE FLASHBACK ON statement.
A data file became corrupted in your database due to bad sectors on the disk. Because of corruption， you lost all the important tables in that data file. Which method would you use for recovery？（）A、flash back all the tables in the data file， one by oneB、restore the data file to a new location and perform a media recoveryC、flash back the database; there is no need to restore the data fileD、restore the data file from the most recent backup and flash back the database
In your database， you discovered that a tempfile in a locally managed temporary tablespace has been deleted at the operating system level. How would you recover the tablespace？（）A、flash back the databaseB、perform point-in-time recoveryC、perform a full database recoveryD、drop and re-create the tablespaceE、use Recovery Manager （RMAN） to recover the database
Which two statements are true regarding the database in ARCHIVELOG mode？（）A、You have to shut down the database to perform the backups.B、Archiving information is written to the data files and redo log files.C、You can perform complete database backups without closing the database.D、Online redo log files have to be multiplexed before putting the database in ARCHIVELOG mode.E、All the previous database backups become invalid after you configure the database to ARCHIVELOG mode.
What RMAN command must you use before you can back up a database using the recovery catalog？（）A、 create catalogB、 install databaseC、 catalog databaseD、 merge Catalog with databaseE、 register database
You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOGmode. Which two statements are true in this scenario（）A、You must shut down the database instance to perform the backups.B、You must configure the Flash Recovery Area （FRA） for the database.C、You can perform complete database backups without closing the database.D、All the previous closed database backups including control files become invalid after you configure thedatabase to ARCHIVELOG mode.
On Friday at 11:30 am you decided to flash back the database because of a user error that occurred at 8:30 am. Which option must you use to check whether a flashback operation can recover the database to the specified time? （）A、Check the alert log fileB、Query the V$FLASHBACK_DATABASE_LOG viewC、Query the V$RECOVERY_FILE_DEST_SIZE viewD、Query the V$FLASHBACK_DATABASE_STAT viewE、Check the value assigned for the UNDO_RETENTION parameter
Your database is in NOARCHIVELOG mode. You start to do a backup， but your users complain that they dont want you to shut down the database to perform the backup. What options are available to you？（） A、 Put the database in hot backup mode and perform an online backup，including backing up the archived redo logs.B、 Just back up the database datafiles without shutting down the database.C、 You will have to wait until you can shut down the database to perform the backup.D、 Mark each datafile as backup in progress， back them up individually，and then mark them as backup not in progress. No archived redo logs will need to be backed up.E、 Only back up the datafiles that the user will not be touching. Once the user has finished what they were doing，you can shut down the database and back up the datafiles the user changed during the course of the remaining backup
You work as a database administrator for Certkiller .com. Your database is configured for automatic undo management. UNDO_RETENTION is set to 3 hours. You want to flash back a table that was created last year. How far back can the flashback query go？ （）A、3 hoursB、6 monthsC、until last yearD、until last commitE、until the point when the undotablespacewas refreshedF、until the database is shut down and the memory erased
A data file become corrupted in your database due to bad sectors on the disk. Because of corruption， you lost all the important tables in that data file. Which method would you use for recovery？（）A、 Flash back all the tables in the data file， one by one.B、 Restore the data file to a new location and perform a media recovery.C、 Flash back the database， there is no need to restore the data file.D、 Restore the data file from the most recent backup and flash the database.
You executed the following query in your database： SELECT oldest_flashback_scn， oldest_flashback_time FROM V$FLASHBACK_DATABASE_LOG； What would you determine from the output？（）A、 The time when the last flashback operation in your database was performed.B、 The time when the first flashback operation in your database was performed.C、 A list of flashback operations performed in your database using SCN and time.D、 The approximate time and the lowest system change number （SCN） to which you can flash back your database.
You are managing an Oracle Database 11g database. You want to ensure the recovery of the database to thepoint of failure. Which configuration will you do to accomplish the task（）A、Multiplex all database files.B、Configure the Flash Recovery Area.C、Configure the database instance for ARCHIVELOG mode.D、Configure the FAST_START_MTTR_TARGET initialization parameter
You executed the following query in your database： FROM V$FLASHBACK_DATABASE_LOG; What would you determine from the output？（）A、the time when the last flashback operation in your database was performedB、the time when the first flashback operation in your database was performedC、a list of flashback operations performed in your database using SCN and timeD、the approximate time and the lowest system change number （SCN） to which you can flash back your database
Flashback Database is enabled in your Oracle 10g database. One of your database users erroneously purged an important table residing in his schema. The table was purged sometime between 10：00 P.M. and 10：30 P.M. The next day， you decide to flash back the database. Before you flash back the database， you want to ensure that you have all the necessary flashback data. Which dynamic performance view must you use to determine whether you have the required flashback data to recover the purged table？（）A、 V$DATABASEB、 V$UNDOSTATC、 V$FLASHBACK_DATABASE_LOGD、 V$FLASHBACK_DATABASE_STAT
You are managing an Oracle Database 11g database. You want to ensure the recovery of thedatabase to the point of failure. Which configuration will you do to accomplish the task（）A、Multiplex all database filesB、Configure the Flash Recovery Area.C、Configure the database instance for ARCHIVELOG mode.D、Configure the FAST_START_MTTR_TARGET initialization parameter.
单选题What does the DB_FLASHBACK_RETENTION_TARGET parameter configure?（）AAn upper limit on how far you can flash back the database, depending on the information in the redo logsBAn upper limit on how far you can flash back the database, depending on the information in the undo tablespaceCThe amount of time for which the flashback data is to be kept in the flash recovery area, provided that there is enough spaceDThe amount of time for which the flashback data is guaranteed to be kept in the undo tablespace, provided that there is enough space
单选题What RMAN command must you use before you can back up a database using the recovery catalog？（）A create catalogB install databaseC catalog databaseD merge Catalog with databaseE register database
单选题You executed the following query in your database： FROM V$FLASHBACK_DATABASE_LOG; What would you determine from the output？（）Athe time when the last flashback operation in your database was performedBthe time when the first flashback operation in your database was performedCa list of flashback operations performed in your database using SCN and timeDthe approximate time and the lowest system change number （SCN） to which you can flash back your database
单选题What does the DB_FLASHBACK_RETENTION_TARGET parameter configure？（）A An upper limit on how far you can flash back the database，depending on the information in the redo logsB An upper limit on how far you can flash back the database，depending on the information in the undo tablespaceC The amount of time for which the flashback data is to be kept in the flash recovery area， provided that there is enough spaceD The amount of time for which the flashback data is guaranteed to be kept in the undo tablespace，provided that there is enough space
单选题You executed the following query in your database： SELECT oldest_flashback_scn， oldest_flashback_time FROM V$FLASHBACK_DATABASE_LOG； What would you determine from the output？（）A The time when the last flashback operation in your database was performed.B The time when the first flashback operation in your database was performed.C A list of flashback operations performed in your database using SCN and time.D The approximate time and the lowest system change number （SCN） to which you can flash back your database.
单选题On Friday at 11:30 am you decided to flash back the database because of a user error that occurred at 8:30am. Which option must you use to check whether a flashback operation can recover the database to the specified time?（）ACheck the alert log fileBQuery the V$FLASHBACK_DATABASE_LOG viewCQuery the V$RECOVERY_FILE_DEST_SIZE viewDQuery the V$FLASHBACK_DATABASE_STAT viewECheck the value assigned for the UNDO_RETENTION parameter