What would you do to retrieve the jobs table fast and with minimum impact to other objects?

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?

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.
use the FLASHBACK DATABASE command

B.
use the ROLLBACK command with SCN

C.
perform point-in-time recovery

D.
drop and re-create the table

E.
use the FLASHBACK TABLE command



Leave a Reply 0

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