untitled

Transcription

1 ( ) Visual FoxPro

2 Visual FoxPro ( ) () () Visual FoxPro http: // http: // /

3 3 (010) (010) E mail dd@hep.com.cn

4

5 () 1 () 7 () 8 () 15 () 16 () 23 () 24 () 30 () 31 () 37 () 38 () 45 () 46 () 52 () 53 () 59 () 60 () 68 () 69 () () () ()

6 2 () () () () () A 123 A A A A A A A A A B (Visual FoxPro) 126 B B B.3 128

7 () Visual FoxPro ( ) ( 2 70 ) A) B) C) D) (1) A) B) C) D) (2) A) B) C) D) (3) Visual FoxPro A) B) C) D) (4) Visual FoxPro CREATE DATA A) B) C) D)

8 2 (5) Visual FoxPro A) LOCAL B) PRIVATE C) PUBLIC D) GLOBAL (6) DBC A) B) C) D) (7) mymenu A) DO mymenu B) DO mymenu.mpr C) DO mymenu.pjx D) DO mymemu.mnx (8) A) B) C) D) (9) A) B) C) D) (10) A) B) C) D) (11) student A) OPEN student B) OPEN DATA student C) USA DATA student D) USE student (12) A) DATE( ) B) TIME( ) C) YEAR( ) D) DATETIME( ) (13).F. A) B) C) D) (14) HAVING A) HAVING GROUPBY B) HAVING WHERE C) HAVING WHERE D) HAVING (15) (27) db_stock stock.dbf

9 () (15) SQL SELECT FROM stock INTO DBF stock ORDER BY A) B) stock.dbf C) stock.dbf D) (16) CLOSE DATABASE a=0 USE stock GO TOP DO WHILE.NOT.EOF( ) IF >10 a=a+1 ENDIF SKIP ENDDO a A) 1 B) 3 C) 5 D) 7 (17) SQL SELECT SELECT FROM stock WHERE BETWEEN 12.76AND15.20 A) SELECT FROM stock WHERE <=15.20.AND. >=12.76 B) SELECT FEOM stock WHERE <15.20.AND. >12.76 C) SELECT FROM stock WHERE >= AND. <=12.76 D) SELECT FROM stock WHERE > AND. <12.76 (18) stock.dbf >0

10 4 A) B) C) D) (19) stock A) DROP stock B) DELETE TABLE stock C) DROP TABLE stock D) DELETE stock (20) SQL SELECT MAX()INTO ARRAY a FROM stock A) a[1] B) a[1] 6 C) a[0] D) a[0] 6 (21) SQL SELECT AVG() AS FROM stock GROUP BY INTO DBF temp temp A) 7.48 B) 9.99 C) D) (22) stock 8 10 SQL A) ALTER TABLE stock WITH c(10) B) ALTER TABLE stock c(10) C) ALTER TABLE stock ALTER c(10) D) ALTER stock ALTER c(10) (23) SQL CREATE VIEW stock_view AS SELECT FROM stock WHERE ="" A) 1 B) 2 C) 3 D) 4 (24) SQL CREATE VIEW view_stock AS SELECT AS FROM stock A) B) C) D) (25) A) MODIFY STRUCTURE B) C) D) SQL (26) SQL SELECT DISTINCT FROM stock

11 () 5 WHERE =(SELECT MIN()FROM stock)into DBF stock_x stock_x A) 1 B) 2 C) 3 D) 4 (27) SQL A) SELECT AVG()FROM stock GROUP BY B) SELECT AVG ()FROM stock ORDER BY C) SELECT AVG ()FROM stock ORDER BY D) SELECT AVG ()FROM stock GROUP BY (28) A) B) C) D) (29) A) CREATE VIEW B) SQL C) SQL QPR D) DO (30) A) B) C) D) (31) Visible.T. A) Hide B) Show C) Release D) SetFocus (32) (EditBox) A) SelLength 0 B) ScrollBars 0 C) SelText / D) Readonly.T. (33) A) B) C) D) (34) A) Value B) ColumnCount C) ListCount D) Selected (35) R1 R2 S S A) B)

12 6 C) D) ( 2 30 ) 1 15 (1) Visual FoxPro (2) 2 (3) 3 (4) 4 (5) LEET(" ",LEN("")) 5 (6) 6 7 (7) 8 9 / / (8) SQL INSERT 10 (,) 11 ("04","") (9) SQL SELECT 12 () FROM ; WHERE IN(SELECT FROM 13 WHERE ="") (10) SQL 5% 14 SET = =""

13 () 7 () (1) D (2) A (3) B (4) A (5) C (6) C (7) B (8) C (9) A (10) D (11) B (12) B (13) C (14) B (15) A (16) C (17) A (18) B (19) C (20) A (21) B (22) C (23) B (24) B (25) D (26) A (27) D (28) D (29) C (30) A (31) B (32) C (33) B (34) D (35) A (1) 1 32 (2) 2 (3) 3 (4) 4 DBF.DBF (5) (6) 6.CDX CDX 7 (7) 8 Value 9 Caption (8) 10 INTO 11 Values Valu Value (9) 12 SUM 13 (10) 14 UPDATE UPDA UPDAT 15 WHERE WHER

14 8 () Visual FoxPro ( ) ( 2 70 ) A) B) C) D) (1) A) B) C) D) A) B) C) (2) A) B) C) D) (3) A) B) C) D) (4) Visual FoxPro A) B) C) D) (5) Visual FoxPro A) B) C) D) (6) Visual FoxPro A) B) C) D) (7) OLE A) B) C) D) (8) A) B) C) AutoOpenDATA AutoCloseDATA

15 () 9 D) (9) A) B) C) D) (10) 9 EOF( ) A) 18 B) 17 C) 0 D) 19 (11) Visual FoxPro A) OPEN TABLE <> B) USE <> C) USE TABLE <> D) OPEN <> (12) SET TALK OFF CLEAR x=0 i= l INPUT ":" TO N DO WHILE x< = N x=x+i i=i+l ENDDO? x SET TALK ON N 4 A) 5 B) 6 C) 4 D) 7 (13) A) LEFT("Visual FoxPro",6) SUBSTR("Visual FoxPro",1,6) B) YEAR(DATE( )) SUBSTR(DTOC(DATE),7,2) C) VARTYPE("36 5 4") VARTYPE(36 5 4) D) A="this" B="is a string" A B A+B (14) A) B) C) D)

16 10 (15) SQL A) GROUP BY B) ORDER ON C) GROUP ON D) ORDER BY (16) Visual FoxPro A) Visual FoxPro B) Visual FoxPro C) Visual FoxPro D) CreateTABLE( ) (17) A) B) C) D) (18) Visual FoxPro A) B) C) D) (19) (25).dbf.dbf.dbf ( C(6) C(10) C(2) D) ( C(6) C(10) N(2,0)) ( C(6) C(6) N(5,2)) (19) SQL A) DELETE FROM WHERE ="00008" B) DELETE FROM WHERE =00008 C) DELETE FROM WHERE =00008 D) DELETE FROM WHERE ="00008" (20) 8 SQL A) CHANGE TABLE ADD C(8) B) REPLACE TABLE ADD C(8) C) ALTER TABLE ALTER C(8) D) MODIFY TABLE ADD C(8) (21) A) ALTER VALUES("00008","",6) B) INSERT INTO VALUES("00008","",6) C) INSERT INTO VALUES(00008,"",6) D) INSERT INTO VALUES("00008","","6") (22) 4 SQL A) SELECT FROM WHERE =4

17 () 11 B) SELECT FROM WHERE =4 C) SELECT FROM FOR =4 D) SELECT WHERE =4 (23) A) SELECT FROM WHERE IS " " B) SELECT FROM WHERE IS NOT NULL C) SELECT FROM WHERE = NULL D) SELECT FROM WHERE < > NULL (24) A) SELECT FROM WHERE = ANY(SELECT FROM ) B) SELECT FROM WHERE < ALL(SELECT FROM ) C) SELECT FROM WHERE < ANY(SELECT FROM ) D) SELECT FROM WHERE =ALL(SELECT FROM ) (25) 6 10 A) ALTER TABLE ADD C(10) B) UPDATE TABLE ALTER C(10) C) UPDATE TABLE ADD C(10) D) ALTER TABLE ALTER C(10) (26) A) B) C) D) (27) test_quer.qpr A) OPEN QUERY test_quer.qpr B) MODIFY QUERY test_quer.qpr C) DO QUERY test_quer.qpr D) CREATE QUERY test_quer.qpr (28) (NAME# VALUEC# NUMBER) SQL A) SELECT COUNT(DISTINCT NAME#)/FROM B) SELECT COUNT( NAME#)/FROM C) SELECT COUNT(#)/FROM

18 12 D) SELECT COUNT(DISTINCT NAME )/FROM (29) A) AT('','') B) CTOD("07/07/98") C) CANDIDATE( ) D) SUBSTR(DTOC(DATE()),l,2) (30) DELETE DROM W WHERE >50 A) W 50 B) W 50 C) W D) W (31) A) TOP B) BOTTOM C) GO D) SKIP (32) A) (DX) B) (CDX) C) D) (33) Visual FoxPro PACK A) B) C) D) (34) Visual FoxPro A) B) C) D) (35) A) B) C) D) ( 2 30 ) 1 15 (1) Record#

