网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
考虑如下两语句:1. boolean passingScore = false && grade == 70;2. boolean passingScore = false & grade == 70;表达式grade == 70 在什么地方被计算
A.在 1 和 2中均计算
B.在 1 和 2中均未计算
C.在1中计算,在2中未计算
D.在2中计算,在1中未计算
E.非法,因为 false 应写 FALSE
参考答案
更多 “ 考虑如下两语句:1. boolean passingScore = false 2. boolean passingScore = false 表达式grade == 70 在什么地方被计算 A.在 1 和 2中均计算B.在 1 和 2中均未计算C.在1中计算,在2中未计算D.在2中计算,在1中未计算E.非法,因为 false 应写 FALSE ” 相关考题
考题
关系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(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.Ⅰ、Ⅱ和Ⅲ
考题
有如下程序: infocase$=InputBox("Inputoneletter:") Select Case infocase$ case"a" grade$="Verygood" case"b" grade$="Good" case"C" grade$="OK" case"d" grade$="Qualified" case Else grade$="Bab" End SelectA.Very goodB.GoodC.BadD.Qualified
考题
( 12 )下列布尔变量定义中,正确并且规范的是A )BOOLEAN canceled = false;B)boolean canceled = false;C)boolean CANCELED = false;D)boolean canceled = FALSE;
考题
在“学生—选课—课程”数据库中的两个关系如下:S(SNO,SNAME,SEX,AGE) ,SC(SNO,CNO,GRADE)若使用连接查询的SQL语句查找年龄大于20岁的学生姓名(SNAME) 和成绩 (GRADE) ,则正确的命令是SELECT sname,grade FROM s,sc WHERE age>20 AND ______。
考题
把对关系SC的属性GRADE的修改权授予用户ZHAO的SQL语句是()。
A、GRANTGRADEONSCTOZHAOB、GRANTUPDATEONSCTOZHAOC、GRANTUPDATE(GRADE)ONSCTOZHAOD、GRANTUPDATEONSC(GRADE)TOZHAO
考题
boolean a=false;boolean b=true;boolean c=(ab)(!b);boolean result=(ab)(!b); boolean result=(ab)(!b); 执行完后,正确的结果是( )。A.c=false;result=falseB.c=true,result=trueC.c=true;result=falseD.c=false;result=true
考题
下面程序段: boolean a=false; boolean b=true; boolean c=(a||b)(b); boolean result=(a|b)(b); 执行完后,正确的结果是A.c=false;result=falseB.c=true,result=trueC.c=true;result=falseD.c=false;result=true
考题
在“学生—选课—课程”数据库中的两个关系如下:s(sno,sname,sex,age)sc(sno,cno,grade)则关系代数表达式πs.sname,grade()等价的SQL命令是SELECT s.sname,sc.grade FROM s,sc WHERE______AND s.age>20
考题
如下的SQL语句是用于查询“每个学生的选修课程数、总成绩、平均成绩”的不完整语句,请在空缺处填入正确的内容。SELECT Student.SNo, (1),SUM(Grade),AVG(Grade)FROM Student,GradeWHERE Student.SNo=Grade.SNo,GROUP BY (2);(1)
考题
“从学生选课信息表中找出无成绩的元组”的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=''
考题
下列布尔变量定义中,正确并且规范的是A.BOOLEAN canceled=false;B.boolean canceled=false;C.boolean CANCELED=false;D.boolean canceled=FALSE;
考题
若要使所有学科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语句:Ⅰ.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.Ⅰ、Ⅱ和Ⅲ
考题
设在SQL Server 2008某数据库中有表SC(Sn0,Cn0,Grade),其中Grade列的类型为int。若在查询成绩时,希望将成绩按“优”、“良”、“中”、“及格”和“不及格”形式显示,则下列Case函数中正确的是( )。A.Case GradeWhen Grade between 90 and 100 THEN Grade=ˊ优ˊWhen Grade between 80 and 89 THEN Grade=ˊ良ˊWhen Grade between 70 and 79 THEN Grade=ˊ由ˊWhen Grade between 60 and 69 THEN Grade=ˊ及格ˊElse Grade=ˊ不及格ˊEndB.Case GradeWhen Grade between 90 and 100 THEN ˊ优ˊWhen Grade between 80 and 89 THEN ˊ良ˊWhen Grade between 70 and 79 THENˊ中ˊWhen Grade between 60 and 69 THENˊ及格ˊElseˊ不及格ˊEndC.CaseWhen Grade between 90 and 100 THEN Grade=ˊ优ˊWhen Grade between 80 and 89 THEN Grade=ˊ良ˊWhen Grade between 70 and 79 THEN Grade=ˊ由ˊWhen Grade between 60 and 69 THEN Grade=ˊ及格ˊElse Grade=ˊ不及格ˊEndD.CaseWhen Grade between 90 and 100 THENˊ优ˊWhen Grade between 80 and 89 THEN ˊ良ˊWhen Grade between 70 and 79 THEN ˊ由ˊWhen Grade between 60 and 69 THEN ˊ及格ˊElseˊ不及格ˊEnd
考题
从学生选课信息表中找出无成绩的元组的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="
考题
设有如下关系 SC(sno,cname,grade)(各属性含义分别为学生的学号、课程名称、成绩)现要将所有学 生的课程成绩增加10分,以下能正确地完成此操作的SQL命令是A. MODIFYScSET grade+10B.UPDATEScSET grade+10C.MODIFYScSET grade=grade+10D.UPDATEScSET grade=grade+10
考题
把对关系SC的属性GRADE的修改权授予用户ZHAO的T-SQL语句是()A.GRANTGRADEONSCTOZHAO
B.GRANTUPDATEONSCTOZHAO
C.GRANTUPDATE(GRADE)ONSCTOZHAO
D.GRANTUPDATEONSC(GRADE)TOZHAO
考题
设SC表中记录成绩的列为:Grade,类型为int。若在查询成绩时,希望将成绩按‘优’、‘良’、‘中’、‘及格’和‘不及格’形式显示,正确的Case函数是()。A Case Grade When 90~100 THEN ’优’ When 80~89 THEN ’良’ When 70~79 THEN ’中’ When 60~69 THEN ’及格’ Else ’不及格’ EndB Case When Grade between 90 and 100 THEN Grade = ’优’ When Grade between 80 and 89 THEN Grade = ’良’ When Grade between 70 and 79 THEN Grade = ’中’ When Grade between 60 and 69 THEN Grade = ’及格’ Else Grade = ’不及格’ EndC Case When Grade between 90 and 100 THEN ’优’ When Grade between 80 and 89 THEN ’良’ When Grade between 70 and 79 THEN ’中’ When Grade between 60 and 69 THEN ’及格’ Else ’不及格’ EndDCase Grade When 90~100 THEN Grade = ’优’ When 80~89 THEN Grade = ’良’ When 70~79 THEN Grade = ’中’ When 60~69 THEN Grade = ’及格’ Else Grade = ’不及格’ End
考题
在linux系统中,更改组class的组名为grade,应执行()命令。A、groupmod -l grade classB、groupmod -n grade classC、chgroup -l grade classD、chgroup -n grade class
考题
设在某SELECT语句的WHERE子句中,需要对Grade列的空值进行处理。下列关于空值的操作,错误的是()。A、Grade IS NOT NULLB、Grade IS NULLC、Grade = NULLD、NOT (Grade IS NULL)
考题
()导致PL/SQL中WHILE循环结束。A、控制传递给EXIT语句B、Boolean变量或表达式值为NULLC、Boolean变量或表达式值为TRUED、Boolean变量或表达式值为FALSE
考题
学生选课信息表: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
考题
把对关系SC的属性GRADE的修改权授予用户ZHAO的SQL语句是 ()A、GRANT GRADE ON SC TO ZHAOB、GRANT UPDATE ON SC TO ZHAOC、GRANT UPDATE (GRADE) ON SC TO ZHAOD、GRANT UPDATE ON SC (GRADE) TO ZHAO
考题
单选题设SC表中记录成绩的列为:Grade,类型为int。若在查询成绩时,希望将成绩按‘优’、‘良’、‘中’、‘及格’和‘不及格’形式显示,正确的Case函数是()。A
Case Grade When 90~100 THEN ’优’ When 80~89 THEN ’良’ When 70~79 THEN ’中’ When 60~69 THEN ’及格’ Else ’不及格’ EndB
Case When Grade between 90 and 100 THEN Grade = ’优’ When Grade between 80 and 89 THEN Grade = ’良’ When Grade between 70 and 79 THEN Grade = ’中’ When Grade between 60 and 69 THEN Grade = ’及格’ Else Grade = ’不及格’ EndC
Case When Grade between 90 and 100 THEN ’优’ When Grade between 80 and 89 THEN ’良’ When Grade between 70 and 79 THEN ’中’ When Grade between 60 and 69 THEN ’及格’ Else ’不及格’ EndD
Case Grade When 90~100 THEN Grade = ’优’ When 80~89 THEN Grade = ’良’ When 70~79 THEN Grade = ’中’ When 60~69 THEN Grade = ’及格’ Else Grade = ’不及格’ End
热门标签
最新试卷