当前位置:文档之家› 二级VF机试真题2011年3月

二级VF机试真题2011年3月

二级VF机试真题2011年3月
二级VF机试真题2011年3月

[真题] 二级VF机试真题2011年3月

一、基本操作题

第1题:

(1)将数据库“农场管理”中的表“职工”移出,使之成为自由表。

(2)为表“农场信息”增加字段“地址”,类型和宽度为字符型(10)。

(3)设置表“农场信息”的字段“地址”的默认值为“内蒙古”。

(4)为表“农场信息”插入一条记录("002","草原牧场","内蒙古")。______ 参考答案:

(1)步骤1:单击工具栏的[打开]按钮,在弹出的[打开]对话框中选择“农场管理.dbc”,单击[确定]按钮,打开数据库设计器。步骤2:在数据库设计器中,右击表“职工”,选择“删除”命令,在弹出的对话框中单击[移去]按钮。 (2)步骤1:在[数据库设计器]中,右击表“农场信息”,选择“修改”命令,打开表设计器。步骤2:在[表设计器]中,单击[字段]选项卡,单击最后一行,输入字段名“地址”,“类型”为“字符型”,“宽度”为“10”。 (3)在[字段有效性]的[默认值]文本框中输入“内蒙古”,单击[确定]按钮。 (4)在命令窗口中输入命令:INSERT INTO 农场信息 VALUES("002","草原牧场","内蒙古"),回车执行。

本题主要考查的知识点有:从数据库中移除表,修改表结构,INSERT语句等的基本操作。

二、简单应用题

第2题:

(1)将order list1表中的记录追加到order list表中,用SQL SELECT语句完成查询,按总金额降序列出所有客户的客户号、客户名及其订单号和总金额,结果存到results表中(客户号、客户名取自customer表,订单号、总金额来自order list表)。

(2)打开form1,修改表单,有5个表单中随机排列的命令按钮,不要移动或改变“基准按钮”的位置,然后让其他命令按钮与“基准按钮”左对齐。

在这组命令按钮的右边添加一个表格控件,并将它的“recordsourcetype”属性设置为“表”,再设置另一个相关属性使之在表格控件中显示“customer”的内容。________

参考答案:

(1)单击工具栏的[打开]按钮,在[打开]对话框中选择“order_list.dbt”,单击[确定]按钮。在命令窗口输入“APPEND FROM order_list1”,把order list1中的全部记录添加到表order list中。由于查询的信息来自于两个表,故应在两个表之间按照客户号相等建立连接。排序可用Order by子句来实现,使用DESC 关键词表示降序。结果保存在表中,可使用INTO子句。参考命令如下: SELECT Customer_a.客户号,Customer_a.客户名,Order_list.订单号,Order_list.总金额; FROM 订货管理. Order_list,customer Customer_a; WHERE Order_list.客户号=Customer_a.客户号; ORDER BY Order_list.总金额 DESC; INTO TABLE results (2)步骤1:单击工具栏的[打开]按钮,在[打开]对话框的[文件类型]列表框中选择“表单”,选择表单文件“form1.scx”后,单击[确定]按钮,将

在表单设计器中打开该表单。在表单设计器中选中这5个按钮(选中第1个按钮后,按住Shift键再一一单击其他按钮),在菜单栏选择[显示]→[布局工具栏],单击[布局]工具栏中的左边对齐按钮。步骤2:右击表单选择“数据环境”,在[添加表或视图]对话框中选择“customer”,单击[添加]按钮,再单击[关闭]按钮。步骤3:单击[表单控件]窗口中的“表格”控件,在表单中单击[添加]表格控件。拖动表格控件放置在表单的相应位置,在[属性]窗口中设置“RecordSourceType”为“0-表”,设置“RecordSource”属性为“customer”。

本题主要考查的知识点有:修改表单、、控件的对齐方式、表格控件的应用,以及SQL语言的应用,其中SQL语言的运用是重点,也是难点。

三、综合应用题

第3题:

现有数据库hospital,包括3个表文件:doctor.dbf(医生)、

medicine.dbf(药品)和formula.dbf。(处方)。设计一个名为cx的菜单,菜单中有两个菜单项:“查询”和“退出”。

