2013VFPϰÌ⣬ģÄâÊÔ¾í¼°´ð°¸ ÏÂÔØ±¾ÎÄ

ÖÐÑ¡ÔñÁË

A) ¹Ø¼ü×Ö¶Î B) SQL UPDATE C) ·¢ËÍSQL¸üРD) ͬ²½¸üР185. ÔÚ²éѯÉè¼ÆÆ÷µÄÊä³ö·½ÏòÉèÖÃÖУ¬²»ÄÜʵÏÖµÄÊä³öÊÇ

A) ±í B) ÊÓͼ C) ͼÐÎ D) ±¨±í 186. ÔÚ Visual Foxpro 6.0 ÖУ¬½¨Á¢²éѯ¿ÉÓÃ________·½·¨

A) ʹÓòéѯÏòµ¼ B) ʹÓòéѯÉè¼ÆÆ÷ C) Ö±½ÓʹÓà SELECT-SQL ÃüÁî D) ÒÔÉÏ·½·¨¾ù¿É 187. ²éѯµÄÊý¾ÝÔ´¿ÉÒÔÊÇ

A) ×ÔÓɱí B) Êý¾Ý¿â±í C) ÊÓͼ D) ÒÔÉϾù¿É 188. Óйضà±í²éѯ½á¹ûÖУ¬ÒÔÏÂ˵·¨ÕýÈ·µÄÊÇ

A) Ö»¿É°üº¬ÆäÖÐÒ»¸ö±íµÄ×Ö¶Î B) ±ØÐë°üº¬²éѯ±íµÄËùÓÐ×Ö¶Î

C) ¿É°üº¬²éѯ±íµÄËùÓÐ×ֶΣ¬Ò²¿ÉÖ»°üº¬²éѯ±í²¿·Ö×Ö¶Î D) ÒÔÉÏ˵·¨¾ù²»ÕýÈ· 189. ÔÚSQLÖУ¬½¨Á¢ÊÓͼÓÃ

A) CREATE SCHEMAÃüÁî B) CREATE TABLEÃüÁî C) CREATE VIEWÃüÁî D) CREATE INDEXÃüÁî 190. ÊÓͼ²»Äܵ¥¶À´æÔÚ£¬Ëü±ØÐëÒÀÀµÓÚ

A) ÊÓͼ B) Êý¾Ý¿â C) Êý¾Ý±í D) ²éѯ 191. Ð޸ı¾µØÊÓͼʹÓõÄÃüÁîÊÇ

A) CREATE SQL VIEW B) MODIFY VIEW C) RENAME VIEW D) DELETE VIEW 192. ÏÂÃæÓйضÔÊÓͼµÄÃèÊöÕýÈ·µÄÊÇ

A£©¿ÉÒÔʹÓÃMODIFY STRUCTUREÃüÁîÐÞ¸ÄÊÓͼµÄ½á¹¹ B£©ÊÓͼ²»ÄÜɾ³ý£¬·ñÔòÓ°ÏìÔ­À´µÄÊý¾ÝÎļþ C£©ÊÓͼÊǶԱíµÄ¸´ÖƲúÉúµÄ

D£©Ê¹ÓöÔÊÓͼ½øÐвéѯʱ±ØÐëÊÂÏÈ´ò¿ª¸ÃÊÓͼËùÔÚµÄÊý¾Ý¿â 193. ÊÓͼÉè¼ÆÆ÷Öк¬Óеġ¢µ«²éѯÉè¼ÆÆ÷ȴûÓеÄÑ¡ÏÊÇ

A£©É¸Ñ¡ B£©ÅÅÐòÒÀ¾Ý C£©·Ö×éÒÀ¾Ý D£©¸üÐÂÌõ¼þ 194. ÏÂÃæ¹ØÓÚ²éѯÃèÊöÕýÈ·µÄÊÇ

A£©¿ÉÒÔʹÓà CREATE VIEW ´ò¿ª²éѯÉè¼ÆÆ÷

B£©Ê¹ÓòéѯÉè¼ÆÆ÷¿ÉÒÔÉú³ÉËùÓÐµÄ SQL ²éѯÓï¾ä

C£©Ê¹ÓòéѯÉè¼ÆÆ÷Éú³ÉµÄ SQL Óï¾ä´æÅ̺󽫴æ·ÅÔÚÀ©Õ¹ÃûΪ QPR µÄÎļþÖÐ D£©Ê¹Óà DO Óï¾äÖ´Ðвéѯʱ£¬¿ÉÒÔ²»´øÀ©Õ¹Ãû 195. ÒÔϹØÓÚ²éѯµÄÃèÊöÕýÈ·µÄÊÇ