19 () 13 1 (2) DIMENSION m(3,4) m m(6) 2 (3) 3 4 (4) 5 (5) JSJ001 SQL SELECT FROM! WHERE IN (SELECT 6 FROM! WHERE 7 ) (6) (9).dbf.dbf.dbf ( C(6) C(8) C(18) C(18)) ( C(6) C(8) C(2) N(3,0)) ( C( 6) C( 6) C(36) C(18) C(18) D(8) N(8,2)) (6) 8 (7) SQL SELECT,, FROM,, WHERE.=. AND.=. FROM 9 (8) 60 SQL SELECT,,, FROM,, WHERE.=. AND.=. AND ="" AND 10 (9) SQL SELECT FROM cf1 WHERE =

20 14 (SELECT 11 FROM cf2 12 GROUP BY cf2.) (10) SCREE1 13 SCREE2 14 SELECT 2 USE SCREE1 SELECT 3 USE SCREE2 SELECT 2 SKIP 2 (11) 15

21 () 15 () (1) A (2) C (3) D (4) A (5) C (6) D (7) C (8) D (9) B (10) D (11) B (12) B (13) A (14) B (15) D (16) C (17) B (18) C (19) D (20) C (21) B (22) A (23) B (24) C (25) D (26) B (27) B (28) B (29) A (30) A (31) C (32) C (33) D (34) D (35) A (1) 1 INDEX ON TO STU (2) 2 m(2,2) (3) 3 4 (4) 5 (5) 6 7 ="JSJ001" (6) 8 + (7) 9 (8) 10 >60 (9) 11 MAX() 12 cf1.=cf2. (10) (11) 15

22 16 () Visual FoxPro ( ) ( 2 70 ) A) B) C) D) (1) A) B) C) D) (2) ABC.DBF 11 USE ABC GOTO 9 LIST ALL? RECNO( ) A) 1 B) 10 C) 11 D) 12 (3) "" A) "" "" B) " " C) ""+"" D) ""$"" (4) VFP A) B) C) D) (5) SQL SELECT FROM A) B) C) D) (6)

23 () 17 SET TALK OFF B=0 DO WHILE.T. B=B+1 IF B>9 EXIT ENDIF ENDDO B A) 0 B) 9 C) 10 D) 11 (7) SELECT FROM A) B) C) D) (8) CHENGJI.DBF >0 A) B) C) D) (9) A) SQL B) SQL C) SQL D) SQL (10) SELECT FROM ORDER BY A) B) C) D) (11) SELECT AVG() FROM A) B) C) D) (12) KECHEN SQL A) ALTER TABLE KECHEN WITH c (18) B) ALTER TABLE KECHEN c (18)

24 18 C) ALTER TABLE KECHEN ALTER c (18) D) ALTER KECHEN ALTER c (18) (13) A) SELECT FROM B) SELECT SUM() FROM C) SELECT AVG() FROM D) SUM ()FROM (14) A) MAX() B) SELECT MAX() FROM Q C) SUM MAX() D) SELECT MIN() FROM Q (15) A) MODIFY STRUCTURE B) C) D) SQL (16) 1200 A) SELECT FROM <1200 B) SELECT FROM WHERE <1200 C) SELECT WHERE <1200 D) SELECT FROM WHERE <1200 (17) 1100 A) SELECT FROM FOR >1100 AND ="" B) SELECT WHERE >1100 AND ="" C) SELECT FROM WHERE >1100 OR ="" D) SELECT FROM WHERE >1100 AND ="" (18) A) B) C) D) (19) STU.DBF 20 USE STU GOTO11 LIST NEXT 3 A) 13 B) 14

25 () 19 C) 15 D) 12 (20) SQL A) B) C) D) (21) 5 10 A) 60 B) 100 C) 70 D) 140 (22) Visual FoxPro A) ACCEPT B) ACCEPT WAIT C) INPUT ACCEPT D) 5,10 SAY GET (23) DA DB A) DA+DB B) DB DA C) DA+100 D) DB 56 (24) XSH.DBF( ) KCH.DBF( ) XK.DBF( ) SELE 0 USE XSH ALIAS X INDEX ON TO XH1 SELE 1 USE KCH ALIAS K INDEX ON TO XH2 SELE 2 USE XK SET RELATION TO INTO X SET RELATION TO INTO K ADDITIVE A) LIST,,, B) LIST,A >,B >, C) LIST,X >,K >, D) LIST,XSH >,KCH >, (25) (24) A) B) C) D) (26) TOTAL ON TO DSR DSR

26 20 A) B) C) D) (27) A) B) C) D) (28) A=567 B=123 S="A+B" 10+&S A) 690 B) C) 700 D) l+a+b (29) Visual FoxPro A) (Event) B) C) D) (30) NN=800 A) LOCATE =NN B) SEEK NN C) FIND "900" D) LOCATE FOR ""="NN" (31) Visual FoxPro A) INIT B) DESTROY C) CONTROL D) CHECK BOX (32) USE STUDENT LIST Record# 1 07/12/ /24/ /05/71 RECNO( ) A) 5 B) 0 C) 3 D) 4 (33) USE TEACHER LIST Record#

27 () DELETE ALL RECCOUNT( ) RECNO(2) A) 0 B) 6 C) 5 D) 4 (34) AB A) SUM AB FOR ="" B) SUM TO AB FOR "" C) SUM () TO AB WHILE ="" D) SUM TO AB FOR ="" (35) X 6 A) MOD(X,6)=0 B) INT(X/6)=X/6 C) 0=MOD(X,6) D) INT(X/6)=MOD(X,6) ( 2 30 ) 1 15 (1) Visual FoxPro SCATTER 1 (2) 2 (3) 3 (4) SELECT SQL 4 (5) (6)? 6? 7 SET TALK OFF A=4 B=2 C=1 DO WHILE C>0 A=A B B=B+A IF A>50 A=A 5 C

28 22 C=C l? A,B ELSE STORE B 5 C TO B N=B ENDIF ENDDO?"N=",N (7) 8 (8) Visual FoxPro 9 Result Submenu / / (9) SQL 10 SET ="" 11 (10) SQL SELECT 12 () FROM 13 (11) SQL FROM WHERE 15 PACK

29 () 23 () (1) A (2) D (3) C (4) C (5) B (6) C (7) A (8) B (9) C (10) A (11) B (12) C (13) B (14) B (15) C (16) B (17) D (18) D (19) A (20) B (21) C (22) D (23) A (24) C (25) C (26) C (27) D (28) C (29) B (30) B (31) C (32) D (33) C (34) D (35) D (1) 1 (2) 2 (3) 3 (4) 4 DISTICT (5) 5 {^ }{^2003/04/26} (6) N=40 (7) 8 LIST /DISPLAY FOR (8) 9 (9) 10 UPDATE 11 WHERE ="" (10) 12 SUM 13 WHERE ="" (11) 14 DELETE 15 >50

30 24 () Visual FoxPro ( ) ( 2 70 ) A) B) C) D) (1) A) DBF B) C) DBC D) DBC (2) A) ISBL B) SQL C) QUEL D) QEL (3) A) B) C) D) (4) CLEAR MEMORY A) B) C) D) (5) A) B) C) D) (6) Visual FoxPro (Docs) A) B) C) D) (7) SQL A) CREAT SCHEMA B) CREAT TABLE C) CREAT INDEX D) CREAT VIEW (8)...

31 () 25 A) B) C) D) (9) Visual FoxPro FIELDS<> A) B) C) D) (10) A) B) C) D) (11) SQL A) B) C) D) (12) SET EXACT OFF X="H " IIF("H"=X X "IF" X+"IF") A) H B) IF C) FIH D) HIF (13) Visual FoxPro 6.0, pi= ROUND(pi,3) A) B) C) D) (14) Visual FoxPro A) MODIFY STRU <> B) MODIFY COMMAND <> C) DO PROCEDURE <> D) ALTER (15) SQL WHERE A) B) C) D) (16) A) B) C) D) (17) A) B) C) D) (18) PROJECT(J# JNAME DATE) DATE

32 26 A) DELETE TABLE PROJECT DROP DATE CASCADE B) DELETE TABLE PROJECT DROP DATE RESTRICT C) ALTER TABLE PROJECT DROP DATE CASCADE D) ALTER TABLE PROJECT DROP DATE RESTRICT (19) Visual FoxPro Result A) Pad Name B) Submenu C) Command D) Procedure (20) Visual FoxPro.FRX A) B) C) D) (21) Visual FoxPro A) (Restrict)(Ignore) B) (Ignore)(Cascade) C) (Cascade) D) (Cascade)(Restrict) (22) SQL A) () B) %() C) D) B C (23) A) CLEAR B) CLEAR ALL C) CLEAR SCREEN D) CLEAR WINDOWS (24) A) B) C) D) (25) Visual FoxPro A) {^ :10:10 AM} 10 B) {^ } DATE( ) C) {^ }+DATE( ) D) {^ }+[1000] (26) A) B) C) D) (27) BC A) OPEN BC B) MODIEY BC C) DO BC D) CREATE BC (28) Visual FoxPro A) DIMENSION DECLARE B) Visual FoxPro C) D).F.

