首页 > 数据库 > Oracle > Oracle 11G OCP 1Z0-052 27
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.
答案:(A、B)
解析:
C(X). 多个事务可以共享一个段,而段是由extent组成的,所以多个事务可以共享多个extent
D(X). 应该是循环使用
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/17013648/viewspace-1176658/ ,如需转载,请注明出处,否则将追究法律责任。