本科生期末试卷 五

精选全文完整版（可编辑修改）中山大学本科生期末考试考试科目：《化工分离过程》（A卷）学年学期：2018学年第二学期姓名：学院/系：学号：考试方式：√闭卷/开卷年级专业：考试时长：120分钟班别：警示《中山大学授予学士学位工作细则》第八条：“考试作弊者，不授予学士学位。

”--------------以下为试题，共###道大题，总分100分,考生请在答题纸上作答--------------一、选择题（共10 小题，每小题 2 分，共20 分）1. 以下分离技术成熟度和应用成熟最高的是( D )A. 超临界萃取B. 结晶C. 吸收D. 精馏2. 下列哪一个是速率分离过程( C )A. 蒸馏B. 吸收C. 膜分离D. 离心分离3. 当气液两相处在平衡时，( A )A. 两相间各组分的逸度相等B. 只是两相温度相等C. 两相间组分的浓度相等D. 相间不发生传质4. 膜过程中动力消耗最大的是( D )A. 纳滤B. 气体分离C. 微滤D. 反渗透5. 人工肾是( B )膜过程A. 膜吸收B. 透析C. 超滤D. 膜萃取6. 关于萃取精馏塔的下列描述中，哪一个不正确( B )A. 气液负荷不均，液相负荷大B. 回流比提高，产品纯度提高C. 恒摩尔流不太适合D. 是蒸馏过程7. A、B、C、D(挥发度依次减少)混合物的分离，工艺要求将B与C分离，则( B )A. A 为轻关键组分，B为重关键组分B. B 为轻关键组分，C为重关键组分C. A 为轻关键组分，D为重关键组分D. C 为轻关键组分，D为重关键组分8. 在超临界萃取过程中，通过改变压力实现溶剂回收的过程是( A )A.等温变压法B. 等压变温法C. 吸附法D. 以上都不是9. 下列能自发产生晶核是( C )A. 介稳区B. 稳定区C. 不稳定区D. 不好确定10.关于离子交换过程，不正确的说法有( C )A．一般来说，液相速度越快或搅拌越激烈，浓度越浓，颗粒越大，吸附越弱，越是趋向于内部扩散控制；B．想反，液体流速慢，浓度稀，颗粒细，吸附强，越是趋向于外部扩散控制；C．颗粒减少，对内部扩散和外部扩散控制的影响程度一样；D．离子的化合价越高，在树脂中扩散时，与树脂骨架（和扩散离子的电荷相反）间存在的库仑引力越大，因此扩散速度就越小。

College English Final Examination 05级本科（全新版B级）大学英语期末考试2006---2007学年度第二学期2007年7月10日上午注意事项：1、将年级、系、专业、班、姓名和学号填写（涂）在答题卡上。

所有答案均应做在答题卡或答题纸上，写在试卷上的答案一律无效。

2、本试卷为[ A ] 上用铅笔填涂。

3、试题分为多项选择题、单词填空、翻译、作文：1）多项选择题的答案用铅笔填涂在答题卡相对应的位置上。

2）单词填空、翻译、作文用钢笔或圆珠笔做在答题纸上。

4、考试时间为120分钟。

考试结束时，答题卡、答题纸、试卷都须交给监考人员，学生不准带走。

