表达条件“学生所在系是计算机系(Sdept = 'CS')、数学系(Sdept = 'MA')和信息系(Sdept = 'IS')”,应该用（）。 A: Sdept IN ('CS', 'MA', 'IS') B: Sdept = 'CS' AND Sdept = 'MA' AND Sdept = 'IS' C: Sdept = 'CS' OR Sdept = 'MA' OR Sdept = 'IS' D: 以上说法都不对

S-L(Sno,Sdept,Sloc)属于三范式（B） 注：Sno →Sdept，Sdept→Sloc

表达条件“学生所在系不是计算机系(Sdept = 'CS')、数学系(Sdept = 'MA')和信息系(Sdept = 'IS')”，应该用 A: Sdept NOT IN('CS', 'MA', 'IS') B: Sdept <> 'CS' ANDSdept <> 'MA' ANDSdept <> 'IS' C: Sdept != 'CS' ANDSdept != 'MA' ANDSdept != 'IS' D: 以上都对

计算机系年龄最大的学生的信息select *from studentwhere __________________________________ A: sdept='计算机系' and sage=(select max(sage) from student where sdept='计算机系') B: sdept='计算机系' and sage=max(sage) C: sdept='计算机系' or sage=(select max(sage) from student ) D: sdept='计算机系' or sage=max(sage)

17e0a6a212da224.gif关系代数练习-学生选课（题干）.docx根据附件内容，查询所在院系是信息工程学院、软件学院、网络空间学院这三个学院的学生姓名、性别和所在院系，正确的SQL语句是（）。 A: select sName,sSex,sDept from student where sDep='信息工程学院' and sDept='软件学院' and sDept='网络空间学院'; B: select sName,sSex,sDept from student where sDep='信息工程学院' or sDept='软件学院' or sDept='网络空间学院'; C: select sName,sSex,sDept from student where sDept in('信息工程学院','软件学院','网络空间学院'); D: select sName,sSex,sDept from student where sDept on('信息工程学院','软件学院','网络空间学院');

S_T数据库关系图如下:[img=332x128]17e448fc85e997f.jpg[/img]查询与“刘晨”在同一个系学习的学生,要求显示学生学号(Sno)、姓名(Sname)及系别(Sdept)。下列SQL语句正确的是()。 A: SELECT Sno, Sname, Sdept FROM Student WHERE Sdept = (SELECT Sdept FROM Student WHERE Sname = '刘晨'); B: SELECT S1.Sno, S1.Sname , S1.Sdept FROM Student S1 , Student S2 WHERE S1.Sdept = S2.Sdept AND S2.Sname = '刘晨'; C: SELECT Sno, Sname, Sdept FROM Student WHERE Sdept IN (SELECT Sdept FROM Student WHERE Sname = '刘晨'); D: SELECT Sno, Sname, Sdept FROM Student WHERE Sdept LIKE (SELECT Sdept FROM Student WHERE Sname = '刘晨');

【单选题】针对学生表student（sno,sname,ssex,sage,sdept），其中sno为学号，sname为姓名，ssex为性别，sage为年龄，sdept为系别。查询学生的姓名sname，系别sdept和年龄sage，显示时按系别升序排列，系别相同的再按年龄降序排列。() A. select * from student  order by sdept , sage B. select sname, sdept, sage  from student  order by sdept , sage desc C. select sname, sdept, sage  from student  order by sdept  desc , sage D. select * from student  order by sdept  desc, sage

查询所有非计算机系学生的信息，不正确的SQL语句是：（ ） A: SELECT * FROM Student WHERE Sdept != 'CS'; B: SELECT * FROM Student WHERE NOT Sdept = 'CS'; C: SELECT * FROM Student WHERE Sdept IN ('MA', 'IS'); D: SELECT * FROM Student WHERE NOT Sdept IN ('CS');

使用教学（STC）数据库，与如下查询语句等价的是（ ）。 SELECT *FROM Student WHERE Sdept = 'CS' EXCEPT SELECT * FROM Student WHERE Sage <= 19; A: SELECT * FROM Student WHERE Sdept = 'CS' AND Sage > 19 B: SELECT * FROM Student WHERE Sdept = 'CS' AND Sage <= 19 C: SELECT * FROM Student WHERE Sdept = 'CS' OR Sage <= 19 D: SELECT * FROM Student WHERE Sdept = 'CS' OR Sage > 19

查询非计算机系中比计算机系中年龄最小者年龄大或相等的学生姓名，不正确的查询语句是： A: SELECT SnameFROM Student S1WHERE NOT EXISTS (SELECT *FROM Student S2WHERE S2.Sdept = 'CS'AND S1.Sage ;= S2.Sage)AND Sdept != 'CS'; B: SELECT SnameFROM StudentWHERE Sage >;= (SELECT MIN(Sage) FROMStudentWHERE Sdept = 'CS')AND Sdept != 'CS'; C: SELECT SnameFROM StudentWHERE Sage >;= ANY (SELECT SageFROM StudentWHERE Sdept = 'CS')AND Sdept != 'CS';