问题 问答题

请在下建立一个项目wy。
(2)将考生文件夹下的数据库ks4加入到新建的项目wy中去。
(3)利用视图设计器在数据库中建立视图view_1,视图包括Sjhy表的全部字段(顺序同gjhy中的字段)和全部记录。
(4)从表hjqk中查询“奖级”为一等的学生的全部信息(hjqk表的全部字段),并按分数的降序在入新表newl中。

答案

参考答案:启动Visual FoxPro后,在命令窗口输入命令:CREATE PROJECT wy,新建一个项目管理器。
(2)在项目管理器wy中,单击“数据”选项卡,然后选中列表框中的“数据库”,单击选项卡右边的“添加”命令按钮,系统弹出“打开”对话框,将考生文件下的ks4数据库文件添加到项目管理器中。
(3)在“数据”选项卡中,依次展开“数据库”—“ks4”,选中ks4分支下的“本地视图”,单击项目管理器右边的“新建”命令按钮,在弹出的“新建本地视图”对话框中,单击“新建视图”按钮,打开视图设计器,将gjhy数据表添加到视图设计器中。根据题意,在视图设计器的“字段”选项卡中,将“可用字段”列表框中的字段全部添加到右边的“选定字段”列表框中,完成视图设计,将视图以view_l文件名保存在考生文件夹下。
(4)在“数据”选项卡中选中“查询”,然后单击“新建”命令按钮,单击“新建查询”对话框中的“新建查询”按钮,打开查询设计器,将数据表hjqk添加到查询设计器中。根据题意,在查询设计器的“字段”选项卡中,将“可用字段”列表框中的字段全部添加到右边的“选定字段”列表框中;单击“筛选”选项卡,在“字段名”下拉框中选择“hjqk.奖级”字段,在“条件”下拉框中选择“=”,在“实例”文本框中输入“一等”:在“排序依据”选项卡中将“选定字段”列表框中的“hjqk.分数”字段添加到右
边的“排序条件”中,在“排序选项”中选择“降序”,最后通过菜单命令“查询”—“查询去向”,打开“查询去向”对话框,在对话框中选择“表”,在“表名”文本框中输入用来保存查询结果的数据表文件名 newl。利用菜单命令“查询”—“运行查询”,系统将自动保存查询结果到数据表newl中。

解析: 本大题考查的主要是项目管理器中“数据”选项卡里面所包含的3个重要内容的设计,包括数据库、视图和查询,需要注意的是新建视图文件时,首先应该打开相应的数据库,且视图文件在磁盘中是找不到的,直接保存在数据库中。
答案考生文件夹

单项选择题
单项选择题

The collapse of Enron, the largest bankruptcy in American history, has rung out a banner year for American business failures. In Europe, the fallout from the Swissair and Sabena insolvencies continues. In the current global slump, more companies are likely to go under. Now is a perfect time to reconsider how to handle such failures: let them sink, or give them a chance to swim

In America, bankruptcy has come to mean a second chance for bust businesses. The famous "Chapter 11" law aims to give a company time to get back on its feet, by shielding it from debt payments and prodding banks to negotiate with their debtor. It even allows an insolvent company to receive fresh finance after it goes bust. On the other side of the Atlantic, when companies stumble, almost as much effort is spent in fingering the guilty as in trying to salvage a viable business. British and French laws, for example, can make a failing company’s directors face criminal penalties and personal liability. Moreover, bankers have the power, at the first sign of trouble, to push a company into the arms of the receivers. Some modest changes are afoot, however. Britain is considering moves that would bring its rules closer to America’s. New laws in Germany should also make it easier to revive sick companies, although trade unions still have their say.

But even with the arrival of the euro and moves towards a single financial market, going bust in Europe is a strictly local affair. Long before America had a single currency, the American constitution provided uniform bankruptcy laws, observes Elizabeth Warren of the Harvard Law School. Europe’s patchwork of national laws, according to Bill Brandt of " Development Specialists", a consultancy, inhibits lending and makes it difficult to fix ailing firms.

Transatlantic insolvencies are even harder, as a Belgian-based software company, Lernout and Hauspie, discovered this year. Its American reorganization plan was thwarted by a Belgian judge, who ordered a sale of the firm’s assets. As the European Union inches toward greater harmonization, should it try to mimic America

Critics of Chapter 11 think not. They argue that America’s bankruptcy system is wasteful, lets failed managers go unpunished, and gives some companies an unfair advantage. In Chapter 11, admittedly, lawyers and advisers gobble up fees, but a recent study argues that the fees are no larger than those for most mergers and acquisitions. One common complaint, that managers enjoy the high life while creditors go begging, fails to stand up to the data from America’s previous wave of bankruptcies in the early 1990s. Stuart Gilson of the Harvard Business School found that more than two-thirds of top managers were ousted within two years of a bankruptcy filing. More troubling is that some American firms seem to enjoy second and third trips to bankruptcy court, cheekily termed Chapters 22 and 33. Some see this as evidence that, ton often, they use Chapter 11 to keep running. But there is more to the story.

The last paragraph is mainly()

A. to accuse the lawyers and advisers of making big money by helping those insolvent companies

B. to introduce the changes of the bankruptcy law—Chapter 11

C. to prove the accusation is groundless that the managers of bust businesses lead a comfortable life at the cost of creditors

D. to argue that the European Union should not follow the American example in their effort to revive sick companies