程序运行时,单击“查询”应完成下列操作:查询同一处方中,包含“感冒”两个字的药品的处方号、药名和生产厂,以及医生的姓名和年龄,把查询结果按处方号升序排序存入result表中。result的结构为(姓名,年龄,处方号,药名,生产厂)。

单击“退出”菜单项,程序终止运行。(注:相关资料表文件存在于考生文件夹下。)______

参考答案:

步骤1:单击工具栏的[新建]按钮,打开[新建]对话框,在[文件类型]区选择“菜单”,单击[新建文件]。打开菜单设计器,在“菜单名称”中输入“查询”,在“结果”下拉列表框中选择“过程”,单击下一行,在“菜单名称”中输入“退出”,在“结果”下拉列表框中选择“过程”,在右边的文本框中编写命令“SET SYSMENU TO DEFAULT”。步骤2:在菜单设计器中,单击选定菜单名称下刚创建的“查询”行,单击[创建]按钮,在弹出的文本框中输入以下代码。 SET TALK OFF SET SAFETY OFF OPEN DATABASE hospital SELECT 姓名,年龄,处方号,药名,生产厂 INTO TABLE result FROM; doctor,medicine,formula WHERE doctor.医生编号=formula.医生编号 AND medicine.药品编号=formula.;药品编号 AND 药品名称 like "%感冒%" ORDER BY 处方号 CLOSE ALL SET SAFETY ON SET TALK ON 步骤3:单击工具栏的[保存]按钮,打开[另存为]对话框,输入“cx”,单击[保存]。选择[菜单]→[生成],在[生成菜单]对话框中输入“cx”,单击[生成]按钮。单击工具栏的[运行]按钮,运行菜单。步骤4:执行“查询”菜单命令后,系统自动将查询结果保存在所建立的新数据表文件“result.dbf”中。

本题主要考查的知识点有:菜单的设计及菜单过程的建立,利用SQL语句进行多表的联接查询,用INTO TABLE语句将查询结果写入新表。

2011年12月大学六级真题+听力原文+答案详解

2011年12月大学英语六级真题 Part I Writing (30 minutes) Directions:For this part, you are allowed 30 minutes to write a short essay entitled The Way to Success by commenting on Abraham Lincoln's famous remark, "Give me six hours to chop down a tree, and I will spend, the first four sharpening the axe." You should write at least 150 words but no more than 200 words. The Way to Success 注意:此部分试题请在答题卡1上作答。 Part II Reading Comprehension (Skimming and Scanning) (15 minutes) Directions:In this part, you will have 15 minutes to go over the passage quickly and answer thequestions on Answer Sheet 1. For questions 1-7, choose the best answer from the four choices marked A), B), C) and D). For questions 8-10, complete the sentences with the information given in the passage. Google's Plan for World's Biggest Online Library: Philanthropy Or Act of Piracy? In recent years, teams of workers dispatched by Google have been working hard to make digital copies of books. So far, Google has scanned more than 10 million titles from libraries in America and Europe - including half a million volumes held by the Bodleian in Oxford. The exact method it uses is unclear; the company does not allow outsiders to observe the process. Why is Google undertaking such a venture? Why is it even interested in all those out-of-printlibrary books, most of which have been gathering dust on forgotten shelves for decades? Thecompany claims its motives are essentially public-spirited. Its overall mission, after all, is to "organise the world's information", so it would be odd if that information did not include books. The company likes to present itself as having lofty aspirations. "This really isn't about making money. We are doing this for the good of society." As Santiago de la Mora, head of Google Books for Europe, puts it: "By making it possible to search the millions of books that exist today, we hope to expand the frontiers of human knowledge." Dan Clancy, the chief architect of Google Books, does seem genuine in his conviction that thisis primarily a philanthropic (慈善的) exercise. "Google's core business is search and find, soobviously what helps improve Google's search engine is good for Google," he says. "But we havenever built a spreadsheet (电子数据表) outlining the financial benefits of this, and I have neverhad to justify the amount I am spending to the company's founders." It is easy, talking to Clancy and his colleagues, to be swept along by their missionary passion. But Google's book-scanning project is proving controversial. Several opponents have recently emerged, ranging from rival tech giants such as Microsoft and Amazon to small bodies representing authors and publishers across the world. In broad terms, these opponents have levelled two sets of criticisms at Google. First, they have questioned whether the primary responsibility for digitally archiving the world's books should be allowed to fall to a commercial company. In a recent essay in the New

