在学生选课数据库中，将所有选了课程‘DB’且分数在60~70分之间的学生的成绩增加百分之十，SQL语句为（ ） A: UPDATE SC SET Grade=Grade*1.1 WHERE Cno=’DB’ AND Grade BETWEEN 60 AND 70; B: UPDATE SC SET Grade+=Grade*0.1 WHERE Cno=(Select Cno From Course WHERE Cname=’DB’) AND Grade >= 60 AND Grade <=70; C: UPDATE SC SET Grade=Grade*1.1 WHERE Cno=(Select Cno From Course WHERE Cname=’DB’) AND Grade <= 60 AND Grade >=70; D: UPDATE SC SET Grade=Grade*1.1 WHERE Cno IN (Select Cno From Course WHERE Cname=’DB’) AND Grade BETWEEN 60 AND 70;

The most common division between primary and secondary education in the US is ___________.（ ） A: primary schools (Grade 1 to Grade 6) and middle schools (Grade 7 to Grade 12) B: elementary schools (Grade Kindergarten to Grade 8) and high schools (Grade 9 to Grade 12) C: elementary schools (Grade Kindergarten to Grade 3), middle schools (Grade 4 to Grade 6) and high schools (Grade 7 to Grade 12) D: grammar schools (Grade Kindergarten to Grade 6) and high schools (Grade 7 to Grade 12)

Which grade were they in? A: Grade 8 B: Grade 9 C: Grade 10 D: Grade 11

【单选题】5. 假定student表中有字段grade,grade代表分数,依次统计grade字段的最大值,最小值,平均值的SQL语句是 A. SELECT max(grade),min(grade),average(grade) FROM student; B. SELECT max(grade),min(grade),avg(grade) FROM student; C. SELECT min(grade),average(grade),max(grade) FROM student; D. SELECT min(grade),avg(grade),max(grade) FROM student;

What grade is the woman in A: Grade one. B: Grade two. C: Grade three.

They are the students of ______. A: grade 7 B: Grade 7 C: 7th grade D: Grade 7th

查询统计选课表SC中成绩列Grade的最小值，可以用_______函数。 A: Min(Grade) B: Max(Grade) C: Avg(Grade) D: Sum(Grade)

查询统计选课表SC中成绩列Grade的平均值，可以用_______函数。 A: Sum(Grade) B: Avg(Grade) C: Min(Grade) D: Max(Grade)

下面代码的输出结果是()。 <?php $score=87; if($score>=90 && $score<=100){$grade="优秀";} if($score>=80){$grade="良好";} if($score>=70){$grade="一般";} if($score>=60){$grade="及格";} else{$grade="不及格";} echo $grade; ?>

中国大学MOOC: 请分析下面的程序，若输入score为80，输出grade为【 】if score >= 60.0: grade=Delif score>=70.0: grade=Celif score>=80.0: grade=Belif score>=90.0: grade=Aprint(grade)