
【名词&注释】
数据表(data table)、数据类型(data type)、不一致(inconsistency)、编译器(compiler)、单元格(unit grid)、不相同(disaffinity)、赋值运算符
[单选题]用SQL语言检索选修课程在5门以上(含5门)的学生的学号、姓名和平均成绩,并按平均成绩降序排序,正确的命令是( )。
A. SELECT S.学号,姓名,平均成绩 FROM S,SC;
B. 学号;
C. GROUP BY S.学号 HAVING COUNT(*)>=5 ORDER BY 平均成绩 DESC
D. SELECT 学号,姓名,AVG(成绩) FROM S,SC;
E. 学号AND COUNT(*)>=5;
F. GROUP BY 学号 ORDER BY 3 DESC
G. SELECT S.学号,姓名,AVG(成绩) 平均成绩 FROM S,SC;
H. 学号AND COUNT(*)>=5;
I. GROUP BY S.学号 ORDER BY 平均成绩 DESC
J. SELECT S.学号,姓名,AVG(成绩) 平均成绩 FROM S,SC;
K. 学号;
L. GROUP BY S.学号 HAVING COUNT(*)>=5 ORDER BY 3 DESC
查看答案&解析
举一反三:
[单选题]在每个c++ 程序中必须包含这样一个函数,该函数的函数名为______ 。
A. main
B. MAIN
C. name
D. function
[单选题]下列赋值语句中错误的是
A. float f=11.1f;
B. double d=5.3E12;
C. char c='\r';
D. byte bb=433;
[单选题]Excel 2000中用相对地址表示第4行第5列单元格,以下正确的是()。
A. E4
B. E$4
C. $E4
D. $E$4
[单选题]若有以下程序:include using namespace std;class Base{public:Base (){x=0;}int x;}
若有以下程序: #include iostream> using namespace std; class Base { public: Base () { x=0; } int x; }; class Derived1 : virtual public Base { public: Derived1 () { x=10; } }; class Derived2 : virtual public Base { public: Derived2 () { x=20; } }; class Derived : public Derived1,protected Derived2{ }; int main() { Derived obi; coutobj.xendl; return 0; } 该程序运行后的输出结果是
A. 20
B. 30
C. 10
[单选题]有如下程序: public class MethLoad { public static void main(String args[]) { MethLoad classObj=new MethLoad(); classObj.methtest(4); classObj.methtest(0); } void methtest(double d) { double sum=2*d; System.out.println("The result is:"+sum); } void methtest(int n) { int sum=4*n; System.out.println("The result is:" +sum); } }程序的运行结果为( )。
A. The result is:16 The result is:0
B. The result is:0 The result is:16
C. The result is:8 The result is:0
D. The result is:0 The result is:8
[单选题]下面程序的输出结果是 ( ) # includestdio.h> # includestring.h> { char * p1="abc" , * p2=" ABC ",str[50]="xyz"; strcpy(str+2.strcat (pi,p2)); printf("%s\n",str);}
A. zabcABC
B. yzabcABC
C. xycbcABC
[单选题]检索所有比“王华”年龄大的学生的姓名、年龄和性别,正确的SELECT语句是______。
A. SELECT SN,AGE,SEX FROM S SHERE AGE>(SELECT AGE FROM S WHERE SN='王华')
B. SELECT SN,AGE,SEX FROM S WHERE SN='王华'
C. SELECT SN,ACE,SEX FROM S WHERE AGE>(SELECT ACE WHERE SN='王华')
D. SELECT SN,ACE,SEX FROM S WHERE ACE>王华 AGE
[单选题]有以下程序,若从键盘上输入7和3 main(){ int a,b,k; scanf("%d,%d ",&a,&b); k=a; if(a
A. 7
B. 3
C. 1
[单选题]语句:print 5*5\5/5输出结果是( )
A. 5
B. 25
D. 1
本文链接:https://www.zhukaozhuanjia.com/download/kv0kw9.html