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
注意下面使用闪回技术的语句，这些语句中的哪些将取决于有关还原段中的撤消数据的可用性？
闪回删除是基于回收站；闪回数据库是基于闪回日志；
闪回表、闪回查询和闪回版本查询是基于UNDO数据的；
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
注意下面使用闪回技术的语句，这些语句中的哪些将取决于有关还原段中的撤消数据的可用性？
闪回删除是基于回收站；闪回数据库是基于闪回日志；
闪回表、闪回查询和闪回版本查询是基于UNDO数据的；
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/81227/viewspace-2124281/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
1Z0-053 V13.02 Q633
下一篇：
1Z0-053 V13.02 Q268
请登录后发表评论
登录
全部评论
