(648)Note the following statements that use flashback technology:
1. FLASHBACK TABLE
TO SCN;
2. SELECT * FROM
AS OF SCN 123456;
3. FLASHBACK TABLE
TO BEFORE DROP;
4. FLASHBACK DATABASE TO TIMESTAMP;
5. SELECT * FROM
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
答案:(A)
解析:
闪回删除并不使用UNDO数据(因为它是原来的数据就没有删除,只是改了一个名称)
闪回数据库也不使用UNDO数据,它使用的是闪回日志和REDO数据
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/17013648/viewspace-1332042/
,如需转载,请注明出处,否则将追究法律责任。