2006年vf笔试题.doc

20064VFP 2008-10-18 LUCK20064VFP20064Visual FoxPro(90,100)(2,70)A)B)C)D),(1)A) B)c) D)(2)A) B)c) D)(3)A)B)c)D)(4)A) B)C) D)(5)A)B)C)D)(6)/exam/A)ABCDEF B)DBEAFCC)ABDECF D)DEBFCA(7)7,A)32 B)31 C)64 D)63(8)A) B)c) D)(9)E-R,A) B) C) D)(10)DBDBSDBMSA)DBDBSDBMS B)DBMSDBDBSC)DBSDBDBMS D)(11)Visual FoxProA) B)C).dbf D)(12)SCXA) B)c) D)(13)A) B)c)SQL SELECT D)(14)Visual FoxPro A) B)C) D)(15)Visual FoxProDOA)PRG B)MPRC)FRX D)QPR(17)Visual FoxPro,A) B)C) D)(18)A) B)C) D)(19)X=11,Y=1122,A)NOT(X=y)AND(X$y) B)NOT(X$Y)OR(XY)C)NOT()(=Y)D)NOT(XSY)(20),A)SET SYSMENU DEFAULT B)SET SYSMENU TO DEFAULTC)SET SYSMENU NOSAVE D)SET SYSMENU SAVE(21)Visual FoxPro,A)EMPTY(SPACE(0) B)LIKE(xy*,xyz)C)AT(xy,abcxyz) D)ISNULL(.NUILL.)(22)SQLA)INSERT B)UPDATEC)DELETE D)CHANGE(16)A) B)C) D)(23) ,ValueA).T. B) C)1 D)1(24)A)USE B)USE DATABASEC)OPEN D)OPEN DATABASE(25)SQL DELETEA,A)DELETE FROMFORLIKEAB)DELETEFROMWHILELIKEAC)DELETE FROMWHERE=A*D)DELETE FROMWHERELIKEA(26)Visual FoxPro,menul.mpr,A)DO menul B)DO menul.mprC)DO MENU menul D)RUN menul(27)A)Parent B)This C)ThisForm D)Click(28)LIST,l2345##6,GO 2SCAN NEXT 4 FOR LEFT(,2)=IF RIGHT(,2)=EXITENDIFENDSCAN?A) B)C) D)(29)SQLA)ALTER TABLE B)MODIFY TABLEC)ALTER STRUCTURE D)MODIFY STRUCTURE(30),SQLA)SELECTFROMGROUP BYHAVING COUNT(*)3 AND AVG_200B)SELECTFROMGROUP BYHAVING COUNT(*)3 AND AVG()200C)SELECTFROMGROUP,BYHAVING COUNT(*)3 WHERE AVG()200D)SELECTFROMGROUP BYWHERE COUNT(*)3 AND AVG_200(31)8,SQLA)UPDATESET=+*8FOR ALLB)UPDATESET=*1.08 FOR ALLC)UPDATESET=+*8D)UPDATESET=*1.08(32),SQLA)SELECT,AVG()FROMGROUP BYB)SELECT,AVG()FROMORDERBYC)SELECT,AVG()FROMORDER BYD)SELECT,AVG()FROMGROUP BY(33),DIMENSION M(2,2)M(1,1)=10M(1,2)=20M(2,1)=30M(2,2)=40? M(2)A) B)10C)20 D).F.(34)s(,)sc(,),SQL85,A)SELECT,FROM s WHERE EXISTS(SELECT* FROM SC WHERE SC.=s.AND=85)B)SELECT,FROM S WHERENOT EXISTS(SELECT * FROM SC WHERE SC.=s.AND85)D)SELECT,FROM S WHERENOTEXISTS(SELECT * FROM SC WHERE SC.=S.AND85)(35)2004110(),SQLA)DROP FROM WHERE=2004-l-10B)DROP FROM FOR =2004-l-lOC)DELETE FROM WHERE =2004-1-10D)DELETE FROM FOR =2004-l-10)(2,30)115,(1)10, 1 (2), 2 (3), 3 (4) 4 ,(5),5(6)2005-1-3 10002005-10-3 9006(7)visual FoxPro,7(8)SQL SELECT8(9),9(10)visual FoxPro, 10 (11)SQL, 11 (12)SQL SELECT 12 (13),SQLSELECT 13 FROM (14),SQL14 (,)VALuEs(2001100111,9l,78,86)(15),151-5 DADBA6-10 DCDAC11-15 DCDAC