问题 多项选择题

(注:相关资料表文件存在于考生文件夹下)

答案

参考答案:在命令窗口输入命令:CREATE MENU chufangC,系统弹出一个“新建菜单”对话框,在对话框中单击“菜单”按钮,进入菜单设计器环境。根据题目要求,首先输入两个主菜单名称“查询”和“退出”,接着在“查询”菜单行的“结果”下拉列表中选择“过程”选项(用于编写程序),在“退出”菜单行的“结果”下拉列表中选择“命令”选项。
单击“查询”菜单行中的“查询”按钮,进入程序设计的编辑窗口,在命令窗口中输入如下程序段:
*********“查询”菜单命令的程序设计***********
SET TALK OFF
SET SAFETY OFF
SELECT姓名,年龄,处方号,药名,生产厂;
FROM yisheng,yao,chufang;
WHERE chufang.药编号=yao.药编号;
AND chufang.职工号=yisheng.职工号AND药名IN("感冒");
ORDER BY处方号;
INTO TABLE jsI
SELECT * FROM jgI GROUP BY姓名INTO cursor curtable
INSERT INTO jgI(处方号)VALUES(J)
在“退出”菜单项的“命令”文本框中编写程序代码:SET SYSMENU TO DEFAULT。
选择菜单命令“菜单”—“生成”,生成一个菜单文件chufangC.mpr。关闭设计窗口,在命令窗口输入命令:DO chufangC.mpr,看到Visual FoxPro的菜单栏被新建的菜单所代替,单击“退出”菜单命令将恢复系统菜单。
执行“查询”菜单命令后,系统将查询结果自动保存到表jgI.dbf中。

解析: 本大题考查的主要是利用SQL语句进行多表查询,其中只要注意每两个表之间进行的关联字段即可,部分语句可以参考第二大题2小题的设计,最后还要注意的是人数的统计,因为要统计的人数,不是人次数,因此可以通过姓名字段的排序,将排序结果存放到一个临时表中,然后通过COUNT函数统计出人数(此函数不统计相邻的重复出现的数据)。

阅读理解

Having Fun “Growing” and “Stealing”?

Recently, an Internet game has become a new fashion among young office workers and students. People can “farm” on a piece of “land” and “grow”,  “sell” or even “steal” “vegetables”,”flowers”, and “fruits” on the Net. They can earn some e-money and buy more “seeds” , “pets”, and even “houses”.

Joyce interviewed some young people. Here are their opinions.

Harold: I don’t quite understand why they are mad about the childish game. Maybe they are just not confident enough to face the real world.

Allan: I enjoy putting some “bugs” in my friends’ gardens and we’ve become closer because of the game. Having fun together is the most exciting thing about it.

Laura: You know, people in the city are longing for (渴望) the life in the countryside. It reduces my work pressure (压力) ; besides, it gives me the exciting experience of being a “thief ”.

Ivy: Well, it’s just a waste of time. Teenagers playing the game spend so many hours on it that they can not focus on (专注于) their study.

小题1:According to the passage, people can’t       things in this game.

A. grow                  B. borrow                C. steal                         

小题2:Among the people Joyce interviewed,       likes the game while        dislikes the game.

A. Laura; Allan            B. Allan; Harold          C. Ivy; Allan                                                    

小题3:From Laura’s words, we can guess that she is most probably       .

A. a student               B. a thief   C. an office worker          

小题4:Which is NOT the reason why people like the game?

A. They can have fun with friends.

B. The game can relax people and give them a new experience.              

C. They are confident enough to face the real world.

小题5:Where can you find this passage?

A. In a newspaper.    

B. In an advertisement.                          

C. In a science book..

选择题