Which of the following are the correct statements of using the Flashback Query feature in Oracle?

Which of the following are the correct statements of using the Flashback Query feature in Oracle? Eachcorrect
answer represents a complete solution. Choose all that apply.

A.
CREATE TABLE AS SELECT AS OF

B.
SELECT AS OF

C.
CREATE TABLE AS SELECT

D.
INSERT INTO (SELECT )

Explanation:
Answer A and BYou perform a Flashback Query by 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 by means of a timestamp or SCN.
It returns committed data that was current
at that point in time. To use the results of a Flashback Query in a DDL or DML statement that affects the
current state of the database, use an
AS OF clause inside the INSERT or CREATE TABLE AS SELECT statement. Answer C is incorrect. The
CREATE TABLE AS SELECT command is used to create a table with data and structure copied from another
table. Since there is no use of the AS OF clause inthis statement, this command is not a Flashback Query
command; instead it’s the normal
CREATE TABLE command.
Answer D is incorrect. INSERT INTO (SELECT ) is nota Flashback Query because the AS OF clause is not
used in this command. This
command will select data from a table and insert into another table on which the INSERT INTO clause is
based. Flashback Query does support
insert commands, but the correct usage is INSERT INTO (SELECT AS OF).