设有图书管理数据库：图书(总编号C(6)，分类号C(8)，书名C(16)_爱下问搜题

搜题请搜索小程序“爱下问搜题”

问题填空题

设有图书管理数据库：
图书(总编号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图书管理! 图书；
WHERE出版单位=“高等教育出版社”______

答案

参考答案：OR 出版单位=“电子工业出版社”ORDER BY 出版单位 DESC

解析：
And & Or
用途：
在WHERE子句中AND和OR被用来连接两个或者更多的条件
解释：
AND在结合两个布尔表达式时，只有在两个表达式都为 TRUE时才传回TRUE
OR在结合两个布尔表达式时，只要其中一个条件为TRUE时，OR便传回TRUE
Order by
用途：
指定结果集的排序
语法：
SELECT column-name(s)FROM table-name ORDER BY{order_by_expression[ASC|DESC]

单项选择题 A1/A2型题

已婚妇女，25岁，平素月经规律，停经56天，恶心、呕吐等早孕反应持续至今，现 * * 少量流血伴下腹坠疼4小时，查体： * * 流血来自宫腔，宫口未开，子宫符合妊娠月份，本例最可能的诊断是（）

A.先兆流产

B.难免流产

C.不全流产

D.完全流产

E.稽留流产

阅读理解

“Choo, Choo!” Here comes the Chunnel train. Get aboard if you want to learn more about this underground transportation system. This is an unusual form of transportation, because it is a tunnel that trains travel through and not an actual form of transportation.

The Chunnel is actually the English nickname for the Channel Tunnel. In French, it is called le tunnel sous la Manche. It is a rail tunnel beneath the English Channel at the Straits of Dover. It connects Cheriton in Kent, England with Sangatte in northern France. It is the second longest rail tunnel in the world.

Did you know that the British and the French had a race whi1e they were building the Chunnel? The race was to see who could get to the middle of the tunnel first. The British won by a little bit. It took 15,000 workers over seven years to dig the tunnel. The tunnel was finished in 1994.

The completed Chunnel cost about $ 21 billion. But it all paid off, because it became very popular, very quick. Millions of people use it. Now it is getting even more popular.

There are three complete tunnels in the Chunnel. The two outside ones are the passenger trains. The small inner one is a guidance train. The guidance train is not used for transportation. Each track is exactly parallel to each other.

There are four different train systems in the Chunnel. The Eurostar is a high speed passenger service that connects London, Paris, Brussels, and Lille. The Eurotunnel shuttle is a rail ferry service. These shuttles carry cars. These are railcars that allow drivers to drive their vehicles on and off. There are also two Eurotunnel goods service trains.

Now you know more about the Chunnel. Everybody off, this is the last stop.

小题1:The Channel Tunnel links ______ with _______.

A．Dover; Kent

B．London; Paris

C．Lille; Brussels

D．Cheriton; Sangatte小题2:Which of the following shows the structure of the tunnels in the Chunnel?

小题3:The Eurotunnel shuttle is intended to carry _________.

A．passengers

B．drivers and their vehicles

C．goods

D．staff members of the Chunnel小题4:The text can most probably be __________.

A．found in a textbook

B．read in a magazine

C．broadcast on a train

D．heard in a railway station