Oracle
1Z0-063 · Question #214
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…
The correct answer is C. 2,3,5,6. See the full explanation below for the reasoning.
Question
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?Options
- A1,2,5
- B1,3,6
- C2,3,5,6
- D3,4,5
How the community answered
(22 responses)- A5% (1)
- B5% (1)
- C82% (18)
- D9% (2)
Community Discussion
No community discussion yet for this question.