OCP 1Z0 052 29
来源:互联网 发布:海岛研究所数据大全 编辑:程序博客网 时间:2024/06/05 00:54
29. Your database instance is configured with automatic undo management and the UNDO_RETENTION
parameter is set to 900 seconds. You executed the following command to enable retention guarantee:
SQL> ALTER TABLESPACE undotbs1 RETENTION GUARANTEE;
What effect would this command have on the database?
A.The extents in the undo tablespace retain data until the next full database backup.
B.The extents containing committed undo in the undo tablespace are not overwritten for at least 15
minutes.
C.The extents containing committed data in the undo tablespace are not overwritten until the instance is
shut down.
D.The extents containing committed undo in the undo tablespace are transferred to Flash Recovery Area before being overwritten.
Answer: B
A undo tablespace与备份无关
C 不对,当没有剩余空间时,commit超过15分钟的数据就会被覆盖掉
D flash recovery area 保存的是数据库快照 与 undo是不同的数据,undo不会进入 flash recovery are
parameter is set to 900 seconds. You executed the following command to enable retention guarantee:
SQL> ALTER TABLESPACE undotbs1 RETENTION GUARANTEE;
What effect would this command have on the database?
A.The extents in the undo tablespace retain data until the next full database backup.
B.The extents containing committed undo in the undo tablespace are not overwritten for at least 15
minutes.
C.The extents containing committed data in the undo tablespace are not overwritten until the instance is
shut down.
D.The extents containing committed undo in the undo tablespace are transferred to Flash Recovery Area before being overwritten.
Answer: B
A undo tablespace与备份无关
C 不对,当没有剩余空间时,commit超过15分钟的数据就会被覆盖掉
D flash recovery area 保存的是数据库快照 与 undo是不同的数据,undo不会进入 flash recovery are
0 0
- OCP 1Z0 052 29
- OCP 1Z0 052 1
- OCP 1Z0 052 2
- OCP 1Z0 052 3
- OCP 1Z0 052 4
- OCP 1Z0 052 5
- OCP 1Z0 052 6
- OCP 1Z0 052 7
- OCP 1Z0 052 8
- OCP 1Z0 052 9
- OCP 1Z0 052 10
- OCP 1Z0 052 11
- OCP 1Z0 052 12
- OCP 1Z0 052 13
- OCP 1Z0 052 14
- OCP 1Z0 052 15
- OCP 1Z0 052 16
- OCP 1Z0 052 17
- Extjs xtype和实际对象的对应关系
- C 到C++ 需要作出的改变(一)
- 第2次实验——算法基本功 与 综合思考
- 编程基础知识——C/C++,Java,ObjC的回调方式探讨
- 第九讲:HTML5中的canvas实现推箱子雏形
- OCP 1Z0 052 29
- linux中fork()函数详解 雄文
- android4.0.3 修改启动动画和开机声音
- 2014/6/10
- Java SLL的双向认证
- 鳥哥的 Linux 私房菜
- Spinner 显示的两种方式
- 第2次实验——算法基本功 与 综合思考
- 数据结构—树、森林与二叉树的转换(类C语言描述)