单选题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: Choose the correc

第1题：

You want to use the Flashback Transaction Query feature to identify all the changes made to your database within a specific time period. What is a prerequisite for using the Flashback Transaction Query feature？（）

• A、 You must use automatic undo management in the database.
• B、 You must configure OMF in your database.
• C、 You must configure ASM for storing the datafiles.
• D、 You must multiplex the online redo log file.

第2题：

What two are the prerequisites for enabling Flashback Database?（） (Choose two)

• A、The database must be in ARCHIVELOG mode
• B、The database must be in MOUNT EXCLUSIVE mode
• C、The database must be opened in RESTRICTED mode
• D、The database instance must be started in the NOMOUNT state
• E、The database instance must have the keep buffer pool defined

第3题：

You disabled the Flashback Database feature by using the following command：  SQL> ALTER DATABASE FLASHBACK OFF；  What would be the effect of this command on the existing flashback logs？（）

• A、 Flashback logs are not deleted.
• B、 Flashback logs are deleted automatically.
• C、 Flashback logs are deleted only if you are using Recovery Manager （RMAN）
• D、 Flashback logs are deleted only if you are using Oracle Manager Files （OFM）
• E、 Flashback logs are deleted only if you are using Automatic Storage Management （ASM）

第4题：

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.

第5题：

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

第6题：

You are performing flashback of the ORDERS table in the Scott’s schema because some important data is deleted in the table by mistake. The SCN number was 771513 at the time of deletion. You issued the following statement to perform Flashback Table：  SQL> FLASHBACK TABLE ORDERS TO SCN 771513；   What is the prerequisite to perform Flashback Table？（）

• A、 You must configure OMF in your database.
• B、 You must enable block change tracking feature in your database.
• C、 You must enable ROW MOVEMENT feature on the ORDERS table.
• D、 You must use the Flashback Version Query before using the Flashback Table feature.

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

Your Oracle Database 10g is online when you execute the following statement：        SQL>ALTER TABLESPACE MY_TABLESPACE FLASHBACK OFF；   What is the result of executing this statement if the Flashback Database feature is already enabled in the database？（）

• A、 The database does not record flashback logs for MY_TABLESPACE
• B、 The tables residing in MY_TABLESPACE are not protected by the Recycle Bin.
• C、 All the tablespaces except MY_TABLESPACE can be recovered using Flashback Database feature.
• D、 None of the flashback technologies， such as Flashback Table， Flashback Transaction Query and Flashback Version Query can be used to recover individual rows within the objects from MY_TABLESPACE

第14题：

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$DATABASE
• B、 V$FLASHBACK_DATABASE_STAT
• C、 V$FLASHBACK_DATABASE_LOG
• D、 V$RECOVERY_FILE_DEST

第15题：

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 Recovery Area.
• 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.

第16题：

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；

第17题：

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 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

第18题：

第19题：

第20题：

第21题：

第22题：

第23题：