33 () 27 (29) SQL A) SELECT B) INDEX C) UPDATE D) DELETE (30) A) B) C) D) (31) A) GO TOP B) GO BOTTOM C) GO 6 D) SKIP (32) A) CrestObject( ) B) DEFINE CLASS C) D) (33) 100 A) CHANGE WITH +100 B) REPLACE WITH +100 C) CHANGE ALL WITH +100 D) REPLACE ALL WITH +100 (34) SQL A) B) C) D) (35) VFP Class BaseClass A) ClassLibrary B) ParentClass C) ClassLibrary, ParentClass D) GrandClass ( 2 30 ) 1 15 (1) 1 (2) Visual FoxPro 2 (3) 3 (4) Show Window 4 5.dbf.dbf.dbf ( C(6) C(8) C(16) C(6) C(20) N(6 2)) ( C(4) C(8) C(6) C(2) C(6) C(20)) ( C(4) C(6) D(8))

34 28 (5) (6) SQL SELECT.... FROM!!! WHERE.=. AND.=. WHERE.=. 7 (7) SQL SELECT FROM 8 WHERE IN("","") (8) (N 6) (C 8) (C 8) (N 5 1) 85 MAN 9 AVECJ 10 (9) (10) SQL SELECT FROM 12 (SELECT FROM! GROUP BY HAVING 13 ) (11) XY.PRG 1) 1 2) 2 4 3) ) ) ) ) ) ) XY.PRG SET TALK OFF

35 () 29 CLEAR FOR J=1 TO 9? STR(J,2)+ ') ' FOR 14?? 15 ENDFOR? ENDFOR RETURN

36 30 () (1) B (2) B (3) A (4) C (5) B (6) D (7) B (8) D (9) B (10) D (11) D (12) D (13) B (14) B (15) C (16) D (17) D (18) D (19) B (20) D (21) C (22) D (23) A (24) B (25) C (26) D (27) D (28) C (29) A (30) C (31) C (32) B (33) D (34) B (35) C (1) 1 (2) 2 PJX.PJX (3) 3 (4) Init (5) 6 (6) 7 (INNER JOIN) (JOIN) (7) 8! (8) 9 COUNT FOR ="".AND. >85.00 TO MAN 10 AVERAGE FOR ="" TO AVECJ (9) 11 GO 7 INSERT (10) 12! 13 COUNT( )>=2 (11) 14 FOR K=1 TO J 15 STR(J k 6)

37 () 31 () Visual FoxPro ( ) ( 2 70 ) A) B) C) D) (1) A) B) C) D) (2) Visual FoxPro.qbr.. SQL SELECT. A) B) C) D) (3) A) JOIN B) LINK RELATION C) SET RELATION D) RELATION (4) A) SQL B) SQL C) SQL D) (5) Visual FoxPro A) TXT B) PRG C) DBT D) FMT (6) Visual FoxPro A) B) C) D) (7) HFE.PRG A) MODIFY STRUCTURE HFE B) MODIFY COMMAND HFE C) PRG USE HFE.PRG D) MODIFY HFE.PRG

38 32 (8) Visual FoxPro A) B) C) D) (9) () A) B) C) D) (10) 20 5 DIPLAY A) 0 B) 20 C) 19 D) 21 (11) 3 25 A) LIST FOR =3 25 B) LIST FOR =3.AND. =25 C) LIST FOR =CTOD("3/25/77") D) LIST FOR MONTH()=3.AND. DAY()=25 (12) SQL SUM( ) A) B) C) D) (13) A B C A B B C A B C A) ADDITIVE SET RELATION B) ADDITIVE SET RELATION C) A B B C D) A B B C A C (14) A) B) C) D) (15) A) B) (Ignore) C) D) (Cascade) (16) SR.PRG XG.PRG DY.PRG BAG.PRG A) COPY SR.PRG+XG.PRG+DYPRG BAG.PRG B) FOXBIND BAG.PRG SR.PRG,XG.PRG,DY.PRG C) FOXBIND BAG SR.PRG XG.PRG DY.PRG D) FOXPCOMP SR.PRG+XG.PRG+DY.PRG BAG.PRG (17) Visual FoxPro A)

39 () 33 B) C) D) (18) USE STUDENT APPEND BLANK REPLACE WITH "", WITH.F. A) B) C).T. D).F. (19) A) B) C) D) (20) A) STORE space(20) TO blank? LEN(SPACE(2)+space(5))? LEN(blank space(5)) B) COUNT ALL? RECCOUNT( ) C) STORE "20" TO m K="50"+"&m" K="50"+m D) DELETE DELETE LEXT 1 (21) Visual FoxPro A) B) C) D) (22) SQL A) SELECT B) INSERT C) UPDATE D) DELETE (23) A) SQL B)

40 34 C) SQL D) (24) Visual FoxPro A) SET PROCEDURE TO <> DO < > B) MODIFY COMMAND C) D) SET PROCEDURE TO DO < > (25) SQL ST-CO A) DROP SCHEMA ST-CO CASCADE B) DROP SCHEMA ST-CO RESTRICT C) DELETE SCHEMA ST-CO CASCADE D) DELETE SCHEMA ST-CO RESTRICT (26) IIF(LEN(REPLICATE(">",4))>6,5, 5) A).T. B).F. C) 5 D) 5 (27) SET TALK OFF X=0 Y=50 DO WHILE Y>X X=X+Y Y=Y 5 ENDDO? X RETURN X A) 55 B) 100 C) 50 D) 15 (28) Visual FoxPro A) Click B) DbClick C) Init D) KeyPress (29) A) B) C) D)

41 () 35 (30) A) SET CONSOLE ON SET CONSOLE OFF B) SET CONSOLE OFF SET CONSOLE ON C) SET CONFIRM OFF SET CONFIRM ON D) SET DELETED OFF SET DELETED ON (31) A) Visual FoxPro B) C) D) (32) COPY TO NEW STRUCTURE EXTE NEW.DBF A) 2 B) 3 C) 4 D) 10 (33) st.dbf(,,) 1 sc.dbf(,) 2 1 qaz.dbf C101 A) JOIN WITH B TO qaz FOR =B >.AND.B >="C101" B) JOIN WITH B TO qaz FILEDS, FOR =B >.AND.B > ;="C101" C) JOIN WITH B TO qaz FOR =B >.OR.B >="C101" D) JOIN WITH B TO qaz FILEDS, FOR =B >="C101" (34) SET DELETE OFF A) B) C) D) (35) CreatObject( ) A) CreatObject("form") B)? CreatObject("form") C) m(l)= CreatObject("form") D) S= CreatObject("form") ( 2 30 ) 1 15 (1) 1 (2) Visual FoxPro 2

42 36 (3) SCAN ENDSCAN 3 (4) 4 5 (5) (9).dbf.dbf.dbf ( C(6) C(8) C(16) C(6) C(20) N(6 2)) ( C(4) C(8) C(6) C(2) C(6) C( 20)) ( C(4) C(6) D(8)) (5) 6 (6) SQL T203 SELECT FROM WHERE 7 (7) SQL SELECT,, FROM WHERE 8 (8) LOCATE 9 (9) SQL SELECT,MAX()AVG(), 10 ; FROM ; 11 (10) SQL SELECT FROM WHERE IN (SELECT 12 FROM GROUP BY 13 COUNT(( )>=2) (11) 14 15

43 () 37 () (1) B (2) D (3) A (4) C (5) C (6) A (7) B (8) D (9) D (10) A (11) D (12) C (13) A (14) C (15) A (16) C (17) A (18) D (19) A (20) A (21) C (22) A (23) C (24) D (25) A (26) C (27) C (28) B (29) D (30) B (31) D (32) C (33) B (34) C (35) B (1) 1 (2) 2 PJX.PJX (3) 3 (4) 4 5 (5) 6 + (6) 7 ="T203" (7) 8 IN("" "") IN("" "") ="".OR.="" (8) 9 CONTINUE (9) 10 COUNT( ) 11 GROUP BY (10) HAVING (11) 14 15

44 38 () Visual FoxPro ( ) ( 2 70 ) A) B) C) D) (1) (DBMS) A) B) C) D) (2) A) B) C) D) (3) Visual FoxPro A) B) C) D) (4) A) B) C) D) (5) STR( ,7,2) A) 2781 B) 2781 C) D) (6) Visual FoxPro A) TXT B) PRG C) DBT D) FMT (7) BCD.PRG A) USE BCD.PRG B) MODIFY COMMAND BCD C) MODIFY STRUCTURE BCD.PRG D) MODIFY BCD.PRG (8) 6 11

