当前位置:在线题库搜索>[单选题] 设有Teachers表,该表的定义如下:CREATE TABLE Teachers(Tno CHAR(8) PRIMARY KEY,    Tname VARCHAR(10) NOT NULL,    Age TINYINT CHECK(Age BETWEEN 25 AND 65) )下列插入语句中,不能正确执行的是 (     )的答案是什么?

问题:

[单选题] 设有Teachers表,该表的定义如下:
CREATE TABLE Teachers(
Tno CHAR(8) PRIMARY KEY,
    Tname VARCHAR(10) NOT NULL,
    Age TINYINT CHECK(Age BETWEEN 25 AND 65) )
下列插入语句中,不能正确执行的是 (     )

A、INSERT INTO Teachers VALUES('T100','张鸿',NULL)
B、INSERT INTO Teachers(Tno,Tname,Age) VALUES('T100','张鸿',30)
C、INSERT INTO Teachers(Tno,Tname) VALUES('T100','张鸿')
D、INSERT INTO TeachersVALUES('T100','张鸿')

参考答案: D

相关内容