PrepAway - Latest Free Exam Questions & Answers

What is the correct procedure for recovering a dropped table when DROPPED TABLE RECOVERY has been enabled and

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

PrepAway - Latest Free Exam Questions & Answers

A.
Run the RECOVER DATABASE command with the RECOVER DROPPED TABLE
option to restore the appropriate table space and recover thedropped table.

B.
Restore the database from a backup image that was taken before the table was dropped;
run the ROLLFORWARD DATABASE command withthe RECOVER DROPPED TABLE
option to restore the database and recover the dropped table.

C.
Restore the appropriate table space from a backup image that was taken before the table
was dropped; run the ROLLFORWARD DATABASEcommand with the RECOVER
DROPPED TABLE option to restore the appropriate table space and recover the dropped
table.

D.
Run the RECOVER DATABASE command with the RECOVER DROPPED TABLE
option to restore the database and recover the droppedtable.


Leave a Reply