45 () 39 A) LIST FOR =6 11 B) LIST FOR =6.AND. =11 C) LIST FOR =CTOD("6/11/77") D) LIST FOR MONTH()=6.AND. DAY()=11 (9) Visual FoxPro 6.0 MIN(ROUND(8.89,1),9) A) 8 B)8.9 C) 9 D)9.8 (10) A) B) C) D) (11) SQL A) MODIFY TABLE B) MODIFY STRUCTURE C) ALTER TABLE D) DELETE DBF (12) A B A B A) ALTE RELATION B) SET RELATION C) UPDATE FROM A D)GATHER FROM B (13) SQL A) DROP TABLE B) DELETE TABLE C) ERASE TABLE D) DELETE DBF (14) USE STUDENT APPEND BLANK REPLACE WITH "", WITH.T. IIF(,"","") A) B) C).T. D).F. (15) Visual FoxPro A) B) C) D) (16) WH2 A) DELETE FOR ="WH2" B) DELETE FROM WHERE ="WH2" C) DROP FOR ="WH2"

46 40 D) PACK ="WH2" (17) A) B) C) D) (18) A) CLEAR B) CLEAR ALL C) CLEAR SCREEN D) CLEAR WINDOWS (19) A) SQL B) SQL DDL C) SQL DML D) SELECT (20) A) STORE space(20) TO blank? LEN(blank+space(5))? LEN(blank space(5)) B) COUNT FOR <>? RECCOUNT( ) C) STORE "20" TO m K=50+ m K="50"+m D) DELETE? DELETE( ) (21) Visual FoxPro A) B) C) D) (22) SET INDEX TO A) B) C) D) (23) SQL A) LIST

47 () 41 B) SELECT FROM C) DISPLAY FROM D) OPEN 24 A) SELECT FROM st WHERE st.="" B) SELECT FROM sc WHERE st.="" C) SELECT FROM sc,st WHERE st.= D) SELECT FROM sc,st WHERE st.="" (25) SQL A) SELECT FROM B) LIST C) SELECT FROM D) DISPLAY ALL (26) IIF(LEN(REPLICATE(">",4)>6,5, 5) A).T. B).F. C) 5 D) 5 (27) SET TALK OFF X=0 Y=1200 DO WHILE.T. X=X+3 IF X=Y EXIT ENDIF ENDDO? X RETURN X A) 1201 B) 93 C) 1200 D) 117 (28) STUDENT SS.DBF A) SORT TO SS ON /D B) INDEX TO SS ON C) SORT TO SS ON D) COPY TO SS ON /D

48 42 (29) SELECT FROM WHERE >1250 A) 1250 B) 1250 C) D) 1250 (30) C SNA CC SNA A) SET SNA=CC B) REPLACE SNA WITH CC C) STORE CC TO SNA D) REPLACE SNA WITH"CC" (31) AAA.PRG SET TALK OFF CLEAR X=10 Y=20 DO BBB?X,Y BBB.PRG PRIVATE Y X=80 Y=90 RETURN A) B) C) D) (32) SQL A) SELECT FROM BY B) SORT BY C) SELECT FROM ORDER BY D) SELECT FROM ORDER BY DESC (33) st.dbf(,,) sc.dbf(, ) C2 A) SELECT FROM st,sc WHERE =C2 B) SELECT FROM st,sc WHERE sc. ="C2" C) SELECT FROM st WHERE st. =sc.c2 D) SELECT FROM st WHERE st. ="C2" (34) A)

49 () 43 B) C) D) (35) A) B) C) D) ( 2 30 ) 1 15 (1) 1 (2) Visual FoxPro 2 (3) 3 (4) ShowWindow 4 5 (5) (9).dbf.dbf.dbf ( C(6) C(18) N(8 2)) ( C(6) C(18) C(8) C(12)) ( C(6) C(6) N(9 3) N(8 2)) (5) SELECT 6 FROM (6) SELECT 7 FROM (7) SELECT FROM 8 (8) SELECT FROM 11 (9) SELECT FROM (10) e x 2 n x x x x e = Λ + 1! 2! n! 10 4 SET TALK OFF

50 44 INPUT " x:" TO x e=1 u=1 n=0 DO WHILE ABS(u)>1e 4 n= 14 u= 15 e=e+u ENDDO? "EXP(",x,")=",e SET TALK ON RETURN

51 () 45 () (1) D (2) B (3) D (4) D (5) B (6) B (7) B (8) D (9) B (10) D (11) C (12) A (13) A (14) B (15) A (16) B (17) D (18) A (19) B (20) A (21) C (22) A (23) B (24) D (25) C (26) C (27) C (28) A (29) D (30) B (31) D (32) C (33) B (34) B (35) D (1) 1 (2) 2 PJX (3) 3 (4) 4 5 (5) 6 (6) 7 SUM() (7) 8 WHERE ="" (8) 9 MAX() 10 MIN() 11 (9) 12 MAX() 13 MAX() (10) 14 n+1 15 u x/n

52 46 () Visual FoxPro ( ) ( 2 70 ) A) B) C) D) (1) A) B) C) D) A) B) C) (2) A) B) C) D) (3) 4 8 A) ALTER TABLE ADD C(8) B) UPDATE TABLE ALTER C(8) C) UPDATE TABLE ADD C(8) D) ALTER TABLE ALTER C(8) (4) A) DELETE ZAP B) ZAP C) DELETE PACK D) DELETE (5) Visual FoxPro A) B) C) D) (6) F U A) TYPE(F) B) TYPE(.F.) C) TYPE( F ) D) (7) A) B) C) D) (8)

53 () 47 A) B) C) AutoOpentables AutoCloseTables D) (9) A) LIST ="" B) LIST FOR ="" C) LIST WHILE ="" D) LIST REST ="" (10) Visual FoxPro (Form) A) B) C) D) (11) ( C(6) C(10) N(2,0)) A) ALTER VALUES("00006","",4) B) INSERT INTO VALUES("00006","",4) C) INSERT INTO VALUES(00006,"",4) D) INSERT INTO VALUES("00006","","4") (12) SET TALK OFF CLEAR x=0 i=1 INPUT ":" TO m DO WHILE x<=m x=x+i i=i+1 ENDDO? x SET TALK ON m 6 A) 9 B) 10 C) 11 D) 0 (13) A) LEFT("CHANA",4) SUBSTR("CHANA",1,4) B) YEAR(DATE( )) SUBSTR(DTOC(DATE),3,2) C) VARTYPE("18+9/3") VARTYPE(18+9/3) D) A="this",B="is an APPLE",A B A+B (14) ( C(6) C(10) N(2,0)) "00007" SQL

54 48 A) DELETE FROM WHERE ="00007" B) DELETE FROM WHERE =00007 C) DELETE FROM WHERE ="00007" D) DELETE FROM WHERE ="00007" (15) SQL ORDER BY A) B) C) D) (16) Visual FoxPro A) Visual FoxPro B) Visual FoxPro C) Visual FoxPro D) CREATEOBJECT (17) A) B) C) D) (18) Visual FoxPro A) B) C) D) (19) Visual FoxPro A) \ B) \< C) > D) (20) Visual FoxPro.qbr A) B) SQL SELECT C) D) (21) (S# C# GRADE) SQL A) SELECT COUNT(DISTINCT S#)/FROM B) SELECT COUNT( S#)/FROM C) SELECT COUNT(#)/FROM D) SELECT COUNT(DISTINCT S )/FROM (22) AT("","") A) 6 B) 7 C) 8 D) 9 (23) DB DBS DBMS A) DBS DB DBMS B) DBMS DB DBS

55 () 49 C) DB DBMS DBS D) DB DBMS DBS (24) 18 3 INSERT BLANK A) 4 B) 3 C) 1 D) 19 (25) Visual FoxPro A) {^ :08:09 AM}+168 B) {^ } DATE( ) C) {^ } 10 D) [^ ] [1986] (26) R R(NO NAME SEX AGE CLASS) NO NO NAME SEX AGE CLASS 10 A) REPLACE FOR NO=10 NAME="" B) UPDATE R SET NAME="" NO=10 C) UPDATE R NAME WITH "" NO=10 D) UPDATE NAME="" NO=10 (27) STU A) OPEN STRU STU B) MODIFY STRU STU C) DO STU D) CREATE STU (28) Visual FoxPro A) DIMENSION DECLARE B) Visual FoxPro C) D).F. (29) R R(NO NAME SEX AGE CLASS) NO NO NAME SEX AGE CLASS A) UPDATE R SET CLASS="95091" WHERE CLASS="95101" B) UPDATE R CLASS="95091" FOR CLASS ="95101" C) REPLACE R CLASS WITH "95091" D) UPDATE R SET CLASS=95091 WHERE CLASS=95101 (30) Visual FoxPro G M

56 50 A) 2 B) 4 C) 8 D) 10 (31) Visual FoxPro A) B) ESC C) D) SET DELETE OFF (32) R R(NO NAME SEX AGE CLASS) NO NO NAME SEX AGE CLASS 20 A) ZAP NO="20" B) DELETE FOR NO="20" C) DELETE FROM R WHERE NO=10 D) DELETE SET NO=" " WHERE NO=10 (33) Visual FoxPro ZAP A) B) C) D) (34) R R(NO NAME SEX AGE CLASS) NO NO NAME SEX AGE CLASS A) UPDATE FROM R WHERE NAME LIKE "%" B) DELETE FROM R WHERE NAME& C) DELETE FROM FOR &NAME D) DELETE FROM R WHERE NAME LIKE "%" (35) A) B) C) ACTIFE D) ( 2 30 ) (1) 1 (2) Visual FoxPro 2 (3) 3 (4) 4 (5) (9)

