2010-DB(A)-exam
- 格式:pdf
- 大小:213.96 KB
- 文档页数:7
绝密★启用前2010 年普通高等学校招生全国统一考试(上海卷)英语试卷(满分150 分,考试时间100 分钟)考生注意:1.考试时间120 分钟, 试卷满分150 分。
2.本考试设试卷和答题纸两部分。
试卷分为第I 卷(第1-12 页)和第II 卷(第13 页),全卷共13 页。
所有答题必须涂(选择题)或写(非选择题)在答题纸上,做在试卷上一律不得分。
答题前,务必在答题纸上填写准考证号和姓名,并将核对后的条形码贴在指定位置上,在答题纸反而清楚地填写姓名。
第一卷(共105 分)I.Listening ComprehensionSection A1.A.A shop assistant..B.A dentist C.An cloarician. D.A bank clerk. 2.A.The exam score.. B.The world news. C.A soccer match.. D.A basketball team. 3.A.At a post office. B.At a flower shop.C.At a department store. D.At a bus station.4.A.5 hours. B.7 hours. C.9 hours. D.10 hours. 5.A.Tim’s not seriously injured.B .Tim will get to the hospital quickly.C.The woman’s heard all about Tim’s i llness.D.The woman doesn’t know how Tim is now.6.A.She isn’t in the mood to travel. B.France is too far for family holiday.C.Family holiday no longer interests her. D.She has had too many holidays this year. 7.A.The cost was reasonable. B.The cost was unbelievably high.C.She likes the hotel. D.She will stay overnight. 8.A.Disappointment B.Disapproval. C.Sympathy. D.Passion.9.A.The man is too forgetful. B.The man shouldn’t get annoyed.C.The man has too many keys. D.The man should attend more lessons. 10.A.He wants to live in apartments. B.He thinks his signature is unnecessary.C.He has already signed a contract. D.He does n’t always say what he means. Section B11.A.White masters. B.African slaves. C.Native dancers. D.Sport trainers. 12.A.Having kung fu experience. B.Being able to sing and play music.C.Wearing a green belt. D.Being strong and able to balance well.13.A.He uses his hands to keep the balance.B.He dos es contact with his opponent.C.He is kicked by his opponent. D.He is pu shed out of the circle.Questions 14 through 16 are based on the following passage14.A.Great guests and talk to hotel staff.B.Have breakfast and examine room service.C.Prepare for the meeting and write new reports.D.Review the previous night’s reports and check emails.15.A.Saying hello to every guest. B.Considering different bath requirements.C.Dining with a different staff member. D.Holding various operational meetings. 16.A.A day’s life of a hotel manager. B.The daily routine at a hotel.C.Hotel service and improvement. D.Meetings attended by a hotel massager. Section CDoctor’s NotesDr.B.HallPatient’s name:Mr. 17Symptoms: Awful 18 and a terrible coughTemperature: 19Doctor’s suggestion: One spoonful of cough 20 every 4 hours for the next five days.Blanks 21 through 24 are based on the following conversation.Complete the form. Write NO MORE THAN THREE WORDS for each answer.What does the man ask the woman to do? To 21 .What does Iaml Wyndham write? 22 .Because they hope to start 23 . Why do the main characters in the story join agroup of people?Between whom w ill there be some conflict in theBetween people and 24 . story?П. Grammar and vocabulary.Section ADirections: Beneath each of the following sentences there are four choices marked A, B,C and Choose the one answer that best completes the sentence.25.Sean has formed the habit of jogging the tree-lined avenue for two hours every day.A. betweenB. alongC. belowD. with26.It took us quite a long time to get to the amusement park. It was journey. A. three hour B. a three-hoursC. a three-hourD. three hours27.If our parents do everything for us children, we won't learn to dependon A. themselves B. themC. usD. ourselves28.Every few years, the coal workers. their lungs X-rayed to ensure their health.A. are havingB. haveC. have hadD. had had29.- Sorry, Professor Smith. I didn't finish the assignment yesterday.- Oh, you have done it as yesterday was the deadline.A. mustB. mustn'tC. shouldD. shouldn't30.In ancient times, people rarely travelled long distances and most farmers only travelledthe local market.A. longer thanB. more thanC. as much asD. as far as31.The church tower which will be open to tourists soon. The work is almost finished.A. has restoredB. has been restoredC. is restoringD. is being restored32.I had great difficulty the suitable food on the menu in that restaurant.A. findB. foundC. to findD. finding33.Lucy has a great sense of humour and always keeps her colleagues with her stories. A. amused B. amusingC. to amuseD. to be amused34.you may have, you should gather your courage to face the challenge. A. However a serious problem B. What a serious problem C. However serious a problem D. What serious a problem35.the city centre, we saw a stone statue of about 10 metres in height.A. ApproachingB. ApproachedC. To approachD. To be approached36.One reason for her preference for city life is she can have easy access to places like shops and restaurants.A. thatB. howC. whatD. why37.When changing lanes, a driver should use his turning signal to let other driversknow A. he is entering which lane B. which lane he is enteringC. is he entering which laneD. which lane is he entering38.Wind power is an ancient source of energy we may return in the near future. A. on which B. by whichC. to whichD. from which39. our manage objects to Tom's joining the club, we shall accept him as a member.A. UntilB. Unless C If D. After40.Thai is the only way we can imagine the overuse of water in students' bathrooms.A. reducingB. to reduceC. reducedD. reduceSection BDirections: Complete the following passage by using the words in the box. Each word can only be used once. Note that there is one word more than you need.A. additionalB. producingC. regularD. predictedE. identifiedE atmosphere G. matched H. reducing I. carried J. increaseForests in the northern half of the globe could be growing faster now than they were 200 years ago as a result of climate change, according to a study of trees in eastern America. The trees appear to have faster growth rates due to longer growing seasons and higher concentrations (浓度) of carbon dioxide in the 41 .Geoffrey Parker, a scientist at the Smithsonian Environmental Research Centre in Edgewater. Maryland, said that the increase ha the rate of growth was unexpected and might be 42 to the higher temperatures and longer growing seasons documented in the region. The growth may also be influenced by the significant 43 in atmospheric CO2,he said."We made a list of reasons these forests could be growing faster and then excluded half of them," Dr Parker said. Their study suggests that northern forests may become increasingly important in 44the influence of man-made CO2 on the climate.Dr Parker and his colleagues have 45 out a detailed record of the trees on a(n) 46 basis since 1987. They calculated that due to the global warming the forest is producing 47 tons of wood each year.The scientists _ 48 _ the land with trees at different stages of growth and found that both young and old trees were showing increased growth rate. More than 90 per cent of the tree groups had grown by between two and four times faster than the scientists had 49 from estimates of the long-term rates of growth.Ⅲ. Reading ComprehensionSection ADirections:For each blank in the following passage there are four words or phrases marked A,B, C and D. Fill in each blank with the word or phrase that best fits the context.The first attempt of even the most talented artists, musicians, and writers is seldom a masterpiece, If you consider your drafts as dress rehearsals (彩排), or tryouts, revising will seem a natural part of the writing 50 .What is the purpose of the dress rehearsals and the out-of-town previews that many Broadway shows go through? The answer is adding, deleting, replacing, reordering, 51revising. Andrew Lloyd Webber's musical Phantom of the Opera underwent such a process.When Lloyd Webber began writing in 1984, he had in mind a funny, exciting production. However, wh en Phantom opened in London in 1986, the audience saw a moving psychological love story set to music. The musical had. 52 several revisions due, in part, to problems with costuming and makeup (戏服和化妆). For instance, Lloyd Webber 53 some of the music because the Phantom's makeup prevented the actor from singing certain sounds.When you revise, you change aspects of your work in 54 to your evolving purpose, or to include 55 ideas or newly discovered information.Revision is not just an afterthought that gets only as much time as you have at the end of an assignment. 56 , it is a major stage of the writing proc ess, and writers revise every step of the way. Even your decision to 57. topics while prewriting is a type of revising. However. don't make the mistake of skipping the revision stage that follows58 . Always make time to become your own 59 and view your dress rehearsal, so to speak. Reviewing your work in this way can give you 60 new ideas.Revising involves 61 the effectiveness and appropriateness of all aspects of your writing, making your purpose more clearly, and refocusing or developing the facts and ideas you present. When you revise, ask yourself the following questions, keeping in mind the audience for whom you are writing: Is my main idea or purpose 62 throughout my draft? Do I ever lose sight of my purpose? Have I given my readers all of the 63 that is, facts, opinions, inferences -- that they need in order to understand my main idea? Finally, have I included too many 64 details that may confuse readers?50.A. technique B. style C. process D. career51.A. in particular B. as a result C. for example D. in other words52.A. undergone B. skipped C. rejected D. replaced53.A. rewrote B. released C. recorded D. reserved54.A. addition B. response C. opposition D. contrast55.A. fixed B. ambitious C. familiar D. fresh56.A. However B. Moreover C. Instead D. Therefore57.A. discuss B. switch C. exhaust D. cover58.A. drafting B. rearranging C. performing D. tra ining59.A. director B. master C. audience D. visitor60.A. personal B. valuable C. basic D. delicate61.A. mixing B. weakening C. maintaining D. assessing62.A. amazing B. bright C. unique D. clear63.A. angles B. evidence C. information D. hints64.A. unnecessary B. uninteresting C. concrete D. finalSection BDirections: Read the following three passages. Each passage is followed by several questions or unfinished statements. For e ach 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)The elephant was lying heavily on its side, fast asleep. A few dogs started barking at it.The elephant woke up in a terrible anger: it chased the dogs into the village whe re they ran forsafety. That didn't stop the elephant. It destroyed a dozen houses and injured several people. The villagers were scared and angry. Then someone suggested calling Parbati, the elephant princess.Parbati Barua's father was a hunter of tigers and an elephant tamer. He taught Parbati to ride an elephant before she could even walk. He also taught her the dangerous art of the elephant round-up -- how to catch wild elephants.Parbati hasn't always lived in the jungle. After a happy childhood hunting with her father, she was sent to boarding school in the city. But Parbati never got used to being there and many years later she went back to her old fife. "Life in the city is too dull. Catching elephants is an adventure and the excitement lasts for days after the chase," she says.But Parbati doesn't catch elephants just for fun. "My work," she says, "is to rescue man from the elephants, and to keep the elephants safe from man." And this is exactly what Parbati has been doing for many years. Increasingly, the Indian elephant is angry: for many years, illegal hunters have attacked it and its home in the jungle has been reduced to small pieces of land. It is now fighting back. Whenever wild elephants enter a tea garden or a village, Parbati is called toguide the animals back to the jungle before they can kill.The work of an elephant tamer also involves love and devotion. A good elephant tamer will spend hours a day singing love songs to a newly captured elephant. "Eventually they grow to love their tamers and never forget them. They are also more loyal than humans," she said, as she climbed up one of her elephants and sat on the giant, happy animal. An elephant princess indeed!65.For Parbati, catching elephants is mainly to .A.get long lasting excitementB. keep both man and elephants safeC. send them back to the jungleD. make the angry elephants tame66.Before Parbati studied in a boarding school, .A.she spent her time hunting with her fatherB.she learned how to sing love songsC.she had already been called an elephant princessD.she was taught how to hunt tigers67.Indian elephants are getting increasingly angry and they revenge because .A.they are caught and sent for heavy workB.illegal hunters capture them and kill themC.they are attacked and their land gets limitedD.dogs often bark at them and chase them68.The passage starts with an elephant story in order to explain that in India .A.people easily fall victim to elephants' attacksB.the man-elephant relationship is getting worseC.elephant tamers are in short supplyD.dogs are as powerful as elephants(B)The following card includes a brief summary and a short assessment of a research paper.It can provide a guide for further reading on the topic.Trevor, C. O., Lansford, B. and Black, J. W., 2004, "Employee turnover (人事变更) and job performance: monitoring the influences of salary growth and promotion", Journal of Armchair Psychology, vol. 113, no.1, pp. 56-64.In this article Trevor et al. review the influences of pay and job opportunities in respect of job performance, turnover rates and employees' job attitude. The authors use data gained through organizational surveys of blue-chip companies in Vancouver, Canada to try to identify the main cause of employee turnover and whether it is linked to salary growth. Their research focuses on assessing a range of pay structures such as pay for performance and organizational reward plans. The article is useful as Trevor et al. suggest that there are numerous reasons for employee turnover and a variety of differences in employees' job attitude and performance. The main limitation of the article is that the survey sample was restricted to mid-level management, thus the authors indicate that further, more extensive research needs to be undertaken to develop a more in-depth understanding of employee turnover and job performance. As this article was published in a professional journal, the findings can be considered reliable. It will be useful additional information for the research on pay structures.69.The research paper published is primarily concerned withA.the way of preventing employee turnoverB.methods of improving employee performanceC.factors affecting employee turnover and performanceD.pay structures based on employee performance70.As is mentioned in the card, the limitation of the research paper mainly lies in that .A.the data analysis is hardly reliableB.the research sample is not wide enoughC.the findings are of no practical valueD.the research method is out-of-date71.Who might be most interested in this piece of information?A.Job hunters.B.Employees in blue-chip companies.C.Mid-level managers.D.Researchers on employee turnover.(C)The 2012 London Olympics had enough problems to worry about. But one more has justbeen added - a communications blackout caused by solar storms.After a period of calm within the Sun, scientists have detected the signs of a flesh cycle of sunspots that could peak in 2012, just in time for the arrival of the Olympic torch in London.Now scientists believe that this peak could result in vast solar explosions that could throw billions of tons of charged matter towards the Earth, causing strong solar storms that could jam the telecommunications satellites and interact links sending five Olympic broadcast from London."The Sun 's activity has a strong influence on the Earth . The Olympics could be in the middle of the next solar maximum which could affect the functions of communications satellites," said Professor Richard Harrison, head of space physics at the Rutherford Appleton Laboratory in Oxfordshire.At the peak of the cycle, violent outbursts called coronal mass ejections (日冕物质抛射) occur in the Sun's atmosphere, throwing out great quantities of electrically-charged matter. " A coronal mass ejection can carry a billion tons of solar material into space at over a million kilometres per hour. Such events can expose astronauts to a deadly amount, can disable satellites, cause power failures on Earth and disturb communications," Professor Harrison added. The risk is greatest during a solar maximum when there is the greatest number of sunspots.Next week in America, NASA is scheduled to launch a satellite for monitoring solar activity called the Solar Dynamics Observatory (SDO), which will take images of the Sun that are 10 times clearer than the most advanced televisions available.The Rutherford Appleton Laboratory helped to make the high-tech cameras that will capture images of the solar flares (太阳耀斑) and explosions as they occur.Professor Richard Hold away, the lab's director, said that the SDO should be able to provide early warning of a so lar flare or explosion big enough to affect satellite communications on Earth "If we have advance warning, we'll be able to reduce the damage. What you don't want is things switching off for a week with no idea of what's caused the problem," he said.72.The phrase "communications blackout" in paragraph 1 most probably refers toduring the 2012 Olympics.A.the extinguishing of the Olympic torchB.the collapse of broadcasting systemsC.the transportation breakdown in LondonD.the destruction of weather satellites73.What can be inferred about the solar activity described in the passage?A.The most fatal matter from the corona falls onto Earth.B.The solar storm peak occurs in the middle of each cycle.C.It takes several seconds for the charged matter to reach Earth.D.The number of sunspots declines after coronal mass ejections.74.According to the passage, NASA will launch a satellite to _ _A.take images of the solar systemB. provide early warning of thunderstormsC. keep track of solar activitiesD. improve the communications on Earth75.Which of the following might be the best title of the passage?A.Solar Storms: An Invisible KillerB.Solar Storms: Earth Environment in DangerC.Solar Storms: Threatening the Human RaceD.Solar Storms: Human Activities to Be TroubledSection CDirections: Read the following text and choose the most suitable heading from A-F for each paragraph. There is one extra heading which you do not need.A. Drug overuse and its consequenceB. The problem of drug overuse in AmericaC. Benefits of medicine and its wise useD Female drug overuse with reference to that of malesE Misuse of medicine among the young generationF. Improper use of medicine among senior citizens76 .Nowadays. millions of people misuse and even overuse pain medications and other drugs. Research by the American National Institute on Drug Abuse (NIDA, 1999) shows that around 2% of the population over age 12 were using drugs non-medically.77.NIDA views medications as a powerful force for good in the contemporary world. They reduce and remove pain for millions of people suffering from illness and disease. They make it possible for doctors to perform complicated surgery to save lives. Many people afflicted by serious medical conditions are able to control their symptoms and become active , contributing citizens . NIDA points out that most individuals who take these drags use them in a responsible.78.Nevertheless . overuse of drugs such as opioids, central nervous system (CNS) depressants and stimulants does lead to harmful reliance in some people and is therefore becoming a serious public health concern. Although this abuse affects many people worldwide , particular trends of concern to the medical profession in the US appear among older adults, teenagers arid women. 79.Though it may be a surprise to many, the misuse of medications may be the most common form of drug abuse among the elderly. Dr Kenneth Schrader of Duke University, North Carolina states that although the elderly represent about 13% of the US population, those aged 65 and over account for the consumption of one third of all drugs. People in this age group use medications roughly three times more than the general population and have poorer compliance with instruction for use. In another study of elderly patients admitted to treatment programs , 70% were women who had overused medicines.80.Unfortunately, this trend among women does not only affect those aged overIn general, among women and men who are using either an anti-anxiety drug or a sedative, women are twice as likely to become addicted. In addition, statistics compiled for 12-17 year olds show that teenage girls are more likely than teenage boys to begin overusing psychotherapeutic medication such as painkillers, tranquillisers, stimulants and sedatives.Section DDirections: Read the passage carefully. Then answer the questionsor complete the statements in the fewest possible words.Phys ed (physical education) is making a comeback as a part of the school core curriculum(核心课程),but with a difference. While group sports are still part of the curriculum,the new way is to teach skills that are useful beyond gym class. Instead of learning how to climb a rope, children are taught to lift weights, balance their diets and build physical endurance. In this way,kids are given the tools and skills and experiences so they can lead a physically active life the rest of their life.Considering that 15 percent of American children 6 to 18 are overweight, supporters say more money and thought must be put into phys ed curriculum. In many cases, that may mean not just replacing the old gym-class model with fitness programs but also starting up phys ed programs because school boards often "put P.E. on the chopping block, cutting it entirely or decreasing its teachers or the days it is offered," says Alicia Moag-Stahlberg, the executive director of Action for Health Kids. The difference in phys ed programs is partly due to the lack of a national standard. "Physical education needs to be part of the core curriculum," she added.The wisdom of the new approach has some scientific support. Researchers at the University of Wisconsin have demonstrated how effective the fit-for-life model of gym class can be. They observed how 50 overweight children lost more weight when they cycled and skied cross-country than when they played sports. The researchers also found that teaching sports like football resulted in less overall movement, partly because reluctant students were able to sit on the bench.Another problem with simply teaching group sports in gym class is that only a tiny percentage of students continue playing them after graduating from high school. The new method teaches sells that translate to adulthood.(Note: Answer the questions or complete the statements in NO MORE THAN TEN WORDS.) 81.In the new P.E. program, children learn to lift weights, balance their diets and build physical endurance rather than82.As for P.E., some school boards either83.What are the two problems with simply teaching group sports?84.What is the long-term benefit of the new P.E program?第Ⅱ卷(共45 分)I. TranslationDirections: Translate the following sentences into English, using the words given in the brackets.1、这本杂志花了我20 多元。
2010 年9 月网考真题3第一部分:交际用语(共5小题;每小题3分,满分15分)1.__Welcome to the party ._________ Thank youA. Excuse meB. I totally agree with youC. How happy you are today.D. which do you prefer2.---How do you do?---_____________________________A. Fine ,thank youB. How do you do?C. Not too badD. Very well3. Hey, Tom,What’s up?A. Yes, definitely!B. oh, not muchC. What’s happening in your life?D. You are lucky4.---I wonder if I could use your computer tonight?_ _____ I’m not using it right now..A. Sure, go aheadB. I don’t knowC. It doesn’t matterD. Who cares?5. –Could you please turn down the radio? I am preparing fortomorrow’s exam._ ______________________________.A. It’s none of your businessB. What are doing?C. Sure, sorry to disturb youD. No, I don’t think so.Key: 1-5 CBBACII. 阅读理解(2篇共10小题;每小题3分,满分30分)Passage 1The French Revolution broke out in 1789. At the time France was in a crisis. The government was badly run and people’s lives were miserable. King Louis XIV tried to control the national parliament and raise more taxes. But his effort failed. He ordered his troops to Versailles. The people thought that Louis intended to put down the Revolution by force. On July 14,1789, they stormed and took the Bastille, where political prisoners were kept. Ever since that day, July 14 has been the French National Day. Louis tried to flee the country in 1792 to get support from Austria and Prussia. However, he was caught and put in prison. In September 1792, the monarchy was abolished. In the same year, Louis was executed. A few months later his wife, Marie also had her head cut off. The Revolution of France had frightened the other kings of Europe. Armies from Austria and Prussia began to march against France. The French raised republican armies to defend the nation. The Revolution went through a period of terror. Thousands of people lost their lives. In the end, power passed to Napoleon Bonaparte. (190 words)1. What’s this passage about?A. France.B. King Louis.C. The French Revolution.D. Europe.2. Which did not happen in 1789?A. The French Revolution broke out.B. The national economy was developing rapidly.C. The government wasn’t well run.D. King Louis XIV was in power.3. Where were the political prisoners kept?A. In Versailles.B. In AustriaC. In Prussia.D. In Bastille.4. What does the underlined word “abolished ” mean?A. Put off.B. Established.C. United.D. Ended.5. What was NOT the effect of the Revolution?A. July 14 has become the French National Day.B. It brought some impact on the other European kings.C. Louis’s wife, Marie was killed.D. The king tried to control the national parliament. Passage2High in the Swiss Alps many years ago, there lived a lonely shepherd boy who longed for a friend to share his evenings. One night he saw three old men, each holding a glass.The first old man said:“Drink this liquid and you shall be victorious in battle.”The second old man said:“Drink this liquid and you shall have countless riches.”The last old man said:“I offer you the happiness of music-----the horn(号角).”The boy chose the third glass, The next day, he came upon a great horn, ten feet in length, When he put his lips to it, a beautiful melody(旋律)floated across the valley. He had found a friend.So goes the legend(传说)of the horn. First known in the ninth century, the horn was used by herdsmen(牧人)to call cattle, for its deep tones echoed across the mountainsides. Even today, on a quiet summer evening, its music can be heard floating among the peaks.1.After the shepherd boy found the horn, he discovered it was ________.A. stolen from someone elseB. very easy to carry with himC. impossible to playD. like a new-found friend2.Today the horn is heard in the Swiss Alps ________.A. when it snowsB. in summerC. when it rainsD. only in winter3.Which of the following would be the best title for the passage?A. The Hobbies of Shepherd BoysB. The Legend of the HornC. The History of the Swiss AlpsD. The Dreams of Shepherd Boys4.What detail about the shepherd boy does the passage tell us?A. His lonely job.B. His age.C. His name.D. His singing ability.5.Why did the boy choose to drink the glass offered by the last old man?A. The boy liked the old man.B. The boy didn't like the other old man.C. The boy loved music.D. The boy was thirsty.Key: CBDDD DBBACIII.词汇与结构(共5小题;每小题3分,满分15分)1. It’s __ for people to feel excited when they start sth. new.A. normalB. ordinaryC. averageD. regular2. __When shall we meet again?__ it any day you like. It’s all the same to meA. DoB. GetC.MeetD. Make3. There __ a book and some magazines on the desk. .A. isB. areC. haveD. has4. I would rather ___ two weeks earlier.A. You should come hereB. you come hereC. You must come hereD. you came here5._Nancy was badly injured in the accident yesterday and she wassent to hospital .-- I _______, I _______see her .A. didn’t know ,will go toB. don’t know, will go toC. didn’t know. Am going toD. haven’t known, am going to Key: A DADAIV. 完形填空(共10小题;每小题1分,满分10分)Nowadays most people decide quite early what kind of work they would do. When I was at school, we had to choose 1 when we were fifteen. I chose scientific subjects. " 2 , scientists will earn a lot of money," my parents said. For three years I tried to learn physics and chemistry, but in the 3 I decided that I would never be a scientist. It was a long time 4 I told my parents that I wasn't happy at school. So my father said, "Well, the best thing to do now is to look for a job."I 5 about it with my friends Frank and Lesley. 6 of them could suggest anything, but they promised that they would ask their friends. A few days later 7 I was still in bed, someone phoned, "Is that Miss Jenkins?" a man's voice asked. "I know your hobby is photography and I've got a job that might interest you in my clothes factory. My name is Mr. Thomson." I decided to see him. I was so excited that I almost forgot 8 goodbye to my mother.I arrived a bit early and when Mr. Thomson came he asked me if I 9 waiting a long time. I replied,"No, not long." After talking to me for about 20 minutes he offered me a job - not as a photographer 10 a model!(1).A. what should study B. what he studied C. what to study D. what studied(2).A. For the future B. In the future C. For future D. In future(3).A. close B. last C. end D. final(4).A. before B. as C. when D. while(5).A. told B. asked C. talked D. said(6).A. Both B. Neither C. Nor D. Not all(7).A. since B. whereas C. while D. before(8).A. saying B. to say C. speaking D. to speak(9). A. had been B. would be C. was D. might be(10).A. being B. as C. to be D. butKey: CBCAC BCBADV. 英翻汉(共3小题;每小题5分,满分15分)1. There’s a large amount of energy wasted due to friction2. I feel lonely without you .3. Would you like some mineral water?4、I’m not an English major student.。
2010年3月国家二级(ACCESS)笔试真题试卷(题后含答案及解析) 题型有:1. 选择题 2. 填空题选择题(每小题2分,共70分)下列各题A、B、C、D四个选项中,只有一个选项是正确的,请将正确选项涂写在答题卡相应位置上。
1.下列叙述中,正确的是A.对长度为n的有序链表进行查找,最坏情况下需要的比较次数为nB.对长度为n的有序链表进行对分查找,最坏情况下需要的比较次数为(n /2)C.对长度为n的有序链表进行对分查找,最坏情况下需要的比较次数为(log2n)D.对长度为n的有序链表进行对分查找,最坏情况下需要的比较次数为(nlog2n)正确答案:A解析:对长度为n的有序链表进行查找,最坏情况是从最小值开始查找最大值(或从最大值开始查找最小值),这个过程需要比较的次数为n,故选项A正确。
对分查找只能针对随机存取的有序表进行,而有序链表只能进行顺序存取,不能进行随机存取,在有序链表上不能进行对分查找,故B、C、D选项都错误。
2.算法的时间复杂度是指A.算法的执行时间B.算法所处理的数据量C.算法程序中的语句或指令条数D.算法在执行过程中所需要的基本运算次数正确答案:D解析:算法的时间复杂度是指算法需要消耗的时间资源,是独立于机器的,选项D正确;相同的算法在不同的机器上运行时间可能不同,选项A错误;算法所处理的数据量与算法无关,选项B错误;程序的长短与程序执行时需要消耗的时间资源没有必然的关系,比如一个条件语句可以很长,但只需判断一次,而一个循环语句可能只有几行,但可以执行很多次,故选项C错误。
3.软件按功能可以分为:应用软件、系统软件和支撑软件(或工具软件)。
下面属于系统软件的是A.编辑软件B.操作系统C.教务管理系统D.浏览器解析:编辑软件、教务管理软件属于应用软件,操作系统属于系统软件,浏览器属于支撑软件,故本题答案选B。
4.软件(程序)调试的任务是A.诊断和改正程序中的错误B.尽可能多地发现程序中的错误C.发现并改正程序中的所有错误D.确定程序中错误的性质正确答案:A解析:软件调试的任务是诊断和改正程序中的错误,本题正确答案为A。
2010年3月计算机等级考试二级真题-Access一、选择题(每小题2分,共70分)下列各题A)、B)、C)、D)四个选项中,只有一个选项是正确的。
请将正确选项填涂在答题卡相应位置上,答在试卷上不得分。
(1)下列叙述中正确的是A)对长度为n的有序链表进行查找,最坏情况下需要的比较次数为nB)对长度为n的有序链表进行对分查找,最坏情况下需要的比较次数为(n/2)C)对长度为n的有序链表进行对分查找,最坏情况下需要的比较次数为(log2n)D)对长度为n的有序链表进行对分查找,最坏情况下需要的比较次数为(n log2n)顺序查找:最坏比较次数N二分法查找(对分查找):LOG2N顺序查找:顺序存储结构的表,链式存储的表(只能用顺序查找)二分法查找:只适用于顺序存储的有序表(2)算法的时间复杂度是指A)算法的执行时间B)算法所处理的数据量C)算法程序中的语句或指令条数D)算法在执行过程中所需要的基本运算次数1算法:解决方案的准确而完整的描述;2评价算法的效率:时间复杂度&空间复杂度3时间复杂度:运行的次数(不是指令的条数),空间复杂度:运行算法所需的内存空间4时间复杂度不会直接影响空间复杂度,反之也成立。
(3)软件按功能可以分为:应用软件、系统软件和支撑软件(或工具软件)。
下面属于系统软件的是A)编辑软件B)操作系统C)教务管理系统D)浏览器系统软件:操作系统、数据库管理系统、语言处理程序(4)软件(程序)调试的任务是A)诊断和改正程序中的错误B)尽可能多地发现程序中的错误C)发现并改正程序中的所有错误D)确定程序中错误的性质软件测试:发现错误软件调试:诊断和改正错误(5)数据流程图(DFD图)是A)软件概要设计的工具B)软件详细设计的工具C)结构化方法的需求分析工具D)面向对象方法的需求分析工具软件生命周期分为三个阶段:定义开发运行维护(6)软件生命周期可分为定义阶段,开发阶段和维护阶段。
详细设计属于A)定义阶段B)开发阶段C)维护阶段D)上述三个阶段(7)数据库管理系统中负责数据模式定义的语言是A)数据定义语言B)数据管理语言C)数据操纵语言D)数据控制语言(8)在学生管理的关系数据库中,存取一个学生信息的数据单位是A)文件B)数据库C)字段D)记录数据库(mdb文件)》数据表》记录》分量(9)数据库设计中,用E-R图来描述信息结构但不涉及信息在计算机中的表示,它属于数据库设计的A)需求分析阶段B)逻辑设计阶段C)概念设计阶段D)物理设计阶段需求分析阶段》概念设计阶段》逻辑设计阶段》物理设计阶段(E-R)(关系模式)(10)有两个关系R和T如下:则由关系R得到关系T的操作是A)选择B)投影C)交D)并关系运算:分为传统和专门的关系运算传统运算:并交差前提:运算的对象具有相同结构两个运算对象,一个结果(11)下列关于关系数据库中数据表的描述,正确的是A)数据表相互之间存在联系,但用独立的文件名保存(一个文件对应一个数据库,包含多个表)B)数据表相互之间存在联系,是用表名表示相互间的联系(共同字段)C)数据表相互之间不存在联系,完全独立D)数据表既相对独立,又相互联系(12)下列对数据输入无法起到约束作用的是A)输入掩码B)有效性规则C)字段名称D)数据类型(13)Access中,设置为主键的字段A)不能设置索引B)可设置为“有(有重复)”索引C)系统自动设置索引D)可设置为“无”索引(14)输入掩码字符“&”的含义是A)必须输入字母或数字B)可以选择输入字母或数字C)必须输入一个任意的字符或一个空格p41D)可以选择输入任意的字符或一个空格(15)在Access中,如果不想显示数据表中的某些字段,可以使用的命令是A)隐藏B)删除C)冻结D)筛选(16)通配符“#”的含义是A)通配任意个数的字符B)通配任何单个字符C)通配任意个数的数字字符D)通配任何单个数字字符*?[]: [abc] like “10[123]”-:[1-9] [a-k] like “10[1-3]”!:[!abc] like “[!王黄]*”#(17)若要求在文本框中输入文本时达到密码“*”的显示效果,则应该设置的属性是A)默认值B)有效性文本C)输入掩码D)密码(18)假设“公司”表中有编号、名称、法人等字段,查找公司名称中有“网络”二字的公司信息,正确的命令是A)SELECT * FROM公司FOR名称 = " *网络* "B)SELECT * FROM公司FOR名称LIKE "*网络*"C)SELECT * FROM公司WHERE名称="*网络*"D)SELECT * FROM公司WHERE名称LIKE"*网络*"查询条件含有通配符的必须使用like关键字(19)利用对话框提示用户输入查询条件,这样的查询属于A)选择查询B)参数查询C)操作查询D)SQL查询(20)在SQL查询中“GROUP BY”的含义是A)选择行条件B)对查询进行排序(order by)C)选择列字段D)对查询进行分组(21)在调试VBA程序时,能自动被检查出来的错误是A)语法错误B)逻辑错误C)运行错误D)语法错误和逻辑错误(22)为窗体或报表的控件设置属性值的正确宏操作命令是A)SetB)SetDataC)SetValueD)SetWarnings操作作用操作作用Beep 通过计算机的扬声器发出嘟嘟声,以提醒用户注意MsgBox显示包含警告信息或其它信息的消息框OpenForm OpenReport OpenTableOpenQuery 打开一个窗体;打开一个报表;打开一个表;打开一个查询MaximizeMinimizeRestore活动窗口最大化;活动窗口最小化;还原窗口GoToControl 将焦点移到打开的数据表、表数据表或控件窗体的指定字段控件上SetValue对 Access窗体、窗体数据表或报表上的字段、控件或属性的值进行设置RunSQL 执行指定的SQL语句SetWarnings 指定是否显示系统消息(23)在已建窗体中有一命令按钮(名为Commandl),该按钮的单击事件对应的VBA代码为:Private Sub Commandl_Click()subT.Form.RecordSource = "select * from雇员"End Sub单击该按钮实现的功能是A)使用select命令查找“雇员”表中的所有记录B)使用select命令查找并显示“雇员”表中的所有记录C)将subT窗体的数据来源设置为一个字符串D)将subT窗体的数据来源设置为“雇员”表(24)在报表设计过程中,不适合添加的控件是A)标签控件B)图形控件C)文本框控件D)选项组控件(25)下列关于对象“更新前”事件的叙述中,正确的是A)在控件或记录的数据变化后发生的事件(更新后)B)在控件或记录的数据变化前发生的事件C)当窗体或控件接收到焦点时发生的事件(得到焦点)D)当窗体或控件失去了焦点时发生的事件(失去焦点)(26)下列属于通知或警告用户的命令是A)PrintOutB)OutputToC)MsgBoxD)RunWarnings(27)能够实现从指定记录集里检索特定字段值的函数是A)NzB)FindC)LookupD)DLookup(28)如果X是一个正的实数,保留两位小数、将千分位四舍五入的表达式是A)0.01*Int(x+0.05)B)0.01*Int(100*(X+0.005))C)0.01*Int(x+0.005)D)0.01*Int(100*(X+0.05))(29)在模块的声明部分使用“Option Base 1”语句,然后定义二维数组A(2 to 5,5),则该数组的元素个数为A)20B)24C)25D)36Dim f(10) ‘默认 f(0)- f(10)Dim f(10) as integerDim f(2 to 10)Option Base 1 ‘数组的下标下限改为1(30)由“For i=1 To 9 Step -3”决定的循环结构,其循环体将被执行A)0次B)1次C)4次D)5次(31)在窗体上有一个命令按钮Commandl和一个文本框Textl,编写事件代码如下:Private Sub Command1_Click()Dim i,j,xFor i = 1 To 20 step 2x = 0For j = i To 20 step 3x = x + 1Next jNext iTextl.Value=Str(x)End Sub打开窗体运行后,单击命令按钮,文本框中显示的结果是A)1B)7C)17D)400(32)在窗体上有一个命令按钮Commandl,编写事件代码如下:Private Sub Commandl_Click()Dim y As Integery = 0y = InputBox("y=")If (y Mod 10) + Int(y / 10) = 10 Then Debug.Print y;Loop Until y = 0End Sub打开窗体运行后,单击命令按钮,依次输入10、37、50、55、64、20、28、19、-19、0,立即窗口上输出的结果是A)37 55 64 28 19 -19B)10 50 20C)10 50 20 0D)37 55 64 28 19负数做mod运算得到结果是负数-10 mod 3= -1-10 mod -3= -110 mod -3 =1(33)在窗体上有一个命令按钮Commandl,编写事件代码如下:Private Sub Command1_Click()Dim x As Integer, y As Integerx = 12: y = 32Call Proc(x, y)Debug.Print x; yEnd SubPublic Sub Proc(n As Integer, ByVal m As Integer)n = n Mod 10m = m Mod 10End Sub打开窗体运行后,单击命令按钮,立即窗口上输出的结果是A)2 32B)12 3C)2 2D)12 3234)在窗体上有一个命令按钮Commandl,编写事件代码如下:Private Sub Commandl_Click()Dim d1 As DateDim d2 As Datedl = #12/25/2009#d2 = #1/5/2010#MsgBox DateDiff(” ww”, d1, d2)End Sub打开窗体运行后,单击命令按钮,消息框中输出的结果是A)1B)2D)11P217(35)下列程序段的功能是实现“学生”表中“年龄”字段值加1Dim Str As StringStr=" "Docmd.RunSQL Str空白处应填入的程序代码是A)年龄=年龄+1B)Update学生 Set 年龄=年龄+1C)Set 年龄=年龄+1D)Edit 学生年龄=年龄+l二、填空题(每空2分,共30分)请将每一个空的正确答案写在答题卡【l】~【15】序号的横线上,答在试卷上不得分。
安徽省2010年高三教学质量检测试卷(三)英语试题第I卷(选择题,共115分)第一部分:听力(共两节,满分30分)第一节(共5小题;每小题1.5分,满分7.5分)听下面5段对话。
每段对话后有一个小题,从题中所给的A、B、C三个选项中选出最佳选项,并标在试卷的相应位置。
听完每段对话后,你都有10秒钟的时间来回答有关小题和阅读下一小题。
每段对话仅读一遍。
1.Why does the woman ask the man to go to the airport?A.To meet a girl on Flight 576 from London.B.To catch Flight 576 for London.C.To see a girl off.2.For what reason won’t the man be able to go to the west coast?A.He is now looking for a new job.B.He is training his workers.C.He is busy with his new job.3.What is the most probable relationship between the two speakers?A.Doctor and patient. B.Professor and student. C.Manager and secretary. 4.How much will the man pay for what he is buying?A.Two dollars. B.Four dollars. C.Six dollars.5.What do you think the man is?A.A clerk. B.A customer. C.A stranger.第二节(共15小题;每题1.5分,满分22.5分)听下面5段对话或独白。
2010浙江省全国计算机等级考试二级VB笔试试卷及参考答案(必备资料)1、算法的时间复杂度是指(C)A. 执行算法程序所需要的时间B. 算法程序的长度C. 算法执行过程中所需要的基本运算次数D. 算法程序中的指令条数2、算法的时间复杂度是指(C)A. 执行算法程序所需要的时间B. 算法程序的长度C. 算法执行过程中所需要的基本运算次数D. 算法程序中的指令条数3、在软件开发中,下面任务不属于设计阶段的是(D)A. 数据结构设计B. 给出系统模块结构C. 定义模块算法D. 定义需求并建立系统模型4、在结构化方法中,软件功能分解属于下列软件开发中的阶段是(C) 注:总体设计也就是概要设计A. 详细设计B. 需求分析C. 总体设计D. 编程调试5、按条件f对关系R进行选择,其关系代数表达式为(C)A. R|X|RB. R|X|RfC. бf(R)D. ∏f(R)6、下列模式中,能够给出数据库物理存储结构与物理存取方法的是(A)A. 内模式B. 外模式C. 概念模式D. 逻辑模式7、检查软件产品是否符合需求定义的过程称为(A)A. 确认测试B. 集成测试C. 验证测试D. 验收测试8、在关系数据库中,用来表示实体之间联系的是(D)A. 树结构B. 网结构C. 线性表D. 二维表9、在软件生命周期中,能准确地确定软件系统必须做什么和必须具备哪些功能的阶段是(D)A. 概要设计B. 详细设计C. 可行性分析D. 需求分析10、用树形结构来表示实体之间联系的模型称为(B)A. 关系模型B. 层次模型C. 网状模型D. 数据模型11、在面向对象方法中,一个对象请求另一对象为其服务的方式是通过发送(D)A. 调用语句B. 命令C. 口令D. 消息12、数据库系统的核心是(B)A. 数据模型B. 数据库管理系统C. 软件工具D. 数据库13、信息隐蔽的概念与下述哪一种概念直接相关(B)A.软件结构定义B. 模块独立性C. 模块类型划分D. 模拟耦合度14、信息隐蔽的概念与下述哪一种概念直接相关(B)A.软件结构定义B. 模块独立性C. 模块类型划分D. 模拟耦合度15、下面对对象概念描述错误的是(A)A. 任何对象都必须有继承性B. 对象是属性和方法的封装体C. 对象间的通讯靠消息传递D. 操作是对象的动态性属性16、数据流图用于抽象描述一个软件的逻辑模型,数据流图由一些特定的图符构成。
2010-2011学年度第一学期高三摸底考试英语试题说明:1.本试卷分第I卷(选择题)和第II卷(非选择题)两部分。
共150分。
考试时间120分钟。
2.将卷I答案用2B铅笔涂在答题卡上,卷II用蓝黑钢笔或圆珠笔答在答题纸上。
第I卷第一部分英语知识运用(共三节,满分70分)第一节语音知识(共10小题;每小题1分,满分10分)从A、B、C、D四个选项中,找出其划线部分与所给单词的划线部分读音相同的选项,并在答题卡上将该项涂黑。
1.example A.exact B.excellent C.expression D.exercise2.fasten A.handsome B.vacation C.disaster D.national3.author A.worthy B.breathe C.length D.smooth4.break A.steal B.great C.deaf D.breakfast5.many A.mad B.any C.surface D.have6.minute A.bury B.busy C.lunch D.argue7.official A.stone B.gold C.clothes D.position 8.season A.satisfied B.absence C.case D.excuse9.blouse A.cough B.through C.aloud D.brought 10.cheer A.careless B.square C.therefore D.hear第二节语法和词汇知识(共30小题;每小题1分,满分30分)从A、B、C、D四个选项中,选出可以填入空白处的最佳选项,并在答题卡上将该项涂黑。
11.What lessons China can draw from _______ global financial crisis has become _______ hot topic among us students.A.the; a B./; a C.a; the D./; the12.The big snow caused great ________ to the people living in the south of China, ________ some of them homeless.A.destroy; left B.damage; leavingC.ruin; having left D.wound; leaving13.Either you or one of your students ________ to attend the meeting ________ tomorrow.A.are; to be held B.is; being heldC.is; to be held D.are; having held14.She has ________ that I find it hard to believe anything bad of her.A.so a lovely face B.so lovely a faceC.such lovely a face D.such lovely face15.Before Sally left home, her mother kept telling her to ________ her manners at the party.A.notice B.care C.mind D.observe16.________, you need to give all you have and try your best.A.Being a winner B.To be a winnerC.Be a winner D.Having been a winner17.You can never be ________ when crossing the street.A.very careful B.too carefulC.carefully enough D.enough careful18.It is usually warm in my hometown in March, but it ________ be rather cold sometimes.A.must B.can C.should D.would19.More wild tigers have been seen in the forest around this area, ________ there used to be very few.A.when B.where C.what D.which20.It is ten years since we ________ each other last time.A.see B.have seen C.saw D.had seen21.Not until she took off her dark glasses ________ she was a famous film star.A.I realised B.that did I realise C.did I realise D.that I realised22.It was the training ________ he had as a young man ________ made him so excellent.A.what; that B.that; which C.that; what D.which; that23._________ he was, he still went on with his work.A.Tired although B.Tiring asC.Tired though D.While tired24.Raising environmental awareness was the aim of our art exhibition ____ last week.A.to hold B.held C.having held D.being held25.________, I could not memorize the text.A.However hard did I try B.However hard I triedC.However I tried hard D.However I had tried hard26.The boy burst into tears ________ he saw his mother.A.at the moment B.in a moment C.for a moment D.the moment 27.Mount Wuyi is such an attractive place of interest ________ everyone likes to visit.A.that B.as C.which D.what28.The letter was so badly written that I couldn’t _________ it.A.make sense B.make sense of C.make sense in D.take sense of29.________, he also had a son in college who had taken a bank loan to pay for his studies.A.Make matters worse B.What worseC.To make matters worse D.To make thing worse30.As far as I see, ________ is no possibility ________ he will win the tennis match this time.A.it; that B.there; that C.it; whether D.there; whether 31.________ lack of interest, Tom kept trying hard to catch up with others.A.Although B.In spite C.Though D.Despite32.In China, shaking hands with each other is a common________ when people meet for the first time.A.sense B.practice C.scene D.rule33.—Tom has passed the final exam.—______! He never really worked hard before.A.Congratulations B.What a good newsC.What a good surprise D.How exciting the exam34.________ the help of her teacher, Mary ________ in the past few months.A.With; has made progress B.Under; has made a progressC.With; had made progress D.Under; had made a progress35.Mathilde and her husband turned the whole room upside down ________ the lost necklace.A.in favor of B.in want of C.in charge of D.in search of 36.Some children want to challenge themselves by learning a language different from ________ their parents speak at home.A.不填B.which C.one D.what37.--- Mike, it’s a pity you didn’t come to last night’s concert.It was really great!--- Really? If I ________ so busy, I would have gone with you.A.hadn’t been B.weren’t C.shouldn’t be D.wouldn’t be 38.Little Bob is often educated by his parents to be good and friendly to anybody even if ________.A.attacking B.is attacked C.to be attacked D.attacked39.______ is often the case, many Chinese parents save enough money for their children’s further education.A.Which B.That C.As D.Where40.Do not start a book unless you can see from the first few pages that it is ________ you can easily read and understand.A.that B.one C.the one D.that one第三节完形填空(共20小题;每小题1.5分,满分30分)阅读下面短文,从短文后所给各题的四个选项(A、B、C和D)中,选出可以填入空白处的最佳选项,并在答题卡上将该项涂黑。
黑龙江省2010年成人英语三级考试试卷(总分100,考试时间120分钟)Part I. Vocabulary and Structure (10 points; 15 minutes) Directions: Each of the following sentences is provided with four choices. Choose the one that **pletes the sentence. Then blacken the corresponding letter on the Answer Sheet.1. As preparations were **pleted in time, the conference had to be __________ till the next Tuesday.A. put awayB. cancelledC. put asideD. postponed2. ___________ with the size of the whole earth, the highest mountain does not seem high at all.A. **paredB. CompareC. **paringD. Comparing3. It’s only a short way to the station, so we might as __________ walk.A. goodB. nowC. quickD. well4. Liquids are like solids __________ they have a definite volume.A. in thatB. for thatC. with thatD. at that5. Since she can speak Japanese fluently, she has an advantage __________ other job applicants.A. toB. inC. overD. against6. Yesterday’s English examination looked simple, but it turned out to be __________ easy.A. nothing butB. everything butC. something butD. anything but7. It was raining hard, but by the time class was over, the rain __________.A. stoppedB. would stopC. had stoppedD. might have stopped8. “Perhaps you should go home now.” “No, I __________ on staying here for a while longer.”A. persistB. stickC. sitD. insist9. Hardly __________ to the bus stop when the bus suddenly pulled away.A. did they getB. they had gotC. they gotD. had they got10. It is necessary that the plan __________ before Thursday.A. were fulfilledB. was fulfilledC. be fulfilledD. would be fulfilled11. Not only __________ our money, but we were also in danger of losing our lives.A. we lostB. lost weC. did we loseD. we did lose12. I __________ a doctor now, if I had studied medical science in my youth.A. wereB. should beC. had beenD. should have been13. I knocked at the door several times __________ an elderly lady came to answer it.A. beforeB. afterC. unlessD. then14. He seemed very young, but __________ he was older than all of us.A. in natureB. in realityC. by natureD. in origin15. You may not have played very well today, but at least you’ve got through to the next round and __________.A. tomorrow **esB. tomorrow is another dayC. never put off till tomorrowD. there is no tomorrow16. It has been said that in no country __________ Britain can one experience four seasons in the course of a single day.A. other thanB. more thanC. better thanD. rather than17. __________ you are familiar with the author’s ideas, try to read all the sections as quickly as you possibly can.A. Now thatB. Ever sinceC. So thatD. As long as18. -Tom is so worried about the test that he said he was going to study all night.-Tell him he should quit __________ and get some help. A. B.A. to have worriedB. to worryC. worryingD. from worrying19. The trees __________ in the storm have been moved off the road.A. being blown downB. blown downC. blowing downD. to blow down20. The boy the teachers considered __________ failed in the final exam, __________ surprised them very much.A. to be the best; whichB. as the best student; thatC. to have been studying well; itD. such as a good student; whichPart II. Cloze Test (10 points;20 minutes)Directions: Read the passage through. Then, goback and choose one suitable word or phrase marked A, B, C, or D for each blank in the passage. Blacken the corresponding letter of the word or phrase you have chosen on the Answer Sheet.As it came near the corner, the taxi stopped suddenly. The driver got out looking very 21 . A big lorry which had been 22 the taxi stopped too. The taxi driver was now standing at the corner looking up at the sky 23 the lorry driver went to 24 him. A number of cars behind were 25 to stop as well and soon a large crowd of people 26 gathered at the corner The 27 of all this trouble was a very strange 28 . It sounded as if thousands and thousands of 29 were singing together. The noise was quite 30 and many people looked disturbed. The most extraordinary thing was that, apart from one or two pigeons, 31 was not a bird in sight. No one was able to solve the mystery 32 two policemen arrived. They noticed a large advertisement 33 a film high up on a wall nearby. 34 the noise seemed to be coming 35 this direction, they climbed up and found that a tape-recorder had been hidden 36 the advertisement. The noise made by birds singing was being broadcast over powerful loudspeakers so as to 37 the attention of passers-by. The police asked the 38 to take the recorder away because the advertisement had attracted 39 much attention that it was 40 for a great many cars and buses to move freely in the street.21.A. puzzledB. unhappyC. tiredD. guilty22.A. pushingB. leadingC. followingD. guiding23.A. butB. yetC. andD. so24.A. shareB. connectC. joinD. charge25.A. agreedB. determinedC. forcedD. persuaded26.A. havingB. hasC. haveD. had27.A. resultB. pointC. effectD. cause28.A. caseB. noiseC. thingD. picture29.A. cocksB. childrenC. birdsD. tape-recorders30.A. excitingB. interestingC. convincingD. frightening31.A. thereB. hereC. itD. that32.A. beforeB. untilC. whenD. after33.A. forB. inC. toD. by34.A. WhenB. BeforeC. AfterD. As35.A. inB. toC. intoD. from36.A. behindB. overC. aboveD. on37.A. payB. giveC. attractD. attack38.A. managersB. advertisersC. driversD. passers-by39.A. tooB. thisC. suchD. so40.A. impassableB. impossibleC. improperD. unnecessaryPart III. Reading Comprehension (40 points; 55 minutes)Section 1Directions: Each of the following three passages is followed by some questions. For each question there are four choices. Choose the best answer to each question. Then blacken the corresponding letter on the Answer Sheet.Passage One Questions 41 to 45 are based on the following passage.For the past twenty years, poll-takers (民意测验者) have told us that the vast majority of Americans report that they are “satisfied”or “very satisfied”with their jobs. But, when the surveys pose a slightly different question-“If you had to do it over, would you choose the same line of work?”-sixty percent of working Americans say they would choose another occupation. This seems to tell us that Americans feel that they are supposed to liketheir jobs but, in reality, they don’t. Most of us are stuck in jobs we’d prefer not to have. And some of us actually hate what we do.How does this happen in a land where citizens are presumably free to do, and become, anything they want? First of all, some of us didn’t deliberately choose our jobs but simply fell into them. Later, there was never time to find out what we really wanted to do.Another reason people dislike their jobs is the result of a change in the American economy. A hundred years ago most Americans worked for themselves on farms or in small stores and workshops. Now, less than 10 percent of us are self-employed. Many of us work as cogs (轮牙) in the wheels of giant corporations. We don’t make a finished product with our own hands, and we feel that we are totally replaceable parts in the machine. Social scientists say that the happiest workers are the ones who are their own bosses-business owners, executives, and professionals. Working for a **pany often results in a sense of powerlessness and malaise. Finally, being a member of the baby boom generation increases the chances of job dissatisfaction. In the struggle for careers among the members of this large population “bulge”, many people are losing out in **petition. These individuals may never achieve the standard of living their parents achieved, or go as far up the success ladder as they had hoped. The result is bitterness, and a feeling of being trapped in a “nowhere” job.41. The best title for this selection is __________.A. Job SatisfactionB. Why People Hate Their JobsC. Nowhere JobsD. A Change in the Workplace42. Which sentence best expresses the main idea of the selection? __________.A. Job burnout is a growing problemB. **panies provide many benefits for workersC. Workers are unhappy because they no longer work with their handsD. There are several reasons why workers are unhappy with their jobs43. According to the passage, the majority of Americans __________.A. would choose another occupation if they could begin againB. are self-employedC. feel that they are supposed to dislike their jD. work in factories44. The author implies that __________.A. job dissatisfaction is a sign of lazinessB. the baby-boomers despise their parentsC. polls can be misleadingD. working for a corporation is very satisfying45. The word “malaise” (Line7, Para. 3) means __________.A. depressionB. fulfillmentC. contentmentD. significancePassage Two Questions 46 to 50 are based on the following passage.Most forest fires are caused by human carelessness or ignorance. Forest fire prevention, therefore, is mainly a problem of creating better understanding of the importance of forests, an awareness of the danger of fire inthe woods, and a sense of personal responsibility to safeguard the forests from danger. This is not an easy job.Careless smokers are responsible for thousands of forest fires each year. Many of these are started when cigarette butts (烟蒂) and matches are thrown from automobiles. Others are caused by hunters, hikers (徒步旅行者), fishermen, or woods workers who are careless in disposing of their smoking materials. The Forest Service has posted rules in many of the National Forests that prohibit smoking except in certain designated areas. Many of the states have laws against throwing lighted materials from automobiles. The prevention of smoker-caused fires, however, depends upon changing the attitudes and behavior of millions of people who smoke in hazardous areas.The most important natural cause of fire is lightning (闪电). This accounts for 11 percent of forest fires on protected land for the entire nation. In the Western States, lightning causes a much higher percentage of fires than it does in the East.Advances in knowledge of fire weather are helping forest protection forces to know when to be alert to lightning-caused fires. Adequate and well-equipped forces can control them quickly and hold the damage to a minimum. Experiments in “seeding” thunder clouds to prevent or control the lightning itself have been in process for many years, but new breakthroughs are needed for any significant reduction in the fires lightning starts.46. This passage is chiefly about __________.A. smoking in forestsB. changing the attitudes and behavior of millions of peopleC. the chief causes of forest fires and their preventionD. advances in knowledge of fire weather47. Preventing smoker-caused forest fires is mainly a problem of __________.A. building the proper knowledge and habits in human beingsB. safeguarding the forests from fireC. posting rules in forestsD. holding the damage to a minimum48. Lightning-caused fires can be controlled quickly by __________.A. holding the fire damage to a minimumB. people who have changed their attitudes and behaviorC. enough fire fighters with good fire-fighting devicesD. carrying out experiments in “seeding” thunder clouds49. “Alert to” (Line 2, Para. 4) most probably means __________.A. aware ofB. watchful forC. responsible forD. busy with50. Which of the following statements is true according to the passage? __________.A. It is difficult to prevent forest firesB. Smoking is allowed only in certain forestsC. 11% of the forest fires in the Western States are caused by lightningD. Experiments in “seeding” thunder clouds have helped reduce lightning-caused forest fires Passage Three Questions 51 to 55 are based on the following passage.Some years ago industries had more freedom than they have now, and they did not need to be as careful as they must today. They did not need to worry a lot about the safety of the new products that they developed. They did not have to pay much attention to the health and safety of the people who worked for them. Often new products were dangerous for the people who used them;oftenconditions in the work place had very bad effects on the health of the workers.Of course sometimes there were real disasters(灾难) which attracted the attention of governments and which showed the need for changes.Also scientists who were doing research into the health of workers sometimes produced information which governments could not ignore.At such times, there were inquiries into the causes of the disasters or the problems. New safety rules were often introduced as a result of these inquiries;however, the new rules came too late to protect the people who died or who became seriously ill.Today many governments have special departments which protect customers and workers. In the U. S., for example, there is a department which tests new airplanes and gives warnings about possible problems. It also makes the rules that aircraft producers must follow. Another department controls the foods and drugs **panies sell.A third department looks at the places where people work,and then reports **panies that are breaking the laws which protect the health and safety of workers. Of course,new government departments and new laws cannot prevent every accident or illness,but they are having some good results. Our work places are safer and cleaner than before. The planes and cars which we use for travel are better. Producers are thinking more about the safety and health of the people who buy and use their products.51. The main topic of the passage is _________.A. conditions in the work placeB. the freedom of industries in the pastC. changes in industrial productionD. the safety and health of workers and customers52. It can be inferred from the passage that in the past _________.A. workers often got ill because of the poor working conditionsB. companies were free to put out any products they wanted toC. many people were killed by dangerous productsD. industries were as careful in management as they are today53. It is implied in the passage that _________.A. governments **panies had different opinions about the safety of productsB. governments paid little attention to the safety of productsC. government officials often did not listen to scientistsD. in the past no safety laws were introduced by governments54. Some years ago safety rules _________.A. were put forward due to scientists’ recommendationsB. came into being as a result of the workers’ demandsC. were introduced because quite a number of people were killed or seriously injuredD. were effective enough to protect workers and customers55. The special departments protect customers and workers in many ways EXCEPT by _________.A. testing new productsB. controlling the sale of productsC. designing new productsD. inspecting work placesSection 2Directions: Read the following passage, and then decide whether the statements are true (A) or false (B). Then blacken the corresponding letter(A or B)on the Answer Sheet. (对的在答题卡上涂A, 错的在答题卡上涂B)Passage Four Questions 56 to 60 are based on the following passage.When someone who is in good health dies suddenly, there is usually an inquest.An inquest is a kind of court inquiry. The person in charge of an inquest is called a coroner (验尸官). His job is to find out exactly how a person died.If there is nothing suspicious (怀疑的) about the death, he would decide that the person died from natural causes or an accident. If, however, he is suspicious, he may decide that the person’s death was caused by a person or persons unknown.At one inquest, the coroner was trying to find out exactly what had caused the death of a local businessman, Henry Smith.The man’s widow was offering the evidence. She was very upset and had to stop from time to time.The coroner did not want to upset her more than necessary, but he had to find out the truth. There were questions he had to ask her.“Mrs. Smith, I know this is too much for you,” he said, “but I want you to think very carefully and then answer my questions.”“You and your husband were ha ving dinner at home. Is that correct?”“Yes.”“Suddenly he fell to the floor.”“Yes.”“Did he say anything?”The widow lowered her head.“Please, Mrs. Smith, you must answer the question. What were his last words?”The widow took a deep breath and t hen spoke. “He said,” she whispered, “I’m not surprised you were charged only 50 cents for that seafood we had for dinner.”56. An inquest is done in one’s home.A. 正确B. 错误57. The coroner decides on the nature of a person’s death.A. 正确B. 错误58. The coroner was very careful in asking Mrs. Smith questions so as not to upset her.A. 正确B. 错误59. Mrs. Smith was quick to tell the truth.A. 正确B. 错误60. The bad seafood was responsible for Mr. Smith’s death.A. 正确B. 错误Directions: In this part there is a short passage with five questions or incomplete statements. Read the passage carefully. Then answer the questions or complete the statements in the fewest possible words (not exceeding 10 words) . Write your answers on the Answer Sheet of Paper Two. (请将此部分的答案写在试卷二的答题纸上)Questions 61 to 65 are based on the following passage.All of us communicate with one another nonverbally as well as with words. Most of the time we’re not aware that we’re doing it. We gesture with eyeb rows or hands, meet someone else’s eyes and look away, or change positions in a chair. These actions we assume are occasional. However in recent years researchers have discovered that there is a system to them almost as consistent and understandable as language. One important kind of body language is eye behavior. Americans are careful about how and when they meet one another’s eyes. In our normal conversation, each eye contact lasts only about a second before one or both of us look away. When two Americans look searchingly into each other’s eyes, they become more intimate. Therefore, we carefully avoid this, except in suitable situations.Researchers who are engaged in the study of communication through body movement are not prepared to spell out a precise vocabulary of gestures. When an American rubshis nose, it may mean he is disagreeing with someone or refusing something. But there are other possible interpretations, too. Another example: when a student in conversation with a professor holds the older man’s eyes a little longer than usual it can be a sign of respect, it can be a challenge to the professor’s authority, or it can be something else entirely. The researchers look for patterns in the situation, not for a separate meaningful munication between human beings would be just dull if it were all done with words.61. How can **municate with each other besides language?62. .Like language, gesture is ___________________________________________________.63. According to the second paragraph, an American will feel uncomfortable if someone64. If a student holds his professor’s eyes a little longer in a conversation, what can it mean?65. What is the main idea of the passage?Directions: For this part, suppose you are Wang Ming, and you are going to visit Yunnan next week. You need a digital camera for your trip. Write a letter of about 80 words to Bob, your good friend, to borrow one and the letter should include the following information:1. 1. 你为什么要借数码相机2. 你会好好爱护相机3. 用完马上归还Directions: For this part, you are required to write a short essay of about 150 words to say something about how you can make your parents happy. Your essay should include the following information:2. 1. 为什么应该使得父母幸福 2. 如何做才能使得父母幸福。
2010上半年数据库系统工程师考试下午真题及解析(2)《五年高考三年模拟》相当于高考“武功秘籍”中的《九阴真经》。
海量的题库,对真题详尽的解析,备受老师和学生的追捧。
可见,真题是应对考试的上好资料,下面希赛软考学院为你整理了2010上半年数据库系统工程师考试下午真题及解析,助你修炼出一身“绝技”,应对来年的数据库系统工程师考试。
试题三阅读下列说明,回答问题1至问题3,将解答填入答题纸的对应栏内。
[说明]某学校拟开发一套实验管理系统,对各课程的实验安排进行管理。
[需求分析]每个实验室可进行的实验类型不同。
由于实验室和实验员资源有限,需根据学生人数分批次安排实验室和实验员。
一门含实验的课程可以开设给多个班级,每个班级每学期可以开设多门含实验的课程。
每个实验室都有其可开设的实验类型。
一门课程的一种实验可以根据人数、实验室的可容纳人数和实验室类型,分批次开设在多个实验室的不同时间段。
一个实验室的一次实验可以分配多个实验员负责辅导实验,实验员给出学生的每次实验成绩。
1.课程信息包括:课程编号、课程名称、实验学时、授课学期和开课的班级等信息;实验信息记录该课程的实验进度信息,包括:实验名、实验类型、学时、安排周次等信息,如表3-1所示。
2.以课程为单位制定实验安排计划信息,包括:实验地点,实验时间、实验员等信息。
实验计划如表3-2所示。
3.由实验员给出每个学生每次实验的成绩,包括:实验名,学号,姓名,班级,实验成绩等信息。
实验成绩如表3-3所示。
4.学生的实验课程总成绩根据每次实验的成绩以及每次实验的难度来计算。
[概念模型设计]根据需求阶段收集的信息,设计的实体联系图(不完整)如图3-1所示。
[逻辑结构设计]根据概念模型设计阶段完成的实体联系图,得出如下关系模式(不完整):课程(课程编号,课程名称,授课院系,实验学时)班级(班级号,专业,所属系)开课情况( (1) ,授课学期)实验( (2) ,实验类型,难度,学时,安排周次)实验计划( (3) ,实验时间,人数)实验员( (4) ,级别)实验室(实验室编号,地点,开放时间,可容纳人数,实验类型)学生( (5) ,姓名,年龄,性别)实验成绩( (6) ,实验成绩,评分实验员)[问题1]补充图3-1中的联系和联系的类型。
《 Access2010数据库基础与应用》期末考试题( A 卷)(含答案)1. DBMS提供了__________语言,用于实现数据的插入、更新、删除、检索等任务。
A . DCLB . DDL C. DML D. APL2.在 E-R 图中,用来表示“实体”的图形是__________ 。
A .椭圆形B .矩形C.三角形D.菱形3.在Access 数据库设计中,将E-R 图转换为关系模式是___________ 中的任务。
A .数据库物理设计B.数据库优化C.数据库概念设计D.数据库逻辑设计4.在Access 数据库中,用于存储数据的对象是__________。
A .表B.窗体C.报表D.查询5.下列叙述中,___________是错误的。
A.一个关系中的任意两个分量不可以相同B.一个关系中的任意两个属性名不可以相同C.一个关系中的任意两个元组不可以完全相同D.关系中的元组也称为记录6.对于一个日期/时间类型的字段,如果想使该字段数据以类似“xxxx 年 x 月 x 日”方式显示,可以通过对其字段属性的“格式”设定为____________ 来实现。
A .短日期B.中日期C.长日期D.常规日期7.下列实体的联系中,属于一对多的联系是___________。
A .学生与宿舍床位B .学校与校长C.学生与课程 D .学校与教师8. SQL 语句中的CREATE TABLE关键字的功能是在数据库中__________。
A .创建表B.创建查询C.创建窗体D.创建数据访问页9.“学院”表中有一个“学院名称”字段,要查找学院名称为“商学院”或“法学院”的记录,使用的条件是 __________ 。
A . In(" 商学院或法学院")B .In(" 商学院 "," 法学院 ")C.In(" 商学院 " or " 法学院 ")D. In(" 商学院 " and " 法学院 ")10.用表“教师”创建新表“教师2”,所使用的查询方式是__________ 。
北京交通大学软件学院2008级《Database System》Final Exam(A)(2010-06-16)姓名_____ ______学号______ ______班级____ _______I.S ingle Choice (10 points)1.There are two transactions scheduled as shown in Fig.1. What kind of schedule is it?(A) U nserializable c oncurrent s chedule (B) S erial S chedules(C) serializable concurrent s chedule (D) None is correctFig. 1 Fig.22. In Fig.2,which transactions should be put into redo-list and which into undo-list?(A) r e do l i st: T1,T2 undo l i st: T3,T4,T5(B) redo list: T1,T2, T3 undo list:T4,T5(C) r e do l i st: T1 undo list: T2, T3,T4,T5(D) r e do l i st: T2,T3 undo l i st: T4,T53. The purpose of schema normalization is to(A) Reduce the number of anomalies that can occur during inserts, deletes, and updates.(B) Eliminate functional dependency among data stored in the database.(C) Reduce the number of joins required to satisfy a query.(D) Convert the data to a canonical form to promote schema integration.4.Let A, B, and C be subsets of the attributes of relation R. which one is Reflexivity rule of Armstrong’s axioms?(A) If A → B and A → C, then A → B,C(B) If B is a subset of A, then A → B(C) If A → B and B → C, then A → C(D) If A → B, then A,C → B,C5. The physical storage structure will be _____ to the application programmer in adatabase approach, and will be _____ to the application programmer in a file system approach.(A) hidden, visible (B) visible, hidden(C) visible, visible (D) hidden, hidden6.What information is necessary when specifying the structure of a table?(A) the name of the table, the names of the table's attributes, the data types of thetable's attributes, the formats of the table's attributes, and the maximumnumber of rows that the table can have.(B) the name of the table and the amount of storage space to be allocated to thetable.(C) the name of the table, the names of the table's attributes, the data types ofattributes, and the formats of attributes.(D) the name of the table and the names of the table's attributes.7. Which of the following is true about views being up to date?(A) Views are up to date only after the synchronization operation by the user.(B) Views are never up to date; there is always a lag time.(C) Views can be automatically made up to date periodically by the system.(D) Views are always up to date.8.If database has been damaged, users need to restore the last copy of databaseand reapply updates of committed transactions using .(A) backup, l o g file (B) log file , backup(C) data, checkpoint r e cord (D) b ackup, c heckpoint r e cord9. Consider the functional dependency: {A, B} -> {C} Regarding this dependency,which of the following statements is (are) true?I .The values of C are uniquely determined by the values of A.II The values of A are uniquely determined by the values of C.(A) I and II (B) I only (C) II only (D) None10. An exclusive lock on a data item represents permission to perform which of theoperations, read and write, on the data item?(A) Both read and write (B) Write only(C) Neither read nor write (D) Read onlyII. Fill in blanks (10 points)1. The log records are written before writing data to database, this rule is called (1)2. .(2) 3. The ANSI-SPARC three-level architecture of DBS includes three-level schemasand two-level mapping, please give their names: model is a data model built in the information world and canrepresent the logical (or community) view that is DBMS-independent.(3) schema , (4) schema, (5) schema and (6) mapping , (7) 4. mapping.(8) 5.Armstrong’s Axioms consist of three rules, i.e. Reflexivity, schedule is such kind of schedule where operations of each transactionare executed consecutively without any interleaved operations from other transactions.(9) and (10).III. (10 points) Given a relational schema, write its functional dependency set, all candidate keys of each relation schema and the highest normal form which it belong to. Then decompose it to BCNF if it is not in BCNF.1. warehouse (wno, addr, goodsNo, qty) where wno is the warehouse number, addr is the address of a warehouse, goodsNo is the goods number, one kind of goods can be stored in many warehouse and one warehouse can hold many kinds of goods, qty is the quantity of one kind of goods being stored in one warehouse.2.Table1 (City, Street, Zip) where Zip is the Zip code of a street in a certain city.You can get the other semantic meaning according to our national situation.IV.(30 points) There are three relation schemas in Database STUDENT, which are as follows.S (sno, sname, age, sex, Total_credits ) <PK>=sno,where Total_credits is the sum of the credits of all courses which the student has taken.C (cno, cname, credit, teacherNo) <PK>=cnoSC (s no,cno,grade) <PK>=(sno, cno) , <F K>=sno, <FK>=cno1.(3 points) Add a new attribute named Addr (varchar(20)) into Table S.2.(7 points) Write a trigger that can modify the corresponding value of Total_creditswhen a student changes one course to another course in Table SC.3.(5 points) Write a stored procedure that shows a student’s name, the names ofall courses which he or she takes, the grades and the credits when the student’s name is given.4.(5 points) Create a view that lists the student number, name and averagegrade of all the students whose average grades are more than 80. Inaddition, it prohibits a row migrating out of the view.5.(5 points) In Table SC, list the tuples in which the grades are less than theaverage grade of the same course.6.(5 points) List the student numbers of all the students who take at leasttwo different courses. (Write relational algebra expression)V.(20 points) Please answer the following questions briefly.1.Explain the following terminologies.(1)Data Independence ,PDI , LDI (5 points)(2)Two-Phase Locking Protocol (5 points)2.(5 points) What items are contained in transaction records in Log file? Writeat least five items of them.3.(5 points) Please write the difference between serial schedule and serializable schedule. VI.(20 points) Database DesignSuppose that you are asked to design a database about book publishing andselling. There are many publishers and many kinds of books. One book onlycan be published by one publisher and may be written by several authors. Allthe authors of one book share the copyright in different proportion, and eachauthor has his or her rank among all the authors of this book. Each book has afixed price. One book can be sold by many book stores and one store can sellmany books. Each transaction of book store’s book-selling has an order whichincludes order number, order date, store number, book number and thequantity of each book. In addition, the database should also include thefollowing information.(1)The individual information of every author, such as name, phone number,address, state and city where he lives.(2)The detail information of every publisher, such as its number, name, stateand city where it locates.(3)The information of a book, such as its title, type, publisher, price, author(s).(4)The information of a book store, such as its name, address, state and citywhere it locates.Please draw the ER-diagram for the application, leaving the attributes out ofthe diagram, and write the set of relation schemas. Then point out the primarykey of each relation schema.。