OCP 1Z0 052 27
来源:互联网 发布:android 调用java接口 编辑:程序博客网 时间:2024/05/16 05:36
27. Which two statements are true regarding transactions in an Oracle database? (Choose two.)
A.Multiple transactions can use the same undo segment.
B.A transaction is assigned an undo segment when it is started.
C.More than one transaction cannot share the same extent in the undo tablespace.
D.The transactions use system undo segment to store undo data if all the segments in the undo
tablespace are used.
Answer: AB
D 不对
if the database instance does not have a designated undo tablespace, then the transaction binds to the system undo segment.
而当有undo tablespace又不够时,会报错
A.Multiple transactions can use the same undo segment.
B.A transaction is assigned an undo segment when it is started.
C.More than one transaction cannot share the same extent in the undo tablespace.
D.The transactions use system undo segment to store undo data if all the segments in the undo
tablespace are used.
Answer: AB
见 http://docs.oracle.com/cd/E11882_01/server.112/e40540/logical.htm#CNCPT305
Undo Segments and Transactions
When a transaction starts, the database binds (assigns) the transaction to an undo segment, and therefore to a transaction table, in the current undo tablespace
Multiple active transactions can write concurrently to the same undo segment or to different segments.D 不对
if the database instance does not have a designated undo tablespace, then the transaction binds to the system undo segment.
而当有undo tablespace又不够时,会报错
0 0
- OCP 1Z0 052 27
- 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
- C++11新特性:右值引用和转移构造函数
- DataTable删除行
- JAVA比较两个数组中的元素是否相同
- Java比较两个数组中的元素是否相同的最简单方法
- ARC简介以及工程中ARC与非ARC的混合
- OCP 1Z0 052 27
- phpcmsV9 域名变更后设置
- Oracle中Access & filter
- 由浅入深探究mysql索引结构原理、性能分析与优化
- 黑马程序员--动态代理
- 一日的感想
- NSSearchPathForDirectoriesInDomains对文件的操作
- 今年的高考依旧备受国人关注
- iOS开发- 隐藏键盘总结