SELETE Sname
F.ROM
5.
[单选题]对于教学数据库的三个基本表:S(Sno,Sname,Ssex),SC(Sno,Cno,Grade),C(Cno,Cname, Teacher),其中S为学生表,SC为学生选课表,C为课程表,则对于语句:检索至少选修LIU老师所授课课程中一门课程的女生姓名,SQL语句错误的是______。A.SELECT Sname FROM S,SC,C WHERE S.Sno=SC.Sno AND SC.Cno=C.Cno AND Teacher=‘LIU’AND Ssex=‘F’B.SELECT Sname
[单选题]对于教学数据库的三个基本表:S(Sno,Sname,Ssex),SC(Sno,Cno,Grade),C(Cno,Cname, Teacher),其中S为学生表,SC为学生选课表,C为课程表,则对于语句:检索至少选修LIU老师所授课课程中一门课程的女生姓名,SQL语句错误的是______。A.) SELECT SnameF.ROM S,SC,CWHERE S.Sno=SC.Sno AND SC.Cno=C.Cno AND Teacher=‘LIU’AND Ssex=‘F’B.) SELECT Sn
[单选题]基于学生-课程数据库中的三个基本表:学生信息表:s(sno, sname, sex, age, dept) 主码为sno 课程信息表:c(cno, cname, teacher) 主码为cno 学生选课信息表:sc(sno, cno, grade) 主码为(sno, cno)“从学生选课信息表中找出无成绩的元组”的SQL语句是A.SELECT * FROM sc WHERE grade=NULLB.SELECT * FROM sc WHERE grade IS ‘ ’C.SELECT * FRO
[单选题]对于学生信息表:student(sno,sname,sex,age,dept),能够得到年龄在20岁到22岁之间的学生的姓名和学号的语句是A.SELECT * FROM student WHERE age BETWEEN 20 AND 22B.SELECT sname,sno FROM student WHERE age BETWEEN 20 AND 22C.SELECT sname,sno FROM student WHERE age>=20D.SELECT sname,sno FROM st
[单选题]对于学生信息表:student(sno,sname,sex,age,dept),如果把学生“张明”的姓名改为“张岩”,则正确的语句是A.UPDATE SET sname='张明'WHERE sname='张岩'B.UPDATE student SET shame='张明'WHERE shame='张岩'C.UPDATE student SET sname='张岩'D.UPDATE student SET sname='张岩'WHERE sname='张明'
[单选题]对于学生信息表STUDENT(SNO, SNAME,SEX,AGE,DEPT)(STUDENT由学号SNO、姓名SNAME、性别SEX、年龄AGE、所在系DEPT 5个属性组成,其中SNO为主码),求年龄20~23岁之间的学生姓名和年龄,正确的语句是( )。A.SELECT SNAME,AGE FROM STUDENT WHERE AGE>20 AND AGE<23B. SELECT*FROM STUDENT WHERE AGE BETWEEN 20 AND 23C.SELECT S
[单选题]对于学生信息表:student(sno, sname, sex, age, dept),能够得到年龄在20岁于22岁之间的学生的姓名和学号的语句是A.SELECT * FROM student WHERE age BETWEEN 20 AND 22B.SELECT sname, sno FROM student WHERE age BETWEEN 20 AND 22C.SELECT sname,sno FROM student WHERE age>=20D.SELECT shame,sno FR
[单选题]对于学生信息表:student(sno,sname,sex,age,grade),查询学习成绩为空的学生的学号和姓名,下面语句正确的是A.SELECT sno,sname FROM student WHERE grade=NULLB.SELECT sno,sname FROM student WHERE grade IS NULLC.SELECT sno,age FROM student WHERE grade IS NULLD.SELECT sno,age FROM student WHERE
[单选题]对于学生信息表:student(sno, sname, sex, age, dept),如果把学生“张明”的姓名改为“张岩”,则正确的语句是A.UPDATE SET sname='张明'WHERE sname='张岩'B.UPDATE student SET sname='张明' WHERE sname='张岩'C.UPDATE student SET sname='张岩'D.UPDATE student SET sname='张岩' WHERE sname='张明'
[单选题]对于学生信息表:student(sno,sname,sex,age,dept),能够得到年龄在20岁于22岁之间的学生的姓名和学号的语句是A.SELECT * FROM student WHERE age BETWEEN 20 AND 22B.SELECT sname,sno FROM student WHERE age BETWEEN 20 AND 22C.SELECT sname,sno FROM student WHERE age>=20D.SELECT sname,sno FROM st