(053)05-06春上机考试题&解答

2005年上海市普通高等学校春季招生考试英语试题第I卷I. Listening Comprehension（略）II. GrammarDirections: Beneath each of the following sentences there are four choices marked A, B, C and D. Choose the one answer that best completes the sentences.25. —Does Lisa have a new hair style?—Yes. In fact, it is quite similar ________ yours.A. asB. likeC. toD. with26. My daughter often makes a schedule to get ________ reminded of what she is to do in the day.A. herselfB. herC. sheD. hers27. —What a nice fire you have in your fireplace!—During the winter I like my house ________ .A. warmly and comfortablyB. warm and comfortableC. warm and comfortablyD. warmly and comfortable28. We have only a sofa, a table and a bed in our new apartment. We need to buy ________ more furniture.A. anyB. manyC. littleD. some29. According to the local regulations, anyone who intends to get a driver's licence ________ take an eye test.A. canB. mustC. wouldD. may30. On top of the books ________ the photo album you're looking for.A. isB. areC. hasD. have31. The year 2002 ________ remarkable changes in Shanghai's landscape.A. seesB. has seenC. sawD. had seen32. I want to know ________ the thief was caught on the spot.A. whichB. thatC. whatD. whether33. Accustomed to ________ the steep mountains, he had no difficulty reaching the top.A. climbingB. climbC. having climbedD. have climbed34. The United States is made up of fifty states, one of ________ is separated from the others by the Pacific Ocean.A. themB. thoseC. whichD. whose35. So little ________ with each other that the neighbouring countries could not settle their differences.A. they agreedB. agreed theyC. did they agreeD. they did agree36. This company was the first ________ portable radio as well as cassette tape recorders in the world.A. producingB. to produceC. having producedD. produced37. Our club is open to adults only. your children have entered without permission.A. There seems thatB. It seems to beC. There seems to beD. It seems that38. Don't leave the sharp knife ________ our little Jane can get it.A. in whichB. to whichC. thatD. where39. When the first English settlers arrived in the New World, the Indians ________ jewellery made of animal bones greeted them warmly.A. wearingB. to wearC. wornD. having worn40. The purpose of new technology is to make life easier, ________ it more difficult.A. not makingB. not makeC. not to makeD. nor to make41. I am sure that Laura's latest play, ________ staged, will prove a great success.A. sinceB. unlessC. onceD. until42. Telephone messages for the manager ________ on her desk but she didn't notice them.A. were leftB. was leftC. was leavingD. were leaving43. Sugar, when ________ with water, dissolves quickly.A. mixedB. mixingC. mixD. is mixed44. It was after the invention of printing ________ to publish large numbers of books and pictures.A. were people ableB. that people were ableC. when were people ableD. people were ableIII. VocabularyDirections: Beneath each of the following sentences there are four choices marked A, B, C and D. Choose the one answer that best completes the sentence.45. You will find this map of great ________ in helping you to get around the city.A. sourceB. senseC. favourD. value46. Do you have any ________ of what life would be like if we lived on other planets?A. planB. ideaC. impressionD. imagination47. That his only son was killed in the air crash was a ________ blow to the old man.A. heavyB. broadC. plainD. main48. Beginners are expected to be familiar with the ________ of the reading material before they come to the class.A. conditionB. conceptC. contestD. content49. I don't care about the good salary offered by the company. What I need is a(n) ________ post.A. creatingB. awardingC. challengingD. competing50. Studies show that many diseases such as SARS and AIDS are ________ from wildlife.A. speciallyB. originallyC. magicallyD. visibly51. The way Einstein answered the question ________ his talent and sense of humour.A. relievedB. releasedC. revealedD. recovered52. Doctors are doing research to find out what happens physically when people ________ smoking.A. quitB. declineC. departD. reserve53. The more frequently farmers use insecticides, the more ________ the insects will become to the chemicals.A. resistantB. availableC. sensitiveD. agreeable54. The photographer needs to charge up the digital camera every day as the battery________ quickly.A. shuts upB. ends upC. runs outD. turns outIV. ClozeDirections: For each blank in the following passages there are four words or phrases marked A, B, C and D. Fill in each blank with the word on phrase that best fits the context.(A)Everybody has different ways of achieving happiness and the reasons for feeling happy may change from year to year, or even from day to day. 55________ , happiness may come from getting a good grade on a school assignment or from a very 56________ thing like having a full stomach. This kind of happiness is inside of you—it is 57________ happiness. Happiness is also something you can 58________ to other people. The good grade you receive on your paper will probably make your parents happy and proud. 59________ way of communicating happiness is to help other people over difficult experiences in their own lives. In this situation, you give of your own happiness to make others happy.The most important things to remember in your pursuit of 60________ are:1. Happiness should not be your only 61________ —a real goal, like better grades, a better job, or closer friends, is sure to give you more happiness than chasing after a feeling.2. Happiness comes in all sizes and shapes. 62________ you keep your sense of humour and see things in a balanced way, happiness will come to you faster than to the person who is always 63________ what tomorrow will bring.3. Happiness is meant to be 64________ . “Laugh and the world laughs with you, cry and you cry alone.”55. A. In general B. In addition C. For instance D. In the meantime56. A. generous B. simple C. healthy D. lucky57. A. personal B. secret C. superb D. physical58. A. attach B. connect C. translate D. communicate59. A. Each B. Another C. Either D. One60. A. fame B. power C. fortune D. happiness61. A. trend B. basis C. goal D. vision62. A. Because B. If C. Until D. Before63. A. running after B. feeling likeC. worrying aboutD. struggling for64. A. shared B. valued C. enjoyed D. agreed(B)A small, damaged, but valuable Greek marble（大理石）head has been stolen from the British Museum, apparently during opening hours. The stand（托架）of the head was discovered ６５________ on Tuesday, and it is believed that the 2,500-year-old statue was stolen that day.A metal device 66________ the base of the marble to the stand, and it would have taken considerable strength to separate them. 67________ small enough to fit into a bag or a large pocket, the head weighed five to six pounds.Only 68________ of the museum's hundreds of galleries are covered by monitors. The Greek Ancient Gallery, where the theft took place, had no permanent guard on duty;69________ , it was visited regularly by a member of staff checking around several galleries at a time. Last year, in a nearby gallery, a marble hand was broken off a Greek statue in70________ was believed to have been chance destruction rather than a(n) 71________ art theft—although the hand has still not been recovered.The head, dating from the sixth century BC, had been badly damaged before the museum acquired it in the 19th century, with the 72________ bottom of the face and most of the nose missing. Despite the damage, it is 73________ several thousand pounds. Although not the most valuable piece in the Greek collection, its loss will be a severe embarrassment to the museum, which is under constant 74________ for poor protection by campaigners for the return of the Parthenon marbles. The museum has informed the police, as well as antiquities dealers（古董商）, the Art Loss Office, and the heads of museums worldwide.65. A. blank B. missing C. lost D. empty66. A. related B. adjusted C. fixed D. stuck67. A. Though B. Since C. Unless D. When68. A. many B. most C. few D. some69. A. contrarily B. instead C. moreover D. namely70. A. which B. that C. this D. what71. A. planned B. expected C. suggested D. supposed72. A. raw B. full C. entire D. complete73. A. counted B. worth C. calculated D. weighed74. A. criticism B. discussion C. argument D. judgementV. Reading ComprehensionDirections: Read the following passages. Each passage is followed by several questions or unfinished statements. For each of them there are four choices marked A, B, C and D. Choose the one that fits best according to the information given in the passage you have just read.(A)Once upon a starless midnight an owl（猫头鹰）sat on the branch of a tree. Two mice tried to pass by quietly, unnoticed. “You!” said the owl. “Who?” they asked, in fear and astonishment, for they could not believe it was possible for anyone to see them in that thick darkness.“You two!” said the owl. The mice hurried away and told the other creatures of the field and forest that the owl was the greatest and wisest of all animals because he could see in the dark. “Can he see in the daytime, too?” asked a red fox. All the other creatures laughed lou dly at this silly question, and they set upon the red fox and his friends and drove them out of the region. Then, they sent a messenger to the owl and asked him to be their leader.When the owl appeared among the animals it was high noon and the sun was shining brightly. He walked very slowly, which gave him an appearance of great dignity, and he looked about him with large, staring eyes, which gave him an air of tremendous importance. “He's God!”screamed a hen. And the others took up the cry, “He's God!” So they followed him wherever he went and when he began to bump into things they began to bump into things, too. Finally he came to a concrete highway and he started up the middle of it and all the other creatures followed him. Presently, a bird observed a truck coming toward them at fifty miles an hour, and he reported to the owl. “There's danger ahead,” said the bird. “What?” asked the owl. The bird told him. “Aren't you afraid?” he asked. “Who?” said the owl calmly, for he could not see the truck. “He's God!” cried all the creatures again, and they were still crying “He's God!” when the truck hit them and ran them down. Some of the animals were merely injured, but most of them, including the owl, were killed.75. Hearing the owl's voice, the two mice were fearful and astonished because ________ .A. mice are very timid animalsB. the owl wanted to eat themC. the owl could see them in darknessD. they thought no other animals were there76. The sentence “...they set upon the red fox and his friends...” in paragraph 1 probably means “ ________ ”.A. the red fox and his friends were under attackB. they sat on the red fox and his friendsC. they set a trap for the red fox and his friendsD. the red fox and his friends set a foolish example77. The animals followed the owl wherever he went for the reason that .A. the owl walked slowly with dignityB. the owl had an air of importanceC. they regarded the owl as GodD. they were not as clever as the owl78. What's the most appropriate moral of the story?A. Pride goes before a fall.B. Seeing is believing.C. Group behaviour is often mad.D. “Follow the leader” can be a dangerous game.(B)The mobile phone has been a part of our lives since the 1980s. It enables us to stay in contact with our family and friends at all times and in most areas. However, because of the quick acceptance and extensive usage of mobiles in our lives, wehave missed out on an important step, namely, theappropriate use.Driving a carDo not use your phone while you are driving! Youcould concentrate on your conversation and forget to lookwhere you are going, or you could take your eyes off theroad to look at the phone's display or to press in a number.Either way, you could cause a terrible accident.In a restaurantThere is probably nothing more annoying than adiner receiving or making a call near you when you are ina restaurant. The icy glares (冷眼) you receive should bewarning enough that it is not appreciated. Turn your phoneoff and use your message service to return calls after youleave.At the cinemaDo not give way to the desire to call a friend if the film is boring, or if you want to find out what happens. You could become the target of all the angry cinema customers.At the theatreThere is no more icy glare than that of a theatre goer who has paid a lot of money to see a show and hears your phone playing a tone. It goes without saying that you will be seen as a socially unacceptable person in this situation.In hospitalsThis is probably the most important place to make sure your phone is switched off. Your phone can disturb life-saving electro-nic equipment in hospitals, so it is necessary that your phone is switched off before you enter.On planesYour phone might disturb navigational (导航的) equipment and cause a horrible accident so you should switch it off before boarding a plane.79. According to the passage, the most annoying thing in a restaurant is that ________ ．A. you receive icy glaresB. a nearby diner is answering a phone callC. you have to use the message serviceD. you can not return calls until after you leave80. Which of the following statements is NOT true?A. Theatre goers will not give you icy glares when they hear your phone.B. When switched on in hospitals, mobile phones could endanger patients' lives.C. Passengers should switch off the phones before getting on a plane.D. Pressing in phone numbers when driving could lead to traffic accidents.81. The passage mainly describes ________ .A. different functions of mobile phonesB. the overuse of mobile phones on some occasionsC. some areas where message service is forbiddenD. the proper use of mobile phones in some public places(C)Leisure and recreation and the chance to play are not luxuries for children, but essentials for normal healthy development. Long hours and days of uninterrupted work have a bad effect on children, narrowing their horizons and often disturbing them emotionally.Why then do parents allow or indeed encourage their children to work? The answer, of course, is poverty. The child's wage, however little, may mean the difference between the family eating or not eating. Many parents, not educated themselves, don't understand the value of schooling, and can neither afford to buy books and school materials, especially if the father himself is out of work.The unfortunate situation is that child labour actually contributes to adult unemployment by providing a very cheap alternative to it. This fact is illustrated in Children of the World: 30 per cent of the entire labour force in Tanzania is composed of boys and girls aged 10 to 14, and in Thailand 25 per cent, as compared to the United States where they cover only 1.6 per cent of the labour force.In agricultural areas this age old child labour system can even be beneficial as a leisurely training for the tasks of adulthood. In performing light tasks, the child feels useful and important, and this sort of work teaches him a sense of responsibility towards others and a sense of belonging. But the system which applies in the countryside becomes cruel and inhuman when it comes to the cities.82. According to the passage, a long period of physical work is harmful to children because ________ ．A. it will ruin their entertainmentB. it affects their mental developmentC. their attitude to life will be abnormalD. they will be easily annoyed83. The main reason for the existence of child labour is that ________ ．A. the parents are short-sightedB. the family needs money and helpC. children can do a better jobD. labour is a good physical exercise84. By quoting the examples about the situation in Tanzania, Thailand and America, the writer intends to tell us that ________ ．A. child labour is a cause of adult unemploymentB. child labour is related with traditional valuesC. in poor countries most children make their living earlyD. different countries use different labour systems85. From the passage we may infer that ________ ．A. children should be made useful from the time they can rememberB. child labour should be fully responsible for overall low wages for adultsC. child labour system may have a positive value in the country, but not in the cityD. the children who are forced to be breadwinners hate their parents(D)Professor Bilveer Singh grades hundreds of papers each year. In every group, he says, there are always a few that are less than original. Nowadays, the suspect source is usually the Internet. “I've caught students quoting paragraph after paragraph,” says Singh. “But they are getting smarter.” Hence the rise of A and A or “alteration and amendment”: cutting a sentence here, pasting(粘贴) a phrase there, all the while using the on-screen terms to replace complicated words with age-appropriate ones.For all its benefits, the rise of technology in the classroom has made it far easier for students to cheat—and get away with it. In the pre-wired days, plagiarism meant carefully copying paragraphs out of the books; today, kids can simply find the text, copy and paste — a much simpler and neater process. The practice is becoming popular around the globe. According to a survey by the Josephson Institute for Ethics, 74% of U.S. high-school students cheated in 2002. (“And those are just the ones admitting it.” says the Institute's Terry Harrison.)Fortunately, the same technology that makes it so easy for students to cheat is aiding teachers in catching them. The most popular anti-plagiarism service, Turnitin. com, compares a student's term paper with everything on the Internet, as well as to 's own database of papers. (Of course, as many teachers know, Google, another well-known search engine company,works pretty well, too.) has users in 51 countries; in Britain, nearly all 700 public universities have signed up for the service.Educators are trying to upgrade their inclass measures as well. Experts say teachers should make it more difficult for students to “cut and paste” by changing the assignment every year and requiring more analysis than description. And teachers shouldn't assume that kids even know what plagiarism is, as many just aren't taught how to source or reference properly. But even when they know better, kids might do the same under the heavy academic pressure and time limits they face. Critics blame parents and educators for emphasizing results over academic honesty.86. The “A and A” phenomenon mentioned in paragraph 1 summarizes ________ ．A. the progress of the digital ageB. the application of the InternetC. the rise of computer technologyD. the new features of cheating in schools87. The expression “the pre-wired days” in paragra ph 2 refers to the time before________ ．A. electricity was usedB. the computer was widely usedC. the wire was inventedD. the radio and television came into being88. Which of the following is NOT true according to the passage?A. The rise of computer technology makes it easier to cheat in the classroom.B. Teachers are trying to find new measures to check cheating in schools.C. Computer technology can be used to find out the cheating of students.D. Teachers are praised for their emphasis on students' academic results.89. The last two paragraphs are mainly concerned with ________ ．A. the importance of academic honestyB. some measures to fight against plagiarismC. some well-known search engine companiesD. experts' suggestions on anti-plagiarism第II卷I. TranslationDirections Translate the following sentences into English, using the words given in the brackets.1. 我昨天给你打了好几次电话，你都不在家。

