---

View the Exhibit and examine the Flashback SCNs.  A user has inserted wrong department data in the DEPT3 table in the USERS tablespace. You use the Flashback Table functionality to rectify the erroneous inserts. While performing the recovery， you chose 2004343 as the Flashback SCN.  Which two statements are correct in this scenario？（）
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 USERS tablespace offline before starting the Flashback Table operation.
E:You would have enabled row movement for the DEPT3 table before starting the Flashback Table operation.

---

出自：Oracle认证

显示答案