向student表插入一条新记录的正确SQL语句是( )。

A:APPEND INTO student VALUES("0401","王芳","女",18) B:APPEND student VALUES("0401","王芳","女",18) C:INSERT INTO student VALUES("0401","王芳","女",18) D:INSERT student VALUES("0401’,"王芳","女",18)

向student表插入一条新记录的正确SQL语句足______。

A:APPEND INTO student VALUES(’0401’,’王芳’,’女’,18) B:APPEND student VALUES(’0401’,’王芳’,’女’,18) C:INSERT INTO student VALUES(’0401’,’王芳’,’女’,18) D:INSERT student VALUES(’0401’,’王芳’,’女’,18)

如果学生表student是使用下面的SQL语句创建的:
CREATE TABLE student (学号 C(6) PRIMARY KEY NOT NULL,姓名 C(8),性别 C(2),年龄 N(2) CHECK (年龄>15 AND 年龄<30))
下面的SQL语句中可以正确执行的是

A:INSERT INTO student(学号,性别,年龄) VALUES ("0542","李雷","男",17) B:INSERT INTO student(学号,性别,年龄) VALUES ("李雷","男",20) C:INSERT INTO student(学号,性别,年龄) VALUES ("女",25) D:INSERT INTO student(学号,性别,年龄) VALUES ("0897","安宁","女",30)

如果学生表STUDENT是使用下面的SQL语句创建的
CREATE TABLE STUDENT(SNOC(4)PR1MARY KEY NOTNULL;
SNC(8),;
SEXC(2),;
AGEN(2)CHECK(AGE>15AND AGE<30)
下面的SQI语句中可以正确执行的是 ______。

A:INSERT INTO STUDENT(SNO,SEX,AGE)valueS("S9","男",17) B:INSERT INTO STUDENT(SNO,SEX,AGE)valueS(“李安琦”,“男”,20) C:INSERT INTO STUDENT(SEX,AGE)valueS(“男”,20) D:INSERT INTO STUDENT(SNO,SN)valueS("S9",“安琦”,16)

如果学生表STUDENT是使用下面的SQL语句创建的:
CREATE TABLE STUDENT(SNO C(4) PRIMARY KEY NOT NULL,,;
SN C(8),;
SEX C(2),;
AGE N(2) CHECK(AGE>15 AND AGE<30))
下面的SQL语句中可以正确执行的是( )。

A:INSERT INTO STUDENT(SNO, SEX, AGE) VALUES(“S9”,“男”,17) B:INSERT INTO STUDENT(SN, SEX, AGE) VALUES (“李安琦”,“男”,20) C:INSERT INTO STUDENT(SEX, AGE) VALUES (“男”,20) D:INSERT INTO STUDENT(SNO, SN) VALUES (“S9”,“安琦”,16)

若用如下的SQL语句创建了一个STUDENT表:   CREATE TABLE STUDENT(SNO C(4) PRIMARY KEY NOT NULL,;)   NAME C(8) NOT NULL,;   SEX C(2),;   AGE N(2))   下列的SQL语句中可以正确执行的是

A:INSERT INTO STUDENT VALUES('1031','王__', '男',23) B:INSERT INTO STUDENT VALUES('1031',.NULL., '男',23) C:INSERT INTO STUDENT VALUES('1031','王__',.NULL.,.NULL.) D:INSERT INTO STUDENT VALUES(.NULL.,'王__','男',23)

如果学生表student是使用下面的SQL语句创建的
CREATE TABLE student(学号 C(4)PRIMARY KEY NOT NULL,;
姓名 C(8),;
性别 C(2),;
年龄 N(2) CHECK(年龄>15 AND年龄<30))
下面的SQL语句中可以正确执行的是( )。

A:INSERT INTO student(学号,性别,年龄)VALUES("0542","男",17) B:INSERT INTO student(姓名,性别,年龄VALUES("李蕾","女",20) C:INSERT INTO student(姓名,性别,年龄)VALUES("男",25) D:INSERT INTO student(学号,姓名)VALUES("0897","安宁",16)

如果学生表STUDENT是使用下面的SQL语句创建的 CREATE TABLE STUDENT(SNOC(4)PR1MARY KEY NOTNULL; SNC(8),; SEXC(2),; AGEN(2)CHECK(AGE>15AND AGE<30) 下面的SQI语句中可以正确执行的是 ______。

A:INSERT INTO STUDENT(SNO,SEX,AGvalueS("S9","男",17) B:INSERT INTO STUDENT(SNO,SEX,AGvalueS(“李安琦”,“男”,20) C:INSERT INTO STUDENT(SEX,AGvalueS(“男”,20) D:INSERT INTO STUDENT(SNO,SvalueS("S9",“安琦”,16)

向信息系学生视图IS_ STUDENT中插入一个新的学生记录,其中,学号01028,姓名为小红,年龄为18岁,正确的SQL语句是( )。

A:INSERT INTO IS_ STUDENT VALUES('01029','小红',18) B:INSERT INTO IS_ STUDENT VALUES(01029,'小红',18) C:SELECT INTO IS_ STUDENT VALUES(01029,小红,18) D:SELECT INTO IS_ STUDENT VALUES('01029','小红',18)

向student表插入一条新记录的正确SQL语句是

A:APPEND INTO student VALUES(’0401’,’王芳’,’女’,18) B:APPEND student VALUES(’0401’,’王芳’,’女’,18): C:INSERT INTO student VALUES(’0401’,’王芳’,’女’,18) D:INSERT student VALUES(’0401’,’王芳’,’女’,18)

微信扫码获取答案解析
下载APP查看答案解析