Exhibit, One of the important tables in the USERStablespace 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认证