Oracle Exam 1Z0-063 Topic 4 Question 16 Discussion

Examine the statements that use flashback technologies:

1. FLASHBACK TABLE customers TO TIMESTAMP TO_TIMESTAMP ('2013-02-04 09:30:00', 'YYYY-MM-DD HH:MI:SS');

2. SELECT * FROM customers AS OF SCN 123456;

3. FLASHBACK TABLE customers TO BEFORE DROP;

4. FLASHBACK DATABASE TO TIMESTAMP TO_TIMESTAMP ('2013-02-04 09:30:00', 'YYYY-MM-DD HH:MI:SS');

5. SELECT * FROM customers VERSIONS BETWEEM SCN 123456 AND 123999;

6. ALTER TABLE customer FLASHBACK ARCHIVE;

Which set of statements depends on the availability of relevant undo data in the undo tablespace?