Oracle
1Z0-043 · Question #125
View the Exhibits. You performed operations on the DEPT4 table as shown in the Exhibit. When you perform the Flashback Versions Query, you find that the first two updates are not listed. What could…
The correct answer is D. The Flashback Versions Query stops producing rows after it encounters a time in the past when the. See the full explanation below for the reasoning.
Question
View the Exhibits. You performed operations on the DEPT4 table as shown in the Exhibit. When you perform the Flashback Versions Query, you find that the first two updates are not listed. What could be the reason? Q106_Exhibit #1 (exhibit):
Q106_Exhibit #2 (exhibit):
Exhibits
Options
- AThe row movement is not enabled on the table.
- BThe first two updates were not explicitly committed.
- CThe Flashback Versions Query lists only the most recent update.
- DThe Flashback Versions Query stops producing rows after it encounters a time in the past when the
How the community answered
(53 responses)- A8% (4)
- B15% (8)
- C4% (2)
- D74% (39)
Community Discussion
No community discussion yet for this question.