Section ADirections:In this section, you will hear ten short conversations. At the end of each conversation, a question will be asked about what was said. Each conversation and question will be read only once. After each question there will be a pause. During the pause, you must read the four choices marked A, B, C and D, and decide which is the best answer. Then mark the corresponding letter on the Answer Sheet with a single line through the center.Section BDirections:In this section, you will hear 3 short passages. At the end of each passage, you will hear some questions. Both the passage and the questions will be spoken only once. After you hear a question, you must choose the best answer from the four choices marked A) , B) , C) and D). Then mark the corresponding letter on Answer Sheet with a single line through the center.Passage onePassage twoPassage threeDirections: There are three passages for this task. The passages are followed by some questions. For each of them there are four choices marked A, B, C, and D. You should decide on the best answer and mark the corresponding letter on the answer sheet with a single line through the center.Passage OneQuestions 21 to 25 are based on the following passage:Several commentators and scientists have suggested that it might in some cases be ethically acceptable to clone existing people. One possibility is generating a replacement for a dying relative. All such possibilities, however, raise the concern that the clone would be treated as less than a complete inddividual, because he or she would likely be subjected to limitation and expectation based on the family’s knowledge of the genetic “twin.” Those expectations might be false, because human personality is only partly determined by genes. The clone of an extrovert(性格外向的人) could have a quite different way of behavior. Clones of athletes, movie stars, entrepreneurs or scientists might well choose different careers because of chance events in early life.Some people have also put forward the notion that couples in which one member is infertile might choose to make a copy of one or the other partner. But society ought to be concerned that a couple might not treat naturally a child who is a copy of just one of them. Because other methods are available for the treatment of all known types of infertility, conventional therapeutic avenues seem more appropriate. None of the suggested uses of cloning for making copies of existing people is ehically acceptable to my way of thinking, because they are not in the interests of the resulting child. It should go without saying that I am strongly opposed to allowing cloned human embryos to develop so that they can be tissue donors.It nonetheless seems clear that cloning from cultured cells will offer important medical opportunities. Predictions about new technologies are often wrong: societal attitudes change; unexpected developments occur. Time will tell. But biomedical researchers looking into the potential of cloning now have plenty to do.21. What is the author’s concern about cloing an existing person?A. The clone created will have one defect or another.B. The clone created will be mistreated.C. The clone created is unlikely to fulfill your expectations.D. The clone created is ethically unacceptable.22. It can be inferred from the text that a clone will _____.A. choose the same career as the person it is created fromB. behave in the same way as the person it is created fromC. share the same characteristics with the person it is created fromD. be partially similar in personality to the person it is created from23. According to the passage, one’s personality is determined by______.A. their genesB. the environment they live inC. both their genes and the environment they live inD. neither their genes nor the environment they live in.24. In the author’s view, which of the following uses of cloning is justifiable?A. To replace a lost relative.B. To help childrenless couples to have a baby.C. To develop tissue donors.D. To culture cells for medical purposes.25. What is autor’s attitude towards cloning technology?A. It should be condemned.B.It has medical potential for scientists to explore.C. It should wait till people’s views change.D. It was unethical from the very beginning.Passage 2Questions 26 to 30 are based on the following passage:The interview is an important event in the job-hunting process, because the 20 or 30 minutes you spend with the interviewer may determine whether or not you get the particular job you want. Therefore, it is important to remember that you objective during the interview may differ from the objective of the potential employer. You want to make yourself stand out as a whole person who has personal strength, is well qualified, and should be considered the right person for the job. It is encouraging to know that the interviewer’s task is not to embarrass you or to trip you up, but to hire the right person for the job.Remember, job hunting is very competitive. Anything you can do to enhance your interciew techniques will be to your advantage. The following suggestions may help you land the most important job.Your goal in this interview is to make sure your good points get across. The interviewer won’t know them unless you point them out, so try to do this in a factual and sincere manner.Do not make slighting references to former employers or professors. If you have been fired from a job and the interviewer asks about it, be frank in you answer.Show the inerviewer that you are interested in the company by asking relevant questions. Ask about responsibilities, working conditions, promotion opportunities and fringe benefits(附加福利) of the job you are interviewing for.If at some point you decide the interview is not going well, do not let your discouragement show. You have nothing to lose by continuing a show of confidence, and you may have much to gain. It may be real, or it may be a test to see how you react to adverse conditions.Some interviers may bring up salary early in the interview. At this time, you may indicate thatyou are more interested in a job where ou can prove yourself than a specific salary. This politely passes the question back to the interviewer. If the interviewer continues to press, give him a range or suggest the going rate for a particular job. If possible, you should negotiate for salary for salary after you have been offered a job and when you are ready to complete the paperwork.26. To get the job you want, during the interview you should .A. avoid the interviewer’s questions that are designed to trip you upB. remember that you are the best qualified candidateC. make yourself stand out as the right person for the jobD. keep in mind that it determines whether or not you get the particular job you want.27. If you did not ger along with your former employee, you .A. should tell the interviewer frankllyB. should not speak ill of himC. should refer to him in a factual mannerD. should never mention it28. When you find the interview is not going well you should ______.A. keep up your comfidenceB. bring it to an end as soon as possibleC. tell your interviewer how you react to adverse conditionsD. tell yourself you have much to gain and nothing to lose29. The best time to discuss your salary is .A. when you have been offered the jobB. at the end of the interviewC. after you have completed the paperworkD. when the interviewer brings this matter up30.The most important thing to do during an interview is .A. to make your strength understoodB. to show your intense interest in the job you are applying forC. to be frank and sincereD. to be natural and confidentPassage 3Questions 31 to 35 are based on the following passage:In traditional education, the teacher may feel that the students are not very grown up. Usually, teacher are older than students, and teachers feel that students are young and do not know very much about the world. The teachers feel that they must tell the students what to do most of the time, and that they must make the students study specific things. In open education, the teacher’s feelings are very different. These teachers feel that the students are individuals first, and students second. They expect the students to be responsible for the things that they do. The teacher allows the students to decide what they want to do, and does not make them study specific subjects ofthings. The teacher lets them decide what to study and how much to study.The second part of the idea of open education has something to do with what the teacher does in the classroom. In the traditional classroom, the students are told what to do. There is a list of things that the students must do to finish the class. There are rules made by the teacher that the students must follow, even if the students see no reason for the rules. In open education, the teacher allows the students to choose what to do. There are no specific things for the students to do. There are no traditional rules made by the teacher. The students are allowed to discover subjects in the open classroom instead of being made to study them.There are some very good things about open education. This way of teaching allows the students to grow as people. And to develop their own interests in many subjects. Open education allows students to be responsible for their own education. Some students do badly in a traditional classroom. The open classroom may allow them to enjoy learning. Some students will be happier in an open education school. They will not have to worry about grades or rules.But many students will not do well in an open classroom. They will not make good use of open education. Because open education is so different from traditional education, these students may have a problem getting used to making so many choices. For many students it is important to have some rules in the classroom. They worry about the rules even when there are no rules. Even a few rules will help this kind of students.So for some of the good points and bad points of open education have been explained. The writer thinks that open education is a good idea, but only in theory. What do you think?31. One of the good points of open education is that .A. students may grow as peopleB. students all like itC. all the students will do wellD. some students have a problem getting used it32. Some students dislike open education because .A. they may have a problem greeting used itB. they are grown-upsC. they may study, or talk or do nothing at allD. they worry about the rules33. The writer thinks that open education is .A. better than traditional educationB. worse than traditional educationC. a good idea only in practiceD. a good idea only in theory34. The students are supposed to in open education.A. study specific thingsB. follow the rulesC. worry about gradesD. decide what to study35. In traditional education, the teacher may feel thatA. the students are not very grown-upB. the students don’t know very much about the worldC. they must make the students study specific thingsD. All of above.Part III Vocabulary (15%)Directions:There are 30 incomplete sentences in this part. For each sentence there are four choices marked A), B), C) and D). Choose the ONE that best completes the sentence. Then mark the corresponding letter on the Answer Sheet with a single line through the center.36. Before Anglo-American westward _______ , North America had been shaped by manyother cultures.A. expandedB. expandC. expansionD. extend37. By a _____ of good luck, Genelle, who had been buried in the rubble for more than26hours,came out alive .A. strokeB. strikeC. stormD. store38. The German victories were over, _____ in part_____ the Russian winter.A.thanks…forB. thanks…toC. thanks…ofD. thanks…with39. The elements of nature must _____with in any military campaignA. reckonedB. considerC. be reckonedD. proposed40. The opening speeches sound more like_______ of war than offering of peace.A. celebrationB. declaratingC. recommendationD. declaration41. The government troops recaptured the city from the rebels _______ two thousand casualties.A. at the cost ofB. on the cost ofC. in case ofD. in the case of42 Once we stepped off the plane and onto the prairie, we were greeted by a gust of ______ andbitting wind.A.freshB.rawC. newD. situation43.Warmer air is able to hold more water _____ than cold air and so has a higher humidity.A. vaporB. waveC. airD. proof44. From the control tower, air traffic controller coordinate aircraft movement both _____ and onthe ground.A. on the airB. in the airC. at the airD. with the air45. In most communities in the United States, the local American Red Cross chapter has beenauthorized to _______ certain local public building in times of emergency.A. get control withB. have control onC. take control ofD. take control with46. Was he planning to _____ the interview with another application letter indicating his eagernessto join us?A. follow upB. follow withC. as followsD. follow by47. The Smiths have always wanted their children to become warm-hearted human being whoreach out_______ to those in need.A. generallyB. incidentallyC. generouslyD. mentally48. She appeatred very nervous one evening, I asked her what was wrong, and she _____ tha shehad fallen in love with me.A. blurted outB. reach outC. rushed outD. went out49. Hid goal is to get into the seme finals and it would be ______ if he could go further than that.A. with his wildest dreamsB. beyond his widest dreamsC. on his wildest dreamsD. over his widest dreams50. I looked at Mary’s pictures and found some of them so amusing and funny that couldn’thelp_____.A.chucklingB. chuckleC. to chuckleD. chuckled51. The quantity of money in a country affects the level of prices, the rate of economic growth,and the ______ situation on the job market.A. employeeB. employerC. recruitmentD. employment52. Salespeopel often try to learn about the need of the ______ buyer to make themselves morepersuasive.A. prospectiveB. probableC. probablyD. problem53. All the lights suddenly_____ and the house was plunged into darkness.A. went outB. went offC. came offD. took off54. Angela didn’t resond to Gavin’s charms so he ______ his affection to her best friend Lucy.A. transplantedB. transportedC. transferredD. transited55. He felt confident that he could overcome his ______ and achieve still greater success.A. limitationsB. limitedC. limitlessD. limit56. Agust of wind knocked him_____ and he fell face down in the mud.A. on balanceB. off balanceC. of balanceD. in balance57. Some days, he feels like____.A. surrenderB. surrenderedC. surrenderingD. to surrender58. “I’m sorry, I’m ______ right now.”A. on the phoneB. with the phoneC. in the phoneD. at the phone59. Sam was______ in hospital for months.A. laid onB. laid upC. lie upD. lay up60. What_____ as fun quickly became hard work.A. started atB. show outC. started outD. appear61. It was Marx’s idea that ______ communism.A. gave birth toB. gave birth inC. born toD. born with62. Susan sounds for ______ like her mother on the telephone.A. justB. all the worldC. soD. such63. The police chief has made no _____ about the attack so far.A. suggestionB. opinionC. commentD. commission64. Telecommunications devices______ different types of information, such as sound and video,into electronic sigalsA. convertB. transportC. checkD. paste65. The endless public appearance and shaking of hands are inevitable part of an election_____.A. campusB. movementC. campaignD. motionPart IV Translation (20%)Directions: There are five sentences in this part. For section A ,you are required to translate the sentences into Chinese. For section B, you are required to translate the sentences into English. You should write your answers on the Answer Sheet.Section ADirections:Translate the following sentences into Chinese.(6%)66.He gets no paid holidays, vacations or raises.67.We should stop focusing on our hypothetical（假设的）fears and think about the benefits thatcloning could bring.68.Approximately 40,000 people are killed each year in the United States in traffic accidents.69.As food ran out, people died from hunger and disease.70.As I see it, there are four keys to getting hired.Section BDirections:Translate the following sentences into English.(4%)71.常言道，好的开端是成功的一半。

