He is a student of ______ . A: Grade One, Class Two B: the Class Two, Grade One. C: Class Two, Grade One D: Class Two, Grade 1

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)

假设表student中，有一条id=1的记录，现要求将其name修改为“itcast”，grade修改为98.5。下列选项中，正确的SQL语句是（ ）。 A: UPDATEstudentname=’youjun’grade=98.5whereid=1 B: UPDATEstudentsetname=’youjun’,grade=98.5whereid=1 C: UPDATEstudentsetname=’youjun’grade=98.5whereid=1 D: UPDATEFORMstudentsetname=’youjun’,grade=98.5whereid=1

‏下列SQL语句中，_____________可以在“学生-课程”数据库正确实现“计算1号课程的学生平均成绩”。‍ A: SELECT AVG(Grade)FROM SCWHERE Cno= ' 1 ' B: SELECT MAX(Grade)FROM SCWHERE Cno= 1 C: SELECT MIN(Grade)FROM SCWHERE Cno= 1 D: SELECT AVG(Grade)FROM SCWHERE Cno= 1

设有关系SC(sno, cname, grade)，各属性的含义分别为学号、课程名、成绩。若要将所有学生的“数据库技术”课程的成绩增加5分，能正确完成该操作的SQL语句是___1___grade = grade+5 WHERE cname=‘数据库技术’。

功能：计算平均成绩并统计90分以上人数。#include <;stdio.h>;main(){int n,m;float grade,average;average=0.0;/***********SPACE***********/n=m=【1】;while(1){【?】("%f",&amp;grade);if(grade<;0) break;n++;average+=grade;if(grade<;90)【3】;m++;}if(n) printf("%.2f%d\n",average/n,m);}

假设表student中，有一条id=1的记录，现要求将其name修改为“huahua"，grade修改为98.5.下列选项中，正确的SQL语句是（ ）。 A: UPDATE `student` SET `name`='huahua' `grade`=98.5 WHERE `id`=1 B: UPDATE `student` SET `name`='huahua', `grade`=98.5 WHERE `id`=1 C: UPDATE FOR `student` SET `name`='huahua', `grade`=98.5 WHERE `id`=1 D: UPDATE `student` `name`='huahua' `grade`=98.5 WHERE `id`=1

更新student表id=1的记录，name值更新为”youjun”,grade值更新为98.5，下列选项中，能够完成上述功能的SQL语句是 A: UPDATE student set name=’youjun’ grade=98.5 where id=1; B: UPDATE student set name=’youjun’, grade=98.5 where id=1; C: UPDATE FROM student set name=’youjun’ ,grade=98.5 where id=1; D: UPDATE student Values name=’youjun’ grade=98.5 where id=1;

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;