《全国计算机等级考试二级VFP》模拟试题

全国计算机等级考试二级VFP模拟试题(一) (1)数据的存储结构是指()。 A)存储在外存中的数据 B)数据所占的存储空间量 C)数据在计算机中的顺序存储方式 D)数据的逻辑结构在计算机中的表示 D:【解析】在对数据进行处理时,各数据元素在计算机中的存储关系,即为数据的存储结构。 (2)下列关于栈的描述中错误的是()。 A)栈是先进后出的线性表 B)栈只能顺序存储 C)栈具有记忆作用 D)对栈的插入与删除操作中,不需要改变栈底指针 B:【解析】栈是限定在一端进行插入与删除的线性表。栈顶(top):插入数据(即入栈)的一端;栈底(bottom):不能入栈也不能出栈的一端。栈存储数据的原则:"先进后出"或"后进先出"。栈的特性是具有记忆作用。 (3)对于长度为n的线性表,在最坏情况下,下列各排序法所对应的比较次数中正确的是()。 A)冒泡排序为n/2 B)冒泡排序为n C)快速排序为n D)快速排序为n(n-1)/2 D:【解析】假设线性表的长度为n,则在最坏情况下,冒泡排序需要经过n/2遍的从前往后的扫描和n/2遍的从后往前的扫描,需要的比较次数为n(n-1)/2。快速排序法也是一种互换类的排序方法,但由于它比冒泡排序法的速度快,因此,称为快速排序法。 (4)对长度为n的线性表进行顺序查找,在最坏情况下所需要的比较次数为()。A)log2n B)n/2 C)n D)n+1

C:【解析】在进行顺序查找过程中,如果被查的元素是线性表中的最后一个元素,或者被查元素根本不在线性表中,则为了查找这个元素需要与线性表中的所有元素进行比较,这是顺序查找的最坏情况,需要比较的次数为n次。 (5)下列对于线性链表的描述中正确的是()。 A)存储空间不一定连续,且各元素的存储顺序是任意的 B)存储空间不一定连续,且前件元素一定存储在后件元素的前面 C)存储空间必须连续,且前件元素一定存储在后件元素的前面 D)存储空间必须连续,且各元素的存储顺序是任意的 A:【解析】一般来说,在线性表的链式存储结构中,各数据结点的存储序号是不连续的,并且各结点在存储空间中的位置关系与逻辑关系也不一致。在线性链表中,各数据元素之间的前后件关系是由各结点的指针域来指示的,指向线性表中第一个结点的指针head称为头指针,当head=NULL(或0)时称为空表。 (6)下列对于软件测试的描述中正确的是()。 A)软件测试的目的是证明程序是否正确 B)软件测试的目的是使程序运行结果正确 C)软件测试的目的是尽可能多地发现程序中的错误 D)软件测试的目的是使程序符合结构化原则 C:【解析】软件测试是为了发现错误而执行程序的过程。一个好的测试用例是指很可能找到迄今为止尚未发现的错误的用例;一个成功的测试是发现了至今尚未发现的错误的测试。软件测试的目的要以查找错误为中心,而不是为了演示软件的正确功能。 (7)为了使模块尽可能独立,要求()。 A)模块的内聚程度要尽量高,且各模块间的耦合程度要尽量强 B)模块的内聚程度要尽量高,且各模块间的耦合程度要尽量弱 C)模块的内聚程度要尽量低,且各模块间的耦合程度要尽量弱 D)模块的内聚程度要尽量低,且各模块间的耦合程度要尽量强 B:【解析】模块的独立性是指,每个模块只完成系统要求的独立的子功能,并且与其他模块的联系最少且接口简单。模块的独立程度是评价设计好坏的重要度量标准。衡量软件的模块独立性使用耦合性和内聚性两个定性的度量标准,两者是相互联系的。一般较优秀的软件设计,应尽量做到高内聚、低耦合,即减弱模块之间的耦合性和提高模块内的内聚性,有利于提高模块的独立性。

2019年12月大学英语四级考试真题完整版(第一套)