57 () 51.dbf.dbf.dbf ( C(6) C(18) N(8 2)) ( C(6) C(18) C(8) C(12)) ( C(6) C(6) N(9 3) N(8 2)) (5) 6 (6) SQL SELECT AS AS AS FROM WHERE.=. AND.=. FROM 7 (7) 6000 SQL SELECT FROM WHERE.=. AND.=. AND ="" AND 8 (8) "World"$"World Wide Web" 9 (9) SQL SELECT AVG() AVG() 10 FROM GROUP BY 11 (10) SQL SELECT FROM xs1 WHERE = (SELECT 12 FROM xs2 13 GROUP BY xs2.) (11) I 14 (12) 15

58 52 () (1) A (2) C (3) D (4) C (5) C (6) C (7) D (8) D (9) B (10) D (11) B (12) B (13) A (14) D (15) D (16) C (17) B (18) C (19) B (20) D (21) B (22) A (23) A (24) A (25) C (26) B (27) B (28) B (29) A (30) B (31) C (32) C (33) A (34) D (35) A (1) 1 (2) 2 APP. APP (3) 3 CommandBotton (4) 4 5 (5) 6 + (6) 7 (7) 8 >6000 (8) 9.T. (9) 10 SUM() 11 (10) 12 MAX() 13 xs1.= xs2. (11) 14 DELETE ALL FOR LEFT( 1)="I" (12) 15 REPLACE

59 () 53 () Visual FoxPro ( ) ( 2 70 ) A) B) C) D) (1) A) B) C) D) (2) A) B) C) D) (3) X=100 Y= X TYPE(Y) A) N B) C C) U D) (4) Visual FoxPro A) B) C) D) (5) Visual FoxPro SQL A) B) C) D) (6) Visual FoxPro A) (Form) B) ( Report) C) (Label) D) (7) A) B) C) D) (8) A)

60 54 B) C) D) (9) A) B) GROUP BY C) WHERE D) (10) Visual FoxPro A) INTO COUSOR B) INTO FILE C) INTO DBF D) INTO TABLE (11) SQL A) WHERE B) FOR C) WHILE D) CONDITION (12) SET EXACT OFF x="a "? IIF(x ="A",x "BCD",x+"BCD") A) A B) BCD C) A BCD D) ABCD (13) DELETE A) RECALL B) FOUND C) RELEASE D) (14) Visual FoxPro A) MODIFY <> B) MODIFY FILE <> C) MODIFY PROCEDURE <> D) B) C) (15) 8 A) B) C) D) (16) A) B) C) D) (17) A) B)

61 () 55 C) D) (18) SQL A) CREATE SCHEMA B) CREATE STRUCTURE C) CHANGE TABLE D) ALTER TABLE (19) Visual FoxPro A) \ B) < C) > D) (20) Visual FoxPro.FRX A) B) C) D) (21) Visual FoxPro A) (Restrict) B) (Ignore) C) (Cascade) D) (Cascade)(Restrict) (22) A) B) C) D) (23) R R(NO NAME SEX AGE CLASS) NO NO NAME SEX AGE CLASS (25, "","",21, "95031") A) ISSERT IN R VALUES(25,"","",21, "95031") B) APPEND IN R VALUES(25, "","",21, "95031") C) UPDATE INTO R VALUES(25, "","",21, "95031") D) INSERT IN R VALUES(25, "","",21, "95031") (24) A) B) C) D) (25) M="AB CD " N=" EF IJ" MN A) AB CD EF IJ B) AB CD EF IJ C) ABCD EF IJ D) ABCDEF IJ (26)

62 56 A) B) C) D) (27) test_report.frx A) OPEN REPORT test_report.frx B) MODIFY REPORT test_report.frx C) DO REPORT test_report.frx D) CREATE REPORT test_report.frx (28) R R(NO,NAME,SEX,AGE,CLASS) NO NO NAME SEX AGE CLASS A) INSERT INTO VALUES (30, "","95031") B) INSERT INTO R SET VALUSE (30, "","95031") C) INSERT INTO R(NO,NAME,CLASS) VALUES (30, "","95031") D) REPLACE R (30, "","95031") (29) R R(NO,NAME,SEX,AGE,CLASS) NO NO NAME SEX AGE CLASS 20 A) ZAP AGE="20" B) DELETE FOR AGE NO="20" C) DELETE FROM R WHERE AGE=20 D) DELETE SET NO=" " WHERE AGE=20 (30) A) OCCURS ( ) B) AT( ) C) YEAR( ) D) DATETIME( ) (31) A) INPUT B) ACCEPT C) WAIT D) (32) R R(NO NAME SEX AGE CLASS) NO NO NAME SEX AGE CLASS A) UPDATE R SET NAME="" WHERE NAME="" B) UPDATE R NAME="" FOR NAME ="" C) REPLACE R NAME WITH "" D) UPDATE R SET CLASS= WHERE NAME=

63 () 57 (33) 1000 A) CHANGE WITH B) REPLACE WITH C) CHANGE ALL WITH D) REPLACE ALL WITH (34) Visual FoxPro A) B) C) D) (35) A) B) Visual FoxPro C) Visual FoxPro D) ( 2 30 ) 1 15 (1) 1 (2) Y N DO WHILE.T. WAIT ' Y/N' TO yn IF ((UPPER(yn)< >.AND.'Y'.AND.((UPPER(yn)< >.AND.'N' 2 ELSE EXIT ENDIF ENDDO (3) FoxPro 3 (4) AT( A+B=C + ) 4 (5) USE STUDENT LIST Record

64 INDEX ON TO STU FIND 20 SKIP DISP 5 (6) JSJ001 SQL SELECT FROM! WHERE IN (SELECT 6 FROM! WHERE 7 ) (7) 3+3>=6.OR.3+3>5.AND.2+3=5 8 (8) 9 (9) 10 (10) SQL ALTER (11) SQL 13 (12) SELECT WHERE 14 15

65 () 59 () (1) C (2) B (3) A (4) A (5) A (6) D (7) A (8) B (9) D (10) A (11) A (12) D (13) A (14) B (15) D (16) D (17) D (18) D (19) A (20) D (21) C (22) C (23) D (24) A (25) A (26) D (27) D (28) C (29) C (30) D (31) A (32) A (33) D (34) B (35) D (1) 1 (2) 2 LOOP (3) 3 (4) 4 0 (5) 5 (6) 6 7 ="JSJ001" (7) 8.T. (8) 9 (9) 10 (10) 11 MODIFY 12 ADD (11) 13 IS NULL (12) 14 GROUP BY 15 ORDER BY

66 60 () Visual FoxPro ( ) ( 2 70 ) A) B) C) D) (1) A) B) C) D) (2) A) B) C) D) (3) STUDENT.DBF 100 USE STUDENT GOTO 10 DISPLAY ALL? RECNO( ) A) 1 B) 10 C) 100 D) 101 (4) LEN(SPACE(5) SPACE(2)) A) 15 B) 2 C) 3 D) 7 (5) S(S# SN AGE SEX) AGE A) B) C) D) (6) STUDENT.DBF USE STUDENT GOTO 3

67 () 61 LOCATE NEXT 3 FOR ="" A) 3 B) 4 C) 5 D) 6 (7) R R(NO NAME SEX AGE CLASS) NO NO NAME SEX AGE CLASS A) REPLACE FOR AGE=19 AGE=20 B) UPDATE R SET AGE=20 WHERE AGE=19 C) UPDATE R AGE WITH AGE=20 D) UPDATE AGE=20 AGE=19 (8) A) 1100 B) 1200 C) 1300 D) 1400 (9) A) B) C) D) (10) SET TALK OFF X=1 DO WHILE X<=5 Y=l C="$" DO WHILE Y<=X C=C+STR(Y,1) Y=Y+1 ENDDO IF X=5? X ENDIF X=X+l ENDDO? X RETURN? X

68 62 A) 1 B) 4 C) 5 D) 6 (11) A) B) C) D) (12) A) B) C) D) (13) A) B) C) D) (14) Visual FoxPro (Event) A) B) C) D) (15) NN=900 A) SEEK NN B) LOCATE FOR =NN C) FIND 900 D) LOCATE FOR >NN (16) Visual FoxPro A) Column B) Control C) Check Box D) Command Group (17) USE STUDENT LIST Record# 1 07/12/ /24/ /05/71 INDEX ON DTOC() TO BD LIST A) 07/12/69 B) 11/05/71 02/24/70 02/24/70 11/05/71 07/12/69 C) 11/05/71 D) 02/24/70 07/12/69 07/12/69

69 () 63 02/24/70 11/05/71 (18) USE TEACHER LIST Record# SELECT 2 USE TITLE ALIAS Q LIST Record INDEX ON TO ZC SELECT 1 SET RELATION TO INTO Q GOTO 2? RECNO(2) RECNO(2) A) 1 B) 2 C) 3 D) 4 (19) ZGZ A) SUM TO ZGZ FOR ="".AND."" B) SUM TO ZGZ FOR ="".OR."" C) SUM TO ZGZ FOR ="".AND.="" D) SUM TO ZGZ FOR ="" $ (20) Y 7 A) MOD(Y,7)=0 B) INT(Y/7)=Y/7 C) 0=MOD(Y,7) D) INT(Y/7)=MOD(Y,7) (21) A) B) C) D)

