网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
21、若用户执行下述语句,则他需要___ 权限。 delete from sc where grade < 60
A.delete
B.delete和select
C.update和select
D.delete,select和insert
参考答案和解析
不再执行
更多 “21、若用户执行下述语句,则他需要___ 权限。 delete from sc where grade < 60A.deleteB.delete和selectC.update和selectD.delete,select和insert” 相关考题
考题
第(37)-(38)题基于学生-课程数据库中的三个基本表: 学生信息表:s(sno, sname, sex, age, dept) 主码为sno 课程信息表:c(cno, cname, teacher) 主码为cno 学生选课信息表:sc(sno, cno, grade) 主码为(sno, cno) \从学生选课信息表中找出无成绩的元组\的SQL语句是A.SELECT * FROM sc WHERE grade=NULLB.SELECT * FROM sc WHERE grade IS ' 'C.SELECT * FROM sc WHERE grade IS NULLD.SELECT * FROM sc WHERE grade =' '
考题
(40)查找学生姓名及其所选修课程号和成绩,正确的 SQL 语句是A)SELECT sname FROM student, SELECT cno,grade FROM sc WHERE student.sno =sc.snoB) FROM sname,cno,grade FROM student,course WHERE student.sno =course.cnoC) SELECT sname ,canme,grade FROM student,course,sc WHERE student.sno =sc.sno and sc.cno=course.cnoD) SELECT sname ,cno,grade FROM student,sc WHERE student.sno =sc.sno
考题
关系SC(Sno,Cno,Grade)表示学号,课程号,成绩。现要查询平均分在90分以上的学生的学号和平均成绩,正确的语句是______。A.SELECT Sno,AVG(Grade) FROM SC WHERE AVG(Grade)>=90 GROUP BY SnoB.SELECT Sno,AVG(Grade) FROM SC GROUP BY Sno HAVING AVG(Grade)>=90C.SELECT Sno,AVG(Grade) FROM SC WHERE AVG(Grade)>=90 ORDER BY SnoD.SELECT Sno,AVG(Grade) FROM SC GROUP BY Cno HAVING AVG(Grade)>=90
考题
在关系SC中,查询学习课程号为\'DB\',且成绩在60至90之间的学生学号的正确的SQL命令是( )。A.SELECT SNO FROM SC WHERE CNO='DB'AND GRADE BETWEEN 60 AND 90B.SELECT SNO FROM SC WHERE CN0='DB' 0R GRADE BETWEEN 60 AND 90C.SELECT SNO FROM SC WHERE CNO='DB'AND GRADE=60 AND 90D.SELECT SNO FROM SC WHERE CNO='DB'AND GRADE=60 AND GRADE=90
考题
假定有三个关系,学生关系S、课程关系C和学生选课关系SC,它们的结构如下: S(S#,SN,Sex,Age,Dept),C(C#,CN),SC(S#,C#,Grade)。其中,S#为学生号,SN为姓名,Sex为性别,Age为年龄,Dept为系别,C#为课程号,CN为课程名,Grade为成绩。检索选修课程“C2”的学生中成绩最高的学生的学号,正确的SQL.语句是______。A.SELECT S#FROM SC WHERE C#="C2" AND Grade IN (SELECT Grade FROM SC WHERE C#="C2")B.SELECT S# FROM SC WHERE C#="C2" AND Grade>= (SELECT Grade FROM SC WHERE C#="C2")C.SELECT S# FROM SC WHERE C#="C2" AND Grade>=ALL (SELECT Grade FROM SC WHERE C#="C2")D.SELECT S# FROM SC WHERE C#="C2" AND Gtade NOT IN (SELECT Grade FROM SC WHERE C#="C2")
考题
有如下的SQL语句: Ⅰ. SELECT sname FROM s, sc WHERE grade60 Ⅱ. SELECT sname FROM s WHERE sno IN(SELECT sno FROM sc WHERE grade60) Ⅲ. SELECT sname FROM s, sc WHERE s.sno=sc.sno AND grade60 若要查找分数(grade)不及格的学生姓名(sname),以上正确的有哪些?( )。A.Ⅰ和ⅡB.Ⅰ和ⅢC.Ⅱ和ⅢD.Ⅰ、Ⅱ和Ⅲ
考题
检索学生姓名及其所选修课程的课程号和成绩,正确的SELECT语句是______。A.SELECT S.SN,SC.C#,SC.GRADE FROMS WHERE S.S#=SC.S#B.SELCECT S.SN,SC.C#,SC.GRADE FROM SC WHERE S.S#=SC.GRADEC.SELECT S.SN,SC.C#,SC,GRADE FROM S,SC WHERE S.S#:SC.S#D.SELSECT S.SN,SC.C#,SC.GRADE FROM S,SC
考题
检索选修四门以上课程的学生总成绩(不统计不及格的课程),并要求按总成绩降序排列出来,正确的SELECT语句是______。A.SELECT S#,SUM(GRADE)FROM SC WHERE GRADE>=60 CROUP BY S# ORDER BY 2 DESC HAVING COUNT(*)>=4B.SELECT S#,SUM(GRADE)FROM SC WHERE GRADE>=60 GROUP BY S# HAVING COUNT(*)>=4 ORDER BY 2 DESCC.SELECT S#,SUM(GRADE)FROM SC WHERE GRADE>=60 HAVING COUNT(*)>=4 GROUP BY S# ORDER BY 2 DESCD.DELECT S#,SUM(GRADE)FROM SC WHERE GRADE>=60 ORDER BY 2 DESC CROUP BY S# HAVING COUNT(*)>=4
考题
在关系SC中,查询学习课程号为′DB′,且成绩在60至90之间的学生学号的正确的 SQL命令是A.SELECT SNO FROM SC WHERE CNO=′DB′AND GRADE DETWEEN 60 AND 90B.SELECT SNO FROM SC WHERE CNO=′DB′OR GRADE BETWEEN 60 AND 90C.SELECT SNO FROM SC WHERE CNO=′DB′AND GRADE>=60 AND 90D.SELECT SNO FROM SC WHERE CNO=′DB′AND GRADE<=60 AND GRADE>=90
考题
已知关系模式:sc(sno, sname, grade),各属性含义依次为学号、课程名、分数。要查找“数据库”课分数最高的学生的学号,正确的SQL语句是A.SELECT sno FROM sc WHERE sname="数据库" AND grade=MAX(grade)B.SELECT sno FROM sc FOR sname="数据库" OR grade>=MAX(grade)C.SELECT sno FROM sc WHERE sname="数据库" AND grade=(SELECT MAX(grade) FROM scD.SELECT sno FROM sc FOR sname="数据库" OR grade=(SELECT MAX (grade) FROM sc
考题
有如下的SQL语句:Ⅰ.SELECT sname FROMs,sc WHERE grade<60Ⅱ.SELECT sname FROMs WHERE sno IN(SELECT sno FROM sc WHERE grade<60Ⅲ.SELECT sname FROMs,sc WHERE s.sno=Sc.sno AND grade<60若要查找分数(grade)不及格的学生姓名(sname),以上正确的有哪些? ( )A.Ⅰ和ⅡB.Ⅰ和ⅢC.Ⅱ和ⅢD.Ⅰ、Ⅱ和Ⅲ
考题
基于学生.课程数据库中的三个基本表:学生信息表:s (snumber, sname, sex, age, dept)主码为snumber课程信息表:c(cnumber, cname,teacher)主码为cnumber学生选课信息表:sc(snumber, cnumber, grade)主码为(snumber, cnumber)“从学生选课信息表中找出无成绩的元组”的SQL语句是( )。A)SELECT ﹡FROM sc WHERE grade=NULLB)SELECT﹡FROM sc WHERE grade IS "C)SELECT﹡FROM sc WHERE grade IS NULLD)SELECT﹡FROM sc WHERE grade=''
考题
( 3 2 )查询学生姓名及其所选修课程的课程号和成绩,正确的 SQL 语句是A ) SELECT S . SNAME , SC.C# , GRADE FROM S WHERE S . S # = SC . S#B ) SELECT S . SNAME , SC.C #, GRADE FROM SC WHERE S . S # = = SC . S#C ) SELECT S . SNAME , SC.C# , GRADE FROM S , SC WHERE S . S# = SC . S#D ) SELECT S . SNAME , SC.C# , GRADE FROM S , SC WHERE S .S# = SC . C#
考题
已知学生选课信息表:sc(sno,cno,grade)。查询“至少选修了一门课程,但没有学习成绩的学生学号和课程号”的SQL语句是A.SELECT sno,cno FROM sc WHERE grade=NULLB.SELECT sno,cno FROM sc WHERE grade IS‘’C.SELECT sno,cno FROM sc WHERE grade IS NULLD.SELECT sno,cno FROM sc WHERE grade=‘’
考题
可以利用Connection对象的Execute方法实现对数据库的更改操作。下列将SC表中学号为S105的学生的成绩减少10分的语句,正确的是()。
A、ADOcn.Execute “ALTER SC SET Grade = Grade - 10 WHERE 学号 = 'S105' ”B、ADOcn.Execute “ALTER FROM SC SET Grade = Grade - 10 WHERE 学号 = 'S105' ”C、ADOcn.Execute “UPDATE SC SET Grade = Grade - 10 WHERE 学号 ='S105' ”D、ADOcn.Execute “UPDATE FROM SC SET Grade = Grade - 10 WHERE 学号 = 'S105' ”
考题
有如下的SOL语句:Ⅰ.SELECT sname FROM s,sc WHERE grade<60Ⅱ.SELECT sname FROMs WHERE sno IN (SELECT sno FROM sc WHERE grade<60)Ⅲ.SELECT sname FROM s,sc WHERE s.sno=Sc.sno AND grade<60若要查找分数(grade)不及格的学生姓名(sname),以上正确的有哪些? ( )A.Ⅰ和ⅡB.Ⅰ和ⅢC.Ⅱ和ⅢD.Ⅰ、Ⅱ和Ⅲ
考题
在关系SC中,查询学习课程号为'OB',且成绩在60至90之间的学生学号的正确的 SQL命令是A.SELECT SNO FROMSC WHERE CNO='DB' AND GRADE BETWEEN 60 AND 90B.SELECT SNO FROM SC WHERE CNO='DB' OR GRADE BETWEEN 60 AND 90C.SELECT SNO FROM SC WHERE CNO='DB' AND GRADE>=60 AND 90D.SELECTSNO FROM SCWHERECNO='DB' AND GRADE<=60 AND GRADE>=90
考题
“从学生选课信息表中找出无成绩的元组”的SQL语句是( )。 A.SELECT*FROM sc WHERE grade=NULL B.SELECT*FROM sc WHERE grade IS'' C.SELECT*FROM sc WHERE grade IS NULL D.SELECT*FROM sc WHERE grade=''
考题
若要使所有学科80分以上的成绩都增加5%, 80至60分的成绩都增加10%,应如何更新数据库( )。 A.UPDATE SC SET GRADE=GRADE*1.05 WHERE SC.GRADE=80 UPDATE SC SET GRADE=GRADE* 1.10 WHERE SC.GRADE=60 AND SC.GRADE =80 B.UPDATE SC SET GRADE=GRADE* 1.10 WHERE SC.GRADE=60 AND SC.GRADE=80 UPDATE SC SET GRADE=GRADE* 1.05 WHERE SC.GRADE=80 C.UPDATE SC SET GRADE=GRADE* 1.05 WIRE SC.GRADE=80 AND SET GRADE =GRADE* 1.10 WHARE SC.GRADE=60 D.UPDATE SC SET GRADE=GRADE* 1.10 WHERE SC.GRADE=60 AND SC.GRADE =80 AND SET GRADE=GRADE* 1.05 WHERE SC.GRADE=80
考题
查找学生姓名及其所选修课程的课程号和成绩,正确的SQL语句是A.SELECT sname FROM student,SELECT cno,grade FROM sc WHERE student.sno=sc.snoB.SELECT sname,cno,grade FROM student,course WHERE student.sno=course.cnoC.SELECT sname,cname,grade FROM student,course,sc WHERE student.sno=sc.sno and sc.cno=course,cnoD.SELECT sname,cno,grade FROM student,sc WHERE student.sno=sc.sno
考题
有如下的SQL语句:Ⅰ.SELECT sname FROMs,sc WHERE grade<60Ⅱ.SELECT sname FROM WHERE sno IN (SELECT sno FROM sc WHERE grade<60)Ⅲ.SELECT sname FROMs,sc WHERE s.sno=Sc.sno AND grade<60若要查找分数(grade)不及格的学生姓名(sname),以上正确的有( )。A.Ⅰ和ⅡB.Ⅰ和ⅢC.Ⅱ和ⅢD.Ⅰ、Ⅱ和Ⅲ
考题
检索选修课程“C2”的学生中成绩最高的学生的学号。正确的SELECT的语句是______。A.SELECT S# FROM SC WHERE C#="C2" AND GRADE> =(SELECT GRADE FROM SC WHERE C#="C2")B.SELECT S# FROM SC WHERE C#="C2" AND GRADE IN(SELECT GRADE FROM SC WHERE C#="C2")C.SELECT S# FROM SC WHERE C#="C2" AND GRADE NOT IN(SELECT GRADE FROM SC WHERE C#="C2")D.SELECT S# FROM SC WHERE C#="C2" AND GRADE> =ALL(SELECT GRADE FROM SC WHERE C#="C2")
考题
设有关系模式:SC(sno,cno,grade),各属性含义依次是学号、课程号、分数。要查询分数低于60分的学生学号,正确的SQL语句是______。A) SEI,ECT sno FROM SC WH ERE grade BETWEEN O AND 60B) SELECT sno FROM SC WHERE grade<60C) SELECT sno FROM SC HAVlNG grade BETWEEN O AND 60D) SELECT sno FROM SC HAVING grade<60A.B.C.D.
考题
检索选修四门以上课程的学生总成绩(不统计不及格的课程),并要求按总成绩的降序排列出来。正确的SELECT语句是______。A.SELECT S#, SUM(GRADE) FROM SC WHERE GRADE>=60 GROUP BY S# ORDER BY 2 DESC HAVING COUNT(*)>=4B.SELECT S#, SUM(GRADE) FROM SC WHERE GRADE>=60 GROUP BY S# HAVING COUNT(*)>=4 ORDER BY 2 DESCC.SELECT S#, SUM(GRADE) FROM SC WHERE GRADE>=60 HAVING COUNT(*)>=4 GROUP BY S# ORDER BY 2 DESCD.SELECT S#, SUM(GRADE)FROM SC WHERE GRADE>=60 ORDER BY 2 DESC GROUP BY S# HAVING COUNT(*)>=4
考题
检索学生姓名及其所选修课程的课程号和成绩。正确的SELECT语句是______。A.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.GRADEC.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
考题
从学生选课信息表中找出无成绩的元组的SQL语句是( )。A.SELECT*FROM sc WHERE grade=NULLB.SELECT*FROM sc WHERE grade IS"C.SELECT*FROM sc WHERE grade IS NULLD.SELECT*FROM sc WHERE grade="
考题
(21 )执行 SQL 语句: SELECT sno,grsde FROM SC WHERE cno= ' c1 ' AND grade60 ,则该语句对关系 S C执行的操作有A )交( ∩ )和选择( σ )B )选择( σ )和投影( ∏ )C )并( ∪ )和投影( ∏ )D) 选择( σ )和笛卡尔积( × )
考题
学生选课信息表:sc(sno,cno,grade),主键为(sno,cno),从学生选课信息表中找出无成绩的元组的SQL语句是()。A、SELECT * FROM sc WHERE grade=NULLB、SELECT * FROM sc WHERE grade IS“ ”C、SELECT * FROM sc WHERE grade=‘ ’D、SELECT * FROM sc WHERE grade IS NULL
热门标签
最新试卷