Part I Writing (30 minutes) Directions: For this part, you are allowed 30 minutes to write a letter to a foreign friend who wants to learn Chinese. Please recommend a university to him. You should write at least 120 words but no more than 180 words. Part II Listening Comprehension (25 minutes) Section A Directions: In this section, you will hear three news reports. At the end of each news report, you will hear two or three questions. Both the news report 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 1 with a single line through the centre. Questions I and 2 are based on the news report you have just heard. 1.A)Many facilities were destroyed by a wandering cow. B) A wandering cow knocked down one of its fences. C)Some tourists were injured by a wandering cow. D) A wandering cow was captured by the police. 2.A) It was shot to death by a police officer. B)It found its way back to the park' s zoo. C)It became a great attraction for tourists. D)It was sent to the animal control department. Questions 3 and 4 are based on the news report you have just heard. 3.A) It is the largest of its kind. B)It is going to be expanded. C)It is displaying more fossil specimens. D)It is staring an online exhibition. 4.AJA collection of bird fossils from Australia. B)Photographs of certain rare fossil exhibits. C)Some ancient wall paintings from Australia. D)Pictures by winners of a wildlife photo contest. Questions 5 to 7 are based on the news report you have just heard. 5.A) Pick up trash. B)Amuse visitors. C)Deliver messages. D)Play with children. 6.A) They are especially intelligent. 8)They are children' s favorite. C They are quite easy to tame. D) They are clean and pretty. 7.A) Children may be harmed by the rooks. B)Children may be tempted to drop litter. C)Children may contract bird diseases.

2011年12月大学英语六级真题答案

2011年12月大学英语六级真题答案 快速阅读 1. Google claims its plan for the world’s biggest online library is _____ 【答案】B. to serve the interest of the general public【解析】该题问的是Google 所声称的自己图书馆计划的目的。根据顺序原则该题靠前,同时注意到第三段开头连续并列why,提示第三段很有可能提到原因或目的。用claim定位至第三段第三句,该句motive 引出后面Google声称的原因是“本质上被公众精神驱动”,三段末更提到是为了所有人的知识需求。核心名词public及句意都对应B选项。 2. According to Santiago de la Mora, Google’s book-scanning project will 【答案】B. broaden humanity’s intellectual horizons【解析】该题问的是Santiago de la Mora对Google图书扫面项目的看法。用人名可定位至四段中,之后该人提到Goo gle该项目能expand the frontiers of human knowledge,即拓广人类知识的范围。对应B选项。核心名词knowledge被改为同义词intellectual,frontier被同义替换为horizon,动词expand被同义替换为broaden。 3. Opponents of Google Books believe that digitally archiving the world's books should be controlledby_______. 【答案】C. non-profit organizations【解析】该题问的是反对Google的人对数字知识控制者的看法。用opponents可定位至第7段前后,control可进一步定位至第八段最后R obert Darnton的观点。该人认为只有public, not-for-profit bodies 可以有控制数字知识的权利,对应C选项。Bodies被同义替换为organization。 4.【答案】D. the copyright of the books it scanned【解析】该题问的是Google卷入官司的原因。由legal battle可定位至第9段前后,用之后第10段短首出现的however

全国计算机等级考试二级VFP模拟试题及答案

全国计算机等级考试二级VFP模拟试卷考试及答案 第一项:单项选择题答案见最后 1、下面关于运行应用程序的说法,正确的是 A)APP应用程序可以在Visual FoxPro和Windows环境下运行 B)EXE应用程序只能在Windows环境下运行 C)EXE应用程序可以在Visual FoxPro和Windows环境下运行 D)APP应用程序只能在Windows环境下运行 2、调用报表格式文件pp1预览报表的命令是 A)REPORT FROM PP1 PREVIEW B)DO FROM PP1 PREVIEW C)REPORT FORM PP1 PREVIEW D)DO FORM PP1 PREVIEW 3、报表的数据源可以是 A)自由表或其他报表 B)数据库表、自由表或视图 C)数据库表、自由表或查询 D)表、查询或视图 4、确定列表框内的某个条目是否被选定应使用的属性是 A)Value B)ColumnCount C)ListCount D)Selected 5、在Visual FoxPro中,为了将表单从内存中释放(清除),可将表单中退出命令按钮的Click事件代码设置为 A)Thisform.Refresh B)Thisform.Delete C)Thisform.Hide D)Thisform.release 6、在Visual FoxPro中,控件分为 A)容器类和控件类 B)控件类和基类 C)容器类和基类 D)控件类的基础类 7、在Visual FoxPro中,扩展名为.DBC的文件是 A)数据库表文件 B)表单文件 C)项目文件 D)数据库文件 8、在下面Visual FoxPro表达式中,运算结果为字符串的是