2005年普通高等学校春季招生考试文科综合能力测试（北京卷）本试卷分第Ⅰ卷(选择题)和第Ⅱ卷(非选择题)两部分。

满分300分。

考试时间150分钟。

第Ⅰ卷(选择题共140分)一、本卷共35小题，每小题4分，共140分。

在每小题列出的四个选项中，只有一项是最符合题目要求的。

2004年12月26日8时58分(北京时间)，印度尼西亚苏门答腊岛西北近海(3.9°N，95.9°E)发生地震并引起海啸。

回答1—4题。

1.该地震发生时，地球在公转轨道上的位置接近右图中的A.①B.②C.③D.④2.这次地震的震中位于印度洋板块与A.太平洋板块的消亡边界B.亚欧板块的消亡边界C.太平洋板块的生长边界D.亚欧板块的生长边界3.海啸以800千米/小时的速度传播到马尔代夫的首都马累(4.2°N，73.5°E)时，当地区时约为A.6时B.9时C.12时D.15时4.海啸造成该地区人员重大伤亡的原因是①人口老龄化②沿海人口密度大③多河流入海口④缺乏海啸预警系统A.①②B.①③C.②④D.③④读下图，回答5—6题。

5.泉水补给区位于A.甲地B.乙地C.丙地D.丁地6.溶洞常形成于A.沉积岩中B.变质岩中C.侵入岩中D.喷出岩中7.作为城市的燃料，天然气比煤炭A.开发利用难度小B.燃烧效率低图3 剑桥科学园位置示意图C.输送、使用方便D.对大气污染严重8.导致土地生产力下降的直接原因是A.水土流失和土地沙化B.城市建设用地扩大C.沼泽地和盐碱地的改良D.滩涂养殖业的发展9.当前，确保中国粮食安全的措施是A.退耕还林、还草B.兴建开发区，进口粮食C.加快城市化进程D.发展科技，保护耕地读下图，回答10—11题。

