Which two statements are true about Flashback Version Query?

Which two statements are true about Flashback Version Query?

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:
https://docs.oracle.com/cd/E11882_01/appdev.112/e41502/adfns_flashback.htm#ADFNS01004



Leave a Reply 0

Your email address will not be published. Required fields are marked *