2011年12月英语四级真题及答案详解

作文: Nothing succeeds without a strong will There is a prevalent joke around young people saying that ‘quitting smoking is the easiest thing in the world, and I’ve done it for hundreds of times.’ This seemingly funny statement ironically reflects the fact that the determination of most youngsters is oftentimes started with enthusiasm, but the passion becomes increasingly weaker each day, and then diminishes as if there has been no such thing at all. It is obvious that their failure in ‘quitting smoking’ and decline of determination are all ascribed to their lack of will. Initially, every success involves several stages of setbacks and risks, and we need to summon up our will to conquer them. Moreover, there are enormous temptation in our path of pursuit of success. For instance, when we plan to quit smoking, our roommates may smoke freely in front of us; when we are eager to keep fit, our close friends may invite us to have late night snacks. Under these occasions, only strong will can assist us to resist the temptation, and persist in chasing our goals until we triumphantly realize them. In short, no dream will successfully come true if we do not have strong will. An old famous proverb says that ‘ where there is a will, there is a way’. Let us bear this motton in mind no matter how many thunders and thorns are on our roads ahead, then we will be successful with such precious and powerful spirit. [快速阅读] 快速阅读 1. A person of integrity not only sets high moral and ethical standards but also _______. A) sticks to them in their daily life B) makes them known to others C) understands their true values D)sees that others also follow them 选择sticks to them in their daily life 定位在原文第一段,文中说正直(integrity)的关键是一致性(consistency),不仅要有很多道德和伦理的准则,还要每天都坚守。 2. What role does integrity play in personal and professional relationships? A) It helps to create team spirit B) It facilitates communication C) It is the basis of mutual trust D) It inspires mutual respect 选择It is the basis of mutual trust.

2011年12月英语六级(CET6)真题

1)现在很多年轻人每个月都把自己赚的钱花光,他们被称作“月光族” 2)有人认为这是一种时尚的消费观念,但很多人反对这样消费 3)我对此的看法是…… 【参考范文】 The Moonlight Clan Nowadays, more and more people, especially the young are joining in the army of “the moonlight clan”. These people exhaust their earnings every month without any savings. Many people think this is a fashionable life style, while other people object to this kind of consumption style. Those who support “the moonlight clan”think that “the moonlight clan”knows how to enjoy life and have a higher life quality. However, other people criticize “the moonlight clan”. They say that the consumption habit of “the moonlight clan”is unhealthy and sometimes wasteful. In addition, no savings will place “the moonlight clan” in a difficult position in case of unexpected expenses. Weighing these two arguments, I prefer the latter one. In my eyes, though “the moonlight clan”may acquire temporary satisfaction from their consumption, in the long term, it is unfavorable to their family and career. Just as a proverb says, one should always prepare for a rainy day. 1)近来,许多经典名著被改写成各种版本以供大众娱乐 2)这种现象产生的原因 3)改写经典名著可能产生的问题 【参考范文】 The Adaptation of the Classics Nowadays many classics are being adapted in many ways, which has aroused great concern. In those adapted works, all plots are changed and all characters become somewhat watered down. In addition, some familiar characters in the classics have been distorted. There are many reasons accounting for this phenomenon. Among all these reasons, readers’preference plays a critical role. Moreover, the concept of creativity is prevailing in every aspect. Besides, the improved living standard enables people to pursue and enjoy more choices of entertainments including the adaptations of the classics. All these above reasons contribute to the adaptation of the classics. As far as I am concerned, the adaptation of the classics does more harm than good. For one thing, since the classical literature is the representation of the outstanding art of China, the act of adapting may ruin its charm. For another, those adapted works may confuse with history. Therefore, the real classics should be presented on the bookshelves to lead people to appreciate the real art. 1)近几年兴起了一股报考国家公务员的热潮 2)分析产生这一现象的原因 3)你对此的看法是…… 【参考范文】 Test for National Civil Servants In recent years, there are more and more people who have participated in the test for national civil servants. Millions of students choose civil servant as their most ideal occupation after