西南财经大学本科期末考试试卷课程名称：统计学担任教师：考试学期：2018－2019学年第2学期专业：全校各专业学号：年级：姓名：考试时间：201年月日（星期）午：--：题号一二三四五六七八总分阅卷人成绩出题教师必填：1、考试类型：闭卷[√]开卷[]（页纸开卷）2、本套试题共五道大题，共8页，完卷时间120分钟。

3、考试用品中除纸、笔、尺子外，可另带的用具有：计算器[√]字典[]等（请在下划线上填上具体数字或内容，所选[]内打钩）考生注意事项：1、出示学生证或身份证于桌面左上角，以备监考教师查验。

2、拿到试卷后清点并检查试卷页数，如有重页、页数不足、空白页及刷模糊等举手向监考教师示意调换试卷。

3、做题前请先将专业、年级、学号、姓名填写完整。

4、考生不得携带任何通讯工具进入考场。

5、严格遵守考场纪律。

请将单项选择题答案填在下表内！题号12345678910答案题号11121314151617181920答案题号21222324252627282930答案请将多项选择题答案填在下表内！题号12345答案一、单项选择题（每小题1分，本大题共计30分）1．下列各项指标中，属于强度相对数的是（）A.产品合格率B.商品流通次数C.增长速度D.工人劳动生产率2．要了解某市国有工业企业生产设备情况，则统计总体是（）A.该市全部国有工业企业B.该市每一个国有工业企业C.该市国有的某一台设备D.该市国有工业企业的全部生产设备3．根据调查可分为顾客对产品的满意度划分为非常满意、比较满意、没有不满、不满意、很不满意几类。

