What would you do to recover the table?

You are working on an Oracle Database 10g database that operates in the ARCHIVELOG
mode. At 06:00 p.m., you discovered that a table in the SYSTEM tablespace that does not
belong to the data dictionary was dropped at 03:00 p.m.
What would you do to recover the table?

You are working on an Oracle Database 10g database that operates in the ARCHIVELOG
mode. At 06:00 p.m., you discovered that a table in the SYSTEM tablespace that does not
belong to the data dictionary was dropped at 03:00 p.m.
What would you do to recover the table?

A.
use the Flashback Transaction Query feature to identify the relevant SQL statement and
use it to undrop the table

B.
restore the entire database from the most recent backup and open it

C.
recover the table by using the Flashback Table feature

D.
perform point-in-time recovery to recover the table



Leave a Reply 0

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