请在 下方输入 要搜索的题目：
推荐参考答案 (
由 搜题小帮手 官方老师解答 )
答案：
以下文字与答案无关
提示：有些试题内容 显示不完整,文字错误 或者 答案显示错误等问题，这是由于我们在扫描录入过程中 机器识别错误导致,人工逐条矫正总有遗漏，所以恳请 广大网友理解。
相关试题
- 1.查询表student（sno,sname,sage,ssex,sphone,cno）中男生的相关信息的SQL语句为（ ）选项： A:select * from student where ssex='男' ; B:select sno,sname,sage,ssex,sphone,cno from student order by ssex='男' ; C:select sno,sname,sage,ssex,sphone,cno from student having ssex='男' ; D: SELECT* FROM student Group By ssex='男‘
- 2.下列哪个语句格式正确？选项： A:SELECT Sno FROM Student GROUP BY Ssex WHERE Sdept="CS" B:SELECT Sno FROM Student ORDER BY Ssex WHERE Sdept="CS" GROUP BY Ssex C:SELECT Sno FROM Student WHERE Sdept="CS" ORDER BY Ssex D:SELECT Sno FROM Student ORDER BY Ssex WHERE Sdept="CS"
- 3.从Student表检索年龄小于21岁的男学生信息,最规范的SQL语句是( )。 选项： A、Select * From Student Where Ssex='男' Or Sage B、Select * From Student Where Ssex='男' And Sage<21 C、Select * From Student Where Ssex=男 And Sage D、Select * From Student Where Ssex='男' Or Sage<21
- 4.查询表student（sno,sname,sage,ssex,sphone,cno）中所有学生的所有信息，下面语句不正确的是（ ） 选项： A、select * from student B、select sno,sname,sage,ssex,sphone,cno from student C、select from student D、SELECT * FROM STUDENT
- 5.从Student表检索年龄小于21岁的男学生信息，最规范的SQL语句是( )。 选项： A、Select * From Student Where Ssex='男' Or Sage<'21' B、Select * From Student Where Ssex='男' Or Sage<21 C、Select * From Student Where Ssex=男 And Sage<'21' D、Select * From Student Where Ssex='男' And Sage<21
- 6.从Student表检索年龄小于21岁的男学生信息，最规范的SQL语句是( )。 选项： A、Select * From Student Where Ssex='男' Or Sage<'21' B、Select * From Student Where Ssex='男' Or Sage<21 C、Select * From Student Where Ssex=男 And Sage<'21' D、Select * From Student Where Ssex='男' And Sage<21
- 7.在学生选课数据库中有学生表student(sno,sname,ssex,sage,sdept)，课程表course(cno,cname)及学生选课表sc(sno,cno,grade)，其中sno是学号，sname是姓名，ssex是性别，sage是年龄，sdept是系别，cno是课程号，cname是课程名，grade是成绩。以下（ ）SQL语句可以实现查询选修了'C002'号课程的学生姓名。 选项： A:select sname from student, sc where student.sno=sc.sno and cno='C002'; B:select sname from student where sno in (select sno from sc where cno='C002'); C:select sname from student where sno = (select sno from sc where cno='C002'); D:select sname from student where exixts (select * from sc where student.sno=sc.sno and cno='C002')
- 8.在学生选课数据库中有学生表student(sno,sname,ssex,sage,sdept)，课程表course(cno,cname)及学生选课表sc(sno,cno,grade)，其中sno是学号，sname是姓名，ssex是性别，sage是年龄，sdept是系别，cno是课程号，cname是课程名，grade是成绩。以下（ ）SQL语句可以实现查询选修了'C002'号课程的学生姓名。选项： A:select sname from student, sc where student.sno=sc.sno and cno='C002'; B:select sname from student where sno in (select sno from sc where cno='C002'); C:select sname from student where sno = (select sno from sc where cno='C002'); D:select sname from student where exixts (select * from sc where student.sno=sc.sno and cno='C002')
- 9.在学生选课数据库中有学生表student(sno,sname,ssex,sage,sdept)，课程表course(cno,cname)及学生选课表sc(sno,cno,grade)，其中sno是学号，sname是姓名，ssex是性别，sage是年龄，sdept是系别，cno是课程号，cname是课程名，grade是成绩。以下（ ）SQL语句可以实现查询没有选修'C002'号课程的学生姓名。选项： A:select sname from student, sc where student.sno=sc.sno and cno !='C002'; B:select sname from student where sno not in (select sno from sc where cno='C002'); C:select sname from student where exixts (select * from sc where student.sno=sc.sno and cno<>'C002'); D:select sname from student where not exixts (select * from sc where student.sno=sc.sno and cno='C002')
- 10.在学生选课数据库中有学生表student(sno,sname,ssex,sage,sdept)，课程表course(cno,cname)及学生选课表sc(sno,cno,grade)，其中sno是学号，sname是姓名，ssex是性别，sage是年龄，sdept是系别，cno是课程号，cname是课程名，grade是成绩。以下（）SQL语句可以实现查询选修了'C002'号课程的学生姓名。 选项： A、select sname from student, sc where student.sno=sc.sno and cno='C002' B、 select sname from student where sno in (select sno from sc where cno='C002') C、 select sname from student where sno = (select sno from sc where cno='C002') D、 select sname from student where exixts (select * from sc where student.sno=sc.sno and cno='C002')
- 11.在学生选课数据库中有学生表student(sno,sname,ssex,sage,sdept)，课程表course(cno,cname)及学生选课表sc(sno,cno,grade)，其中sno是学号，sname是姓名，ssex是性别，sage是年龄，sdept是系别，cno是课程号，cname是课程名，grade是成绩。以下（ ）SQL语句可以实现查询没有选修'C002'号课程的学生姓名。选项： A:select sname from student where sno not in (select sno from sc where cno='C002'); B:select sname from student, sc where student.sno=sc.sno and cno !='C002'; C:select sname from student where exixts (select * from sc where student.sno=sc.sno and cno<>'C002'); D:select sname from student where not exixts (select * from sc where student.sno=sc.sno and cno='C002')
- '王华'.SAGE;">12.本次考试所涉及的题目7-10均基于如下描述：设有一个学生选课数据库，其包括学生表S、课程表C和学生选课表SC三个关系：S(SNO, SNAME, SAGE, SSEX, SDEP);C(CNO, CNAME);SC(SNO, CNO, GRADE)。其中SNO是学生号，SNAME是学生姓名，SAGE是年龄，SDEP是学生所在系，CNO是课程号，CNAME是课程名称。 检索所有比“刘晨”年龄大的学生姓名、年龄和性别。正确的SELECT语句是（）。选项： A:SELECT SNAME, SAGE, SSEX FROM S WHERE SAGE > (SELECT SAGE FROM S WHERE SNAME = '刘晨');; B:SELECT SNAME, SAGE, SSEX FROM S WHERE SNAME = '刘晨';; C:SELECT SNAME, SAGE, SSEX FROM S WHERE SAGE> (SELECT SAGE WHERE SNAME = "刘晨");; D:SELECT SNAME, SAGE, SSEX FROM S WHERE SAGE>'王华'.SAGE;
- '王华'.SAGE;">13.如无特殊说明，本次考试所涉及的题目均基于如下描述：设有一个学生选课数据库，其包括学生表S、课程表C和学生选课表SC三个关系：S(SNO, SNAME, SAGE, SSEX, SDEP);C(CNO, CNAME);SC(SNO, CNO, GRADE)。其中SNO是学生号，SNAME是学生姓名，SAGE是年龄，SDEP是学生所在系，CNO是课程号，CNAME是课程名称。检索所有比“刘晨”年龄大的学生姓名、年龄和性别。正确的SELECT语句是（）。选项： A:SELECT SNAME, SAGE, SSEX FROM S WHERE SAGE > (SELECT SAGE FROM S WHERE SNAME = '刘晨');; B:SELECT SNAME, SAGE, SSEX FROM S WHERE SNAME = '刘晨';; C:SELECT SNAME, SAGE, SSEX FROM S WHERE SAGE> (SELECT SAGE WHERE SNAME = "刘晨");; D:SELECT SNAME, SAGE, SSEX FROM S WHERE SAGE>'王华'.SAGE;
- '刘晨'.SAGE;">14.如无特殊说明，本次考试所涉及的题目均基于如下描述：设有一个学生选课数据库，其包括学生表S、课程表C和学生选课表SC三个关系：S(SNO, SNAME, SAGE, SSEX, SDEP);C(CNO, CNAME);SC(SNO, CNO, GRADE)。其中SNO是学生号，SNAME是学生姓名，SAGE是年龄，SDEP是学生所在系，CNO是课程号，CNAME是课程名称。检索所有比“刘晨”年龄大的学生姓名、年龄和性别。正确的SELECT语句是（）。选项： A:SELECT SNAME, SAGE, SSEX FROM S WHERE SAGE > (SELECT SAGE FROM S WHERE SNAME = '刘晨');; B:SELECT SNAME, SAGE, SSEX FROM S WHERE SNAME = '刘晨';; C:SELECT SNAME, SAGE, SSEX FROM S WHERE SAGE> (SELECT SAGE WHERE SNAME = "刘晨");; D:SELECT SNAME, SAGE, SSEX FROM S WHERE SAGE>'刘晨'.SAGE;
- 15.在学生选课数据库S_T中有学生表student(sno,sname,ssex,sage,sdept)，课程表course(cno,cname,cpno,ccredit)及学生选课表sc(sno,cno,grade)，其中sno是学号，sname是姓名，ssex是性别，sage是年龄，sdept是系别，cno是课程号，cname是课程名，cpno是先行课号，ccredit是学分，grade是成绩。以下（ ）SQL语句可以实现查询没有选修'1'号课程的学生姓名。选项： A:select sname from student where not exists (select * from sc where student.sno=sc.sno and cno='1'); B:select sname from student, sc where student.sno=sc.sno and cno !='1'; C:select sname from student where sno not in (select sno from sc where cno='1'); D:select sname from student where exists (select * from sc where student.sno=sc.sno and cno<>'1')
- 16.在学生选课数据库中有学生表student(sno,sname,ssex,sage,sdept)，课程表course(cno,cname)及学生选课表sc(sno,cno,grade)，其中sno是学号，sname是姓名，ssex是性别，sage是年龄，sdept是系别，cno是课程号，cname是课程名，grade是成绩。以下（ ）SQL语句可以实现查询“CS”系并且年龄超过20岁的学生姓名。选项： A:select sname from student where sdept=’CS‘exceptselect sname from student where sage<=20; B:select sname from student where sdept=’CS‘intersectselect sname from student where sage>20; C:select sname from student where sdept=’CS‘ and sage>20; D:select sname from student where sdept=’CS‘unionselect sname from student where sage>20
- 17.在学生选课数据库中有学生表student(sno,sname,ssex,sage,sdept)，课程表course(cno,cname)及学生选课表sc(sno,cno,grade)，其中sno是学号，sname是姓名，ssex是性别，sage是年龄，sdept是系别，cno是课程号，cname是课程名，grade是成绩。以下（ ）SQL语句可以实现查询“CS”系并且年龄超过20岁的学生姓名。选项： A:select sname from student where sdept=’CS‘ and sage>20; B:select sname from student where sdept=’CS‘intersectselect sname from student where sage>20; C:select sname from student where sdept=’CS‘exceptselect sname from student where sage<=20; D:select sname from student where sdept=’CS‘unionselect sname from student where sage>20
- 18.在学生选课数据库中有学生表student(sno,sname,ssex,sage,sdept)，课程表course(cno,cname)及学生选课表sc(sno,cno,grade)，其中sno是学号，sname是姓名，ssex是性别，sage是年龄，sdept是系别，cno是课程号，cname是课程名，grade是成绩。以下（ ）SQL语句可以实现查询“CS”系并且年龄超过20岁的学生姓名。 选项： A、select sname from student where sdept=’CS‘ and sage>20 B、select sname from student where sdept=’CS‘intersectselect sname from student where sage>20 C、select sname from student where sdept=’CS‘exceptselect sname from student where sage<=20 D、select sname from student where sdept=’CS‘unionselect sname from student where sage>20
