ITPub博客

首页 > 数据库 > Oracle > 1Z0-052 V12.49 Q87

1Z0-052 V12.49 Q87

原创 Oracle 作者:cow977 时间:2016-05-12 12:42:27 0 删除 编辑
QUESTION 87
Which statement is true about the UNDO_RETENTION parameter when retention guarantee is not enabled?
A. It is the time period after which the undo data becomes obsolete.
B. It is the time period after which the committed undo data would be transferred to a temporary tablespace.
C. It is the minimum time period up to which the committed undo data would be retained if free undo space is available.
D. It is the time period after which the undo data is transferred to the Flash Recovery Area to provide read consistency.
Correct Answer: C

当retention guarantee没有设置时,即undo数据不强制保留UNDO_RETENTION 所设置的时间。
如果undo表空间是自动增长,或在有足够的空闲空间情况下,则可能会保留到UNDO_RETENTION 所设置的时间。
如果undo表空间是固定的,则UNDO_RETENTION 可能会被忽略,undo数据可能被覆盖。

C答案:如果有足够的空闲undo表空间,则undo数据会保留,保留的时间为UNDO_RETENTION所设置的时间。是正确的。

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

上一篇: 1Z0-052 V12.49 Q53
下一篇: 1Z0-052 V12.49 Q94
请登录后发表评论 登录
全部评论

注册时间:2011-03-02

  • 博文量
    698
  • 访问量
    893887