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

第1题：

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.

第2题：

You want to use the automatic management of backup and recovery operations features for your database.Which configuration must you set?（）

• A、Enable the flash recovery area and specify it as the archived redo log destination.
• B、Disable the flash recovery area and start the database instance in ARCHIVELOG mode.
• C、Enable the flash recovery area but do not specify it as the archived redo log destination.
• D、Disable the flash recovery area and start the database instance in NOARCHIVELOG mode

第3题：

第4题：

Which files will you need to perform a full recovery of a database backed up in NOARCHIVELOG mode？（） 

• A、 Database datafiles
• B、 Control files
• C、 Archived redo logs
• D、 Online redo logs
• E、 Flashback logs

第5题：

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.

第6题：

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.

第7题：

Flashback Database relies on which technologies to recover to a point in time？（）  

• A、 Flashback Data Archive
• B、 Flashback logs in the flash recovery area
• C、 FlashbUndo tablespace
• D、 RMAN command line
• E、 None of the above

第8题：

第9题：

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

第10题：

You have joined a new organization as a Database Administrator. The Security Administrator in your organization has kept human errors， such as erroneously dropping users， tables， and important data， to a minimum by carefully granting only the necessary privileges to each user. As a result of several ongoing transactions within your database， you discover that the flashback logs are rapidly increasing in the flash recovery area. To avoid out-of-space errors， you decide to delete the flashback logs from the flash recovery area. How can you delete the flashback logs from the database if your database is up and running？（）

• A、 Shut down the database using the SHUTDOWN command. Mount the database using the STARTUP MOUNT EXCLUSIVE command and disable Flashback Database using the ALTER DATABASE FLASHBACK OFF statement.
• B、 Change the parameter setting in the SPFILE for the DB_RECOVERY_FILE_DEST parameter using the ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’’ SCOPE=BOTH statement while the database is up and running.
• C、 Shut down the database using the SHUTDOWN command. Mount the database using the STARTUP MOUNT EXCLUSIVE command. Change the parameter setting in the SPFILE for the DB_RECOVERY_FILE_DEST parameter using the ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’’ SCOPE=BOTH statement. Disable Flashback Database using the ALTER DATABASE FLASHBACK OFF statement.
• D、 Change the parameter setting in the SPFILE for the DB_RECOVERY_FILE_DEST parameter using the ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’’ SCOPE=BOTH statement. Shut down the database using the SHUTDOWN command. Mount the database using the STARTUP MOUNT EXCLUSIVE command and disable Flashback Database using the ALTER DATABASE FLASHBACK OFF statement.