Oracle
1Z0-067 · Question #232
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 A. 1, 2, 5. 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 BETWEEN SCN 123456 AND 123999; 6. ALTER TABLE customers FLASHBACK ARCHIVE; Which set of statements depends on the availability of relevant undo data in the undo tablespace? (Choose the best answer.)Options
- A1, 2, 5
- B1, 3, 6
- C2, 3, 5, 6
- D3, 4, 5
How the community answered
(42 responses)- A81% (34)
- B12% (5)
- C5% (2)
- D2% (1)
Community Discussion
No community discussion yet for this question.