You flashed back the jobs table at 11:00 a.m. to its state at 9:30 a.m. At 11:15 a.m., you decided to retrieve the jobs table as it was at 10:12 a.m. What would you do to retrieve the jobs table fast and with minimum impact to other objects?
A.
drop and re-create the table
B.
perform point-in-time recovery
C.
use the ROLLBACK command with SCN
D.
use the FLASHBACK TABLE command
E.
use the FLASHBACK DATABASE command
Explanation:
Oracle Flashback Table provides the DBA the ability to recover a table or set of tables to a specified point in time in the past very quickly, easily, and without taking any part of the database offline. In many cases, Flashback Table eliminates the need to perform more complicated point-in-time recovery operations. Flashback Table restores tables while automatically maintaining associated attributes such as current indexes, triggers and constraints, and not requiring the DBA to find and restore application-specific properties. Using Flashback Table causes the contents of one or more individual tables to revert to their state at some past SCN or time. Flashback Table uses information in the undo tablespace to restore the table. You do not have to restore any data from backups, and the rest of your database remains available while the Flashback Table operation is being performed.
REF.: Oracle(r) 10g Backup and Recovery Basics, 7-4