Oracle
1Z0-043 · Question #95
View the Exhibit. 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 correct answer is B. The rows with DEPARTMENT_ID 290 and 300 would be flashed back. E. You would have enabled row movement for the DEPT3 table before starting the Flashback Table operation. See the full explanation below for the reasoning.
Question
View the Exhibit. 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 choose 2004343 as the Flashback SCN. Which two statements are correct in this scenario? (Choose two.)
Exhibit
Options
- AOnly the row with DEPARTMENT_ID 290 would be flashed back.
- BThe rows with DEPARTMENT_ID 290 and 300 would be flashed back.
- CThe rows with DEPARTMENT_ID 290 and 280 would be flashed back.
- DYou would have taken the USERS tablespace offline before starting the Flashback Table operation.
- EYou would have enabled row movement for the DEPT3 table before starting the Flashback Table operation.
How the community answered
(33 responses)- A6% (2)
- B70% (23)
- C9% (3)
- D15% (5)
Community Discussion
No community discussion yet for this question.