Which of the following can be used in conjunction with a Flashback Versions Query to filter
the results? (Choose all that apply.)
A.
A range of SCN values
B.
A list of SCN values
C.
A starting and ending timestamp
D.
Minimum and maximum sequence values
E.
A list of sequence values
A and C are correct:
https://docs.oracle.com/cd/B13789_01/appdev.101/b10795/adfns_fl.htm
Using Flashback Query (SELECT … AS OF)
You perform a Flashback Query using a SELECT statement with an AS OF clause. You use a Flashback Query to retrieve data as it existed at some time in the past. The query explicitly references a past time using a timestamp or SCN. It returns committed data that was current at that point in time.