2011年12月英语六级全真预测试题及答案解析

之 2011年12月大学英语六级全真预测试题及答案解析

2011年12月英语六级全真预测试题及答案解析 一、阅读理解 第1题: Occasional self-medication has always been part of normal living. The making and selling of drugs have a long history and are closely linked, like medical practice itself, with the belief in magic. Only during the last hundred years or so has the development of scientific techniques made it possible for some of the causes of symptoms to be understood, so that more accurate diagnosis has become possible. The doctor is now able to follow up the correct diagnosis of many illnesses with specific treatment of their causes. In many other illnesses, of which the causes remain unknown, it is still limited, like the unqualified prescriber, to the treatment of symptoms. The doctor is trained to decide when to treat symptoms only and when to attack the cause: this is the essential difference between medical prescribing and self-medication. The advance of technology has brought about much progress in some fields of medicine, including the development of scientific drug therapy. In many countries public health organization is improving and people's nutritional standards have risen. Parallel with such beneficial trends have two adverse effects. One is the use of high-pressure advertising by the pharmaceutical industry, which has tended to influence both patients and doctors and has led to the overuse of drugs generally. The other is the emergence of the sedentary society with its faulty ways of life: lack of exercise, over-eating, unsuitable eating, insufficient sleep, excessive smoking and drinking. People with disorders arising from faulty habits such as these, as well as from unhappy human relationships, often resort to self-medication and so add the taking of pharmaceuticals to the list. Advertisers go to great lengths to catch this market. Clever advertising, aimed at chronic sufferers who will try anything because doctors have not been able to cure them, can induce such faith in a preparation, particularly if steeply priced, that it will produce—by suggestion—a very real effect in some people. Advertisements are also aimed at people suffering from mild complaints such as simple colds and coughs, which clear up by themselves within a short time. These are the main reasons why laxatives, indigestion remedies, painkillers, tonics, vitamin and iron tablets and many other preparations are found in quantity in many households. It is doubtful whether taking these things ever improves a person's health; it may even make it worse. Worse because the preparation may contain unsuitable ingredients; worse because the taker may become dependent on them; worse because they might be taken in excess; worse because they may cause poisoning, and worse of all because symptoms of some serious underlying cause may be masked and therefore medical help may not be sought. 1. The first paragraph is intended to ________. [A] suggest that self-medication has a long history [B] define what diagnosis means exactly [C] praise doctors for their expertise [D] tell the symptoms from the causes

2017年计算机二级《VFP》考试题及答案

2017年计算机二级《VFP》考试题及答案 1). 如下描述中正确的是:( ) A.数据库中仅存储数据 B.数据库管理系统是数据库集合的组成部分 C.数据库中的数据具有很高的冗余并缺乏数据独立性 D.数据库管理系统是为数据库的建立、使用和维护而配置的软件 正确答案:D 答案解析:数据库是存储在计算机存储设备上的结构化的相关数据集合。它不仅包括描述事物的数据本身,而且还包括相关事物之间的联系。数据库管理系统是为数据库的建立、使用和维护而配置的软件,数据库系统的特点有:实现数据共享,减少数据冗余;采用特定的数据模型;具有较高的数据独立性;有统一的数据控制功能。 2). 某二叉树共有7个结点,其中叶子结点只有1个,则该二叉树的深度为(假设根结点在第1层)( )。 A.3 B.4 C.6 D.7 正确答案:D 答案解析:根据二叉树的基本性质3:在任意一棵二叉树中,度为O的叶子结点总比度为2的结点多一个,所以本题中度为2的结点为1-1=0个,所以知道本题目中的二叉树的每一个结点都有一个分支,所以共7个结点,共7层,即深度为7。 3). 下面不属于软件需求分析阶段主要工作的是( ) A.需求变更申请 B.需求分析 C.需求评审

D.需求获取 正确答案:A 答案解析:需求分析阶段的工作可概括为4个方面:①需求获取。②需求分析。③编写需求规格说明书。④需求审评。 4). 对于查询输出到临时表中的叙述,下列说法错误的是( ) A.产生的临时表文件的后缀名仍为.dbf B.执行查询后,该临时表文件是当前文件 C.可以像一般的dbf文件一样使用,可查询和修改表中记录 D.当关闭文件时,临时表文件将自动被删除 正确答案:C 5). “教师表”中有“职工号”、“姓名”和“工龄”等字段,其中“职工号”为主关键字,建立“教师表”的SQL命令是( )。 A.CREATETABLE教师表(职工号C(10)PRIMARY,姓名C(20),工龄I) B.CREATETABLE教师表(职工号C(10)FOREIGN,姓名C(20),工龄I) C.CREATETABLE教师表(职工号C(10)FOREIGNKEY,姓名C(20),工龄I) D.CREATETABLE教师表(职工号C(10)PRIMARYKEY,姓名C(20),工龄I) 正确答案:D 答案解析:在VisualFoxPro中,可以通过SQL的CREATETABLE命令建立表,PRIMARYKEY用来设置主关键字。本题“职工号”为主关键字,因此D选项正确。 6). 有A、B、C三个数据表,若已建立了A->B的关联,需要再建立B->C的关联,形成A->B->C的关联,则( ) A.必须使用带ADDITIVE子句的SETRELATION命令 B.直接利用SETRELATION命令进行关联 C.在保持A->B关联的基础上不能再建立B->C关联 D.在保持A->B关联的基础上不能在建立的B->C关联,但可以建立A->C关联

2011年12月英语四级真题及答案

2011年12月英语四级真题 Part Ⅰ Writing (30 minutes) 注意:此部分试题在答题卡1上. For this part, you are allowed 30 minutes to write a short essay entitled Nothing Succeeds Without a Strong Will by commenting on the humorous saying, "Quitting smoking is the easiest thing in the world. I've done it hundreds of times." You should write at least 120 words but no more than 180 words. Part II Reading Comprehension (Skimming and Scanning) Why Integrity Matters What is Integrity? The key to integrity is consistency--not only setting high personal standards for oneself (honesty, responsibility, respect for others, fairness) but also living up to those standards each day. One who has integrity is bound by and follows moral and ethical standards even when making life's hard choices, choices which may be clouded by stress, pressure to succeed, or temptation. What happens if we lie, cheat, steal, or violate other ethical standards? We feel disappointed in ourselves and ashamed. But a lapse of integrity also affects our relationships with others. Trust is essential in any important relationship, whether personal or professional. Who can trust someone who is dishonest or unfair? Thus, integrity must be one of our most important goals. Risky Business We are each responsible for our own decisions, even if the decision-making process has been undermined by stress or peer pressure. The real test of character is whether we can learn from our mistake, by understanding why we acted as we did, and then exploring ways to avoid similar problems in the future. Making ethical decisions is a critical part of avoiding future problems. We must learn to recognize risks, because if we can't see the risks we're taking, we can't make responsible choices. To identify risks, we need to know the rules and be aware of the facts. For example, one who doesn't know the rules about plagiarism may accidentally use words or ideas without giving proper credit, or one who fails to keep careful research notes may unintentionally fail to quote and cite sources as required. But the fact that such a violation is "unintentional" does not excuse the misconduct. Ignorance is not a defense. "But Everybody Does It" Most people who get in trouble do know the rules and facts, but manage to fool themselves about the risks they're taking by using excuses: "Everyone else does it," "I'm not hurting anyone," or "I really need this grade." Excuses can get very elaborate: "I know I'm looking at another's exam, even though I'm supposed to keep my eyes on my own paper, but that's not cheating because I'm just checking my answers, not copying." We must be honest about our actions, and avoid excuses. If we fool ourselves into believing we're not doing anything wrong, we can't see the real choice we're making--and that leads to bad decisions. To avoid fooling yourself, watch out for excuses and try this test: Ask how you would feel if your actions were public, and anyone could be watching over your shoulder. Would you feel proud or ashamed of your actions? If you'd rather hide your actions, that's a good indication that you're taking a risk and rationalizing it to yourself.

相关主题
文本预览
相关文档 最新文档