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?
A.
1, 2, and 5
B.
1, 3, and 4
C.
2, 3, 4, and 5
D.
1, 2, 3, 4, and 5
Explanation:
The BEFORE DROP clause uses Recycle Bin;
The FLASHBACK DATABASE uses flashback logs at FRA area.