技术活动
CUUG学员就业信息
学员感言、就业资讯
报名热线
软件&工具
当前您的位置:首页 > 技术活动 > 技术中心 > 软件&工具
练习题(四)-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: