请在下方输入要搜索的题目：

如下3条语句是等价的。SELECT Sname FROM Student WHERE Sno IN (SELECT Sno FROM SC);SELECT Sname FROM Student WHERE EXISTS (SELECT * FROM SC WHERE S
C:Sno=Student.Sno);SELECT Sname FROM Student WHERE Student.Sno=S
C:Sno;

发布时间：2024-05-16 20:57:38

推荐参考答案 ( 由搜题小帮手官方老师解答 )

联系客服

答案：

以下文字与答案无关

提示：有些试题内容显示不完整,文字错误或者答案显示错误等问题，这是由于我们在扫描录入过程中机器识别错误导致,人工逐条矫正总有遗漏，所以恳请广大网友理解。

相关试题

1.对于student学生表（sno,sname,sex,sage,sdept）以及选课表sc(sno,cno,grade)，请问”查询刘佳同学得选课”，其SQL语句为？（）选项： A:select sc.* from student,sc where student.sno=sc.sno and sname=’刘佳’; B:select sc.* from student inner join sc on student.sno=sc.sno and sname=’刘佳’; C:select sc.* from student,sc where sname=’刘佳’; D:select sc.* from student,sc where student.sno=sc.sno ;
2.以下（）操作实现了student表与sc之间的自然连接。选项： A:select student.sno, sname,ssex,sage,sdept , cno, grade from student , sc where student.sno=sc.sno; B:select student.* , sc.* from student , sc where student.sno=sc.sno; C:select student.* , cno, grade from student , sc where student.sno=sc.sno; D:select student.* , cno, grade from student join sc on student.sno=sc.sno
3.以下（）操作实现了student表与sc之间的等值连接。选项： A:select student.* , cno, grade from student , sc where student.sno=sc.sno;; B:select student.sno, sname,ssex,sage,sdept , cno, grade from student , sc where student.sno=sc.sno;; C:select student.* , cno, grade from student join sc on student.sno=sc.sno;; D:select student.* , sc.* from student , sc where student.sno=sc.sno;
4.以下（）操作实现了student表与sc之间的等值连接。选项： A:select student.* , cno, grade from student , sc where student.sno=sc.sno;; B:select student.sno, sname,ssex,sage,sdept , cno, grade from student , sc where student.sno=sc.sno;; C:select student.* , cno, grade from student join sc on student.sno=sc.sno;; D:select student.* , sc.* from student , sc where student.sno=sc.sno;
5.以下（）操作实现了student表与sc之间的自然连接。选项： A:select student.sno, sname,ssex,sage,sdept , cno, grade from student , sc where student.sno=sc.sno; B:select student.* , sc.* from student , sc where student.sno=sc.sno; C:select student.* , cno, grade from student , sc where student.sno=sc.sno; D:select student.* , cno, grade from student join sc on student.sno=sc.sno
6.以下（）操作实现了student表与sc之间的自然连接。（3.0分）选项： A:select student.* , cno, grade from student , sc where student.sno=sc.sno B:select student.sno, sname,ssex,sage,sdept , cno, grade from student , sc where student.sno=sc.sno C:select student.* , cno, grade from student join sc on student.sno=sc.sno D:select student.* , sc.* from student , sc where student.sno=sc.sno
7.针对学生选课数据库S_T，以下（）操作实现了student表与sc之间的自然连接。选项： A:select student.* , cno, grade from student join sc on student.sno=sc.sno; B:select student.* , sc.* from student , sc where student.sno=sc.sno; C:select student.sno, sname, ssex, sage, sdept , cno, grade from student , sc where student.sno=sc.sno; D:select student.* , cno, grade from student , sc where student.sno=sc.sno
8.针对学生选课数据库S_T，以下（）操作实现了student表与sc之间的自然连接。选项： A:select student.* , cno, grade from student join sc on student.sno=sc.sno; B:select student.* , sc.* from student , sc where student.sno=sc.sno; C:select student.sno, sname, ssex, sage, sdept , cno, grade from student , sc where student.sno=sc.sno; D:select student.* , cno, grade from student , sc where student.sno=sc.sno
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.在学生选课数据库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')
11.在学生选课数据库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')
12.在学生选课数据库中有学生表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')
13.在学生选课数据库中有学生表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')
14.以下（）操作实现了student表与sc之间的自然连接。A.select student.* , cno, grade from student join sc on student.sno=sc.snoB.select student.* , cno, grade from student , sc where student.sno=sc.snoC.select student.* , sc.* from student , sc where student.sno=sc.snoD.select student.sno, sname,ssex,sage,sdept , cno, grade from student , sc where student.sno=sc.sno
15.在学生选课数据库中有学生表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')
16.在学生选课数据库中有学生表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')
17.【多选题】针对学生选课数据库S_T，以下()操作实现了student表与sc之间的自然连接。A. select student.* , cno, grade from student join sc on student.sno=sc.snoB. select student.* , sc.* from student , sc where student.sno=sc.snoC. select student.sno, sname, ssex, sage, sdept , cno, grade from student , sc where student.sno=sc.snoD. select student.* , cno, grade from student , sc where student.sno=sc.sno
18.有关系S(SNO, SNAME, SAGE)，C(CNO, CNAME)，SC(SNO, CNO, GRADE)。其中SNO是学生号，SNAME是学生姓名，SAGE是学生年龄， CNO是课程号，CNAME是课程名称，GRADE是成绩。以下（）SQL语句可以实现查询没有选修'C002'号课程的学生姓名。选项： A:SELECT SNAME FROM S, SC WHERE S.SNO=SC.SNO AND CNO !='C002'; B:SELECT SNAME FROM S WHERE SNO NOT IN (SELECT SNO FROM SC WHERE CNO='C002'); C:SELECT SNAME FROM S WHERE NOT EXISTS (SELECT * FROM SC WHERE S.SNO=SC.SNO AND CNO='C002'); D:SELECT SNAME FROM S WHERE EXISTS (SELECT * FROM SC WHERE S.SNO=SC.SNO AND CNO !='C002')
19.有关系S(SNO, SNAME, SAGE)，C(CNO, CNAME)，SC(SNO, CNO, GRADE)。其中SNO是学生号，SNAME是学生姓名，SAGE是学生年龄， CNO是课程号，CNAME是课程名称，GRADE是成绩。以下（）SQL语句可以实现查询没有选修'C002'号课程的学生姓名。A.SELECT SNAME FROM S, SC WHERE S.SNO=SC.SNO AND CNO !='C002'B.SELECT SNAME FROM S WHERE SNO NOT IN (SELECT SNO FROM SC WHERE CNO='C002')C.SELECT SNAME FROM S WHERE NOT EXISTS (SELECT * FROM SC WHERE S.SNO=SC.SNO AND CNO='C002')D.SELECT SNAME FROM S WHERE EXISTS (SELECT * FROM SC WHERE S.SNO=SC.SNO AND CNO !='C002')

没有账号？点我注册

首付间里管用闻所未闻南通社仪表堂堂受限仙游远古文化等时

立即注册

已购买搜题包，但忘记账号密码？

登录即同意《服务协议》及《隐私政策》

立即登录

登录即同意《服务协议》及《隐私政策》

如下3条语句是等价的。SELECT Sname FROM Student WHERE Sno IN (SELECT Sno FROM SC);SELECT Sname FROM Student WHERE EXISTS (SELECT * FROM SC WHERE SC:Sno=Student.Sno);SELECT Sname FROM Student WHERE Student.Sno=SC:Sno;

如下3条语句是等价的。SELECT Sname FROM Student WHERE Sno IN (SELECT Sno FROM SC);SELECT Sname FROM Student WHERE EXISTS (SELECT * FROM SC WHERE S
C:Sno=Student.Sno);SELECT Sname FROM Student WHERE Student.Sno=S
C:Sno;