【单选题】有如下表定义,( )插入语句是正确的。CREATE TABLE student(studentid int not null,name char(10) null,age int not null,sex char(1) not null,dis char(10))
A.
INSERT INTO student VALUES(11,'abc',20, 'f')
B.
INSERT INTO student(studentid,sex,age) VALUES (11,'f',20)
C.
INSERT INTO student(studentid,sex,age) VALUES (11,20, 'f',NULL)
D.
INSERT INTO student SELECT 11, 'ABC',20, 'F', 'test'