第1题:
用SQL语言检索选修课程在5门以上(含5门)的学生的学号、姓名和平均成绩,并按平均成绩降序排序,正确的命令是A)SELECT S.学号,姓名,平均成绩FROM S,SC; WHERE S.学号=SC.学号; GROUP BY S.学号HAVING GOUNT(*)>=5 ORDER BY平均成绩DESCB)SELECT学号,姓名,AVG(成绩)FROM S,SC; WHERE S.学号SC.学号AND COUNT(*)>=5; GROUP BY学号ORDER BY 3 DESCC)SELECT S.学号,姓名,AVG(成绩)平均成绩FROM S,SC; WHERE S.学号=SC.学号AND COUNT(*)>=5; GROUP BY S.学号ORDER BY平均成绩DESCD)SELECT S.学号,姓名,AVG(成绩)平均成绩FROM S,SC; WHERE S.学号=SC.学号; GROUP BY S.学号HAVING COUNT(*)=5 ORDER BY 3 DESC
第2题:
假设有如下的记录类型: Type Student number As String name AS String age As Integer End Type 则正确引用该记录类型变量的代码是______。
A.Student. name="" s. name="张红"
B.Dim s As Student s. Dame="张红"
C.Dim s As Type Student s. name="张红"
D.Dim s As Type s. name="张红"
第3题:
用SQL语言检索选修课程在5门以上(含5门)的学生的学号、姓名和平均成绩,并按平均成绩降序排序,正确的命令是( )。
A.SELECT S.学号,姓名,平均成绩 FROM S,SC;
WHERE S.学号=SC.学号;
GROUP BY S.学号 HAVING COUNT(*)>=5 ORDER BY 平均成绩 DESC
B.SELECT 学号,姓名,AVG(成绩) FROM S,SC;
WHERE S.学号=SC.学号AND COUNT(*)>=5;
GROUP BY 学号 ORDER BY 3 DESC
C.SELECT S.学号,姓名,AVG(成绩) 平均成绩 FROM S,SC;
WHERE S.学号=SC.学号AND COUNT(*)>=5;
GROUP BY S.学号 ORDER BY 平均成绩 DESC
D.SELECT S.学号,姓名,AVG(成绩) 平均成绩 FROM S,SC;
WHERE S.学号=SC.学号;
GROUP BY S.学号 HAVING COUNT(*)>=5 ORDER BY 3 DESC
第4题:
第5题:
The poor man was so frightened that he could do _____ but stand there sobbing.
A. something
B. anything
C. everything
D. nothing
第6题:
Part B
Directions:
Read the following saying and write an essay in which you should
1) interpret the saying,
2) give your comments onthe saying, and
3) write a title for your essay.
A woman’s career, particularly if it is successful, is often blamed for the break-up of a marriage, but never a man’s.
You should writ 160—200 words neatly on ANSWER SHEET 2. (20 points)
参考范文
A self-evident prejudice is made clear by the given saying that a woman’s career, particularly if it is successful, is often blamed for the break-up of a marriage, but never a man’s. Those who support the saying attribute the break-up of a marriage to the successful career of the wife. In their eyes, a successful woman devoted to her career will certainly neglect her duties to her husband, her children and thus results in the break-up of the family. This accusation is unfair and absolutely unacceptable.
The prejudice lies in the fact that it has been branded in our mind that women should be inferior to men and they should be at home to foster children and to support their husband. In fact, women should be entitled the rights to have their own careers. They have the rights to get the satisfaction from work besides that from their families. This accusation ignores the fact that the responsibilities for break-up of a marriage should be taken by both parties instead of one. Cleary, to blame a carrer woman for the break-up of a marriage is groundless.
As a conclusion, what has been traditionally taken for granted in our mind should be replaced by more rational ideas. From now on, it should be prescribed in our mind as law of various nations that everyone is born equal and they should be on equal terms.
第7题:
查询选修了课程号为“MATHS”的学生的姓名和年龄,若用下列SQL的SELECT语句表达时,错误的是( )。
A) SELECT SNAME,AGE FROM S WHERE S. S# =(SELECT SC. S# FROM SC WHERE
c.c# ='MATHS ')
B ) SELECT SNAME, AGE FROM S WHERE S. S# =(SELECT SC. S# FROM SC WHERE
SC. C# =' MATHS ')
C) SELECT SNAME, AGE FROM S, SC WHERE S. S# =SC. S# AND SC. C# ='MATHS'
ORDER BY S. S#
D)SELECT SNAME, AGE FROM S, SC WHERE S. S# =SC. S# AND SC. C# ='MATHS'
第8题:
A.what’s
B.what it’s like
C.it feels
D.how feel
第9题:
A、poor as his sister’s if not poor
B、as poor, if not poorer than, his sister
C、as poor, if not poorer than sister’s
D、as poor as, if not poorer than, his sister’s
第10题:
s. o. s.的含义是
A.饭前
B.下午
C.必要时
D.需要时
E.立即