A) ²»Äܸù¾Ý×ÔÓÉ±í½¨Á¢²éѯ B) Ö»Äܸù¾Ý×ÔÓÉ±í½¨Á¢²éѯ

C) Ö»Äܸù¾ÝÊý¾Ý¿â±í½¨Á¢²éѯ D) ¿ÉÒÔ¸ù¾ÝÊý¾Ý¿â±íºÍ×ÔÓÉ±í½¨Á¢²éѯ 196. ÒÔϹØÓÚÊÓͼµÄÃèÊöÕýÈ·µÄÊÇ

A) ¿ÉÒÔ¸ù¾Ý×ÔÓÉ±í½¨Á¢ÊÓͼ B) ¿ÉÒÔ¸ù¾Ý²éѯ½¨Á¢ÊÓͼ

C) ¿ÉÒÔ¸ù¾ÝÊý¾Ý¿â±í½¨Á¢ÊÓͼ D) ¿ÉÒÔ¸ù¾ÝÊý¾Ý¿â±íºÍ×ÔÓÉ±í½¨Á¢ÊÓͼ 197. ²éѯÉè¼ÆÆ÷Öаüº¬µÄÑ¡ÏÓÐ

A) ×ֶΣ¬É¸Ñ¡£¬ÅÅÐòÒÀ¾Ý B) ×ֶΣ¬Ìõ¼þ£¬·Ö×éÒÀ¾Ý C) Ìõ¼þ£¬ÅÅÐòÒÀ¾Ý£¬·Ö×éÒÀ¾Ý D) Ìõ¼þ£¬É¸Ñ¡£¬ÔÓÏî 198. ÏÂÁйØÓÚ²éѯÉè¼ÆÆ÷µÄ˵·¨ÖдíÎóµÄÊÇ

16

A) ¼È¿É¶Ôµ¥±í²éѯ£¬Ò²¿É¶Ô¶à±í²éѯ

B) ÔÚ·Ö×éÒÀ¾ÝÑ¡ÏÖУ¬¿ÉÒÔÉèÖòéѯ½á¹û°´Ä³Ò»×Ö¶ÎÖµµÄÉýÐòÅÅÁÐ

C) ¿ÉÒÔ½«²éѯ½á¹û±£´æµ½À©Õ¹ÃûΪ.qprµÄ²éѯÎļþÖУ¬²¢¿ÉÔÚÃüÁî´°¿ÚÖÐÖ±½ÓÓÃdo ÃüÁîÖ´ÐÐ

D) ¿ÉÒÔÉ趨²éѯ½á¹ûµÄÊä³öÐÎʽ£¬ÈçÁÙʱ±í£¬Í¼ÐεÈ

199. ÔÚ²éѯÉè¼ÆÆ÷ÖÐÒÑÉ趨Áª½ÓÌõ¼þΪ STUDENT.ÐÕÃû=xscj.ÐÕÃû, ÈôÒªÔÚ²éѯ½á¹ûÖÐÏÔ

ʾ STUDENT ±íÖÐËùÓмǼ¼° xscj ±íÖÐÂú×ãÌõ¼þµÄ¼Ç¼£¬ÔòÁª½ÓÀàÐÍӦΪ A) ÄÚ²¿Áª½Ó B) ×óÁª½Ó C) ÓÒÁª½Ó D) ÍêÈ«Áª½Ó 200. ÏÂÁÐ˵·¨ÖУ¬´íÎóµÄÊÇ

A) ÔÚÊý¾Ý¿âÖУ¬¿ÉÒÔ°üº¬±í,ÊÓͼ,²éѯÒÔ¼°±í¼äÓÀ¾Ã¹ØÏµ

B) ¿ÉÒÔͨ¹ýÐÞ¸ÄÊÓͼÖÐÊý¾ÝÀ´¸üÐÂÊý¾ÝÔ´ÖÐÊý¾Ý£¬µ«²éѯ²»¿ÉÒÔ

C) ²éѯºÍÊÓͼ¶¼ÊÇÓà select-SQL ÓïÑÔʵÏֵ쬶¼ÒªÒÔÊý¾Ý±í×÷ΪÊý¾ÝÔ´ D) ÊÓͼËäÈ»¾ß±¸ÁËÒ»°ãÊý¾Ý±íµÄÌØÕ÷£¬µ«Ëü±¾Éí²¢²»ÊDZí 201. ÔÚ³ÌÐòÖж¨Òå¾Ö²¿±äÁ¿µÄÃüÁ´ÊÊÇ

A) public B) private C) local D) declare 202. Ö´ÐÐÈçϳÌÐò

S=0 I=1

INPUT \ DO WHILE S<=N S=S+I I=I+1 ENDDO ?S

SET TALK ON

