问题 填空题

对图书管理数据库,求共借出多少种图书。请对下面的SQL语句填空: SELECT 【15】 ROM借阅

答案

参考答案:COUNT(DISTINCT总编号)

解析:[知识点] SQL的数据查询功能 [评析] 本题是一个计算查询的问题,使用SELECT命令实现,要统计数需要用COUNT()函数。求共借出多少种图书,要统计借阅表中共有多少种图书的总编号。由于一种书可能被多个读者借阅,所以借阅表中的总编号属性的值可能会有一些重复值,在统计时应加DISTINCT短语去掉重复值。除非是统计表中的元组个数,一般情况下,COUNT函数应该使用DISTINCT短语

阅读理解

You have been badly injured in a car accident. It is necessary to give you a blood transfusion because you lost a great deal of blood in the accident. However, special care must be taken in selecting new blood for you. If the blood is too different from your own, the transfusion could kill you.

There are four basic types of blood; A, B, AB, and O. A simple test can make sure of a person's blood type. Everybody is born with one of these four types of blood. Blood type, like hair color and height, is received from parents.

The four groups must be transfused carefully. A and B cannot be mixed. A and B cannot receive AB, but AB may receive A or B. O can give to any other group; therefore, it is often called the universal donor (万能捐赠者). For the opposite reason, AB is sometimes called the universal recipient(接受者). However, because so many reactions (反应) can happen in transfusions(输血), patients usually receive only salt of plasma (liquid part of blood) until their blood can be matched as exactly as possible in the blood bank of a hospital. In this way, it is possible to prevent the transfusion from any bad reactions.

86. People with type A blood can receive type     .

A. AB           B. B       C. O                    D. all of the three

87. If you need a blood transfusion, the best and safest blood for you is    .

A. a mixture of type A and type B

B. a mixture of salt, plasma and type O

C. type AB

D. exactly the same type as your own

88. The phrase "universal recipient" means a person who    .

A. can receive blood of type A or B

B. can receive blood of any other type

C. can give blood to anybody

D. cannot give blood to others

89. A good title for this article is    .

A. Getting Enough Blood

B. Differences Between Blood Types

C. Man's Four Types of Blood

D. How to Give Blood Transfusion

90. Which of the following statement is NOT true?

A. Carelessness in a blood transfusion may lead to death. 

B. AB is the mixture of A and B

C. AB is called the universal recipient because it can receive any other group.

D. In transfusions, patients usually receive only salt of plasma at first.

单项选择题