A对
B错
第1题:
(40)查找学生姓名及其所选修课程号和成绩,正确的 SQL 语句是
A)SELECT sname FROM student, SELECT cno,grade FROM sc WHERE student.sno =sc.sno
B) FROM sname,cno,grade FROM student,course WHERE student.sno =course.cno
C) SELECT sname ,canme,grade FROM student,course,sc WHERE student.sno =sc.sno and sc.c
no=course.cno
D) SELECT sname ,cno,grade FROM student,sc WHERE student.sno =sc.sno
第2题:
若要求查找‘李’姓学生的学生号和姓名,正确的SQL语句是
A.SELECT S#,SNAME FROM S WHERE SNAME='李%.'
B.SELECT S#,SNAME FROM S WHERE SNAME LIKE '李%.'
C.SELECT S#,SNAME FROM S WHERE SNAME='%.李%.'
D.SELECT S#,SNAME FROM S WHERE SNAME LIKE '%.李%.'
第3题:
此题为判断题(对,错)。
第4题:
若要求查找姓名中第一个字为“李”的学生号和姓名。下面列出的SQL语句中,哪个(些)是正确的?
Ⅰ.SELECT S#,SNAME FROM S WHERE SNAME=‘李%’
Ⅱ.SELECT S#,SNAME FROM S WIERE SNAME LIKE'李%'
Ⅲ.SELECT S#,SNAME FROM S WHERE SNAME LIKE'李_'
A.Ⅰ
B.Ⅱ
C.Ⅲ
D.全部
第5题:
对于学生信息表:student(sno,sname,sex,age,dept),能够得到年龄在20岁到22岁之间的学生的姓名和学号的语句是
A.SELECT * FROM student WHERE age BETWEEN 20 AND 22
B.SELECT sname,sno FROM student WHERE age BETWEEN 20 AND 22
C.SELECT sname,sno FROM student WHERE age>=20
D.SELECT sname,sno FROM student WHERE age<=22
第6题:
(41)若要求查找姓名中第二个字为‘阳’字的学生的学号和姓名,下列 SQL 语句中,哪一个(些)是正
确的?
Ⅰ.SELECT S#,SNAME FROM S WHERE SNAME = '__阳%'
Ⅱ. SELECT S#,SNAME FROM S WHERE SNAME LIKE '__阳%'
Ⅲ. SELECT S#,SNAME FROM S WHERE SNAME LIKE '%阳%'
A)只有Ⅰ
B)只有Ⅱ
C)只有Ⅲ
D)都正确
第7题:
“从学生关系S中检索姓′王′的学生学号”的SQL语句是
A.SELECT sno FROM sc WHERE sname=′王′
B.SELECT sno FROM sc WHERE sname IS LIKE′王%′
C.SELECT sno FROM sc WHERE sname LIKE′王%′
D.SELECT sno FROM sc WHERE sname LIKE′王_′
第8题:
此题为判断题(对,错)。
第9题:
以下2题基于以下说明。设有三个关系:
学生关系S(SNO,SNAME,AGE,SEX) (分别代表学生的学号、姓名、年龄、性别)
学习关系SC(SNO,CNO,GRADE) (分别代表学生的学号、课程编号、成绩)
若在关系S中查找姓名中第一个字为′王′的学生的学号和姓名。下面列出的SQL语句中,正确的是
A.SELECT SNO,SNAME FROM S WHERE SNAME=′王%′
B.SELECT SNO,SNAME FROM S WHERE SNAME=′王_′
C.SELECT SNO,SNAME FROM S WHERE SNAME LIKE′王%′
D.SELECT SNO,SNAME FROM S WHERE SNAME LIKE′王_′
第10题:
在学生表STUD中查询所有姓张的学生的信息,使用的SQL语句是______。
A.SELECT * FROM STUD WHERE 姓名LIKE“张%”
B.SELECT * FROM STUD WHERE 姓名IN(“张%”)
C.SELECT * FROM STUD WHERE 姓名LIKE“张$”
D.SELECT * FROM STUD WHERE 姓名IN(“张$)”