您在这里:首页 > 技术沙龙&教程 > 资源共享
Oracle视频
Oracle
CUUG课程

练习题(四)

 CREATE TABLESPACE hr_tbs
DATAFILE '/usr/oracle9i/OraHomel/hr_data.dbf' SIZE 2M
AUTOEXTEND ON
MINIMUM EXTENT 4K
NOLOGGING
DEFAULT STORAGE (INITIAL 5K NEXT 5K PCTINCREASE 50)
EXTENT MANAGEMENT DICTIONARY
SEGMENT SPACE MANAGEMENT AUTO;

Why does the statement return an error?

A.  The value of PCTINCREASE is too high.
B.  The size of the data file is too small.
C.  You cannot specify default storage for dictionary managed tablespaces.
D.  Segment storage management cannot be set to auto for a dictionary managed tablespace.
E.  You cannot specify default storage for a tablespace that consists of an autoextensible data file.
F.  The value specified for INITIAL and NEXT storage parameters should be a multiple of the value specified for MINIMUM EXTENT.

Answer:
相关文章 [上一篇] 练习题(三)
010-88589926(88587026)
CUUG热门培训课程
Oracle DBA就业培训
CUUG名师
网络课程
技术沙龙
最新动态

总机:(010)-88589926,88589826,88587026 QQ讨论群:243729577 182441349 邮箱:cuug_bj@cuug.com
通信地址:北京市海淀区紫竹院路98号北京化工大学科技园609室(CUUG)邮政编码:100089 
中国UNIX用户协会 Copyright 2010  ALL Rights Reserved 北京神脑资讯技术有限公司
京ICP备11008061号  京公网安备110108006275号