Oracle
1Z0-063 · Question #26
Which two statements are true about Flashback Version Query?
The correct answer is A. The result of a query can be used as part of a DML statement. C. It can be used only if Flashback Data Archive is enabled for a table. See the full explanation below for the reasoning.
Question
Which two statements are true about Flashback Version Query?
Options
- AThe result of a query can be used as part of a DML statement.
- BIt can be used to create views.
- CIt can be used only if Flashback Data Archive is enabled for a table.
- DIt retrieves all versions of rows that exist in a time interval, including the start time and end time.
- EIt can be used to retrieve the SQL that is required to undo a row change and the user responsible
How the community answered
(29 responses)- A79% (23)
- B14% (4)
- D3% (1)
- E3% (1)
Community Discussion
No community discussion yet for this question.