nerdexam
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)
  • A
    5% (1)
  • B
    5% (1)
  • C
    82% (18)
  • D
    9% (2)

Community Discussion

No community discussion yet for this question.

Full 1Z0-063 Practice