Oracle
1Z0-067 · Question #90
1Z0-067 Question #90: Real Exam Question with Answer & Explanation
The correct answer is D. It retrieves all versions of rows that exist in a time interval, including the start time and end time. E. It can be used to retrieve the SQL that is required to undo a row change and the user responsible. https://docs.oracle.com/cd/E11882_01/appdev.112/e41502/adfns_flashback.htm#ADFNS01004
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
Explanation
https://docs.oracle.com/cd/E11882_01/appdev.112/e41502/adfns_flashback.htm#ADFNS01004
Community Discussion
No community discussion yet for this question.