Which two statements are true about Flashback Version Query?
A.
The result of a query can be used as part of a DML statement.
B.
It can be used to create views.
C.
It can be used only if Flashback Data Archive is enabled for a table.
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 for the change.
Explanation:
BD
You can create a view that refers to past data by using the AS OF clause in the SELECT statement that defines the view.
Use Oracle Flashback Version Query to retrieve the different versions of specific rows that existed during a given time interval. A row version is created whenever a COMMIT statement is executed.
DE!
yes sorry DE