问题 单项选择题

(31)到(35)题使用如下数据表。
“作者”表:
作者编号 姓名 所在城市
1101 张晓云 北京
1102 李丽北京
1103 袁熙林 上海
1104 赵三立 广州
1105 方德胜 上海
1106 刘清北京
“图书”表:
图书编号 书名 出版单位 价格 作者编号 页数
1101 计算机基础知识 经济科学出版社 32.80 1101 252
2202 会计基础知识 经济科学出版社 17.80 1105 215
1102 VB9.0初级入门 人民邮电出版社 22.50 1102 264
1103 Word2003基础知识 大地出版社19.80 1101 298
1105 VFP6.0程序设计基础 大地出版社38.50 1103 310
2201 中级会计财务知识 经济科学出版社 28.80 1106 245
1110 计算机网络基础 高等教育出版社 26.50 1101 258
1111 计算机组成原理 北京大学出版社 31.20 1103 98
1112 数据库设计原理 高等教育出版社 35.50 1101 330
1113 C语言程序设计 北京大学出版社 32.00 1102 326
1114 软件设计分析高等教育出版社 34.50 1102 330
2203 信息系统分析理论 经济科学出版社 25.50 1102 235

若有下列SQL语句:

SELECT 出版单位,COUNT(*)FROM图书;

GROUP BY 出版单位ORDER BY 2 DESC

查询结果中,第一条记录的“出版单位”名称是( )。

A.高等教育出版社

B.北京大学出版社

C.经济科学出版社

D.人民邮电出版社

答案

参考答案:C

解析: 本题SQL语句的功能是按“出版单位”对“图书”表记录进行分组,然后通过COUNT()函数统计每个出版社的图书种类数量,查询结果中包括“出版单位”和该出版单位出版的图书种类数量,查询结果中按第2个字段降序排序,即按出版单位出版的图书种类数量由高到低的顺序排序。

阅读理解

阅读理解。

     Most American families like to have a vacation in summer. Summer is a good season for vacation. It is

often hot during the months of July and August. Children do not go to school during these two months.

     Some people like to stay at home during their vacation. They walk in the garden,visit their friends, read

books or watch TV. Many families take their lunch to a park or somewhere far from the city. They like to 

get where there are many trees or a nice lake. If they live near the ocean, they often go to the beach. There

they can fish,swim or enjoy the sun.

     Many Americans like to meet people from other countries like Mexico or Canada. Some people have

enough time and money to travel to other countries like Frence, Japan or Argentina. They usually fly to the

countries by plane. The United States is a large county. Many families travel by car or by train to see

interesting places in their country. Some favorite cities to visit are New York, Chicago, Miami, San Francisco

and Los Angeles. These big cities have many famous buildings, theaters, stores and other places of interest

for tourists.

     Not everyone likes to go to busy cities. Some families travel to the mountains or to beautiful valleys.

They usually take a camera and return with many nice pictures of the places they visit. It is always fun to

put the pictures in an album (相册) and share them with friends.

1. From the passage we know that children don't go to school during________.

A. the months of July and August

B. the months of June and July

C. the month of August and September

D. the month of July

2. Argentina is a ________.

A. city

B. village

C. country

D. town

3. Not everyone likes to go to busy cities. This sentence tells us that ________.

A. no one likes to go to busy cities

B. Everybody likes to go to busy cities

C. many people like to go to busy cities but not all like to go to

D. the United States is a large country indeed.

4. The underlined word "tourist" means "________".

A. 建筑师

B. 旅游者

C. 诗人

D. 商人

5. Which of the following is TRUE?

A. All the Americans like to meet people from other countries.

B. Americans like to travel to some mountains and valleys.

C. Americans really like to travel during their vacation.

D. If the people live near the ocean.they like to stay at home.

填空题