一.单选题（共6题,66.6分）

1查询刘晨同学的学号,可以使用的SQL语句是:

?A、SELECT Sno FROM Student WHERE Sname = '刘晨';

?B、SELECT Sno FROM Student WHERE Sname == '刘晨';

?C、SELECT Sno FROM Student WHERE Sname = "刘晨";

?D、SELECT Sno FROM Student WHERE Sname == "刘晨";

正确答案：A

2选择题:查询所有名字中包含“数”字的课程信息,可以使用的SQL语句是: ?A、SELECT * FROM Course WHERE Cname = '*数*';

?B、SELECT * FROM Course WHERE Cname LIKE '*数*';

?C、SELECT * FROM Course WHERE Cname LIKE '_数_';

?D、SELECT * FROM Course WHERE Cname LIKE '%数%';

正确答案：D

3假设学号是9位数,前7位表示班级号,后两位表示学生在班级内的序号,如学号201215122表示2012151班的第22位学生。若要查询2012151班所有学生的学号和姓名,( ) ?A、SELECT Sno, Sname FROM Student WHERE Sno LIKE '2012151_';

?B、SELECT Sno, Sname FROM Student WHERE Sno LIKE '2012151__';

?C、SELECT Sno, Sname FROM Student WHERE Sno LIKE '2012151**';

?D、SELECT Sno, Sname FROM Student WHERE Sno LIKE '2012151==';

正确答案：B

4查询所有非计算机系学生的信息,不正确的SQL语句是:( )

?A、SELECT * FROM Student WHERE Sdept != 'CS';

?B、SELECT * FROM Student WHERE NOT Sdept = 'CS';

?C、SELECT * FROM Student WHERE NOT Sdept IN ('CS');

?D、SELECT * FROM Student WHERE Sdept IN ('MA', 'IS');

正确答案：D

5查询曾经考过100分的学生的学号,可以使用的SQL语句是:( )

?A、SELECT ALL Sno FROM SC WHERE Grade = 100;

?B、SELECT DISTINCT Sno FROM SC WHERE Grade = 100;

?C、SELECT ALL Sno FROM Student WHERE SC.Grade = 100;

?D、SELECT DISTINCT Sno FROM Student WHERE SC.Grade = 100;

正确答案：B

6查询学号为“201215121”和学号为“201215122”的两个学生中任一学生选修过的课程的课程号,可以使用的SQL语句是:( )

?A、SELECT Cno FROM SC WHERE Sno NOT IN ('201215121', '201215122');

?B、SELECT Cno FROM SC WHERE Sno = '201215121' OR Sno = '201215122';

?C、SELECT Cno FROM SC WHERE Sno = '201215121' AND Sno = '201215122';

?D、SELECT Cno FROM SC WHERE Sno != '201215121' OR Sno != '201215122';

…… 此处隐藏0字 ……

正确答案：B

二.判断题（共3题,33.4分）

1可以为SELECT子句中的目标列表达式指定别名,一种方法是直接在目标列表达式后加上空格和别名。

答案：√

2如果要在WHERE子句中判断某元组的某一字段(假设是FieldName)是否为空值,可以使用FieldName IS NULL 语法,也可以使用FieldName = NULL 语法。

答案：错

3假设某同学年龄为30岁(Sage=30),另一个同学年龄为20岁(Sage=20),则他们都不满足Sage BETWEEN 20 AND 30.

答案：：错