Oracle
1Z0-034 · Question #123
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…
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.
Backup and Recovery
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
How the community answered
(35 responses)- A71% (25)
- B3% (1)
- C9% (3)
- D17% (6)
Explanation
The BEFORE DROP clause uses Recycle Bin; The FLASHBACK DATABASE uses flashback logs at FRA area.
Topics
#Flashback Query#undo segments#Flashback Table#SCN dependency
Community Discussion
No community discussion yet for this question.