如果学生表STUDENT是使用下面的SQL语句创建的: CREATE TABLE STUDENT(SNO C(4)PRIMARY KEY NOT NULL. SN C(8), SEX C(2), AGE N(2)CHECK(AGE15 AND AGE25)) 下面的SQL语句中可以正确执行的是( )。A. INSERT INTO STUDENT(SN,SEX,AGE)VALUES(”王磊”,”男”,20)B. INSERT INTO STUDENT(SN0,SEX,AGE)VALUES(”S9”,”男”,17)C. INSERT INTO STUDENT(SEX,AGE)VALUES(”男”,20)D. INSERT INTO STUDENT(SN0,SN,AGE)VALUES(”S9”,”王磊”,14)

如果学生表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<25)) 下面的SQL语句中可以正确执行的是( )。

A. INSERT INTO STUDENT(SN,SEX,AGE)VALUES(”王磊”,”男”,20)

B. INSERT INTO STUDENT(SN0,SEX,AGE)VALUES(”S9”,”男”,17)

C. INSERT INTO STUDENT(SEX,AGE)VALUES(”男”,20)

D. INSERT INTO STUDENT(SN0,SN,AGE)VALUES(”S9”,”王磊”,14)


相关考题:

用SQL语句创建简单数据表设教学管理数据库中有多张数据表,其中学生表Student包括学生编号Sno,学生姓名Sname,学生年龄Sage,学生性别Ssex字段;Sno和Sname为字符型(长度20), Sage为整型,Ssex为位型。Sno是主键。课程表Course包括课程编号Cno,课程名Cname,授课教师Teacher字段;三个字段均为字符型(长度20) , Cno是主键。请用SQL语句创建上面的两张数据表。

根据SQL标准,删除表student中对字段sno的唯一性约束,应该使用下面哪条语句? ()A drop sno from table studentB alter table student drop snoC alter table student drop unique(sno)D alter table student drop sno unique

如果学生表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)

如果学生表STUDENT是使用下面的SQL语句创建的CREATE TABLE STUDENT (SNO C (4) PRIMARY KEY NOT NULL , ;SN C (8) , ;SEX C (2) , ;AGE N (2) CHECK (AGE15 AND AGE30 ))下面的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)

如果学生表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)

如果学生表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语句中可以正确执行的是( )。AA.BB.CC.DD.答案

下面的SQL语句也可以用带Join关键词的语句来实现。 Select Student.Sno,Student.Sname, SC.Cno,SC.Grade From SC,Student Where SC.Sno=Student.Sno

将SC和Student表连接起来,显示学生的学号、姓名、课程号、考试分数,不正确的SQL语句是()。A.Select Student.Sno,Student.Sname, SC.Cno,SC.Grade From SC,Student Where SC.Sno=Student.SnoB.Select Student.Sno,Student.Sname, SC.Cno,SC.Grade From SC Join Student On SC.Sno=Student.SnoC.Select Student.Sno,Student.Sname, SC.Cno,SC.Grade From Student Join SC On SC.Sno=Student.SnoD.Select Student.Sno,Student.Sname, SC.Cno,SC.Grade From SC,Student On SC.Sno=Student.Sno

9、将SC和Student表连接起来,显示学生的学号、姓名、课程号、考试分数,不正确的SQL语句是()。A.Select Student.Sno,Student.Sname, SC.Cno,SC.Grade From SC,Student Where SC.Sno=Student.SnoB.Select Student.Sno,Student.Sname, SC.Cno,SC.Grade From SC Join Student On SC.Sno=Student.SnoC.Select Student.Sno,Student.Sname, SC.Cno,SC.Grade From Student Join SC On SC.Sno=Student.SnoD.Select Student.Sno,Student.Sname, SC.Cno,SC.Grade From SC,Student On SC.Sno=Student.Sno