Prev Question
Next Question

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 should you do? (Choose two.)

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.
issue ALTER DATABASE FLASHBACK ON; command

G.
set the RETENTION GUARANTEE clause for the undo tablespace

Explanation:
Flashback Table, Flashback Query, Flashback Transaction Query and Flashback Version Query all rely on undo data, records of the effects of each update to an Oracle database and values overwritten in the update.
Creating a guaranteed restore point at a particular SCN enforces the requirement that you can perform a Flashback Database operation to return your database to its state at that SCN, even if flashback logging is not enabled for your database.
REF.: Backup and Recovery Basics – p1-12 and 5-4

Prev Question
Next Question

Leave a Reply

Your email address will not be published. Required fields are marked *