nerdexam
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)
  • A
    81% (34)
  • B
    12% (5)
  • C
    5% (2)
  • D
    2% (1)

Community Discussion

No community discussion yet for this question.

Full 1Z0-067 Practice