这里的数据是（）A.定类数据B.定序数据C.定距数据D.定比数据4．某连续变量数列末位组为开口组,下限为200,相邻组组中值为170，则末位组中值为（）A.230B.200C.210D.1806．某车间三个班生产同种产品，6月份劳动生产率分别为2、3、4（件／工日），产量分别为400、500、600件，则该车间平均劳动生产率计算式应为（）A．33432=++B．13.31500600450034002=⨯+⨯+⨯C．88.24323=⨯⨯D．9.24600350024001500=++7．下列应该用几何平均法计算的是（）A.年末平均人口数B.平均计划完成程度C.不同批次产品的平均废品率D.以复利计息的平均年利率8．下述各项调查中属于全面调查的是（）A.对某种连续生产的产品质量进行检验B.对某地区工业企业设备进行普查C.对全面钢铁生产中的重点单位进行调查D.抽选部分地块进行农产量调查9.根据一个具体的样本求出的总体均值95%的置信区间（）A.以95%的可能性包含总体均值B.有5%的可能性包含总体均值C.一定包含总体均值D.可能包含也可能不包含总体均值10.以下现象应采用调和平均数计算的有（）A.已知各组工人人数和相应的工资总额，求平均工资B.已知各组计划完成百分数和各组计划产值，求平均计划完成百分数C.已知各车间工人劳动生产率和产品产量，求平均工人劳动生产率D.已知某企业各产品产量和单位成本，求平均单位成本11．对固定资产投资额这种现象，求平均发展速度宜采用（）A.几何平均法B.水平法C.方程式法D.以上均可12.以下关于时间序列说法错误的是（）A.时间序列是一串以时间为指标的随机变量B.时间序列发展速度根据基期水平不同分为环比发展速度和定基发展速度C.时间序列通常包含长期趋势、季节变动和不规则变动D.不能从时间序列中分离出不规则变动13.下列方法中，不属于综合评价方法的是（）A.排队计分法B.指数平滑法C.加权指数法D.功效系数法14.下列各项属于超额完成计划的是（）A.单位成本计划完成百分数105%B.建筑预算成本计划完成百分数105%C.流通费用率计划完成百分数105%D.利润计划完成百分数105%15.某企业的职工工资水平比上年提高5%，职工人数增加2%，则企业工资总额增长（）A.3%B.10%C.7.1%D.107.1%16.某部队夏季拉练，发生中暑21例，其中北方籍战士为南方籍战士的2.5倍，则结论为（）A．北方籍战士容易发生中暑B．南方籍战士容易发生中暑C．北方、南方籍战士都容易发生中暑D．尚不能得出结论17.公式∑∑-01pqpq的经济意义为（）A．反映价格综合变动的绝对额B．反映销售量综合变动的绝对额C．反映由于价格变化引起销售额的增减额D．反映由于销售量变化引起销售额的增减额18．综合评价中的加权指数法（）A.评价指标体系中既可包括正指标也可以包括拟指标B.指数值越大越好C.指数值越小越好D.应该先将评价指标体系中的指标进行同向化19.某商品近几年销售量大致持平，年平均为1200万件，1月份的季节比率为260%，2月份月平均销售量比1月份低35%，那么正常情况下2月份的销售量应该是（）。

本科生期末试卷（一）一、选择题（每小题1分，共15分）1 从器件角度看，计算机经历了五代变化。

但从系统结构看，至今绝大多数计算机仍属于（冯.诺依曼）计算机。

2 某机字长32位，其中1位表示符号位。

若用定点整数表示，则最小负整数为（-(231-1) ）。

3 以下有关运算器的描述，（算术运算与逻辑运算）是正确的。

4 EEPROM是指（电擦除可编程只读存储器）。

5 常用的虚拟存储系统由（主存-辅存）两级存储器组成，其中辅存是大容量的磁表面存储器。

