Oracle
1Z0-043 · Question #95
1Z0-043 Question #95: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-043 to reveal the answer and full explanation for question #95. The question stem and answer options stay visible for context.
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.
Unlock 1Z0-043 to see the answer
You've previewed enough free 1Z0-043 questions. Unlock 1Z0-043 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.