70 64 (22) A) B) C) D) (23) (35) db_stock stock.dbf (23) A) SELECT ALL FROM stock B) SELECT FROM stock WHERE ="" C) SELECT WHERE ="" D) SELECT ALL FROM stock WHERE ="" (24) SELECT MAX() FROM stock A) 7.48 B) C) D) (25) SELECT FROM stock WHERE ="" A) B) C) D) (26) 10 A) SELECT FROM stock B) SELECT FROM stock WHERE >10 C) SELECT ALL FROM stock WHERE >10 D) LIST ALL (27) stock A) MODIFY COMMAND stock B) DELETE TABLE stock C) MODIFY STRUCTURE stock D) DELETE STRUCTURE stock (28) A) INSERT INTO stock VALUES ("000001","",12.54, "")

71 () 65 B) INSERT VALUES ("000001","",12.54, "") C) INSERT INTO stock SET ("000001","",12.54, "") D) INSERT TO stock VALUES ("000001","",12.54, "") (29) A) SELECT FROM stock WHERE ="" B) SELECT FROM stock WHERE LIKE " " C) SELECT FROM stock WHERE =" " D) SELECT FROM stock WHERE =" " (30) stock 8 12 SQL A) ALTER TABLE stock WITH c (12) B) ALTER TABLE stock c (12) C) ALTER TABLE stock ALTER c (12) D) ALTER stock ALTER c (12) (31) A) SELECT FROM stock WHERE ALL B) SELECT FROM stock ORDER BY C) SELECT FROM stock ORDER BY DESC D) SELECT FROM stock GROUP BY (32) SQL A) SELECT FROM stock WHERE 10<<10 B) SELECT FROM stock WHERE BETWEEN 10 AND 15 C) SELECT FROM stock WHERE >10 AND <15 D) SELECT WHERE BETWEEN 10 AND 15 (33) SQL A) SELECT SUM FROM stock B) SELECT SUM( ) FROM stock C) SELECT COUNT FROM stock D) SELECT COUNT( ) FROM stock (34) SQL A) SELECT FROM stock WHERE BETWEEN MAX( ) AND MIN( ) B) SELECT MAX() MIN() FROM stock C) SELECT FROM stock WHERE MAX() MIN() D) MAX() MIN() SELECT FROM stock (35) SQL A) SELECT,AVG() FROM stock GROUP BY B) SELECT,AVG() FROM stock ORDER BY C) SELECT,AVG() FROM stock ORDER BY D) SELECT,AVG() FROM stock GROUP BY

72 66 ( 2 30 ) 1 15 (1) EOF( ) 1 YEAR(DATE( )) 2 (2) STORE 230 TO S,N,M N 3 (3) Visual FoxPro 4 (4) 5 (5) SP1.DBF SP2.DBF SP3.DBF SP1.DBF /C /C /C /C SP2.DBF /C /N N /N SP3.DBF /C /N SET TALK OFF SELECT 1 USE SP1 SELECT 2 USE SP2 INDEX ON TO P1 SELECT 3 USE SP3 6 SELECT 1 SET RELATION INTO B 7 LIST,,,,B >,B >,B >,C > SET RELATON TO CLOSE ALL RETURN (6) ( 4 ) SET 8 ON (7) Visual FoxPro Result 9 S C SC S(S# SN SEX AGE DEPT) C(C# CN) SC(S# C# GRADE) S# SN SEX AGE DEPT C# CN GRADE

73 () 67 (8) SELECT SN,AGE,SEX FROM S 10 AGE>(SELECT AGE ; FROM S WHERE SN= 11 ) (9) C2 SELECT S# FROM SC WHERE 12 AND GRADE >=ALL; (SELECT 13 FROM SC WHERE C#="C2") (10) 14 S.SN, SC.C#, SC.GRADE FROM 15 WHERE S.S#=SC.S#

74 68 () (1) C (2) B (3) D (4) D (5) C (6) A (7) B (8) C (9) D (10) D (11) C (12) C (13) C (14) B (15) B (16) C (17) D (18) C (19) D (20) D (21) C (22) D (23) B (24) C (25) A (26) B (27) C (28) A (29) B (30) C (31) B (32) B (33) D (34) B (35) D (1) 1 L 2 N (2) (3) 4 SCATTER COPY TO ARRAY (4) 5 (5) 6 INDEX ON TO P2 7 SET RELATON TO INTO C ADDITIVE (6) 8 CENTURY (7) 9 Submenu (8) 10 WHERE 11 "" (9) 12 C#="C2" 13 GRADE (10) 14 SELECT 15 S SC

75 () 69 () Visual FoxPro ( ) ( 2 70 ) A) B) C) D) (1) A) B) C) D) (2) S S# SN AGE SEX S1 Wang 23 M Liu 20 F S2 Hou 23 M S# A) B) C) D) (3) A) B) C) D) (4) A) 1:1 B) 1:n C) m:n D) (5) ( ) ( ) ( )

76 70 A) B) C) D) (6) A) DTOC(DATE( )) B) DTOC(DATE( ),1) C) STR( ) D) AT ("1",STR 1321) (7) A) B) C) D) (8) R S A) R S B) R S C) R S D) R S (9) SQL SQL A) $ B) $ C) D) (10) R S A) R S B) R S C) R S D) R S (11) SQL A) SELECT B) FROM C) WHERE D) SET (12) Student( ) A) ( ) B) () C) ( ) D) ( ) (13) A) B) C) D) (14) Y=YEAR({12/15/99}) Y A) 99 B) 05 C) 20 D) (15) A) B) C) D) (16)

77 () 71 A) B) C) D) (17) A) SET DEVICE TO 3,10 SAY ": "+ B) SET PRINT 3,10 SAY ":" + C) SET PRINT ON SET DEVICE 3,10 SAY ": "+ D) LIST ": "+ TO PRINT (18) SET DELETED OFF A) B) C) D) (19) SET EXACT OFF ""=" " A).T. B).F. C).0. D). 0. (20) STD2.DBF STD1.DBF A) USE STD1 COPY TO STD2 B) USE STD1 COPY STRU TO STD2 C) COPY FILE STD1.DBF TO STD2.DBF D) CREATE STD2 FROM STD1 (21) A).DBF B).FPT C).TXT D).CDX (22) SQL UNIQUE A) B) C) D) (23) SQL < >ALL < >ALL A) NOT IN B) IN C) < >SOME D) =SOME (24) A) SQL B) SQL

78 72 C) SQL D) SQL (25) A) B) C) D) (26) PROJECT(J#,JNAME,DATE), DATE A) DELETE TABLE PROJECT DROP DATE CASCAPE B) DELETE TABLE PROJECT DROP DATE PESTRICT C) ALTER TABLE PROJECT DROP DATE CASCDADE D) ALTER TABLE PROJECT DROP DATE RESTRICT (27) SC(S#,C#,GRADE), SQL A) SELECT COUNT (DISTINCT S#)/FROM SC B) SELECT COUNT (S#)/FROM SC C) SELECT COUNT( )/FROM SC D) SELECT COUNT(DISTINCT)/FROM SC (28) S SC Sno Cno SQL Select S. From S,SC Where S.Sno=SC.Sno and SC.Cno='C2' A) C2 B) C2 C) S SC D) S SC (29) SQL A) CREATE SCHEMA B) CREATE TABLE C) CREATE VIEW D) CREATE INDEX (30) A) B) C) D) (31) SET TALK OFF STORE.T. TO x STORE 0 TO y DO WHILE x y=y+1

79 () 73 IF INT(y/5)=y/5?? y ELSE LOOP ENDIF IF y>15 STORE.F. TO x ENDIF ENDDO A) B) B) 5 10 D) (32) MyForm A) MyForm.BackColor=RGB(0,255,0) B) THIS.Parent.BackColor=RGB(0,255,0) C) THISFORM.BackColor=RGB(0,255,0) D) THIS.BackColor = RGB(0,255,0) (33) A) B) C) D) (34) CLEA USE student INDEX ON xb TO xbindex SEEK '' DO WHILE NOT EOF( ) SKIP ENDDO A) B) student.dbf C) student.dbf D), student.dbf (35) A) PRG B) APP C) DLL D) EXE ( 2 30 ) 1 15

80 74 (1) 1 (2) VAL(SUBSTR('1999',3)+RIGHT(STR(YEAR(DATE())),2))+17 (3) LEN("")<LEN(SUBSTR("computer",1,6)) 3 (4) 4 (5) (C 8) (D 8) (C 8) (N 7 2) (6) 6 (7) 7 (8) R S T R(BH XM XB DWH) S(DWH DWM) T(BH XM XB DWH) RUT SQL 8 (9) 9 (10) BLL.DBF TJD.DBF BLL.DBF DBASE TJD.DBF SELECT 1 USE TJD SELECT 2 USE BLL LOCATE FOR ='DBASE ' SELECT 1 10 CLOSE ALL (11) 11 (12) 12 (13) 13 (14) Caption 14 (15) SQL 15

