ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 042-094

042-094

原创 Linux操作系统 作者:jbymy2000 时间:2012-03-15 04:12:09 0 删除 编辑
94. The UNDO_RETENTION parameter in your database is set to 1000 and undo retention is not guaranteed.
Which statement regarding retention of undo data is correct?
A) Undo data becomes obsolete after 1,000 seconds.
B) Undo data gets refreshed after every 1,000 seconds.
C) Undo data will be stored permanently after 1,000 seconds.
D) Committed undo data would be retained for 1,000 seconds if free undo space is available.
E) Undo data will be retained in the UNDO tablespace for 1,000 seconds, then it gets moved to the TEMPORARY tablespace to provide read consistency.
答案:D
UNDO_RETENTION=1000s undo retention is not guaranteed Committed的undo数据会在undo表空间中保留1000s,只要undo 表空间有空闲undo表空间够用

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/11312660/viewspace-718580/,如需转载,请注明出处,否则将追究法律责任。

上一篇: 042-093
下一篇: 042-095
请登录后发表评论 登录
全部评论

注册时间:2012-01-10

  • 博文量
    416
  • 访问量
    203260