Èç¹ûÊäÈëֵΪ5£¬Ôò×îºóSµÄÏÔʾֵÊÇ

A) 1 B) 3 C) 5 D) 6 203. ÓгÌÐòÈçÏÂ

USE CJ M.ZF=0 SCAN

M.ZF=M.ZF+ZF ENDSCAN ?M.ZF RETURN

ÆäÖÐÊý¾Ý¿âÎļþCJ.DBFÖÐÓÐ2Ìõ¼Ç¼£¬ÄÚÈÝÈçÏ XM ZF 1 ÀîËÄ 500.00 2 ÕÅÈý 600.00 ÔËÐиóÌÐòµÄ½á¹ûÓ¦µ±ÊÇ

A) 1100.00 B) 1000.00 C) 1600.00 D) 1200.00 204. Ö´ÐÐÈçϳÌÐò£º

STORE \ DO WHILE .T.

17

CLEAR

@3,10 SAY \Ìí¼Ó 2.ɾ³ý 3.ÐÞ¸Ä 4.Í˳ö\ @5,15 SAY \ÇëÊäÈëÑ¡Ôñ£º\ READ

IF TYPE(\ PROG=\ DO &PROG ENDIF QUIT ENDDO

Èç¹ûÔÚ\ÇëÊäÈëÑ¡Ôñ:\ʱ£¬¼üÈë4£¬Ôòϵͳ

A) µ÷ÓÃ×Ó³ÌÐòPROG4.PRG B) µ÷ÓÃ×Ó³ÌÐò&PROG.PRG C) ·µ»ØÃüÁî´°¿Ú D) Í˳öVFP

205. ÔÚÓÀÕæÌõ¼þ DO WHILE .T. µÄÑ­»·ÖУ¬ÎªÍ˳öÑ­»·¿ÉʹÓÃ

A) LOOP B) EXIT C) CLOSE D) CLEAR 206. ÔÚÏÂÁÐÃüÁîÖУ¬²»ÄÜÊäÈë×Ö·ûÐÍÊý¾ÝµÄÃüÁîÊÇ

A) accept B) wait C) input D) @...say... 207. Visual Foxpro 6.0 ³ÌÐòÉè¼ÆµÄÈýÖÖ»ù±¾½á¹¹ÊÇ

A) ˳Ðò£¬Ñ¡Ôñ£¬Ñ­»· B) ˳Ðò£¬Ñ¡Ôñ£¬Âß¼­ C) Ä£¿é£¬×ªÒÆ£¬Ñ­»· D) Íø×´£¬Ñ¡Ôñ£¬Âß¼­ 208. ´Ó¼üÅÌÉϽÓÊÜһλÕûÊý²¢´æÈëÄÚ´æ±äÁ¿ X£¬ÕýÈ·µÄ²Ù×÷Ϊ

A) WAIT TO X B) ACCEPT TO X

C) INPUT TO X D) @1,20 GET X PICT \209. SCAN Ñ­»·Óï¾äÊÇ________ɨÃèʽѭ»·

A) Êý×é B) ±í C) ÄÚ´æ±äÁ¿ D) ³ÌÐò

210. Ö´ÐÐÃüÁî INPUT\ÇëÊäÈëÊý¾Ý:\ʱ,Èç¹ûҪͨ¹ý¼üÅÌÊäÈë×Ö·û´®,Ó¦µ±Ê¹Óõ͍

½ç·û°üÀ¨

A) µ¥ÒýºÅ B) µ¥ÒýºÅ»òË«ÒýºÅ

C) µ¥ÒýºÅ¡¢Ë«ÒýºÅ»ò·½À¨ºÅ D) µ¥ÒýºÅ¡¢Ë«ÒýºÅ¡¢·½À¨ºÅ»òÔ²µã 211. Ö´ÐÐÃüÁî INPUT\ÇëÊäÈëÊý¾Ý:\ʱ,¿ÉÒÔͨ¹ý¼üÅÌÊäÈëµÄÄÚÈݰüÀ¨

A) ×Ö·û´® B) ÊýÖµºÍ×Ö·û´®

C) ÊýÖµ¡¢×Ö·û´®ºÍÂß¼­Öµ D) ÊýÖµ¡¢×Ö·û´®¡¢Âß¼­ÖµºÍ±í´ïʽ 212. ˳ÐòÖ´ÐÐÏÂÃæÁ½ÌõÃüÁ

N = 123456.789 @ 10,6 SAY N ÆÁÄ»ÏÔʾµÄ½á¹ûÊÇ

A) $123,456.7 B) 123456.789 C) $123,456.8 D) $$123,456.8 213. ÓÐÒÔϳÌÐò¶Î:

Do CASE

Case ¼ÆËã»ú<60

