8、Examine the statements that use flashback technologies:
-
FLASHBACK TABLE customers TO TIMESTAMP TO_TIMESTAMP(‘2013-02-04 09:30:00‘, ‘YYYY-MM-DD HH:MI:SS‘);
-
SELECT * FROM customers AS OF SCN 123456;
-
FLASHBACK TABLE customers TO BEFORE DROP;
-
FLASHBACK DATABASE TO TIMESTAMP TO_TIMESTAMP(‘2013-02-04 09:30:00‘, ‘YYYY-MM-DD HH:MI:SS‘);
-
SELECT * FROM customers VERSIONS BETWEEN SCN 123456 AND 123999;
- ALTER TABLE customers FLASHBACK ARCHIVE;
Which set of statements depends on the availability of relevant undo data in the undo tablespace?
A) 1,3,6
B) 1,2,5
C) 3,4,5
D) 2,3,5,6