10.剑桥科学园位于A.英国的西南、伦敦的西北B.英国的西南、伦敦的东北C.英国的东南、伦敦的东北D.英国的东南、伦敦的西北11.剑桥科学园的工业布局属于A.临空型B.劳动密集型C.临海型D.煤铁复合体型中国历代经济制度或措施，与社会稳定及经济发展息息相关。

05年春VB单选题2005年（春）笔试试卷第一部分基础知识(基础知识分为I和II两类，考生选做其中的一类，且不需要在答题卡上标注类别)I计算机基础知识1.十进制数100对应的二进制数、八进制数和十六进制数分别是_____。

A.1100100B,144Q和64HB.1100110B,142Q和62HC.1011100B,144Q和66HD.1100100B,142Q和60H2.在各种数字系统中，汉字的显示与打印均需要有相应的字形库支持。

目前汉字的字形主要有两种描述方法，即点阵字形和________字形。

A.仿真 B.轮廓 C.矩形 D.模拟3.下列有关PC机及CPU芯片的叙述正确的是______。

A.目前PC机所用CPU芯片均为Intel公司生产B.PC机只能安装MS-DOS或Windows操作系统7.下列有关Internet的叙述错误的是_______。

A.随着Modem性能的提高，电话拨号上网的速度越来越快，目前可达1Mb/s以上B.用户从不同的网站下载信息，其速度通常有所不同C.从Internet上搜索到的信息，有时不能下载到本地计算机D.网页上的图片大多为GIF和JPEG格式8.在Internet中，域名服务器的主要功能是实现_______的转换。

