View the Exhibit.  One of the important tables in the USERS tablespace was dropped and purged from the recycle bin at 9:00 a.m. You noticed this at 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 USERS tablespace to the required SCN.
D:You cannot recover all data files because segment space management is performed manually for the undo tablespace.
出自:Oracle认证