A user has inserted wrong department data in the DEPT3table in the USERS tablespace. You use
the Flashback Table functionality to rectify the erroneous inserts. While performing the recovery,
you choose 2004343 as the Flashback SCN. Which two statements are correct in this scenario?
(Choose two.)
A.
Only the row with DEPARTMENT_ID 290 would be flashed back.
B.
The rows with DEPARTMENT_ID 290 and 300 would be flashed back.
C.
The rows with DEPARTMENT_ID 290 and 280 would be flashed back.
D.
You would have taken the USERStablespace offline before starting the Flashback Table
operation.
E.
You would have enabled row movement for the DEPT3 table before starting the Flashback
Table operation.