?\¼ÆËã»ú³É¼¨ÊÇ:\²»¼°¸ñ\

Case ¼ÆËã»ú>=60

?\¼ÆËã»ú³É¼¨ÊÇ:\¼°¸ñ\

Case ¼ÆËã»ú>=70

18

?\¼ÆËã»ú³É¼¨ÊÇ:\ÖÐ\Case ¼ÆËã»ú>=80

?\¼ÆËã»ú³É¼¨ÊÇ:\Á¼\

Case ¼ÆËã»ú>=90

?\¼ÆËã»ú³É¼¨ÊÇ:\ÓÅ\Endcase

ÉèѧÉúÊý¾Ý¿âµ±Ç°¼Ç¼µÄ\¼ÆËã»ú\×ֶεÄÖµÊÇ89,Ö´ÐÐÏÂÃæ³ÌÐò¶ÎÖ®ºó,ÆÁÄ»Êä³ö A) ¼ÆËã»ú³É¼¨ÊÇ:²»¼°¸ñ B) ¼ÆËã»ú³É¼¨ÊÇ:¼°¸ñ C) ¼ÆËã»ú³É¼¨ÊÇ:Á¼ D) ¼ÆËã»ú³É¼¨ÊÇ:ÓÅ 214. ½«ÄÚ´æ±äÁ¿¶¨ÒåΪȫ¾Ö±äÁ¿µÄ VFP ÃüÁîÊÇ

A£©LOCAL B£©PRIVATE C£©PUBLIC D£©GLOBAL 215. ÓÐÈçϳÌÐò£º INPUT TO A IF A=10 S=0 ENDIF S=1 ?S

¼Ù¶¨´Ó¼üÅÌÊäÈëµÄAµÄÖµÒ»¶¨ÊÇÊýÖµÐÍ£¬ÄÇôÉÏÃæÌõ¼þÑ¡Ôñ³ÌÐòµÄÖ´Ðнá¹ûÊÇ A) 0 B) 1 C) ÓÉ A µÄÖµ¾ö¶¨ D) ³ÌÐò³ö´í 216. ÓÐÒ»¸ö±íÎļþ ͼÊé.DBF£¬ÆäÄÚÈÝÈçÏ£º

¼Ç¼ºÅ ×ܱàºÅ ÊéÃû ³ö°æµ¥Î» µ¥¼Û 1 113388 ¸ßµÈÊýѧ Ç廪´óѧ³ö°æÉç 24.00 2 445501 Êý¾Ý¿âµ¼ÂÛ ¿ÆÑ§³ö°æÉç 27.90 3 332211 ¼ÆËã»ú»ù´¡ ¸ßµÈ½ÌÓý³ö°æÉç 23.00 4 665544 VFP 6.0 µç×Ó¹¤Òµ³ö°æÉç 28.60 5 456788 ²Ù×÷ϵͳԭÀí µç×Ó¹¤Òµ³ö°æÉç 25.00 6 456728 ²Ù×÷ϵͳ¸ÅÂÛ ¸ßµÈ½ÌÓý³ö°æÉç 21.00 7 375666 ¼ÆËã»úÍøÂç Ç廪´óѧ³ö°æÉç 37.00 8 245682 ¼ÆËã»úÔ­Àí ¸ßµÈ½ÌÓý³ö°æÉç 25.00

ÇëÎÊÔËÐÐÏÂÁгÌÐòʱ£¬ÔÚÆÁÄ»ÏÔʾµÄ½á¹ûÊÇʲô USE ͼÊé

UPDATE ͼÊé SET µ¥¼Û=µ¥¼Û+5 WHERE ³ö°æµ¥Î»=¡°¿ÆÑ§³ö°æÉ硱 SELECT ³ö°æµ¥Î»,AVG(µ¥¼Û) AS ƽ¾ù¼Û FROM ͼÊé; GROUP BY ³ö°æµ¥Î» INTO CURSOR lsb

SELECT * FROM lsb WHERE ƽ¾ù¼Û<30 ORDER BY ƽ¾ù¼Û; INOT CURSOR lsb1 GO BOTTOM

?LEFT(³ö°æµ¥Î»,8) CLOSE DATABASE

¹©Ñ¡ÔñµÄ´ð°¸ÓУº

A) Ç廪´óѧ B) ¸ßµÈ½ÌÓý C) µç×Ó¹¤Òµ D) ³ö´íÐÅÏ¢ 217. ÓÐ¹Ø loop Óï¾äºÍ exit Óï¾äµÄÐðÊöÕýÈ·µÄÊÇ

A) loop ºÍ exit Óï¾ä¿ÉÒÔдÔÚÑ­»·ÌåµÄÍâÃæ

19