A.IP地址到域名(主机名字)B.域名到IP地址C.主机IP地址和路由器IP地址之间D.路由器IP地址之间9.是“江苏省高等学校计算机等级考试中心”的网址。

其中，“http”是指_______。

A.超文本传输协议B.文件传输协议C.计算机主机域名D.TCP/IP协议10.下列有关电子邮件(E-mail)的叙述错误的是_______。

A.E-mail地址具有特定的格式，即“<邮箱名>@<邮件服务器域名>”B.一个用户可以向一个或多个邮件服务提供商申请多个E-mail地址C.目前邮件发送时一般采用POP3协议，接收时采用SMTP协议D.一封电子邮件通常由三部分组成，即邮件的头部、正文和附件11.下列有关操作系统的叙述错误的是_____。

2005年上海市普通高等学校春季招生考试综合能力测试试卷本试卷分第Ⅰ卷和第Ⅱ卷两部分。

全卷共12页，满分为150分。

考试时间为120分钟。

第Ⅰ卷（共48分）考生注意：1．答第Ⅰ卷前，考生务必在试卷和答题卡上用钢笔或圆珠笔清楚填写姓名、准考证号、校验码，并用铅笔在答题卡上正确涂写准考证号和校验码。

2．第1卷（1～24小题）为单选题，由机器阅卷，答案必须全部涂在答题卡上。