6 RISC访内指令中，操作数的物理位置一般安排在（两个通用寄存器）。

7 当前的CPU由（控制器、运算器、cache）组成。

8 流水CPU是由一系列叫做“段”的处理部件组成。

和具备m个并行部件的CPU相比，一个m段流水CPU的吞吐能力是（具备同等水平）。

9 在集中式总线仲裁中，（独立请求）方式响应时间最快。

10 CPU中跟踪指令后继地址的寄存器是（程序计数器）。

11 从信息流的传输速度来看，（单总线）系统工作效率最低。

12 单级中断系统中，CPU一旦响应中断，立即关闭（中断屏蔽）标志，以防止本次中断服务结束前同级的其他中断源产生另一次中断进行干扰。

13 安腾处理机的典型指令格式为（41位）位。

14 下面操作中应该由特权指令完成的是（从用户模式切换到管理员模式）。

15 下列各项中，不属于安腾体系结构基本特征的是（超线程）。

二、填空题（每小题2分，共20分）1 字符信息是符号数据，属于处理（非数值）领域的问题，国际上采用的字符系统是七单位的（IRA ）码。

2 按IEEE754标准，一个32位浮点数由符号位S（1位）、阶码E（8位）、尾数M（23位）三个域组成。

其中阶码E的值等于指数的真值（ e ）加上一个固定的偏移值（127 ）。

3 双端口存储器和多模块交叉存储器属于并行存储器结构，其中前者采用（空间）并行技术，后者采用（时间）并行技术。

4 虚拟存储器分为页式、（段）式、（段页）式三种。

