计算机等级考试二级VF模拟试题及答案解析Microsoft Word 文档.doc

VF1 1ABCD: C2381A12B13C14D15: B3ABCD: D4ABCDgoto: B5ABCD: B6APADBN-SCD: B7A B C D : B8ABCD: B9ABCD: B103ABCD: B11ABCD: A12ABCD: A13Visual FoxProAPI(01)BPI(20)CPI(23)DPI(123): C14X=45VARTYPE(X)ALBCCNDD: A15LEN(ALLTRIM()()A14B16C19D22: B16ACREATE DATABASEBMODIFY DATABASECOPEN DATABASEDUSE DATABASE: B17ABCD: C18135SELECT 0A0B1C2D: C195ACHANGE WITH +5BREPLACE WITH +5CCHANGE ALL WITH +5DREPLACE ALL WITH +5: D20ALIST FOR =FBLIST FOR TCLIST FOR DLIST FOR NOT: D210ABCD: C22zg.dbfSQLSELECT * FROM zg INTO CURSOR zg ORDER BY /AAzg.dbf?Bzg.dbfCD: D23BROWSEAUSE BUSE NODATA IN CUSE NODATA ON DUSE STRUCTURE TO : B24ADO WHILE-ENDDOBDO CASE-ENDCASECSCAN-ENDSCANDFOR-ENDFOR: C25X=10M=2N=3DO SUB1 WITH M,NDO SUB1 WITH M,NPROCEDURE SUB1PARAMETERS M,NX=M+10M=M+N?X,M,NENDPROCA12531283B12831583C12531583D12231283: C26ASelStartBSelLengthCSelTextDScrollBars: D27ASparseBControlSourceCAlignmentDCurrentControl: C28AGotFocusBLostFocusCSetFocusDInteractiveChange: A29A4B4C4D4: B30ABCD: B 12 821.6555 827.4500 825.9500 14 1171.4300 1176.5000 1204.0500 15 877.5325 895.5600 886.2686 18 585.5500 600.4888 604.6500 12 1000 14 1300 15 1500 14 2000 18 1500 14 1800 15 1200 12 2000 15 1200 18 150031SQLSELECT , FROM ,;WHERE.=.;AND =1500;ORDER BY DESC,A2000B1500C1500D1500: B32= * ASELECT SUM(*) AS ;FROM ,;WHERE .=.;AND =BSELECT SUM(*) AS ;FROM ,;WHERE .=.;FOR =CSELECT COUNT(*) AS ;FROM ,;WHERE .=.;AND =DSELECT COUNT(*) AS ;FROM ,;WHERE .=.;FOR =: A330.05%SQLAUPDATE FOR =*1.05;WHERE = OR =BUPDATE SET =*1.05;WHERE = OR=CUPDATESET =*1.05;WHERE =AND =DUPDATE FOR =*1.05;WHERE =AND =: B34SQLADELETE FROM WHERE IN;(SELECT FROM WHERE =)BDELETE FROM WHERE IN;SELECT FROM WHERE =CDELETE FROM ;WHERE .=.;AND =DDELETE FROM ,;WHERE .=.;AND =: A353ASELECT ,COUNT(*) AS FROM ;GROUP BY HAVING COUNT(*)=3;ORDER BY COUNT(*) ASC, DESCBSELECT ,COUNT(*) AS FROM ;GROUP BY HAVING COUNT(*)=3;ORDER BY COUNT(*) ,CSELECT ,COUNT(*) AS FROM ;GROUP BY HAVING COUNT(*)=3;ORDER BY , DESCDSELECT ,COUNT(*) AS FROM ;GROUP BY HAVING COUNT(*)=3;ORDER BY + DESC: C 1 1 : 1.()2 2 : 1.()3 3 : 1.()43 4 : 1.()5 5 : 1.()6Visual FoxPro 6 7 : 1.(.IDXIDX) 2.(.CDXCDX)7 8 9 : 1.() 2.()8Visual FoxPro 10 11 : 1.() 2.()91002USE DO WHILE 12IF =1002DISPLAYENDIF13ENDDOUSE: 1.(NOT EOF() 2.(SKIP)10()SQLSELECT 14 AS FROM 15: 1.(COUNT(*) 2.(GROUP BY )VF2?:2009-7-21 ?:fatcat? 1ABCD: B2pqqpABCD: B3nA0B1Cn-1Dn: C4ABCD: C5ABCD: D6 ABCD: C7ABCD: D84ABCD: C9 4ABCD: A10 ABCD: D11ABCD: D12Visual FoxProABCD: C13Visual FoxProABCD: B14ADIMENSIONDECLAREBVisual FoxProCD.F.: C15A+123B+DTOC(2004/01/01)C. T.+. F.D2004/01/01+10: C16ABCD: B17(NULL)AB0CD: D18ABCD: A19AGO TOPBGO BOTTOMCSKIPDGO 5: D20500REPLACE WITH *1.2A1.2B500C600D: C21Visual FoxPro42A6B7C8D9: C22AEDITBBROWSECREPLACEDCHANGE: C23SQLACREATE TABLEBCREATE INDEXCCREATE VIEWDINDEX ON: B24A.dbfBCdbfD: C25SQLDISTINCTABCD: B26ABCD: D27A5B6C7D8: C28ABCD: A29USE DO WHILE NOT EOF()IF =60SKIPLOOPENDIFDISPLAYSKIPENDDOUSEA60B60C60D60: B30ABCD: C31AClickBDbClickCRightClickD3: D323000ASELECT , FROM ;WHERE 3000BSELECT , FROM ;WHERE 3000CSELECT , FROM ,;WHERE (3000) OR (.=.)DSELECT , FROM ,;WHERE (3000) AND (.=.): D33ASELECT FROM WHERE IN;SELECT FROM WHERE != BSELECT FROM WHERE IN;(SELECT FROM WHERE != )CSELECT FROM WHERE IN;SELECT FROM WHERE != DSELECT FROM WHERE IN;(SELECT FROM WHERE != ): B34SQL ACREATE VIEW xs_view AS;SELECT , FROM BCREATE VIEW xs_view;SELECT, FROM CCREATE VIEW xs_view AS;(SELECT, FROM )DCREATE VIEW xs_view;(SELECT, FROM ): A35SQLSELECT FROM WHERE IN;(SELECT FROM WHERE 90)SQLASELECT FROM WHERE EXISTS;(SELECT FROM WHERE 90)BSELECT FROM WHERE EXISTS;(SELECT FROM WHERE =. AND 90)CSELECT FROM WHERE EXISTS;(SELECT FROM WHERE =. AND 90)DSELECT FROM WHERE=;(SELECT FROM WHERE 90): B 1 1 : 1.()2 2 : 1.()3 3 : 1.()4 4 : 1.()5 5 : 1.()6STORE2004-05-01 TO rqDAY(rq) 6 : 1.(1)7Visual FoxPro 7 : 1.()8 8 9 : 1.()