Oracle 11G OCP 1Z0-052 28
（28）View the Exhibit and examine the undo tablespace attributes.
Your database instance is experiencing a large volume of transactions from non-DBA users in the last one hour.
答案：（A）
Your database instance is experiencing a large volume of transactions from non-DBA users in the last one hour.
The undo tablespace UNDOTBS1 is full with transactions and no transaction was committed more than one hour ago. The database has two more undo tablespaces.
What happens to the new DML operations in this scenario?
A.The DML commands will fail.
B.The undo data generated by the DML is stored in one of the two other undo tablespaces.
C.The undo data generated by the DML will overwrite the extents that contain committed undo data.
D.The undo data generated by the DML is stored in the SYSTEM undo segment of the SYSTEM tablespace.答案：（A）
解析：因为UNDO_RETENTION = 60分钟，Retention Guarantee = Yes，Auto-Extensible = false
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/17013648/viewspace-1176660/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
最新文章
- 2015.09.18 网络公开课 《Oracle 11G OCP试题精讲（4）》
- 2015 最新OCM 10g考试资料汇总 Skillset 7（1）
- 2015 最新OCM 10g考试资料汇总 Skillset 6（2）
- 2015 最新OCM 10g考试资料汇总 Skillset 6（1）
- 2015.05.15 网络公开课 《Oracle 11G RAC深入探索之RAC和RAC One Node之间的切换》
- 2015 最新OCM 10g考试资料汇总 Skillset 5（5）
- 2015 最新OCM 10g考试资料汇总 Skillset 5（3）
- 2015 最新OCM 10g考试资料汇总 Skillset 5（2）
- 2015.04.10 网络公开课 《玩转DG系列之-使用RMAN创建物理DG》
- 2015 最新OCM 10g考试资料汇总 Skillset 5（1）
