Oracle
1Z0-034 · Question #123
1Z0-034 Question #123: Real Exam Question with Answer & Explanation
The correct answer is A. 1, 2, and 5. The BEFORE DROP clause uses Recycle Bin; The FLASHBACK DATABASE uses flashback logs at FRA area.
Question
Note the following statements that use flashback technology: 1. FLASHBACK TABLE <table> TO SCN <scn>; 2. SELECT * FROM <table> AS OF SCN 123456; 3. FLASHBACK TABLE <table> TO BEFORE DROP; 4. FLASHBACK DATABASE TO TIMESTAMP <timestamp>; 5. SELECT * FROM <table> VERSIONS AS OF SCN 123456 AND 123999; Which of these statements will be dependent on the availability of relevant undo data in the undo segment?
Options
- A1, 2, and 5
- B1, 3, and 4
- C2, 3, 4, and 5
- D1, 2, 3, 4, and 5
Explanation
The BEFORE DROP clause uses Recycle Bin; The FLASHBACK DATABASE uses flashback logs at FRA area.
Community Discussion
No community discussion yet for this question.