Oracle Database 12c: Advanced Administration — Question 54

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?

Answer options

• A. 1,2,5
• B. 1,3,6
• C. 2,3,5,6
• D. 3,4,5

Correct answer: C

Explanation

The correct answer is C because statements 2, 3, 5, and 6 require access to undo data to return to a previous state or to view versions of the data. Statement 1 and 4 do not depend on undo data for their operations since they reference specific timestamps or conditions that do not require undo information.