One of the important tables in the USERStablespace was dropped and purged from the recycle
bin at 9:00 A.m. You noticed that 11:00 A.m. and you want to perform an incomplete recovery to
recover the table. Which statement is true?
A.
You must recover all data files to the required system change number (SCN).
B.
You must recover all data files, except those that are offline, to the required SCN.
C.
You must recover all data files belonging to the USERStablespace to the required SCN.
D.
You cannot recover all data files because segment space management is performed manually
for the undotablespace.