天津大学试卷专用纸学院计算机学院专业班年级学号姓名 A卷共 7 页第 1页题号一二三成绩核分人签字得分1C2D3D4A5B6D7B8D9B10B 11B12C13B14B15D 16C17C18B19B20C 21A22D23D24C25D 26B27B28D29B30B 31C32C33D34D35A 36D37C38C39B40C 41A42B43BC44BD45AB 46D47CD48CD49A50ABD天津大学试卷专用纸学院计算机学院专业班年级学号姓名 A卷共7 页第 2页7.某个企业的数据库包含以下信息.员工(由员工编号唯一确定,记为ssn),员工的子女(属性为name,age),在双亲给定的情况下,每个孩子能由他的姓名唯一确定(假设他们的双亲中只有一个是公司的员工).一旦员工离开公司,那么企业不再对其子女信息感兴趣.下面哪个ER图能够正确的反映以上需求B8.如果将下面的ER图转换成数据库中的关系,那么在数据库中需要定义. DA. 2个关系B. 3个关系C. 3个关系 ,1个断言D. 2个关系,1个断言9. 如果将下面的ER图转换成数据库中的关系(该ER图中要求员工的年龄在18到55岁之间),那么在数据库中至少需要定义. BA. 3个关系,1个断言个关系,1个约束个关系个关系10. 我们在一个关系中BA.必须定义一个主关键字B.只能创建一个聚集索引(cluster index)C.只能创建一个稠密索引D.只能定义一个约束.11. 在DBMS的关系中BA.关键字属性值可以为空B.外关键字属性值可以为空C.任何属性值都可以为空D.任何属性值都不可以为空.12. 下面关于外关键字描述不正确的是CA.外关键字必须是所参考表的主关键字.B.外关键字属性必须与参考的属性是相同的数据类型C.定义外关键字需要对所参考表拥有select权D.一个表中可以有多个外关键字.13.我们在DBMS中记录数据库员工和员工工作信息,要求当某个员工离职后,数据库需要自动删除该员工的工作信息,在定义工作表时我们对于外关键字的删除规则应定义为BA. ON DELETE ROLLBACKB. ON DELETE CASCADEDELETE SET NULL DELETE NO ACTION14.在DBMS中执行GRANT update(col1) ON TABLE TO user7,对于该语句下面哪个描述是正确的: B天津大学试卷专用纸学院计算机学院专业班年级学号姓名 A卷共 7页第3页15. 关系模式R,R的属性集是{ABCDEG}有函数依赖集F={AB C , C A, BE C, BC D , CG BD}计算(AB)的属性闭包.DA.. BDEGB. BDCC. ABCDEGD. ABCD16. staff的定义如下Cid INTEGERname CHAR(20)dept INTEGERjob CHAR(20)years INTEGERsalary DECIMAL(10,2)comm DECIMAL(10,2)下面哪个语句可以按照job和salary的升序排序来返回所有员工的信息.A. SELECT id,name,salary,dept,job,years,comm FROM staff ORDER BY 4,6B. SELECT id,name,salary,dept,job,years,comm FROM staff GROUP BY 4,6C. SELECT id,name,salary,dept,job,years,comm FROM staff ORDER BY 5,3D. SELECT id,name,salary,dept,job,years,comm FROM staff GROUP BY 5,317. 关系模式Sailors(sid,,age,ratring)其中lastname允许为空. 下面哪个语句能够查找出lastname属性值不为空的水手信息. CA. SELECT * FROM SAILORS WHERE LASTNAME<>’NULL’B. SELECT * FROM SAILORS WHERE LASTNAME<>NULLC. SELECT * FROM SAILORS WHERE LASTNAME IS not NULLD. SELECT * FROM SAILORS WHERE LASTNAME not LIKE ’NULL’18. 关系模式Sailors(sid,sname,age,ratring)下面哪个语句能够查找出sname属性值至少为四个字符长,并且开始和结束字符都是B的水手信息. B* FROM SAILORS WHERE sname like ’B%%_B’20.有关系模式R(A,B,C)和三个合法实例(6,4,6),(6,4,6),(7,4,8),下面哪个函数依赖在关系模式R 上不成立CA. A->BB. BC->AC. B->CD. C->A.21.设有关系模式R(B,I,S,Q,D),其上函数依赖集F={S D,I B,IS Q,B Q,B I}下面那些是R的关键字. A22.下面哪个改变可以通过alter table实现DA. 增加一个触发.B. 增加一个索引.C. 增加一调记录D. 定义一个候选关键字23.下面的语句按顺序成功执行后CREATE TABLE tab1 (c1 CHAR(1))INSERT INTO tab1 VALUES ('b')CREATE VIEW view1 AS SELECT c1 FROM tab1 WHERE c1 ='a'INSERT INTO view1 VALUES ('a')INSERT INTO tab1 VALUES ('b')执行SELECT c1 FROM tab1可以选择出多少条记录D24.有一个关系模式employee(name,department,phone_number),下面哪句话允许user1可以修改phone_number列的值CA. GRANT MODIFY (phone_number) ON TABLE employee TO user1B. GRANT ALTER (phone_number) ON TABLE employee TO user1C. GRANT UPDATE (phone_number) ON TABLE employee TO user1D. GRANT REFERENCES (phone_number) ON TABLE employee TO user125.数据库中SAILORS表是由joe创建的.在DBMS完成下面的语句后 D天津大学试卷专用纸学院计算机学院专业班年级学号姓名 A卷共7页第4页26.在使用数据库中使用索引的目的是: BA.提高数据文件的存储率.B.可以更加有效的控制事务处理中的幻影问题.C.增加DBMS的安全性.D.提高增加记录的效率.27.下面哪种文件格式对不等值搜索的效率最高BA.无序文件B.排序文件C.哈希文件D.队列文件28.下面关于主关键字描述不正确的是: DA.在表中可以通过主关键字唯一的确定一条记录.B.主关键字可以由多个属性组成.C.组成主关键字的属性值不能空.D.一个表中可以有多个主关键字29.关于第三范式描述正确的是BA.一个关系属于第第一范式,它就属于第三范式B. 一个关系模式属于BC范式,它就属于第三范式C. 一个关系实例有数据冗余,它就是属于第三范式D.一个关系实例没有数据冗余,它就是属于第三范式30.下面哪个调度是串行调度: BA. T1:R(A),T2:R(B),T2:W(B),T1:W(A)B. T1:R(B),T1:W(B),T2:R(A), T2:W(A)C. T1:R(A),T2:R(B),.T1:W(A),T2:W(B)D. T2:R(A),T1:R(B),.T1:W(A),T2:W(B)31.下面关于数据库事务处理描述错误的是: CA.原子性:表示的是事务的所有操作在数据库中要么全部正确反映出来要么全部不反映.B.一致性:事务在执行前如果数据库是一致性的那么执行后也是一致性的.C.隔离性:事务在执行过程中可以感觉到系统中其他事务的执行33.数据库系统的log中检查点的作用是: DA.系统事务取消时数据库关系系统需要重检查点开始取消.B.系统事务正确完成时数据库系统会在log中设置检查点.C.数据库重新启动时恢复系统中的重做阶段从检查点开始.D.数据库重新启动时恢复系统中的分析阶段从检查点开始34. 下面哪个说法符合数据库系统WAL(log先写协议): DA.数据库内存中被事务修改的页面在事务成功完成时被强制写到磁盘中B.数据库内存中被事务修改的页面在事务撤销时被写到标记为非脏页C.事务成功完成时不需要将与其相关的log页面强制写回磁盘D.事务中被修改的内存数据页面在写回磁盘前必须将与其相关的log写回磁盘35.一个企业提供了一个查询数据库,该数据库的数据可以很容易的重新构造.为了提供数据库中磁盘数据的访问速度,下面磁盘技术中采用哪种方法可以满足该要求: AA. RAID 0 1 C. RAID 0+1 536.一个企业有大量的数据需要存储在数据库中,企业要求数据的稳定性存储和数据开速访问,但不想使用太多的磁盘进行冗余存储,下面磁盘技术中采用哪种方法可以满足该要求: DA. RAID 0 1 C. RAID 0+1 537.在JDBC提供的数据库编程方法中提供了几种JDBC和数据库的连接方法: C38.下面哪些说法是正确的：CA．在死锁预防中，等待--死亡法是中止优先级高的事务B．在死锁预防中，受伤--等待法是优先级高的事务可能等待优先级低的事务释放锁C．使用死锁预防的系统中不会出现死锁。

班级：学号：第1页 共2页第2页 共2页所有试题答案均需写在答题册上，写在本试卷上无效。

一、简答题（每空1分，共60分）1.组合声纳参数中噪声隐蔽级的表达式为 ；混响隐蔽级的表达式为；它们都表示主动声纳正常工作所需的最低 。

2.主动声纳的背景干扰有 和 。

其中 是平稳的随机过程，是非平稳的随机过程。

对应两种不同干扰背景的主动声纳方程分别为和 。