考生应将代表正确答案的小方格用铅笔涂黑。

注意试题题号和答题卡编号一一对应，不能错位。

答案需要更改时，必须将原选项用橡皮擦去，重新选择。

答案不能写在试卷上，写在试卷上一律不给分。

一、2004年11月25日，上海市十二届人大常委会第十六次会议全票通过《上海市未成年人保护条例》（以下简称《条例》）。

1．《条例》备受关注，审议历时半年。

市人大常委会在三审的同时，还召开了20多次座谈会征求意见。

这说明①社会主义政治文明的进步②各级地方人大拥有制定法律的权力③社会主义民主是社会主义法制的前提④未成年人行为能力弱，应该保护A ①②④B ②③④C ①②③D ①③④2．2004年10月初，21名上海中小学学生代表应邀走人上海市人大常委会会议室，就《条例（草案）》发表意见。

孩子们提出—个立法机关未曾考虑的问题：张榜公布学生成绩排名，事关隐私，易对学生造成伤害。

最终，该意见在《条例》中得到反映。

这说明青少年①发扬主人翁精神，成为立法主体②社会主义法制观念增强③在社会参与中学做“社会人”④依法行使公民权利A ①②④B ②③④C ①②③D ①③④二、经国务院同意，中国人民银行从2004年10月29日起上调金融机构存贷款基准利率，对各档次存、贷款利率也相应调整（俗称：加息）。

