单选题:设有Teachers表,该表的定义如下:
设有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 Teachers VALUES('T100','张鸿')
答案:D
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 Teachers VALUES('T100','张鸿')
答案:D