3.在水声学中，声压级的定义式为 ；声强级的定义式为 ；声压级与声强级相等的条件为 。

4.已知发射换能器的辐射声功率为100W ，则距离声源声中心1m 处无指向性声源的声强为 W /㎡；声源级为 dB 。

5.传播损失的一般表示式为 。

其中几何衰减项为 、物理衰减项为 。

6.影响海水声速的三个主要因素为 、 、 。

海水中声速的典型结构有 、 、 、 。

7.一般情况下，声波的频率越低，海水的吸收衰减 ，传播距离 ；但当声波的频率低于波导的 频率时，简正波水平方向的波数由实数变为 ，波导中的简正波蜕化为 的简正波，传播距离反而 。

8.射线声学的两个基本方程分别为 方程和 方程。

由Snell 折射定律可知，声线总是向 的方向弯曲；当介质的声速为常数时，声线轨迹为 ；当介质的声速梯度为常数时，声线轨迹为 ，圆的半径为 。

9.声波在 声道和 声道中能够远距离传播。

10.邻近海面水下点源声场声压振幅随距离的变化关系表现为：近场菲涅耳干涉区，声压振幅随距离 减小，远场夫琅和费区，声压振幅随距离 减小。

11.水池中测量目标强度，一般可采用比较法或直接测量法，但应注意：第一，声源与目标之间的距离和目标与水听器之间的距离都应满足 条件。

第二，应保证 条件得到满足。

第三，合理选取发射信号 。

12.目标回声信号的形成主要有 、 、 、 。

回声信号的一般特征为 、 、、 。

13.根据混响形成原因的不同，习惯上将海洋混响分为 、 和 ；其中和 又统称为界面混响。

混响的瞬时值服从 分布；振幅服从 分布。

本科生期末试卷五答案一．选择题1． B 2. D 3. B 4. B 5. B 6． D 7. A 8. A 9.C 、D 10. A 、B 、C 二．填空题。

1.A.高速缓冲 B.速度 C.指令cache与数据cache2. A.指令条数少 B.指令长度固定 C.指令格式和寻址方式3.A.时间 B.空间 C.时间 + 空间并行4.A.存储 B.记录 C.结构5.A.时间并行性 B.经济而实用 C.高性能。

三．解：命中率 H = Ne / （NC+ Nm） = 3800 / (3800 + 200) = 0.95主存慢于cache的倍率：r = tm / tc= 250ns / 50ns = 5访问效率：e = 1 / [r + (1 – r)H] = 1 / [5 + (1 – 5)×0.95] = 83.3%平均访问时间：ta = tc/ e = 50ns / 0.833 = 60ns四．解：（1）串行进位方式：C 1 = G1+ P1C其中： G1= A1B1，P1= A1⊕B1C 2 = G2+ P2C1G2= A2B2，P2= A2⊕B2C 3 = G3+ P3C2G3= A3B3, P3= A3⊕B3C 4 = G4+ P4C3G4= A4B4, P4= A4⊕B4(2) 并行进位方式：C1 = G1+ P1CC 2 = G2+ P2G1+ P2P1CC 3 = G3+ P3G2+ P3P2G1+ P3P2P1CC 4 = G4+ P4G3+ P4P3G2+ P4P3P2G1+ P4P3P2P1C其中 G1—G4，P1—P4表达式与串行进位方式相同。

五．解：根据图B5.1中已知，ROM1的空间地址为0000H——3FFFH，ROM2的地址空间地址为4000H——7FFFH，RAM1的地址空间为C000H——DFFFH，RAM2的地址空间为E000H——FFFFH。

对应上述空间，地址码最高4位A15——A12状态如下：0000——0011 ROM1 0100——0111 ROM2 1100——1101 RAM1 1110——1111 RAM22 ：4译码器对A15A14两位进行译码，产生四路输出，其中：y= 00对应ROM1 ，y1= 01对应ROM2，y3= 11 对应 RAM1和RAM2。

国家开放大学电大本科《数据库应用技术》2023-2024期末试题及答案(试卷代号：1256)一、单项选择题（每个题只有一个答案是正确的，请将正确的答案填写到括号内。

本题共20个小题，每小题2分，共40分）1．下列不属于组织层数据模型的是( )。

A．层次模型B．网状模型C．关系模型D．概念模型2。

在用数据模型描述数据时，一般要求数据模型要满足三个要求。

不属于数据模型应满足要求的是( )。

A．能够描述并发数据B．能够真实地模拟现实世界C．容易被业务人员理解D．能够方便地在计算机上实现3。

下列属于面向用户信息需求设计的是( )。

A．外模式B．内模式C。

模式D．模式间的映像4．关于关系运算中选择运算的说法，正确的是( )。

A．选择运算是从垂直方向选取表中的若干列B。

选择运算是从水平方向选取表中满足条件的记录C．进行选择运算的两个表必须结构相同D．进行选择运算时要求两个表中必须有同名列5．若关系模式中不存在复合数据项，则此关系模式一定属于( )。

A.第一范式B．第二范式C．第三范式D．第四范式6.属于SQL Server推荐的日志文件扩展名的是( )。

A.. dataB. mdfC.. ndfD.. ldf7.属于数据控制操作的是( )。

A. REVOKEB. INSERTC. DROPD. SELECT8.属于浮点类型的是( )。

