问题 问答题

1.打开考生文件夹下的数据库College,物理删除该数据库中的temp表,然后将3个自由表“教师表”、“ 课程表”和“学院表”添加到该数据库中。
2.为“课程表”和“教师表”分别建立主索引和普通索引,字段名和索引名均为“课程号”,并为两个表建立一对多的联系。
3.使用SQL语句查询“教师表”中工资大于4500的教师的全部信息,将查询结果按职工号升序排列,查询结果存储到文本文件one.txt中,SQL语句存储于文件two.prg中。
4.使用报表向导为“学院表”创建一个报表three,选择“学院表”的所有字段,其他选项均取默认值。

答案

参考答案:[操作步骤]
(1)打开College数据库,用鼠标右键单击表temp,选择“删除”命令,在弹出的对话框中选择“删除”按钮;用鼠标右键单击数据库设计器空白处,通过快捷菜单中的“添加”命令将自由表“教师表”、“课程表”和“学院表”添加到数据库中。
(2)在数据库设计器中用鼠标右键单击表,通过快捷菜单中的“修改”命令打开表设计器,按要求分别为“课程表”和“教师表”建立主索引和普通索引,在数据库设计器中从主索引拖曳到普通索引以建立两表间的联系。
(3)新建一个程序,写入下列代码。
&&选择查询字段
SELECT*;
&&指定字段来源
FROM教师表;
&&设置查询条件
WHERE教师表.工资>4500;
&&查询结果按职工号升序排列
ORDER BY教师表.职工号;
&&将查询结果存储到one.txt中
TO FILE one.txt
保存程序名为“two.prg”,并单击系统菜单中的运行按钮,运行程序。
(4)通过报表向导新建一个报表,添加“学院表”作为报表的数据源,将所有字段添加到选定字段,最后输入报表名“three”。

解析:[考点] 本大题主要考查的知识点是:从数据库中删除表、向数据库中添加自由表、为表建立索引并建立表间联系、SQL语句的编写以及利用报表向导建立报表。
在数据库设计器中通过鼠标右键单击表完成删除、添加和修改表的操作。新建程序,在程序中完成SQL语句的编写。通过“报表向导”建立报表。

单项选择题

Texans have bursting pride and love attention. They also have a thick streak of shortsighted greed and, even by American standards, a busted disposition to violence. When they hear this sort of criticism they usually ascribe it to the ignorance and jealousy of stuffy Yankees who have not spent enough time in the state to understand it. For such avowedly robust people they are surprisingly sensitive. They hated Edna Ferber’’s novel Giant, which scourged Texan vulgarity, racism and the mores of millionaires, but they bought it in great quantities and packed cinemas to see the film. They would rather be talked about than not, and if you do not talk about them they do it for you.In claiming special qualities for themselves, Texans have had to become reconciled to the fact that a large number of them are not native. In the last century "Gone to Texas" was a commonplace graffito daubed on barns in other states, and in recent years "Gone to Texas" has, figuratively, been written on the front doors of millions of Americans and also Mexicans. In the early 1980s newcomers accounted for nearly two-thirds of the state’’s population increase. But Texans do not believe they are being diluted. They maintain that Texanhood, or Texianism, is a matter of attitude and that Texanic qualities exist in abundance in many Americans, regardless of their birthplace: it is when these people are planted in Texas, and nourished by its atmosphere, that they flower like true Texans. A man may not be born in Texas, which is unfortunate; but he can be born to be Texan.Many Alaskans are urban, young and raising families, here for a while, and trying to make money before moving to somewhere warmer. But many are staying. While most remain in Anchorage and other centers, some set out to build a cabin in the wilderness and live by hunting, trapping and fishing, learning how to skin a muskrat and moose, how to survive terrible weather, how to be truly in tune with the land, taking pleasure in great silence and unpeopled immensity. To settle the frontier the state has a homesteading program, based on the federal Homestead Act of 1864, which was a key event in the opening up of the American west. Hundreds of Alaskans are awarded parcels of wilderness land in an annual lottery and undertake to invest sweat equity, to build a home within three years and clear and cultivate the land within five. Alaskans love reading about Alaska, and two of the most popular books are a manual on log cabin building and a collection of tales about grizzly bears, of which Alaska is a phold. Log cabin life is for the stout-hearted few with the springs of adventure p in them, and these wilderness Alaskans are remarkable. Some are refugees of one kind or another. Several hundred are Vietnam veterans, tortured by their experiences of war and unable to fit into normal urban life, seeking solace in the wilds.

Which of the following statements can best summarize the implications of Paragraph 2

A.Texans are so conceited that they blindly and subjectively consider everything Texan to be inclusively Texan.

B.Texans pride themselves on being superior to other Americans who are not as rich as Texans.

C.Texans thumb down on all non-natives and regard them as being less educated and resourceful.

D.Texans are crude in nature, savage in behavior, and conceited in personality.

单项选择题