练习题（四）

 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：