What is the correct procedure for recovering a dropped table when DROPPED TABLE RECOVERY has been enabled and the database must remain online?

What is the correct procedure for recovering a dropped table when DROPPED TABLE RECOVERY has been enabled and the database must remain online?
A. Run the RECOVER DATABASE command with the RECOVER DROPPED TABLE option to restore the database and recover the dropped table.
B. Run the RECOVER DATABASE command with the RECOVER DROPPED TABLE option to restore the appropriate table space and recover the dropped table.
C. Restore the database from a backup image that was taken before the table was dropped; run the ROLLFORWARD DATABASE command with the RECOVER DROPPED TABLE option to restore the database and recover the dropped table.
D. Restore the appropriate table space from a backup image that was taken before the table was dropped; run the ROLLFORWARD DATABASE command with the RECOVER DROPPED TABLE option to restore the appropriate table space and recover the dropped table.

Download Printable PDF. VALID exam to help you PASS.

Leave a Reply

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


The reCAPTCHA verification period has expired. Please reload the page.