问题 问答题

在考生文件夹下有仓库数据库gz3,其中包括如下两个表文件: zg(仓库号C(4),职工号C(4),工资N(4)) dgd(职工号C(4),供应商号C(4),订购单号C(4),订购日期D,总金额N(10)) 首先在gz3库中建立工资文件数据表gj(职工号C(4),工资N(4))。设计一个名为chaxun的菜单,菜单中有两个菜单项“查询”和“退出”。程序运行时,单击“查洵”应完成下列操作:检索出与供应商S7、S4和S6都有业务联系的职工的职工号和工资,并按工资降序存放到所建立的gj文件中。单击“退出”单项,程序终止运行。 (注:相关数据表文件存在于考生文件夹下)

答案

参考答案:

解析:在命令窗口输入命令:MODIFY DATABASE gz3,打开数据库设计器,右击数据库,选择“新建表”快捷菜单命令,表名为sj保存到考生文件夹下,接着在表设计器中根据题意,设置两个字段的字段名、类型及宽度。 在命令窗口输入命令:CREATE MENU chaxun,系统弹出一个“新建菜单”对话框,在对话框中单击“菜单”图形按钮,进入菜单设计器环境。根据题目要求,首先输入两个主菜单名称“查询”和“退出”,接着在“查询”菜单行的“结果”下拉框中选择“过程”选项,在“退出”菜单行的“结果”下拉框中选择“命令”选项。 单击“查询”菜单行中的“创建”按钮,进入程序设计的编辑窗口,在程序编辑器中输入如下程序段: **********“查询”菜单命令的程序设计********** SELECT DISTINCT zg.职工号,zg.工资FROM zg,dgd; WHERE zg.职工号=dgd.职工号; ANDzg.职工号IN; (SELECT职工号FROM dgd WHERE供应商号="S4"); AND zg.职工号IN(SELECT职工号FROM dgd WHERE供应商号="S6"); AND zg.职工号IN(SELECT职工号FROM dgd WHERE供应商号="S7"); ORDER BY zg.工资DESC; INTO ARRAY arr INSERT INTO gj FROM ARRAY arr ********************************************** 在“退出”菜单项的“命令”文本框中编写程序代码SET SYSMENU TO DEFAULT。 选择菜单命令“菜单”→“生成”,:生成一个菜单文件chaxun.mpr。关闭设计窗口,在命令窗口输入命令:DO CHAXUN.mpr,看到Visual FoxPro的菜单栏被新建的菜单所代替,单击“退出”菜单命令将恢复系统菜单。 执行“查询”菜单命令后,查询结果将保存到gj.dbf表中。 本大题主要考查的是利用SQL中特殊运算符进行多表的连接查询,本题中可使用 IN运算符进行包含查询,将查询结果写入新表时,由于表已经存在于数据库中,因此不能直接使用SQL直接输出到表的短语,但可以将结果先写入数组,然后通过数组将查询结果插入到新表gj中。

选择题
单项选择题

What a difference Kathleen made in my college life! She was confident where I was shaky. She was disciplined while I was wild. She was responsible; I was lazy. We signed up for all of the same classes. I was so impressed with her. She worked with incredible diligence and with such self-assurance. I started to emulate her. I wanted to impress her.
One day the homework assignment was to create an exciting illustration based on a pair of shoes. I was bursting with ideas and ran home and pulled out my favorite pair of antique thrift shop "old-lady shoes." I concentrated and worked and sweated and created a self-perceived masterpiece !
I called Kathleen and bragged that I’d finished the assignment. "What !" she exclaimed. "How could you possibly be finished already " I was so pleased with myself that I asked her if I could run by her apartment and show her my stunning creation. "Sure," she said.
I raced down from my fifth-floor apartment, precious drawing in hand, and headed to her place. When I got there, I held up my paper with such glowing confidence, only to have my swelled cockiness crushed by Kathleen’s reaction:
"Is that the only drawing you did "
"Well, yes," I responded sheepishly. "Why "
"C’mon," she said. "It’s still nice out. Let’s go to Washington Square Park and really do some drawings." I was puzzled; but when she led, I willingly followed.
The whole way to the park, Kathleen animatedly talked about form, content, composition and really studying the subjects. She described the shoes in my drawing as the kind you see on the old women that sit in the park and feed pigeons. Her excitement was contagious,
When we got to the park, she surveyed the scene and chirped, "Over there!" She pointed to a bench that was surrounded by discarded, crumpled paper bags, soda cans and empty cigarette packs. An old woman sitting on the bench had fallen asleep. Kathleen handed me her drawing pad and said, "Here. Now, draw the shoes on that woman! Draw them over and over until you really know what they look like."
I drew and drew. I filled the sketchbook pages. They were the best I’d ever done thus far. Kathleen watched, and I felt fueled by my captive audience. I was showing off! It was such fun.
The next day was the class critique. I felt so proud hanging my drawing up on the wall for all to see. I knew I had drawn an illustration to be proud of. As the class discussion circled the room to my piece, I heard my fellow students say, sensitive, accurate, beautifully stylized. I looked over at Kathleen, and she gave me that wink and loving smile of hers. College was going to be a lot more fun with her around.
And it was. She continually inspired me, laughed with me, sketched with me and went out dancing with me. Our works of art were chosen for special exhibits, and we both made the dean’s list. We wore our caps and gowns together, and a few years later, I was "best woman" at her wedding. Whatever fears I had going into college about not being able to make new friends were gently washed away when I found my special, best friend.
After we obtained our BFA degrees, the world opened up for both of us. Now we are both successful self-employed artists. I work in my lovely Chelsea cooperative apartment that I bought five years ago as a freelance, illustrator, a graphic designer. Kathleen, a sculptor and mural painter. Oops! I gotta run. Kathleen and I are meeting for dinner and a movie.

"Her excitement was contagious" (Paragraph 8 means ______.

A.the speaker was also made excited under her influence

B.her excitement was very emotional

C.her excitement deeply moved the author

D.the speaker was made very happy by her smile