问题 单项选择题

第36~40题使用如下关系:   客户(客户号,名称,联系人,邮政编码,电话号码)   产品(产品号,名称,规格说明,单价)   订购单(订单号,客户号,订购日期)   订购单明细(订单号,序号,产品号,数量)

假设客户表中有客户号(关键字)C1~Cl0共10条客户记录,订购单表有订单号(关键字)OR1~OR8共8条订购单记录,并且订购单表参照客户表。下列命令可以正确执行的是( )。

A.INSERT INTO订购单VALUES(’OR5’,’C5’,{’2008/10/10})

B.INSERT INTO订购单VALUES(’OR5’,’Cll’,(’2008/10/10))

C.INSERT INTO订购单VALUES(’OR9’,’Cll’,{’2008110/10})

D.INSERT INTO订购单VALUES(’OR9’,’C5’,{’2008/10/10})

答案

参考答案:D

解析:【解析】实体完整性是保证表中记录唯一的特性,即在一个表中不允许有重复的记录。由于订购单表中已经存在ORl~OR8的订单号,所以选项A和选项B的订单号OR5不可以进行插入操作。参照完整性是指当插入、删除或修改一个表中的数据时,通过参照引用相互关联的另一个表中的数据,来检查对表的数据操作是否正确。由于选项C中的客户号Cll在客户表中并不存在,所以选项C也不可以进行插入操作。因此正确的答案是选项D。

单项选择题
完形填空

阅读表达(共5小题;每小题3分,满分l 5分)

Do you want to work with people or animals or machines or tools? Do you want to work indoors or outdoors, directly serve people in need or serve people behind the scenes? These are the typical questions that a volunteer service agency would ask.

Every year, thousands and thousands of people in the west offer volunteer services. Volunteering greatly strengthens the community partly because it helps the old, the young, the weak, the sick, the disabled and the injured to overcome difficulties.

Volunteers usually help in many different ways. They may give people advice, offer friendship to the young, drive the elderly to church, counsel kids against drugs. Work as an assistant in a school or nursing home, raise funds, plant trees, help out in local libraries and do many other things.

Volunteering can be a few hours a week or a few hours a month, time during the day, evenings or weekends, either part time or full time. Anybody __________ can become a volunteer.

The art of volunteering is a process of both giving and receiving. Volunteering allows volunteers to meet new people and make new friends and mix with people from all walks of life. Volunteering is an excellent way to experiment, practice and try out new techniques and skills. It is much more effective to practice a skill than to read about it or study it in a classroom. Volunteering is a great way to develop good teamwork skills, discover your individual talents and explore career choices. Being a volunteer takes individuals on a wonderful journey and helps them learn many important things beyond their school.

76. What is the best title of the passage? (Please answer within 10 words)

_______________________________________________________________________77. Which sentence in the passage can be replaced by the following one?

Volunteer service can provide chances for volunteers to make acquaintance of all kinds of people.

_______________________________________________________________________78. Please fill in the blank in the fourth paragraph with proper words, phrases or sentences to complete the sentence. (Please answer within 10 words.)

______________________________________________________________________

79. What kind of volunteer jobs would you like to take? Why? (Please answer within 30 words)

______________________________________________________________________________________________________________________________________________

80. Translate the underlined sentence in the fifth paragraph into Chinese?

____________________________________________________________________________________________________________________________________________