VFP练习册(自主练习部分)答案.doc 6页

'VFP练习册(自主练习部分)答案(2008.11.7更新)2.1数据库系统基础知识一、选择题1．A2．C3．C4．A5．D6．C7．C8．B　9．C10．C11．C12．C13．C14．C二、判断题1．X2．V3．V4．V5．X6．X7．V8．X2.2VisualFoxPro操作基础一、选择题1．D2．C3．C4．C5．D二、判断题（正确打√，错误打×）1．×2．√2.3VisualFoxPro的数据及其运算一、选择题1．B2．B3.C4.B5.D6.B7.A8.C9.A10.B11.A12.B13.D14.B15.D16.C17.A18.C19.C20.B21.C22.D23.B24.D25.D26.D27.D28.A29.B30.B31.A32.A33.C34.B35.A36.D37.A38.B39.B40.D41.C42.A43.B44.D45.C46.D47.A48.A49.A50.C51.A52.A二、判断题1.×2.×3.√4.×5.×6.√7.X8.V9.V10.X11.X12.X13.√14.√15.√16.X17.√18.√19.X20.√21.√22.×23.X2.4表的基本操作一、选择题1.A2.A3.C4.D5.D6.B7.C8.B9.B10.D11.B12.C13.A14.C15.D16.B17.D18.D19.B20.A21.C22.B23.A24.C25.B26.B27.C28.C29.D30.C31.C32.B33.C34.C35.B36.A37.A38.C39.A40.B41.B42.B43.D44.A45.B46.B47.A48.C49.A50.C51.B52.B53.A54.D55.C二、判断题 1.V2.X3.X4.V5.V6.X7.X8.V9.V10.X11.V12.V13.X14.X15.V16.V17.X18.V2.5数据库的基本操作一、选择题1.C2.A3.B4.A5.C6.B7.A8.C9.A10.C11.A12.D13.A14.B15.A16.A17.A2.6SQL语言的应用一、选择题1.A2.B3.A4.B5A6.D7.A8.A9.B10.B11.B12.C13.D14.C15.C16.A17.D18.D19.A20.D21.D22.B23.A24.B25.B26.C27.B28.D29.A30.B31.B32.A33.B34.B35.B2.7查询与视图设计一、选择题1.D2.A3.A4.D5.C6.D7.C8.C9.A10.B11.D12.D13.B14.C15.D16.B17.D18.D19.C2.8VisualFoxPro项目管理器一、选择题1.A2.D3.C4.D5.C6.B7.A8.B9.C10.D11.D12.A13.B14.D15.D2.9结构化程序设计一、选择题1.C2.A3.A4.B5.B二、判断题1.X2.V3.V4.V5.V三、程序填空1.①成绩>mx;②记录号=RECNO();③ENDSCAN;④STR(成绩,5,1)或STR(成绩)2.①sUBSTR(T,1,2)(或SUBS(T,1,2));②y=y+’*’3.①学号=A.学号或学号=A->学号;②USESCJ1;③N=N+14.①X1>学分;②SKIP5.①TS=0;②WITHR1,R2,TS;③ABS(R11-R21)6.①USEXB;②TO编号INTOXA;③XB.标志=.T.④ENDIF7.①WITHSHGZ,TAX;②SKIP;③ENDCASE 8.①0;②>=359.①I<=10;②X>MAX;③X=320REPL录取否WITHTENDS*2小题?"录取考生情况表"?"准考证号姓名总分毕业中学录取学校"SCANFOR录取否?准考证号,姓名,A.总分,毕业学校,志愿ENDSSETTALKONCLOSEALLRETURN5．*PRO5.PRGSETTALKOFFCLEASELE1USESTUDENTINDEON学号TAGXH SELE2USESCORESETRELATO学号INTOA SCANIFA.民族<>"汉族"REPL成绩WITH成绩+5,加分否WITHTENDIFENDSCOUNTTOSFOR加分否=TAND成绩>=450CALCMAX(成绩)TOMAXLISTFOR成绩>=600FIEL学号,A.姓名,成绩6．*PRO6.PRG*1小题SETTALKOFFCLEASELE1USEXSDAINDE学号TODAXHSELE2USEXSCJSELE3USEXSKCINDEON课程号TOKCBHSELE2SETRELATO学号INTOASETRELATO课程号INTOCADDILIST学号,A->姓名,C->课程名,考试成绩*2小题GOTOPACCE"请输入课程号:"TOKHACCE"请输入学期:"TOXQCALCAVG(考试成绩),MAX(考试成绩),MIN(考试成绩)TOAV,MA,MI;FOR课程号=KHAND学期=XQ?"平均分:"+STR(AV,5,1)+SPACE(3)+"最高分:"+STR(MA,5,1);+"最低分:"+STR(MI,5,1)?INDEON学期+课程号TOXQKCGOTOPSEEKXQ+KHDOWHILE学期=CQAND课程号=KHIF考试成绩<60?SPACE(20)+"补考通知单"?TRIM(A->姓名)+"同学:"?SPACE(4)+"第"+学期+"学期你的"+TRIM(C->课程名); +"课程考试不及格,请利用假期看书"?"复习,作好补考准备."?ENDISKIPENDDOCLOSEDATARETURN7．*PRO7.PRG答案略2.10面向对象程序设计基础一、选择题1.D2.C3.D4.A5.A6.B7.D8.A9.C10.B11.D12.A13.C2.11表单设计与应用一、选择题1.A2.D3.C4.D5.D6.C7.B8.B9.A10.B11.D12.C13.C14.D15.D16.A17.B二、填空题1．①Val(thisform.text1.value)*0.8②label1.caption2．①"*"②thisform.text1.value#thisform.text2.value3．①for性别="0"ton②性别="0"AND职称="副教授"4．①0②thisform.text1.value③thisform.text2.value=p④thisform.release5．①x、y②x*y-x*y*0.06③this.value=z6．①计算(0②I=I+1③ALLT(STR(N))④Y=1三、运行表单，写出结果1．82．良好3．不是秋4．65．西部开发在重庆6．1139525749981367．M=10N=28．dk1907891088.569．99012李四高等数学6599012李四计算机70'