问题 填空题

第(9)~(12)是基于下述描述:
假设图书管理数据库中有3个表,图书.dbf、读者.dbf和借阅.dbf。它们的结构分别如下:
图书(总编号C(6),分类号C(8),书名C(16),出版单位C(20),单价N(6,2))
读者(借书证号C(4),单位C(8),姓名C(6),性别C(2),职称C(6),地址C(20))
借阅(借书证号C(4),总编号C(6),借书日期D(8))

对图书管理数据库,查询由“清华大学出版社”或“电子工业出版社”出版,并且单价不超出20元的书名。请对下面的SQL语句填空:
SELECT书名,出版单位,单价FROM图书;
WHERE 【13】 AND;
【14】

答案

参考答案:[AC]单价<=B0
[AD](出版单位="清华大学出版社"OR出版单位="电子工业出版社") 或 出版单位in(’电子工业出版社’,’清华大学出版社’)

解析:[知识点] SQL的数据查询功能
[评析] 本题是带条件的简单查询,要使用带WHERE的SELECT命令,将限制条件
单价<=20 AND(出版单位="清华大学出版社"OR出版单位="电子工业出版社")
放在WHERE短语后面,限定条件是由逻辑运算符AND和OR连接的逻辑表达式,由于AND运算的优先级比OR运算的优先级高,为了先进行OR运算,需要加括号。
注意:不能将"清华大学出版社"或"电子工业出版社"出版的条件写为:
(出版单位="清华大学出版社"OR"电子工业出版社")。
本题中两个空的答案可以交换。

阅读理解

Have you ever thought of taking a train and having an adventure(奇遇)?Riding the train can be a real adventure. That is how I feel every time I take Amtrak. I often take a four-hour trip to visit my children. Every time I take this trip I never know what will happen.

Last week when I was on the train and over an hour into the train ride,there was a man sitting by himself in the back of the train carrying on a mobile phone conversation-in another language. It was loud and disturbed most of the people on the train. I think it was annoying.

Fortunately I sat next to a wonderful old lady who was taking a two-day trip by train. She said her two daughters were distraught at the thought of her driving for three days to reach her home,although she had no trouble driving. The train ride was the only choice for her. She loved to look out of the window and watch the world go by on the train.

She was fun to talk to and asked me when my children started being parents. That is a very good question. Both of us are old and have children. She asked that same question from time to time.

There are always many people on the train from all walks of life,different countries,and many  languages. Riding the train is a great way to increase your knowledge and take in all kinds of cultures. If you get hungry,you can buy food in the food car at any time. If you need to use the restroom there is always one available.

It sure beats driving the car,which has to stop for food and restrooms. And it is better than taking the bus.

小题1:According to the passage,the purpose of the author’s train ride was    .

A.to do business

B.to see her children

C.to visit places of interest

D.to see her old friends小题2:Which of the following is the closest in meaning to the underlined word “distraught” in Paragraph 3?

A.Disappointed.

B.Satisfied.

C.Worried.

D.Pleased.小题3:Which of the following is TRUE about the old lady sitting next to the author?

A.She is too old to drive now.

B.She does not like to take trains.

C.Although she is old,she has a good memory.

D.Her daughters live far away from her home.小题4:What is the best title for this passage?

A.Train ride-a cultural experience

B.A painful experience on the train

C.The history of Amtrak

D.A wonderful lady

单项选择题