Exhibit
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 USERS tablespace to the required SCN.
D.
You cannot recover all data files because segment space management is performed
manually for the undo tablespace.