81 () 75 () (1) D (2) A (3) A (4) D (5) D (6) D (7) C (8) B (9) C (10) D (11) A (12) B (13) D (14) D (15) D (16) B (17) C (18) B (19) A (20) B (21) B (22) D (23) A (24) C (25) D (26) D (27) B (28) A (29) D (30) C (31) B (32) B (33) D (34) C (35) A (1) 1 (2) (3) 3.F. (4) 4 ( RI) (5) 5 REPLACE ALL FOR ="" WITH +300 (6) 6 MODIFY PROJECT (7) 7 EOF( ) BOF( ) (8) 8 SELECT FROM R UNION SELECT FROM T (9) 9 (10) 10 REPLACE WITH B., WITH FOR =;'DBASE ' (11) 11 (12) 12 (13) 13 DO<.MPR> (14) 14 FontSize (15) 15 PRIMARY KEY

82 1. 2. Visual FoxPro Visual FoxPro (1) 30 (2) 40 (3) 30 (Windows ) Windows 95/98

83 77 1. (1) 1 1 (2) 2 2 (3) 3 3 (4) 4

84 78 4 (DjksDl.mdb) (5) 5 5

85 Visual FoxPro 7 3. Visual FoxPro 6 () 6 C 6 ( ) () 6 K 4.

86 C WEXAM C:\WEXAM\ K K:\ \

87 81 5 5

88 () (1) Visual FoxPro (2) File Open 11

89 () 83 (3) Open.dbc OK (4) Database Designer Add Table (5) Open order_detail.dbf 14 OK 15 14

90 (1) order_detail Modify (2) Table Designer Fields NULL OK 17

91 () (1) Rule >0 (2) Message (1) File New (2) New Table New file 19 19

92 86 (3) Create Customer Save (4) Table Designer Fields Name Type Character Width (5) (4)

93 () (1) View1 Database Designer New Local View 23 New View 24 View Designer Fields Functions and expressions AVG(Order_list.) 25 Add Selected fields 26 View

94 88 AVG(Order_list.) (2) File New Query 28 Order_list

95 () 89 View1 Query Designer (3) Fields Selected fields Order_list. Order_list. Order_list. Order_list

96 90 (4) Filter Field Name Order_list. Criteria > Example view (5) Query Designer Output Settings (6) Query Destination Table Table name results OK 33 33

97 () 91 2 (1) File New Report (2) Report Quick Report (3) Open Order_detail.DBF OK (4) Quick Report Field layout OK 36 36

98 92 (5) Report Title/Summery (6) Title/Summery Title band OK (7) Report Designer Title 39 39

99 () 93 (8) Page Footer DATE( ) Properties (9) Report Expression Expression DATE( ) TIME( ) OK 41 (10) report1.frx

100 SELECT SELECT a USE od_bak.dbf SCAN REPLACE a. WITH SUBSTR(a.,6) ENDSCAN SELECT od_bak., od_bak., od_bak.,; MIN(od_bak.) AS, SUM(od_bak.) AS ; FROM od_bak; GROUP BY od_bak.,od_bak.; ORDER BY od_bak., od_bak.; INTO TABLE od_new.dbf

101 () 95 () (1) Visual FoxPro (2) File New (3) New Project New file (4) Create sdb_p Save (5) Project Manager Data Databases New (6) New Database New Database (7) Create sdb Save 2 (1) Database Designer Add Table (2) Open student.dbf OK (3) Open sc.dbf OK 3

102 96 (1) Database Designer New Table (2) New Table New Table (3) Create course Save (4) Table Designer Fields Name Type Width 2 (5) (4) (6) Database Designer course Browse (7) course 6 4 (1) Database Designer course Modify (2) Table Designer Indexes (3) Name cno Type Primary Expression OK SQL SELECT SELECT student., student., course., sc.; FROM sdb!course INNER JOIN sdb!sc; INNER JOIN sdb!student ; ON sc. = student. ;

103 () 97 ON course. = sc.; ORDER BY course., sc. DESC; INTO TABLE sclist.dbf 2 (1) File New (2) New Form Wizard (3) Wizard Selection Form Wizard OK (4) Step1-Select Fields Databases and tables student student Selected Fields (5) Step2-Choose Form Style Style Shadowed Button type Picture buttons (6) Step3-Sort Records Selected fields Ascending (7) Step4-Finish Finish (1) SELECT student., student., AVG(sc.) AS,; MIN(sc.) AS, SUM(sc.)/ AVG(sc.) AS ; FROM sdb!course INNER JOIN sdb!sc;

104 98 INNER JOIN sdb!student ; ON sc. = student. ; ON Course. = sc.; GROUP BY student.; ORDER BY 3 DESC (2) File New (3) New Report Wizard (4) Wizard Selection Report Wizard OK (5) Step1-Select Fields Databases and tables Sview Sview Selected fields Next (6) Step2-Group Records Next (7) Step3-Choose Report Style Style Casual Next (8) Step5-Sort Records Selected fields Ascending Next (9) Step6-Finish Type a title for your report Finish (10) Save As p_student Save 2 (1) form2 ( Command1) ( Command2) (2) Form Designer Code (3) Command1.Click MODIFY DATABASE SELECT *; FROM SVIEW (4) Form Designer Code (5) Command2.Click report form p_student preview

105 () 99 () (1) Visual FoxPro (2) File Open (3) Open salary_db.dbc OK (4) Database Designer New Table (5) New Table New Table (6) Create dept Save (7) Table Designer Fields Name Type Width 2 Name Type Width 20 (8) Database Designer dept Browse (9) dept 5 2 (1) Database Designer dept Modify (2) Table Designer Indexes (3) Name Order Type Primary Expression OK

106 100 3 (1) Database Designer dept Indexes salarys Indexes (2) dept salarys Edit Relationship (3) Edit Relationship Tabel:dept Related Table:salarys OK 4 (1) Database Clean Up Database (2) dept salarys Edit Referential Integrity (3) Referential Integrity Builder Rules for Updating Cascade Rules for Deleting Restrict Rules for Inserting Restrict OK (1) Visual FoxPro (2) File New (3) New Report Wizard (4) Wizard Selection Report Wizard OK (5) Step1-Select Fields Databases and tables... salarys salarys Selected fields

107 () 101 Next (6) Step2-Group Records Next (7) Step3-Choose Report Style Style Casual Next (8) Step4-Define Report Layout Next (9) Step5-Sort Records Selected fields Ascending Next (10) Step6-Finish Type a title for your report Finish (11) Save As print1 Save 2 (1) For Designer Properties (2) Properties All Caption (3) (4) For Designer Code (5) Command1.Click SELECT SELECT*; FROM salarys (6) For Designer Code (7) Command1.Click thisform.release

108 USE salarys COPY STRUCTURE TO bak_salarys.dbf USE bak_salarys APPEND FROM salarys SELECT a USE c_salary1 SELECT b USE salarys UPDATE ON FROM a REPLACE WITH a. 2 (1) form2 Form Command ( Command1) ( Command2) (2) Form Designer Code (3) Command DO change_c (4) Form Designer Code (5) Command thisform.release

109 () 103 () (1) Visual FoxPro (2) File Open (3) Open.dbc OK (4) Database Designer Add Table (5) Open order_list.dbf OK 2 (1) Database Designer New Table (2) New Table New Table (3) Create order_detail Save (4) Table Designer Fields Name Type Width 6 (5) (4) 3

110 104 (1) Database Designer order_detail Modify (2) Table Designer Indexes (3) Name Type Regular Expression OK 4 (1) Database Designer order_list Indexes order_detail Indexes (2) order_list order_detail Edit Relationship (3) Edit Relationship Tabel:order_list Related Table order_detail OK (1) order_detail (2) Table Append Records (3) Append From Type Table From... (4) Open order_detail1 OK (5) Append From OK (6) Command SQL SELECT SELECT order_list., order_list., order_list.,; order_detail., order_detail.;

111 () 105 FROM!order_list INNER JOIN!order_detail ; ON order_list. = order_detail.; ORDER BY order_list., order_list. DESC 2 (1) UPDATE order_detail1 SET WITH + 5 UPDATE order_detail1 SET = + 5 (2) SELECT,AVG() AS FROM order_detail1 ORDER BY INTO CURSOR lsb SELECT,AVG() AS FROM order_detail1 GROUP BY INTO CURSOR lsb (3) SELECT * FROM lsb FOR < 500 SELECT * FROM lsb WHERE < SELECT result od_bak od_bak od_bak od_bak SELECT SUM(order_detail.* order_detail.) as,;

112 106 Order_detail.; FROM order_detail; GROUP BY order_detail.; INTO TABLE result.dbf CLOSE TABLE USE order_list COPY STRUCTURE TO od_bak CLOSE TABLE USE od_bak APPEND FROM order_list FOR order_list.!= Result. FIELDS; od_bak., od_bak., od_bak., od_bak. CLOSE TABLE SELECT a USE RESULT SELECT b USE od_bak UPDATE ON FROM a REPLACE WITH a. SORT TO od_mod ON ASCENDING