3．这次宏观调控是基于以下情况①上半年居民消费价格指数上升较快②钢铁、建材等行业投资过热③商业银行利润水平过低④能源、原材料价格大幅度上涨A ①②③B ①②④C ①③④D ②③④4．此次加息有利于稳定物价，抑制物价高幅运行。

2003年（春）（试卷代号VFP01）一、项目、数据库和表操作（12分）打开软盘根目录下的项目文件TEST，在该项目中已有一数据库SJK。

1．按如下要求修改SJK中工资（GZ）表的结构：（1）为住房补贴（zfbt）字段设置标题：住房补贴；（2）设置zfbt字段的有效性(验证)规则：它的值或者为0或者为基本工资（jbgz）字段的19%；（3）设置zfbt字段的字段注释：98年以后参加工作的教师才有住房补贴；（4）增加一个备注型字段，字段名为bz；（5）创建一个普通索引ghsfgz，要求先按工号（gh）字段排序，工号相同的再实发工资（sfgz）字段排序。

2．为GZ表添加编辑说明：教师工资信息表。

3．把TEST项目中的自由表GZC的包含状态设置为“排除”。

4．修改GZC表中所有记录的实发工资（sfgz），计算实发工资的公式为：sfgz = yfgz（应发工资）– zfgj（住房公积金）– ylbx（医疗保险）– grsds（所人所得税）5．为GZ表设置删除触发器：工号为空的记录允许删除，否则不允许删除。

6．SJK中JS表已存在主索引jsgh，索引表达式为gh，GZ表已存在普通索引gzgh，索引表达式为gh，以JS表为主表，GZ表为子表按gh建立永久关系，并设置JS表和GZ表之间的参照完整性：更新级联。

二、设计查询（8分）在TEST项目中已存在查询chaxun，按如下要求修改该查询：基于成绩（CJ）表和课程（KC）表查询每门课有多少学生选修、考试的最高成绩、考试的平均成绩。

要求输出字段为：kcdh、kcm、选课人数、最高成绩、平均成绩，查询结果按 kcdh 的升序排序。

三、设计菜单（5分）TEST项目中已存在菜单menu，其中已定义了“文件”菜单栏及其中的“恢复系统菜单”项。