A. numericB. intC. datetimeD. real9.用于定义主键约束的是( )。

A. NOT NULL.B. DEFAULTC. PRIMARY KEYD. FOREIGN KEY10.在条件子句中,能够筛选出价格在100~200(包括边界值)的是()。

A.Where价格>=100OR价格<=200.B. Where 价格IN(100.. 200)C. Where 价格BETWEEN 200 AND 100D.Where价格>=100AND价格<=20011.现要统计选课表中C01课程的总成绩,正确的语句是( ) .A. SELECT COUNT(成绩) FROM选课表WHERE课程号= C01'B. SELECT COUNT(* ) FROM选课表WHERE课程号= C01'C. SELECT SUM(成绩) FROM选课表WHERE课程号= C01'D. SELECT SUM( * ) FROM选课表WHERE课程号= C01'12.查询年龄最大的前3位学生的姓名和年龄的语句,正确的是( )。

本科生期末考试试卷统一格式（16开）：20 ～20 学年第 学期期末考试试卷《化工热力学 》（A 或B 卷 共 页）（考试时间：20 年 月 日）学院 专业 班 年级 学号 姓名一、 简答题（共8题，共40分，每题5分） 1. 写出封闭系统和稳定流动系统的热力学第一定律。

答：封闭系统的热力学第一定律：W Q U +=∆稳流系统的热力学第一定律：s W Q Z g u H +=∆+∆+∆2212. 写出维里方程中维里系数B 、C 的物理意义，并写出舍项维里方程的混合规则。

答：第二维里系数B 代表两分子间的相互作用，第三维里系数C 代表三分子间相互作用，B 和C 的数值都仅仅与温度T 有关；舍项维里方程的混合规则为：∑∑===ni nj ij j i M B y y B 11，()10ijij ij cijcij ij B Bp RT B ω+=，6.10422.0083.0pr ij T B -=，2.41172.0139.0prij T B -=，cij pr T T T =，()()5.01cjci ijcijT Tk T ⋅-=，cijcijcij cij V RT Z p =，()[]331315.0Cjci cij V V V +=，()cj ci cij Z Z Z +=5.0，()j i ij ωωω+=5.03. 写出混合物中i 组元逸度和逸度系数的定义式。

答：逸度定义：()i i i f RTd y p T d ˆln ,,=μ （T 恒定）1ˆlim 0=⎪⎪⎭⎫ ⎝⎛→i i p py f逸度系数的定义：iii py f ˆˆ=φ4. 请写出剩余性质及超额性质的定义及定义式。

答：剩余性质：是指同温同压下的理想气体与真实流体的摩尔广度性质之差，即：()()p T M p T M M id ,,-='∆；超额性质：是指真实混合物与同温同压和相同组成的理想混合物的摩尔广度性质之差，即：idm m M M -=E M5. 为什么K 值法可以用于烃类混合物的汽液平衡计算答：烃类混合物可以近似看作是理想混合物，于是在汽液平衡基本表达式中的1=i γ，i v i φφ=ˆ，在压力不高的情况下，Ponding 因子近似为1，于是，汽液平衡表达式化简为：visi s i i i idip p x y Kφφ==。

国家开放大学电大本科《岩土力学》2023-2024期末试题及答案（试卷代号：1181）一、单项选择题（每小题3分，共30分。

在所列备选项中，选1项正确的或最好的作为答案，将选项号填入各题的括号中）1.关于土的灵敏度，下面说法正确的是（）oA.灵敏度越大，表明土的结构性越强B.灵敏度越小，表明土的结构性越强C.灵敏度越大，表明土的强度越高D.灵敏度越小，表明土的强度越高2.土中附加应力起算点位置为（）oA.天然地B.基础底而C.室外设计地面D.室内设计地面3.地下水位上升将使土中自重应力减小的土层位置是（）0A.原水位以下Bo变动后水位以下C.不透水层以下D.变动后水位以上4.通过直剪试验得到的土体抗四强度线与水平线的夹角为（）0A.内摩擦角Bo有效内摩擦角C.粘聚力D.有效粘聚力5.下列哪个选项不属于朗肯土压力的基本假定（）。

A.挡土墙是刚性的，墙背垂直B.挡土墙的墙后填土表而水平C.滑动楔体整体处于极限平衡状态D.挡土墙的墙背光滑，不考虑墙背与填土之间的摩擦力6.土中某一点发生剪切破坏时，破裂而与大主应力作用面的夹角是（）。

A.45°B.45° +q>c. 45° -号D. 45° + 告7.岩坡的破坏类型从形态上来看可分为（）A.岩崩和岩滑B.平而滑动和旋转滑动C.平而滑动和楔形滑动D.楔形滑动和旋转滑动8.下列关于岩石初始应力的描述中，哪个是正确的（）。

A.垂直应力一定大于水平应力B.构造应力以水平应力为主C.自重应力以压应力为主，亦可能有拉应力D.自重应力和构造应力分布范围基本- -致9.设置截渗墙的目的是（）。

A.加快排水B.减缓排水C.改善岩基的整体性D.阻止水的渗透10.均质黏性土沿墙高为H的挡土墙上的主动土压力分布图为（）。

A.矩形B.三角形（高度二H）C.梯形D.三角形（高度《）二、判断题（每小题2分，共20分。

判断以下说法的正误，并在各题后的括号内进行标注。