Oracle OCP 1Z0 053 Q648(Flashback)

648.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
Answer: A

3. flashback..drop 依賴的是recyclebin

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/8520577/viewspace-2076153/，如需轉載，請註明出處，否則將追究法律責任。