113 () 107 () (1) Visual FoxPro (2) File New (3) New Project New file (4) Create Save 2 (1) Project Manager Data Databases New (2) New Database New Database (3) Create Save 3 (1) Project Manager Data Databases Tables New (2) New Table New Table (3) Create order_list Save (4) Table Designer Fields Name Type

114 108 Width 6 (5) (4) 4 (1) Table Designer Indexes (2) Name Type Primary Expression OK (1) order_list (2) Table Append Records (3) Append From Type Table From... (4) Open order_list1 OK (5) Append From OK (6) Command SQL SELECT SELECT customer.,customer.,order_list,order_list ; FROM!order_list INNER JOIN customer ; ON order_list. = customer.; ORDER BY order_list. DESC; INTO TABLE results.dbf 2

115 () 109 (1) Form Designer (2) Layout Align left sides (3) Form Controls Grid (4) Grid Properties (5) Properties Data RecordSourceType Table ReccordSource Customer SELECT result order_list SELECT SUM(order_detail.* order_detail.) as,; order_detail.; FROM order_detail; GROUP BY order_detail.; INTO TABLE result.dbf CLOSE TABLE SELECT a USE result SELECT b USE order_list UPDATE ON FROM a REPLACE WITH a. SORT TO od_new ON ASCENDING

116 110 () (1) Visual FoxPro (2) File Open (3) Open.dbc OK (4) Database Designer Add Table (5) Open order_detail.dbf OK (6) (4) (5) order_list customer 2 (1) Database Designer order_list Modify (2) Table Designer Indexes (3) Name Type Primary Expression OK 3 (1) Database Designer order_detail Modify

117 () 111 (2) Table Designer Indexes (3) Name Type Regular Expression OK (4) Database Designer order_list Indexes order_detail Indexes (5) order_list order_detail Edit Relationship (6) Edit Relationship Tabel:order_list Related Table order_detail OK 4 (1) Database Clean Up Database (2) order_list order_detail Edit Referential Integrity (3) Referential Integrity Builder Rules for Updating Restrict Rules for Deleting Cascade Rules for Inserting Restrict OK (1) File New Query customer order_list order_detail (2) order_detai. order_detai. order_detai. order_detai. order_detai. Selected fields (3) Selected fields order_detai. Ordering criteria order

118 112 options Ascending (4) Selected fields order_detai. Ordering criteria order options Descending (5) Query Designer Output settings (6) Query destinations Table Table name results OK 2 (1) For Designer Code (2) Command1.Click thisform.caption="" (3) For Designer Code (4) Command1.Click thisform.grid1.recordsource="order_list.dbf" (5) For Designer Code (6) Command1.Click thisform.release SELECT a USE order_list SELECT b USE order_detail UPDATE ON FROM a REPLACE WITH *0.9 *ABS(YEAR(a. ) 2002)+*1.1*(YEAR(a.) 2001)

119 () 113 (1) File New Report (2) Report Quick Report (3) Open order_detail.dbf OK (4) Quick Report Field layout Fields. (5) Field Picker OK (6) Quick Report OK

120 114 () (1) 2001.dbf (2) 2001.dbf Table Append records (3) Append From From Type Table(DBF) Options (4) Append From Options Fields (5) Append From Options For <={^ } OK (6) Append From OK 2 (1) View Browse (2) Table Delete record (3) Delete Scope All For. <={^ } Delete (4) Table Remove deleted records

121 () (1) View Browse (2) File Save as HTML (3) Save as HTML OK 4 (1) (2) Database Designer Modify (3) Table Designer Indexes (4) Name Type Primary Expression OK (5) Database Designer Modify (6) Table Designer Indexes (7) Name Type Regulary Expression OK (1) File New (2) New Query New file (3) Query Designer Join Condition

122 116 (4) Query Designer Fields.....*. AS Selected fields (5) Query Designer Order By.*. Ordering criteria Order options Ascending (6) Query Query Destination (7) Query Destination Table Table name see_a OK 2 (1) Form Designer Code (2) Command1.Click thisform.caption=" " (3) Form Designer Code (4) Command2.Click DO FORM sellcomm (5) Form Designer Code (6) Command3.Click report form print1 preview USE.dbf

123 () 117 COPY STRUCTURE TO.dbf USE.dbf APPEND FROM.dbf SELECT a USE.dbf SCAN REPLACE a. WITH a.*0.1 FOR INT(a./100)=10 ENDSCAN SELECT a USE.dbf SELECT b USE.dbf UPDATE ON FROM a REPLACE WITH a. 2 (1) form2 Form Command ( Command1) ( Command2) (2) Form Designer Code (3) Command DO change_c (4) Form Designer Code (5) Command thisform.release

124 118 () (1) Visual FoxPro (2) File Open (3) Open salary_p.pjx OK (4) Project Manager Data Databases Add (5) Open salary_db.dbc OK 2 (1) Project Manager Data Databases salary_db Modify (2) Database Designer dept Modify (3) Table Designer Indexes (4) Name Order Type Primary Expression OK (5) Database Designer salarys Modify (6) Table Designer Indexes (7) Name Order Type Regular Expression

125 () 119 (8) Name Order Type Primary Expression OK 3 (1) Database Designer dept Indexes salarys Indexes (2) dept salarys Edit Relationship (3) Edit Relationship Tabel:dept Related Table:salarys OK 4 (1) Database Clean Up Database (2) dept salarys Edit Referential Integrity (3) Referential Integrity Builder Rules for Updating Restrict Rules for Deleting Cascade Rules for Inserting Restrict OK (1) File Open (2) Open 13 salary_db OK (3) File New (4) salarys View Desiger (5) View Desiger Fields salarys. salarys. salarys. salarys. salarys. salarys. salarys.

126 120 salarys. salarys.+salarys.+salarys.salarys.salarys. AS Selected fields (6) View Desiger Order By salarys. Ordering criteria Order options Descending (7) View Desiger View SQL (8) View1 (9) File New (10) New Program New file (11) Program T1.PRG (12) Program Do 2 (1) File New (2) New Form New file (3) Form Controls Grid Form Designer Form1 (4) Form Controls Button Form Designer Form1 (5) Grid Properties Properties All RecordSourceType Table ReccordSource salarys name grdsalarys (6) Button Properties Properties All Caption (7) Button Code Command1.Click thisform.release

127 () (1) form2 Form Command group Command (2) Command group Optiongroup1 ( Option1) ( Option2) ( Option3) (3) ( Command1) ( Command2) (4) dept ( Cursor1) salarys ( Cursor2) (5) Form Designer Code (6) Command cur = 1 (7) Form Designer Code (8) Command cur = 2 (9) Form Designer Code (10) Command cur = 3 (11) Form Designer Code (12) Command DO CASE CASE cur ==1 SELECT salarys., salarys., salarys., salarys.,; salarys., salarys., salarys., salarys.,; salarys. + salarys. + salarys. salarys.; salarys. AS ; FROM salary_db!salarys; ORDER BY salarys. DESC; INTO TABLE gz1.dbf CASE cur ==2 SELECT *; FROM salary_db!dept; INTO TABLE bm1.dbf OTHERWISE SELECT dept.*, SUM(salarys.) AS, SUM(salarys.) AS ;, SUM(salarys.) AS, SUM(salarys.) AS ;,SUM(salarys.) AS ;

128 122 FROM salary_db!dept INNER JOIN salary_db!salarys ; ON dept. = salarys.; GROUP BY dept.; INTO TABLE hz1.dbf ENDCASE (13) Form Designer Code (14) Command thisform.release

129 A A.1 A.2 () A.3 ( ) A.4 () (Internet) ( QBASIC C FORTRAN FoxBASE + Visual Basic Visual FoxPro) PC PC PC Windows PC

130 124 ( ) B B B B A.5 Visual Basic Visual FoxPro 90 QBASIC C FORTRAN FoxBASE QBASIC C FORTRAN FoxBASE + 60 Visual Basic Visual FoxPro 90 B 90 A.6 ( FORTRAN ) FORTRAN 4 () B 4 9 A.7 () ( ) FoxBASE + Visual FoxPro FoxPro 2.5/2.6 for Windows FoxPro 2.5/2.6 for Windows Visual FoxPro FoxPro 2.5/2.6 for Windows FoxBASE + FoxBASE + Visual FoxPro A.8

131 A 125 A.9 (

132 126 B Visual FoxPro B Visual FoxPro B.2 Visual FoxPro (1) (2) (3) 3. Visual FoxPro (1) Windows (2) (3) (4) ( ) 4. Visual FoxPro (1) (2) Visual FoxPro 1. (1) (2) (3) (4) (5) 2.

133 B Visual FoxPro 127 (1) (2) (3) (4) JION (5) 3. (1) (2) (3) SQL 1. SQL (1) CREATE TABLE SQL (2) ALTER TABLE SQL 2. SQL (1) DELETE SQL (2) INSERT SQL (3) UPDATE SQL 3. SQL (1) (2) (3) (4) (5) 1. (1) (2) 2. (1) (2) 3. (1) (2) (3) 4. (1)

134 128 (2) (3) (4) 5. Visual FoxPro 1. (1) (2) (3) 2. (1) (2) (3) 3. (1) (2) (3) B (1) (2) (3)