问题 单项选择题

第33 ~(35)是基于下述描述:
设有图书管理数据库:
图书(总编号C(6),分类号C(8),书名C(16),作者C(6),出版单位C(20),单价N(6,2))
读者(借书证号C(4),单位C(8),姓名C(6),性别C(2),职称C(6),地址C(20))
借阅(借书证号C(4),总编号C(6),借书日期D(8))

对于图书管理数据库,要查询所藏图书中,各个出版社的图书最高单价、平均单价和册数,下面SQL语句正确的是 ______。 SELECT出版单位 ______,______,______,______;FROM图书管理!图书______出版单位

A.MIN(单价) AVGAGE(单价) COUNT(*) GROUP BY

B.MAX(单价) AVG(单价) COUNT(*) ORDER BY

C.MAX(单价) AVG(单价) SUM(*) ORDER BY

D.MAX(单价) AVG(单价) COUNT(*) GROUP BY

答案

参考答案:D

解析:[知识点] SQL的数据查询功能/连接查询[评析] 查询操作用SELECT命令实现,本题属于分组计算查询。所要查询的数据来自一个表,通过GROUP BY短语关于出版社进行分组,并通过函数MAX()和AVG()来计算每一组内单价的最大值和平均值,通过 COUNT(*)来统计每一组的个数。

多项选择题
阅读理解

C

Years ago ,when I started looking for my first job ,wise advised,“Barbara, be enthusiastic! Enthusiasm will take you further than any amount of experience. ”How right they were!

“Nothing great was ever achieved without enthusiasm.”wrote Ralph Waldo Emerson. It is the paste that helps you hang on there when the going tough. It is the inner voice that whispers, “I can do it!”when others shout, “No, you can’t !”It took years and years for the early work of  Barara  McClintock, a geneticist who won the 1983 Nobel  Prize in medicine , to be generally accepted. Yet she didn’t stop working on her experiments. Work was such a deep pleasure for her that she never thought of stopping.

We are all born with wide-eyed, enthusiastic wonder and it is this childlike wonder that gives enthusiastic people such youthful air, whatever their age was. At 90,cellist Palblo Cassls would start his day by playing Bach.  A s the music flowed through his fingers his stooped shoulders would strengthen and joy would reappear in his eyes . As author and poet Samuei Ulman once wrote ,“ Years wrinkle the skin ,but to give up enthusiasm wrinkles the soul.”

Enthusiastic people also love what they do, regardless of money or power . Patricia  Mellrath, retired director of the Missouri  Repertory  Theatre in Kansas City, was once asked where she got her enthusiasm. She replied, “My father ,a lawyer long ago told me , I never made a dime until I stopped working for money.”

If we cannot do what we love as a full-time career, we can as a hobby. Elizabeth  Layton was 68 before she began to draw. This activity ended periods of depression that had troubled her for at least 30 years ,and the quality of her led one critic to say,“I’m tempted to call Layton a genius.”

We can’t afford to waste tears on “might-have-beens”. We need to turn the tears into sweat as we go after “what-can-be ”.We need to live each moment whole-heartedly, which all our senses-including pleasure in the sweet smell of a back-yard garden, the simple picture of a six-year –old ,the beauty of  a  rainbow.

66. What is the Chinese for “Enthusiasm”?

A.热情               B. 色彩                                C. 惰性                 D.金钱

67. Which of the following can best explain the underlined sentence in the second paragraph?

A. Enthusiasm can give you courage and strength in difficult times.

B. If you don’t have enthusiasm, you can achieve nothing.

C. Enthusiastic people never consider money and fame.

D. Enthusiastic people can gain great fame and honor.

68. The author mentions cellist Pablo Casals in the third paragraph to show that____

A. music can arouse people’s enthusiasm

B. enthusiasm can give people inspiration needed to succeed

C. enthusiasm can keep people feel young

D. enthusiasm can keep people healthy

69. How many examples are given in the passage to show the importance of enthusiasm?

A. Three             B. Two              C. Four                     D.  Five

70. The author mainly wants to say that _________

A. enthusiasm people never get old                            

B. enthusiasm can make you succeed and enjoy life

C. enthusiasm is more important than experience

D. enthusiasm can give people more success and fame .