网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
His temper and personality show that he can become a soldier of the top ___.
A) circle B) rank C) category D)grade
参考答案
更多 “ Histemperandpersonalityshowthathecanbecomeasoldierofthetop___.A)circleB)rankC)categoryD)grade ” 相关考题
考题
关系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
考题
有如下程序： 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
考题
设有如下关系： SC(sno，cname，grade)(各属性含义分别为学生的学号、课程名称、成绩)现要将所 有学生的课程成绩增加10分，以下能正确地完成此操作的SQL命令是( )。A．MODIFY sc SET grade+10B．UPDATE sc SET grade+10C．MODIFY sc SET grade=grade+10D．UPDATE sc SET grade=grade+10
考题
若要使所有学科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 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
考题
设有如下关系 SC(sno，cname，grade)(各属性含义分别为学生的学号、课程名称、成绩)现要将所有学 生的课程成绩增加10分，以下能正确地完成此操作的SQL命令是A． MODIFYScSET grade+10B．UPDATEScSET grade+10C．MODIFYScSET grade=grade+10D．UPDATEScSET grade=grade+10
考题
12．A． grade one，class fourB． class four，grade oneC． Grade One，Class FourD． Class Four，Grade One
考题
Camphor oil is classified as a ______．A.Grade A flammable liquidB.Grade C flammable liquidC.Grade D combustible liquidD.Grade E combustible liquid
考题
The Cornwall Times is published weekly by QYC Newspapers,Inc,a __________of Woodbridge Media Holdings.A.division
B.selection
C.category
D.separation
考题
设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）
考题
CGN（运营商NAT）是以下哪个英语的缩写A、Carrier-Grade NETB、Carrier-Grade NetworkC、Carrier-Grade NetworkingD、Carrier-Grade NAT
考题
把对关系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
热门标签
最新试卷