检索选修四门以上课程的学生总成绩(不统计不及格的课程),并要求按总成绩的降序排列出来。正确的SELECT语句是( )。

A:SELECT S#,SUM(GRADE)FROM SC B:WHERE GRADE>=60 C:GROUP BY S# D:ORDER BY 2 DESC E:HAVING COUNT(*)>=4 F:SELECT S#,SUM(GRADE)FROM SC G:WHERE GRADE>=60 H:GROUP BY S# I:HAVING COUNT(*)>=4 J:ORDER BY 2 DESC K:SELECT S#,SUM(GRADE)FROM SC L:WHERE GRADE>=60 M:HAVING COUNT(*)>=4 N:GROUP BY S#

下面程序段的输出结果是
public class Test
public static void main(String args[])
int n=5,sum=O;
while(n>0)
sum+=n;
--n;

System.out.println("sum is "+Sum);

A:sum is 14 B:sum is 15 C:sum is 10 D:sum is 5

以下C程序的运行结果为______。
main( )
int i=1,sum=0;
loop:if(i<=10)
sum+=i;
i++;
goto loop;

printf("sum=%d/n",sum);

A:sum=10 B:sum=55 C:sum=100 D:sum=88

以下程序段的执行结果为______。 #define PLUS(X,Y)X+Y main( ) { int x=1,y=2,z=3,sum; sum=PLUS(x+y,z)*PLUS(y,z); printf("SUM=%d",sum); }

A:SUM=9 B:SUM=12 C:SUM=18 D:SUM=28

下面程序段的输出结果是 public class Test{ public static void main(String args[]){ int n=5,sum=O; while(n>0){ sum+=n; --n; } System.out.println("sum is "+Sum); } }

A:sum is 14 B:sum is 15 C:sum is 10 D:sum is 5

下面程序段的输出结果是 public class Test{ public static void main(String args[]){ int n=5,sum=0; while(n>0){ sum+=n; --n; } System.out.println("sum is"+sum); } }

A:sum is 14 B:sum is 15 C:sum is 10 D:sum is 5

下列程序的执行结果是______。 public class ex3 { public static void main(String[] args) { int sum=0; for(int i=1;i<=100;i++) { sum+=i; } System.out.println("sum="+sum); }

A:sum=5050 B:sum=4950 C:sum=100 D:sum=1

下面程序段的输出结果是( )。 public class Test { public static void main (String[] args) { int sum=0; for ( int i=0;i<=100; i++) sum+=i; System. out. println ("sum="+sum); } }

A:sum =5050 B:sum=4950 C:sum=0 D:sum=100

下列程序的输出结果是( )。 public class Test { public static void main (String[] args) { int n=5,sum=0; while (n>0) { sum+=n; --n; } System.out.println("Sum is"+sum); } }

A:sum is 14 B:sum is 15 C:sum is 10 D:sum is 5

检索选修四门以上课程的学生总成绩(不统计不及格的课程),并要求按总成绩的降序排列出来。正确的SELECT语句是______。

A:SELECT S#, SUM(GRAD FROM SC WHERE GRADE>=60 GROUP BY S# ORDER BY 2 DESC HAVING COUNT(*)>=4 B:SELECT S#, SUM(GRAD FROM SC WHERE GRADE>=60 GROUP BY S# HAVING COUNT(*)>=4 ORDER BY 2 DESC C:SELECT S#, SUM(GRAD FROM SC WHERE GRADE>=60 HAVING COUNT(*)>=4 GROUP BY S# ORDER BY 2 DESC D:SELECT S#, SUM(GRADFROM SC WHERE GRADE>=60 ORDER BY 2 DESC GROUP BY S# HAVING COUNT(*)>=4

微信扫码获取答案解析
下载APP查看答案解析