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、

第1题：

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

第2题：

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

第3题：

第4题：

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

第5题：

You work as a database administrator for Certkiller .com. You want to create your database with the automatic undo management feature enable.Which two tasks must you perform to achieve this？（）

• A、Set the UNDO_RETENTION parameter to AUTO.
• B、Create an initial undo segment in undotablespace.
• C、Set the UNDO_RETENTION parameter to 900 or more
• D、Set the initialization parameter UNDO_MANAGEMENT to AUTO
• E、Set the UNDO_MANAGEMENT parameter to the name of an undotablespace

第6题：

You need to ensure that the database users should be able to use the various flashback query features in order to go back in time by four hours. What would you do to achieve this?（）

• A、set SQL_TRACE=True 
• B、set UNDO_RETENTION=14400 
• C、set FAST_START_MTTR_TARGET=240 
• D、set LOG_CHECKPOINT_INTERVAL=240 
• E、set DB_FLASHBACK_RETENTION_TARGET=14400 
• F、set the RETENTION GUARANTEE clause for the undo tablespace

第7题：

You work as a database administrator for Certkiller .com. One of the user sessions was terminated abnormally in the middle of a transaction. What does Oracle database do to recover it？（）

• A、Uses undo data for roll forward
• B、Uses Flashback Log for recovery
• C、Uses online redo logs to roll back
• D、Uses undo data to roll back the transaction
• E、Uses Recovery Manager （RMAN） to roll back
• F、Uses the System Monitor （SMON） background process to perform instance recovery

第8题：

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.

第9题：

You work as a database administrator for Supportcenter.cn. You want to create your database with the automatic undo management feature enable.Which two tasks must you perform to achieve this？（）

• A、Set the UNDO_RETENTION parameter to AUTO.
• B、Create an initial undo segment in undotablespace.
• C、Set the UNDO_RETENTION parameter to 900 or more
• D、Set the initialization parameter UNDO_MANAGEMENT to AUTO
• E、Set the UNDO_MANAGEMENT parameter to the name of an undotablespace

第10题：

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.