网友您好， 请在下方输入框内输入要搜索的题目：

题目内容 （请给出正确答案）
多选题
Which three actions are required to configure the Flashback Database？（）
A

set Flash Recovery Area

B

enable Flashback logging

C

create FLASHBACK tablespace

D

start the database in the ARCHIVELOG mode

E

start the database in the NOARCHIVELOG mode

参考答案

参考解析
解析： 暂无解析
更多 “多选题Which three actions are required to configure the Flashback Database？（）Aset Flash Recovery AreaBenable Flashback loggingCcreate FLASHBACK tablespaceDstart the database in the ARCHIVELOG modeEstart the database in the NOARCHIVELOG mode” 相关考题
考题 Which three actions are required to configure the Flashback Database? () A. set Flash Recovery AreaB. enable Flashback loggingC. create FLASHBACK tablespaceD. start the database in the ARCHIVELOG modeE. start the database in the NOARCHIVELOG mode
查看答案
考题 You want to flash back a test database by five hours.You issue this command:SQL > FLASHBACK DATABASE TO TIMESTAMP (SYSDATE － 5／24);Which two statements are true about this flashback scenario?() A. The database must have multiplexed redo logs for the flashback to succeed.B. The database must be MOUNTED for the flashback to succeed.C. The database must use block change tracking for the flashback to succeed.D. The database must be opened in restricted mode for the flashback to succeed.E. The database must be opened with the RESETLOGS option after the flashback is complete.F. The database must be opened in read-only mode to check if the database has been flashed back to the correct SCN.
查看答案
考题 You are working on an Oracle Database 10g database. You enabled the Flashback Database feature. Which two statements regarding flashback logs are true？ （）A、 Flashback logs are not archived.B、 Flashback logs are maintained in redo log files.C、 Flashback logs are maintained in the Flash Recovery Area.D、 Flashback logs are used to maintain Flashback Database related errors.E、 Flashback logs need to be cleared manually after you disable Flashback Database.
查看答案
考题 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.
查看答案
考题 Flashback Database relies on which technologies to recover to a point in time？（）  A、 Flashback Data ArchiveB、 Flashback logs in the flash recovery areaC、 FlashbUndo tablespaceD、 RMAN command lineE、 None of the above
查看答案
考题 In order to perform Flashback Transaction Query operations， which of these steps are required？（）A、 Ensure that database is running with version 10.1 compatibility.B、 Enable Flashback Logging.C、 Enable Supplemental Logging.D、 Ensure that the database is running with version 10.0 compatibility.E、 Ensure that the database is in ARCHIVELOG mode.
查看答案
考题 You are maintaining the SALES database for an organization. You have enabled the Flashback Database feature and want to estimate the flashback space required for future operations.  Which view would you query to estimate the flashback space required？（）A、 V$DATABASEB、 V$FLASHBACK_DATABASE_STATC、 V$FLASHBACK_DATABASE_LOGD、 V$RECOVERY_FILE_DEST
查看答案
考题 Which files will you need to perform a full recovery of a database backed up in NOARCHIVELOG mode？（） A、 Database datafilesB、 Control filesC、 Archived redo logsD、 Online redo logsE、 Flashback logs
查看答案
考题 The database is currently running in the NOARCHIVELOG mode. What would be the first step to configure Flashback Database？（）A、 Enable flashback logging.B、 Start the database in the ARCHIVELOG mode.C、 Issue the ALTER DATABASE FLASHBACK ON； command.D、 Set the FAST_START_MTTR_TARGET initialization parameter.
查看答案
考题 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
查看答案
考题 Which three statements are true about Flashback Database?（）A、Flashback logs are written sequentially, and are archived.B、Flashback Database uses a restored control file to recover a database.C、The Oracle database automatically creates, deletes, and resides flashback logs in the Fast RecoveryArea.D、Flashback Database can recover a database to the state that it was in before a reset logs operation.E、Flashback Database can recover a data file that was dropped during the span of time of the flashback.F、Flashback logs are used to restore to the blocks' before images, and then the redo data may be used to roll forward to the desired flashback time.
查看答案
考题 You are managing a single instance Oracle 10g database that utilizes the following parameters：  Which of the following set of commands must you execute to enable Flashback Database？（）A、  STARTUP MOUNT EXCLUSIVE  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN；B、  STARTUP MOUNT  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN RESETLOGS；C、  STARTUP MOUNT EXCLUSIVE  ATLER DATABASE ARCHIVELOG；  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN RESETLOGS；D、  STARTUP MOUNT  ALTER DATABASE ARCHIVELOG；  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN；
查看答案
考题 You configured the Flash Recovery Area （FRA） for your database. The database instance is runningin ARCHIVELOG mode. The default location for the archived redo log files is the Flash Recovery Area.  Which two files are removed automaticallyif the space is required in the FRA as per the retention policy（）A、flashback log filesB、backups that have become obsoleteC、copies of the data files and control filesD、archived redo log files that have multiple copies in a different archive location and not backed up
查看答案
考题 Which three actions are required to configure the Flashback Database? （）A、set Flash Recovery AreaB、enable Flashback loggingC、create FLASHBACK tablespaceD、start the database in the ARCHIVELOG modeE、start the database in the NOARCHIVELOG mode
查看答案
考题 You are required to flashback your database. You want to find the amount of flashback data generated since the database was opened. Which task will you perform to obtain the required information？（）A、 Query the V$FLASHBACK_DATABASE_LOG view.B、 Query the V$FLASHBACK_DATABASE_STAT view.C、 Check the value of the DB_FLASHBACK_RETENTION_TARGET initialization parameter.D、 Query the V$RECOVERY_FILE_DEST view.
查看答案
考题 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 maintaining the SALES database for an organization. You have enabled the Flashback Database feature and want to estimate the flashback space required for future operations.  Which view would you query to estimate the flashback space required？（）A  V$DATABASEB  V$FLASHBACK_DATABASE_STATC  V$FLASHBACK_DATABASE_LOGD  V$RECOVERY_FILE_DEST
查看答案
考题 单选题The database is currently running in the NOARCHIVELOG mode. What would be the first step to configure Flashback Database？（）A  Enable flashback logging.B  Start the database in the ARCHIVELOG mode.C  Issue the ALTER DATABASE FLASHBACK ON； command.D  Set the FAST_START_MTTR_TARGET initialization parameter.
查看答案
考题 单选题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 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？ （）AOpen the database in read-only mode.BSet the retention target with the DB_FLASHBACK_RETENTION_TARGET initialization parameter.CEnable the block change tracking feature.DExecute the ALTER DATABASE FLASHBACK ON statement.
查看答案
考题 多选题Which three actions are required to configure the Flashback Database？（）Aset Flash Recovery AreaBenable Flashback loggingCcreate FLASHBACK tablespaceDstart the database in the ARCHIVELOG modeEstart the database in the NOARCHIVELOG mode
查看答案
考题 单选题You are required to flashback your database. You want to find the amount of flashback data generated since the database was opened. Which task will you perform to obtain the required information？（）A  Query the V$FLASHBACK_DATABASE_LOG view.B  Query the V$FLASHBACK_DATABASE_STAT view.C  Check the value of the DB_FLASHBACK_RETENTION_TARGET initialization parameter.D  Query the V$RECOVERY_FILE_DEST view.
查看答案
考题 单选题Flashback Database relies on which technologies to recover to a point in time？（）A  Flashback Data ArchiveB  Flashback logs in the flash recovery areaC  FlashbUndo tablespaceD  RMAN command lineE  None of the above
查看答案
考题 单选题You are managing a single instance Oracle 10g database that utilizes the following parameters：  Which of the following set of commands must you execute to enable Flashback Database？（）A   STARTUP MOUNT EXCLUSIVE  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN；B   STARTUP MOUNT  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN RESETLOGS；C   STARTUP MOUNT EXCLUSIVE  ATLER DATABASE ARCHIVELOG；  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN RESETLOGS；D   STARTUP MOUNT  ALTER DATABASE ARCHIVELOG；  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN；
查看答案
考题 多选题In order to perform Flashback Transaction Query operations， which of these steps are required？（）AEnsure that database is running with version 10.1 compatibility.BEnable Flashback Logging.CEnable Supplemental Logging.DEnsure that the database is running with version 10.0 compatibility.EEnsure that the database is in ARCHIVELOG mode.
查看答案
考题 多选题You want to flash back a test database by five hours.You issue this command:SQL FLASHBACK DATABASE TO TIMESTAMP (SYSDATE - 5/24);Which two statements are true about this flashback scenario?（）AThe database must have multiplexed redo logs for the flashback to succeed.BThe database must be MOUNTED for the flashback to succeed.CThe database must use block change tracking for the flashback to succeed.DThe database must be opened in restricted mode for the flashback to succeed.EThe database must be opened with the RESETLOGS option after the flashback is complete.FThe database must be opened in read-only mode to check if the database has been flashed back to the correct SCN.
查看答案
考题 单选题You want to configure the Flashback Database feature and retain flashback logs for three days.  Presently the database is open and configured in ARCHIVELOG mode. The following steps must be performed in the correct sequence to do this：   1. Set the retention target：  SQL ALTER SYSTEM SET DB_FLASHBACK_RETENTION_TARGET=4320；  2. Enable Flashback Database：  SQL ALTER DATABASE FLASHBACK ON；  3. Mount the database：  SQL STARTUP MOUNT EXCLUSIVE  4. Shutdown the instance： SQL SHUTDOWN IMMEDIATE  5. Open the database：  SQL ALTER DATABASE OPEN；   Choose the correct sequence.（）A  4， 1， 3， 2， 5B  4， 3， 1， 2， 5C  2， 4， 3， 5， 1D  4， 2， 5， 3， 1
查看答案
考题 多选题You are working on an Oracle Database 10g database. You enabled the Flashback Database feature. Which two statements regarding flashback logs are true？ （）AFlashback logs are not archived.BFlashback logs are maintained in redo log files.CFlashback logs are maintained in the Flash Recovery Area.DFlashback logs are used to maintain Flashback Database related errors.EFlashback logs need to be cleared manually after you disable Flashback Database.
查看答案
热门标签
最新试卷