按如下要求设计菜单：1．创建“系统”菜单栏，并为“系统”菜单设置热键“ALT + S”；2．在“系统”菜单中添加“数据录入”、“数据维护”和“选项”菜单项；3．创建“数据录入”菜单的子菜单，其中包含“成绩”和“教师工资”菜单项；4．设置“选项”菜单项为废止。

江苏省高等学校非计算机专业学生2005 年(春)计算机基础知识和应用能力等级考试上机试卷二级Visual FoxPro(试卷代号VFP01)(本试卷完成时间70分钟)打开软盘根目录下的项目文件TEST，在该项目中已有一数据库SJK。

1．按如下要求修改SJK中工资(gz)表的结构:(1)为个人所得税（grsds）字段设置标题：个人所得税。

(2)设置个人所得税（grsds）字段的注释：基本工资1000元以上征税；(3)设置gz表的记录有效性(验证)规则：如果jbgz小于1000元，grsds的值为0，否则grsds的值为jbgz 的5%（该规则对表中已有的数据不做验证）；iif(jgbz<1000,grsds=0,grsds=jbgz*0.05)(4)设置gz表的记录有效性信息：“个人所得税按基本工资的5%收取”；(5)创建一个普通索引gzjx，要求按jbgz降序排列。

（最后要把那个框的勾打掉）2．设置test项目信息：作者为”张勇”，单位为”南京大学”。

（项目-项目信息）3．向kc表中添加一条记录，记录内容为：4．修改js表中简历（jl）字段的值，要求：所有xdh为”02”的记录的简历都改为”计算机系的教师”。

Replace jl with “计算机系教师” for xdh=”02”Update js set jl=”计算机系教师” where xdh=”02”5．设置js表的插入触发器：gh字段的值必须为5个字节的字符串（除去首尾空格），否则不允许插入。

Len(Alltrim(gh))=56． JS表中已存在主索引jsgh，索引表达式为gh;rk表已存在普通索引rkgh，索引表达式为gh。

以JS 表为主表、rk表为子表，按gh 建立永久关系，并设置JS表和rk表之间的参照完整性：删除级联。

二、设计查询（8分）在TEST项目中已存在查询chaxun，且在SJK中包含一个名为XSCJST的视图，该视图中包含学生的学号(xh)，课程代号(kcdh)、课程名(kcm)和成绩(cj)字段，另外在SJK的学生（xs）表含有学生的学号（xh）和所在班级编号（bjbh）字段。

第一部分计算机基础知识1．信息技术指的是用来扩展人的信息器官功能、协助人们进行信息处理的一类技术。

在下列基本信息技术中，用于扩展人的效应器官功能的是。

A．A.感测与识别技术；B．通信与存储技术；C．计算与处理技术；D．控制与显示技术。

2．微电子技术是以集成电路为核心的电子技术。

在下列关于集成电路（IC）的叙述中，正确的是。

A．集成电路的发展导致了晶体管的发明；B．现代计算机的CPU均是超大规模集成电路；C．小规模集成电路通常以功能部件、子系统为集成对象；D．所有的集成电路均为数字集成电路。

3．通信技术的发展促进了信息的传播。

在下列有关通信与通信技术的叙述中，错误的是。

A．通信系统必有“三要素”，即信源、信号与信宿；B．现代通信指的是使用电（光）波传递信息的技术；C．数据通信指的是计算机等数字设备之间的通信；D．调制技术主要分为三种，即调幅、调频和调相。

4．在计算机中，数值为负的整数一般不采用“原码”表示，而是采用“补码”方式表示。

若某带符号整数的8位补码表示为1000 0001, 则该整数为。

A．129；B．-1；C．-127；D．127。

5．在下列有关CPU（中央处理器）与Pentium微处理器的叙述中，错误的是。

A．CPU除包含运算器和控制器以外，一般还包含若干个寄存器；B．CPU所能执行的全部指令的集合，称为该CPU的指令系统；C．Pentium系列处理器在其发展过程中，其指令系统越来越丰富；D．Pentium处理器与Power PC处理器虽然产自不同的厂商，但其指令系统相互兼容。

6．根据存储器芯片的功能及物理特性，目前用作优盘存储器芯片的是。

A．SRAM；B．SDRAM；C．EPROM；D．Flash ROM。

