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

第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题：

Every Sunday， consistent backups are performed on your database. Because of a user error， you performed an incomplete recovery on Tuesday and opened the database with the RESETLOGS option. A user error occurs again on Thursday， which necessitates an incomplete recovery. Sunday’s backup is the most recent backup available. What would you do in this scenario？（）

• A、recovery cannot be performed because a backup was not performed after the last incomplete recovery
• B、restore all the files from Sunday’s backup， and then perform an incomplete recovery up to the point in time when the user error occurred on Thursday
• C、restore all the files from Sunday’s backup， and then recover up to the point in time when the RESETLOGS operation was performed on Tuesday
• D、restore all the files from Sunday’s backup， and open the database to reset the database to the point in time when the backup was performed on Sunday

第3题：

第4题：

You plan to execute the following command to perform a Flashback Database operation in your database：   SQL> FLASHBACK DATABASE TO TIMESTAMP （SYSDATE -5/24）；   Which two statements are true about this？（）

• A、 The database must have multiplexed redo log files
• B、 The database must be in the MOUNT state to execute the command
• C、 The database must be in the NOMOUNT state to execute the command
• D、 The database must be opened in RESTRICTED mode before this operation
• E、 The database must be opened with the RESETLOGS option after the flashback operation

第5题：

You executed the following query：  SELECT operation， undo_sql， table_name FROM flashback_transaction_query； Which statement is correct regarding the query output？（）

• A、 It would return information regarding only the last committed transaction.
• B、 It would return only the active transactions in all the undo segments in the database.
• C、 It would return only the committed transactions in all the undo segments in the database.
• D、 It would return both active and committed transactions in all the undo segments in the database.
• E、 It would return information regarding the transactions that began and were committed in the last 30 minutes.

第6题：

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

第7题：

You are working as a DBA at NetFx Corporation. You discover that the SCOTT schema is deleted by mistake. You decide to flash the database back to the time when the schema existed. Which view will you query to determine the estimated size of the flashback data that you require for your current target retention？（）

• A、 V$FLASHBACK_DATABASE_LOG
• B、 V$FLASHBACK_DATABASE_STAT
• C、 V$DATABASE
• D、 V$UNDOSTAT

第8题：

第9题：

You are maintaining your OLTP database in Oracle10g. You are performing the Flashback Transaction Query to find the undo SQL statements that can be used to undo the changes made to the database in the specific time period. Which pseudocolumn will you use to perform the Flashback Transaction Query？（）

• A、 VERSIONS_STARTSCN
• B、 VERSIONS_STARTTIME
• C、 VERSIONS_XID
• D、 VERSIONS_OPERATION

第10题：

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 file
• B、Query the V$FLASHBACK_DATABASE_LOG view
• C、Query the V$RECOVERY_FILE_DEST_SIZE view
• D、Query the V$FLASHBACK_DATABASE_STAT view
• E、Check the value assigned for the UNDO_RETENTION parameter