一道选择题

[y0z0]

1. Given the following CREATE TABLE statement:
CREATE TABLE t1 (
col1 INTERGER NOT NULL CONSTRAINT chk1 UNIQUE,
col2 DATE NOT NULL CHECK(col2<=CURRENT_DATE),
col3 CHARACTER(128) NOT NULL WITH DEFAULT USER,
col4 VARCHAR(300) NOT NULL WITH DEFAULT )
which column caused the statement to fail and why?

A.col1 B.col2 C.col3 D.col4

[y0z0]

自己顶一下。。。

[yxhballme]

1.INTERGER 错了该是INTEGER
2.CURRENT_DATE你是准备区当前日期吧.这点有点问题

[y0z0]

Thanks