7．I/O接口指的是计算机中用于连接I/O设备的各种插头/插座，以及相应的通信规程以及电气特性。

在下列相关I/O总线与I/O接口的叙述中，错误的是。

A．PC机系统总线一般分为处理器总线和主板总线；B．PCI总线属于I/O总线；C．PC机的I/O接口可分为独占式和总线式；D．USB是以并行方式工作的I/O接口。

江苏2005春二级Visual Basic语言（试卷代号 VB01）（本试卷完成时间70分钟）【考试须知】1. 改错题的界面不作要求，主要用来调试程序，若题目中有参考界面，则仅作参考；2. 考试结束后，文件必须存放在指定位置，否则适当扣分；考试盘中若无指定文件，则不予评分；3. 程序代码书写应呈锯齿形。

一、改错题（14分）【题目】下面程序功能是：找出100以内满足N+1个连续自然数之和等于其后N个连续自然数之和的序列（例如：4+5+6=7+8就是满足要求的序列）。

Option ExplicitPrivate Sub Command1_Click()Dim I As Integer,S As String,Flg As BooleanFor I=2 To 10Call Sub1(I,S,Flg)Flg=FalseIf Flg ThenText1=Text1&S&vbCrLfEnd IfNext IEnd SubPrivate Sub Sub1(K As Integer,S As String,F As Boolean) Dim I As Integer,Sum1 As Integer,Sum2 As Integer Dim N As Integer, Start As IntegerDo While Sum1<>Sum2 And N<100Start=Start+1N=StartS=N:Sum1=NFor I=1 To K-1N=N+1Sum1=Sum1+N S=S&"+"&NNext IS=S&"="&NN=N+1Sum2=NFor I=1 To K-2N=N+1Sum2=Sum2+N S=S&"+"&NNext IN=N+1If Sum1=Sum2 ThenF=TrueEnd IfLoopEnd Sub【要求】1. 新建工程，输入上述代码，改正程序中的错误；2. 改错时，不得增加或删除语句，但可适当调整语句位置；3. 将窗体文件和工程文件分别命名为F1和P1，并保存到软盘A的根目录下。

题目--1、"查找员工的编号、姓名、部门和出生日期，如果出生日期为空值，--显示日期不详,并按部门排序输出,日期格式为yy-mm-dd。

--2、"查找与喻自强在同一个单位的员工姓名、性别、部门和职称--3、"按部门进行汇总，统计每个部门的总工资--4、"查找商品名称为14寸显示器商品的销售情况，--显示该商品的编号、销售数量、单价和金额--5、"在销售明细表中按产品编号进行汇总，统计每种产品的销售数量和金额--6、"按客户编号统计每个客户1996年的订单总金额--7、"查找有销售记录的客户编号、名称和订单总额--8、"查找在1997年中有销售记录的客户编号、名称和订单总额--9、"查找一次销售最大的销售记录--10、"查找至少有3次销售的业务员名单和销售日期--11、"用存在量词查找没有订货记录的客户名称--12、"使用左外连接查找每个客户的客户编号、名称、订货日期、订单金额--订货日期不要显示时间，日期格式为yy-mm-dd--按客户编号排序，同一客户再按订单降序排序输出--13、"查找16M DRAM的销售情况，要求显示相应的销售员的姓名、--性别，销售日期、销售数量和金额，其中性别用男、女表示--14、"查找每个人的销售记录，要求显示销售员的编号、姓名、性别、--产品名称、数量、单价、金额和销售日期--15、"查找销售金额最大的客户名称和总货款--16、"查找销售总额少于1000元的销售员编号、姓名和销售额--17、"查找至少销售了3种商品的客户编号、客户名称、商品编号、商品名称、数量和金额--18、"查找至少与世界技术开发公司销售相同的客户编号、名称和商品编号、商品名称、数量和金额19、"查找表中所有姓刘的职工的工号，部门，薪水20、"查找所有定单金额高于200的所有客户编号21、"统计表中员工的薪水在400-600之间的人数22、"查询表中的同一部门的职工的平均工资，但只查询＂住址＂是＂上海市＂的员工23、"将表中住址为"上海市"的员工住址改为"北京市"24、"查找业务部或会计部的女员工的基本信息。