数据库习题 模拟2.docVIP

练习9 单项选择题 SQL语言是( )语言 层次数据库 B.网络数据库 C. √关系数据库 D.非数据库 在SQL语言中,实现数据检索的语句是( ) √SELECT B.INSERT C.UPDATE D.DELETE 下列SQL语句中,修改表结构的是( ) √ALTER B.CREATE C.UPDATE D.INSERT 第(4)~(7)题基于这样的3个表即学生表S、课程表C和学生选课表SC,它们的结构如下: S(S#,SN,SEX,AGE,DEPT) C(C#,CN) SC(S#,C#,GRADE) 其中:S#为学号,SN,为姓名,SEX为性别,AGE为年龄,DEPT为系别,C#为课程号,CN为课程名,GRADE为成绩 检索所有比王华同学年龄大的学生姓名、年龄和性别.正确的SELECT语句是( ) √SELECT,AGE,SEX FROM S; WHERE AGE(SELECT AGE FROM S WHERE SN=王华) B.SELECT SN,AGE,SEX; FROM S; C.SELECT SN,AGE,SEX ,FROM S; WHERE AGE(SELECT AGE WHERE SN=王华) D.SELECT SN,AGE,SEX,FROM S; WHERE AGE王华.AGE 检索选修课程C2的学生中成绩最高的学生的学号,正确的SELECT语句是( ) SELECT S# FORM SC; WHERE C#=C2 AND GRADE =; (SELECT GRADE FROM SC WHERE C#=C2) B.SELECT S# FORM SC WHERE C#=C2 AND GRADE IN; (SELECT GRADE FROM SC WHERE C#=C2) C.SELECT S# FORM SC; WHERE C#=C2 AND GRADE NOT IN; (SELECT GRADE FROM SC WHERE C#=C2) D. √SELECT S# FORM SC; WHERE C#=C2 AND GRADE =ALL; (SELECT GRADE FROM SC WHERE C#=C2) 检索学生姓名及其所选修课程的课程号和成绩.正确的SELECT语句是( ) SELECT S.SN,SC.C#,SC.GRADE; FROM S; WHERE S.S#=SC.S# B.SELECT S.SN,SC.C#,SC.GRADE; FROM SC; WHERE S.S#=SC.GRADE C. √SELECT S.SN,SC.C#,SC.GRADE; FROM S,SC; WHERE S.S#=SC.S# D.SELECT S.SN,SC.C#,SC.GRADE; FROM S.SC 检索选课在四门以上的课程的学生总成绩不统计不及格的课程),并要求按总成绩的降序排列出来,正确的SELECT语句是( ) SELECT S#, SUM(GRADE) FROM SC; WHERE GRADE=60; GROUP BY S#; ORDER BY 2 DESC; HAVING COUNT (*)=4 B. √SELECT S#,SUM(GRADE) FROM SC; WHERE GRADE=60; GROUP BY S#; HAVING COUNT (*).=4; ORDER BY 2 DESC C.SELECT S#,SUM(GRADE) FROM SC; WHERE GRADE=60; HAVING COUNT (*)=4; GROUP BY S#; ORDER BY 2 DESC D.SELECT S#,SUM(GRADE) FROM SC; WHERE GRADE=60; ORDER BY 2 DESC; GROUP BY S#; HAVING COUNT (*)=4 假定学生关系是S(SNAME, SEX, AGE),课程关系是C( C#, CNAME,TEACHER),学生选课关系是SC(S#, C#,GRADE).要查找选修COMPUTER课程的女学生姓名,将涉及到关系( ) S B. √SC,C C.S,SC