问题 单项选择题

(31)到(35)题使用如下数据表。
“班级”表 班级号 班级名称 人数
11 计算机200801班 44
22 计算机200802班 50
33 计算机200803班 49
44 计算机200804班 46
55 计算机200805班 48
“学生”表 学号 姓名 性别 年龄 班级号
S1 李志明 男 18 33
S2 万力佳 女 19 11
S3 李凤 女 20 22
S4 赵洪波 男 24 33
S5 刘鹏 男 22 44
S6 王晓晓 女 20 22
S7 张文静 女 22 11
S8 汪菁菁 女 19 44
S9 刘立洋 男 20 11

有如下SQL语句: SELECT MAX(人数)FROM 班级 INTO ARRAY temp执行该语句后( )。

A.temp[0]的内容为44

B.temp[0]的内容为50

C.temp[1]的内容为44

D.temp[1]的内容为50

答案

参考答案:D

解析: SQL不仅有一般的检索功能,而且还有计算方式的检索,利用MAX()函数可以计算指定列中的最大值。本题的SQL语句功能是检索“班级”表中人数最多的班级,将数值输出到数组temp中,其中INTO ARRAY表示将结果输出到指定的数组中。注意:数组的下标是从1开始的,而不是从0开始。

阅读理解

阅读理解

     Think about the different ways that people use the wind. You can use it to fly a kite or to sail a boat.

Wind is one of our cleanest and richest power sources(来源) as well as one of the oldest. Evidence shows that windmills(风车)began to be used in ancient Iran back in the seventh century BC. They were first

introduced to Europe during the 1100s, when armies returned from the Middle East with knowledge of

using wind power.

    For many centuries, people used windmills to grind(磨碎)wheat into flour or pump water from deep

underground. When electricity was discovered in the late 1800s. people living in remote areas began to use them to produce electricity. This allowed them to have electric lights and radio. However, by the1940s

when electricity was available to people in almost all areas of the United States, windmills were rarely

used.

     During the 1970s,people started becoming concerned about the pollution that is created when coal and gas are burned to produce electricity .People also realized that the supply of coal and gas would not last

forever .Then, wind was rediscovered ,though it means higher costs. Today ,there is a global movement to supply more and more of our electricity through the use of wind.

1. From the text we know that windmills

A. were invented by European armies            

B. have a history of more than 2,800 years

C. used to supply power to radio in remote areas    

D. have rarely been used since electricity was discovered

2. What was a new use for wind power in the late 19th century?

A. Sailing a boat.                            

B. Producing electricity

C. Grinding wheat into flour.                  

D. Pumping water from underground

3. One of the reasons wind was rediscovered in the 1970s is that_________.

A. wind power is cleaner                    

B. it is one of the oldest power sources

C. it was cheaper to create energy from wind    

D. the supply of coal and gas failed to meet needs

4. What would the author probably discuss in the paragraph that follows?

A. The advantages of wind power.            

B. The design of wind power plants.

C. The worldwide movement to save energy  

D. The global trend towards producing power from wind

配伍题 B型题