µÚÒ»Õ Êý¾Ý¿â¼¼Êõ»ù´¡ ÏÂÔØ±¾ÎÄ

1£®ÊÓͼ¿ÉÒÔÔÚÊý¾Ý¿âÉè¼ÆÆ÷Öдò¿ª£¬Ò²¿ÉÒÔÓÃUSEÃüÁî´ò¿ª£¬µ«ÔÚʹÓÃUSEÃüÁî֮ǰ£¬±Ø

Ðë´ò¿ª°üº¬¸ÃÊÓͼµÄ______¡£

2£®ÔÚVisual FoxProϵͳÖУ¬²éѯÎļþÊÇÖ¸Ò»¸ö°üÀ¨Ò»ÌõSELECT¡ªSQL ÃüÁîµÄ³ÌÐòÎļþ£¬

ÎļþµÄÀ©Õ¹ÃûΪ______¡£

3£®²éѯÉè¼ÆÆ÷µÄ¡°É¸Ñ¡¡±Ñ¡ÏÓÃÀ´Öƶ¨²éѯµÄ______¡£

4£®Ê¹Óõ±Ç°Êý¾Ý¿âÖеÄVisual FoxPro±íËù½¨Á¢µÄÊÓͼÊÇ______£¬Ê¹Óõ±Ç°Êý¾Ý¿âÖ®ÍâµÄ

Êý¾ÝÔ´ÖеıíËù½¨Á¢µÄÊÓͼÊÇ______¡£

5£®²éѯ½¨Á¢ºó£¬Óû§¿ÉÒ԰Ѳéѯ½á¹ûÊä³öµ½²»Í¬µÄÄ¿µÄµØ£¬Ä¬ÈÏÄ¿µÄµØÊǽ«²éѯ½á¹ûÊä³ö

µ½______ÖС£

6£®ÔÚ´´½¨ÊÓͼʱ£¬ÏàÓ¦µÄÊý¾Ý¿â±ØÐëÊÇ______״̬¡£

7£®ÔÚ²éѯÉè¼ÆÆ÷ÖУ¬ÓÃÓڱ༭Á¬½ÓÌõ¼þµÄÑ¡ÏÊÇ______¡£

8£® ÔÚ²éѯÉè¼ÆÆ÷ÖУ¬¿ÉÒÔÖ¸¶¨ÊÇ·ñÖØ¸´¼Ç¼µÄÊÇ______Ñ¡Ï¡£

9£®ÎªÁ˽¨Á¢Ô¶³ÌÊÓͼ£¬±ØÐëÊ×ÏȽ¨Á¢ÓëÔ¶³ÌÊý¾Ý¿âµÄ______£¬______ÊÇVisual FoxProÊý

¾Ý¿âÖеÄÒ»ÖÖ¶ÔÏó¡£

10£®ÔÚÉæ¼°µ½ÊÓͼµÄʱºò£¬³£°Ñ±í³Æ×÷______¡£ 11£®ÊÓͼÔÊÐíÒÔϲÙ×÷£¬£¨1£©ÔÚÊý¾Ý¿âÖÐʹÓÃUSEÃüÁî´ò¿ª»ò¹Ø±ÕÊÓͼ¡££¨2£©ÔÚ¡°ä¯ÀÀÆ÷¡±

´°¿ÚÖÐÏÔʾ»òÐÞ¸ÄÊÓͼÖеļǼ¡££¨3£©______¡££¨4£©ÔÚÎı¾¿ò¡¢±í¸ñ¿Ø¼þ¡¢±íµ¥»ò±¨±íÖÐʹÓÃÊÓͼ×÷ΪÊý¾ÝÔ´¡£

12£®ÊÓͼһ¾­½¨Á¢£¬¾Í¿ÉÒÔÏñʹÓÃ______Ò»ÑùÀ´Ê¹Óᣠ13£®ÊÓͼÊÇÔÚÊý¾Ý¿â±íµÄ»ù´¡ÉÏ´´½¨µÄÒ»ÖÖÐéÄâ±í¡£ËùνÐéÄâ±íÊÇÖ¸ÊÓͼÖÐÌáÈ¡³öÀ´µÄÊý¾Ý

ÔÚ______Öв¢²»Êµ¼Ê´æÔÚ¡£

14£®ÔÚ¡°ÃüÁ´°¿Ú´ò¿ª¡°ÊÓͼÉè¼ÆÆ÷¡±ÐÞ¸ÄÊÓͼµÄÃüÁîÊÇ______¡£ 15£®ÔÚ¹ØÏµÊý¾Ý¿âÖУ¬ÊÓͼÒÀÀµÓÚ______£¬²¢²»¶ÀÁ¢´æÔÚ¡£

16£®ÔÚÏîÄ¿¹ÜÀíÆ÷ÖÐʹÓÃÊÓͼʱÏÈÑ¡ÔñÒ»¸ö______£¬½Ó×ÅÔÙÑ¡Ôñ______£¬È»ºóÑ¡Ôñ______£¬

Ôò¿ÉÔÚ¡°ä¯ÀÀ¡±´°¿ÚÖÐÏÔʾÊÓͼ£¬²¢¿É¶ÔÊÓͼ½øÐвÙ×÷¡£ 17£®ÄÚ²¿Áª½ÓÊÇÖ¸Ö»ÓÐÂú×ã______µÄ¼Ç¼²Å°üº¬ÔÚ²éѯ½á¹ûÖС£ 18£®Ê¹ÓÃÊÓͼµÄ______¹¦ÄÜ¿ÉÒÔÐ޸ıíÖеÄÊý¾Ý¡£ 19£®²éѯÉè¼ÆÆ÷______Éú³ÉËùÓеÄSQL²éѯÓï¾ä¡£

20£®ÔÚVisual FoxProÖÐ,ÊÓͼ¾ßÓÐ______ºÍ______¹¦ÄÜ¡£

µÚÆßÕ ¹ØÏµÊý¾Ý¿â±ê×¼ÓïÑÔSQL

Ò»¡¢Ñ¡ÔñÌâ

1£®ÔÚVisual FoxProÖУ¬¹ØÓÚSQLÓïÑÔµÄ˵·¨²»ÕýÈ·µÄÊÇ______¡£ A.Ö§³ÖÊý¾Ý¶¨Ò幦ÄÜ B.Ö§³ÖÊý¾Ý²éѯ¹¦ÄÜ C.Ö§³ÖÊý¾Ý²Ù×÷¹¦ÄÜ D.Ö§³ÖÊý¾Ý¿ØÖƹ¦ÄÜ 2£®ÏÂÃæ¹ØÓÚHAVING×Ó¾äÃèÊö´íÎóµÄÊÇ______¡£

A. HAVING×Ӿ䱨ÐëÓëGROUP BY×Ó¾äͬʱʹÓ㬲»Äܵ¥¶ÀʹÓà B. ʹÓÃHAVING×Ó¾äµÄͬʱ²»ÄÜʹÓÃWHERE×Ó¾ä C. ʹÓÃHAVING×Ó¾äµÄͬʱ¿ÉÒÔʹÓÃWHERE×Ó¾ä D. ʹÓÃHAVING×Ó¾äµÄʹÓÃÊÇÏÞ¶¨·Ö×éµÄÌõ¼þ

3£®ÔÚSELECT-SQLÓï¾äÖУ¬ORDER BY×Ó¾ä¸ù¾ÝÁеÄÊý¾Ý¶Ô²éѯ½á¹û½øÐÐÅÅÐò£¬¹ØÓÚÅÅÐòÒÀ

¾ÝµÄ˵·¨Öв»ÕýÈ·µÄÊÇ______¡£ A.Ö»ÒªÊÇFROM×Ó¾äÖбíµÄ×ֶμ´¿É

B.ÊÇSELECTÖ÷¾ä£¨²»ÔÚ×Ó²éѯÖУ©µÄÒ»¸öÑ¡Ïî

C.Ò»¸öÊýÖµ±í´ïʽ£¬±íʾ²éѯ½á¹ûÖеÄÁеÄλÖã¨×î×ó±ßÁбàºÅΪ1£© D.ĬÈÏÊÇÉýÐò£¨ASC£©ÅÅÁУ¬¿ÉÔÚÆäºó¼ÓDESCÖ¸¶¨²éѯ½á¹ûÒÔ½µÐòÅÅÁÐ 4£®¡°Ñ§Éú¡±±í½á¹¹Îª(ѧºÅN(3),ÐÕÃûC(3)£¬ÐÔ±ðC(1)£¬ÄêÁäN(2))£¬Ñ§ºÅΪÖ÷Ë÷Òý£¬ÈôÓÃ

SQLÃüÁîË÷ÒýËùÓбȡ°ÕÅ»»Ð¡±ÄêÁä´óµÄͬѧ£¬ÏÂÁÐÓï¾äÕýÈ·µÄÊÇ______¡£

A.SELECT * FROM ѧÉú WHEREÄêÁä>£¨SELECT ÄêÁä FROM ѧÉú WHERE ÐÕÃû=¡°ÕÅ»»Ð¡±£© B.SELECT * FROM ѧÉú WHERE ÐÕÃû=¡°ÕÅ»»Ð¡±

C.SELECT * FROM ѧÉú WHEREÄêÁä>£¨SELECT ÄêÁä WHERE ÐÕÃû=¡°ÕÅ»»Ð¡±£© D.SELECT * FROM ѧÉú WHERE ÐÕÃû>¡°ÕÅ»»Ð¡±

5£®ÔÚSQLÓï¾äÖУ¬Óë±í´ïʽ¡°²Ö¿âºÅ NOT IN(¡°wh1¡±,¡°wh2¡±)¡±¹¦ÄÜÏàͬµÄ±í´ïʽÊÇ

______¡£

A.²Ö¿âºÅ=¡°wh1¡± AND²Ö¿âºÅ=¡°wh2¡± B.²Ö¿âºÅ!=¡°wh1¡± OR²Ö¿âºÅ#=¡°wh2¡± C.²Ö¿âºÅ<>¡°wh1¡± OR²Ö¿âºÅ!=¡°wh2¡± D.²Ö¿âºÅ!=¡°wh1¡± AND²Ö¿âºÅ!=¡°wh2¡±

6¡¢ÔÚSQL-SELECT Óï¾äÖÐÓÃÓÚʵÏÖ¹ØÏµµÄÑ¡ÔñÔËËãµÄ¶ÌÓïÊÇ______¡£ A.FOR B.WHILE C.WHERE D.CONDITION

7£®²éѯÿÃſγ̵Ä×î¸ß·Ö£¬ÒªÇóµÃµ½µÄÐÅÏ¢°üÀ¨¿Î³ÌÃû³ÆºÍ·ÖÊý£¬ÕýÈ·µÄÃüÁîÊÇ______¡£ A.SELECT ¿Î³ÌÃû³Æ SUM(³É¼¨) AS ·ÖÊý FROM ¿Î³Ì , ѧÉú³É¼¨£» WHERE ¿Î³Ì.¿Î³Ì±àºÅ=ѧÉú³É¼¨.¿Î³Ì±àºÅ£» GROUP BY ¿Î³ÌÃû³Æ

B.SELECT ¿Î³ÌÃû³Æ , MAX(³É¼¨) ·ÖÊý FROM ¿Î³Ì , ѧÉú³É¼¨£» WHERE ¿Î³Ì.¿Î³Ì±àºÅ=ѧÉú³É¼¨.¿Î³Ì±àºÅ£» GROUP BY ¿Î³ÌÃû³Æ

C.SELECT ¿Î³ÌÃû³Æ, SUM(³É¼¨) ·ÖÊý FROM ¿Î³Ì , ѧÉú³É¼¨£» WHERE ¿Î³Ì.¿Î³Ì±àºÅ=ѧÉú³É¼¨.¿Î³Ì±àºÅ£» GROUP BY ¿Î³Ì.¿Î³Ì±àºÅ

D.SELECT ¿Î³ÌÃû³Æ , SUM(³É¼¨) AS ·ÖÊý FROM ¿Î³Ì , ѧÉú³É¼¨£» WHERE ¿Î³Ì.¿Î³Ì±àºÅ=ѧÉú³É¼¨.¿Î³Ì±àºÅ£» GROUP BY ¿Î³Ì±àºÅ

8£®Ò»ÌõûÓÐÖ¸Ã÷È¥ÏòµÄSQL-SELECTÓï¾äÖ´ÐÐÖ®ºó£¬»á°Ñ²éѯ½á¹ûÏÔʾÔÚÆÁÄ»ÉÏ£¬ÒªÍ˳öÕâ

¸ö²éѯ´°¿Ú£¬Ó¦¸Ã°´µÄ¼üÊÇ______¡£

A.ALT B.DELETE C.ESC D.RETURN 9£®ÔÚµ±Ç°ÅÌĿ¼ÏÂɾ³ý±ístock µÄÃüÁîÊÇ______¡£

A.DROP stock B.DELETE TABLE stock C.DROP TABLE stock D.DELETE stock

10£®ÔÚVisual FoxPro ÖУ¬Ê¹ÓÃSQLÃüÁѧÉú±íSTUDENTÖеÄѧÉúÄêÁäAGE×ֶεÄÖµÔö

¼Ó1Ë꣬Ӧ¸ÃʹÓõÄÃüÁîÊÇ______¡£

A.REPLACE AGE WITH AGE+1 B.UPDATE STUDENT AGE WITH AGE+1 C.UPDATE SET AGE WITH AGE+1 D.UPDATE STUDENT SET AGE=AGE+1

11£®½«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 TABLE ¹ÉƱÃû³Æ c(10)

12£®Èç¹ûÒª´´½¨Ò»ÕŽöº¬ÓÐÒ»¸ö×ֶεÄ×ÔÓɱíRY£¬Æä×Ö¶ÎÃûΪXM£¬×Ö¶ÎÀàÐÍΪ×Ö·ûÐÍ£¬×Ö

¶Î¿í¶ÈΪ8£¬Ôò¿ÉÒÔÓÃÏÂÁеÄ______ÃüÁî´´½¨¡£

A.CREATE TABLE RY XM C(8) B.CREATE TABLE RY (XM C(8))

C.CREATE TABLE RY FIELD XM C(8) D.CREATE TABLE RY FIELD (XM C(8)) 13£®ÔÚSQLµÄ²éѯÓï¾äÖУ¬______Óï¾äÏ൱ÓÚʵÏÖ¹ØÏµµÄͶӰ²Ù×÷¡£ A.WHERE B.GROUP BY C.SELECT D.FROM 14£®SQL³ýÁ˾ßÓÐÊý¾Ý²éѯµÄ¹¦ÄÜÍ⣬»¹ÓÐ______µÄ¹¦ÄÜ¡£

A.Êý¾Ý¶¨Òå B.Êý¾Ý²Ù×Ý C.Êý¾Ý¿ØÖÆ D.ÒÔÉ϶¼ÕýÈ· 15£®SQLµÄºËÐÄÊÇ______¡£

A.²éѯ B.Êý¾Ý¶¨Òå C.Êý¾Ý²Ù×Ý D.Êý¾Ý¿ØÖÆ 16£®SQLͬÆäËûÊý¾Ý²Ù×ÝÓïÑÔ²»Í¬£¬¹Ø¼üÔÚÓÚ______¡£

A.SQLÊÇÒ»ÖÖ¹ý³ÌÐÔÓïÑÔ B.SQLÊÇÒ»Öַǹý³ÌÐÔÓïÑÔ C.SQLÓïÑÔ¼òÁ· D.SQLµÄ´Ê»ãÓÐÏÞ 17£®Á¬½Ó²éѯÊÇ»ùÓÚ______µÄ²éѯ

A.Ò»¸ö±í B.Á½¸ö±í C.¶à¸ö¹ØÏµ D.ÓÐÒ»¸ö¹ØÁªµÄ±í 18£®Ê¹ÓÃSQLÓï¾ä¿ÉÒÔ½«²éѯ½á¹ûÅÅÐò£¬ÅÅÐòµÄ¶ÌÓïÊÇ_______¡£ A.ORDER BY B.ORDER C.GROUP BY D.COUNT 19£®¹ØÓÚSQLµÄ¶ÌÓÏÂÁÐ˵·¨ÖÐÕýÈ·µÄÊÇ______¡£ A.HAVING±ØÐëÓëORDER BY¶ÌÓïÁ¬Óà B.ASC±ØÐëÓë¶ÌÓïGROUP BY¶ÌÓïÁ¬ÓÃ

C.ORDER BY¶ÌÓïͨ³£ÔÚGROUP BY¶ÌÓïÖ®ºó D.ORDER BY¶ÌÓï±ØÐëÓëGROUP BY¶ÌÓïÁ¬ÓÃ

20£®ÔÚSQLÖÐÓÃÀ´¼ÆËãÆ½¾ùÖµµÄº¯ÊýΪ______¡£

A.COUNT B.SUM C.AVG D.MAX 21£®ÏÂÁйØÓÚINSERT-SQLµÄÐðÊöÖУ¬ÕýÈ·µÄÊÇ______¡£

A.ÔÚ±íβ²åÈëÒ»Ìõ¼Ç¼ B.ÔÚ±íÍ·²åÈëÒ»Ìõ¼Ç¼ C.ÔÚ±íµÄÈκÎλÖòåÈëÒ»Ìõ¼Ç¼ D.¿ÉÒÔ²åÈëÈô¸ÉÌõ¼Ç¼

22£®ÔÚORDER BY×Ó¾äÖУ¬DESC±íʾ______£»Ê¡ÂÔDESC±íʾ______£¬ÕýÈ·´ð°¸Îª______ A.ÉýÐò£¬½µÐò B.½µÐò£¬ÉýÐò C.ÉýÐò£¬ÉýÐò D.½µÐò£¬½µÐò 23£®SQLÓï¾äÖеÄÌØÊâÔËËã·û²»°üÀ¨______¡£

A.BETWEEN B.AND C.OR D.LIKE

24£®ÔÚSQLÖмÈÔÊÐíÖ´ÐбȽϲÙ×÷£¬ÓÖÔÊÐíÖ´ÐÐËãÊõ²Ù×÷µÄÊý¾ÝÀàÐÍÊÇ______¡£ A.ÊýÖµÐÍ B.×Ö·ûÐÍ C.ʱ¼äÈÕÆÚÐÍ D.ʱ¼äÐÍ 25£®ÒÔϹØÓÚ¿ÕÖµ(NULL)µÄÐðÊöÖУ¬ÕýÈ·µÄÊÇ______¡£

A.¿ÕÖµµÈͬÓÚ¿Õ×Ö·û´® B.¿ÕÖµ±íʾ×ֶλò±äÁ¿»¹Ã»ÓÐÈ·¶¨Öµ C.VFP ²»Ö§³Ö¿ÕÖµ D.¿ÕÖµµÈͬÓÚÊýÖµ0 26£®ÔÚSQL-SELECTÓï¾äÖУ¬ÉèÖÃÄÚ²¿Áª½ÓµÄÃüÁîÊÇ______¡£

A.INNER JOIN B.LEFT JOIN C.RIGHT JOIN D.FULL JOIN 27£®SQLµÄ²éѯÃüÁîµÄ»ù±¾ÐÎʽÓɲéѯ¿é______×é³É¡£

A.SELECT-WHERE-FROM B.SELECT-WHERE-FROM C.SELECT-FROM-WHERE D.SELECT-FROM-WHERE

28£®Èç¹ûÔÚSQL-SELECTÓï¾äµÄORDER BY×Ó¾äÖÐÖ¸¶¨ÁËDESC£¬Ôò±íʾ______¡£ A.°´½µÐòÅÅÐò B.°´ÉýÐòÅÅÐò C.²»ÅÅÐò D.ÎÞÒâÒå

29£®ÔÚ²éѯÀàÐÍÖУ¬²»ÊôÓÚSQL²éѯµÄÊÇ______¡£

A.ǶÌײéѯ B.Áª½Ó²éѯ C.¼òµ¥²éѯ D.ÊÓͼ²éѯ 30£®Visual FoxProÖ§³ÖSQLÃüÁîÒªÇó______¡£

A.±»²Ù×÷µÄ±íÒ»¶¨Òª´ò¿ª B.±»²Ù×÷µÄ±íÒ»¶¨²»Òª´ò¿ª C.±»²Ù×÷µÄ±í²»Ò»¶¨Òª´ò¿ª D.ÒÔÉÏ˵·¨¶¼²»ÕýÈ·

¶þ¡¢Ìî¿ÕÌâ

1£®Ê¹ÓÃSQLÓï¾äÍê³ÉÈçϲÙ×÷£¨½«ËùÓнÌÊڵŤ×ÊÌá¸ß5%£©£º ______½Ìʦ SET ¹¤×Ê=¹¤×Ê*1.05______Ö°³Æ=¡°½ÌÊÚ¡±¡£

2£®SQL²åÈë¼Ç¼µÄÃüÁîÊÇINSERT£¬É¾³ý¼Ç¼µÄÃüÁîÊÇ______£¬Ð޸ļǼµÄÃüÁîÊÇ______¡£ 3£®ÉèÓÐѧÉúÑ¡¿Î±íSC(ѧºÅ£¬¿Î³ÌºÅ£¬³É¼¨)£¬ÓÃSQLÓï¾ä¼ìË÷ÿÃſγ̵Ŀγ̺ż°Æ½¾ù·Ö

µÄÓï¾äÊÇ£º SELECT ¿Î³ÌÃû£¬AVG(³É¼¨) FROM SC______

4£®Óû§Ê¹ÓÃCREATE TABLE-SQL ÃüÁî´´½¨±íµÄ½á¹¹£¬×Ö¶ÎÀàÐͱØÐëÓõ¥¸ö×Öĸ±íʾ£¬¶ÔÓÚ

»õ±ÒÐÍ×ֶΣ¬Æä×Ö¶ÎÀàÐÍÓõ¥¸ö×Öĸ±íʾΪ______¡£

5£®ÓÐÒ»¸öÃûΪV_VIEWµÄÊÓͼ£¬ÏÖÒª°ÑËüɾ³ý£¬¿ÉʹÓõÄÃüÁîΪ______V_VIEW¡£ 6£®ÔÚSQLÖУ¬²éѯ¿ÕֵʱҪʹÓÃ______¡£

7£®ÔÚSQLÓï¾äÖУ¬ÓÃ______Ïû³ýÖØ¸´³öÏֵļǼÐС£

8£®SQLÓï¾äÖеÄINNER JOINµÈ¼ÛÓÚ______£¬Îª______£¬ÔÚVisual FoxProÖгÆÎª______¡£ 9£®ÔÚSQLÖУ¬ÓÃ______ÃüÁî¿ÉÒÔÐ޸ıíÖеÄÊý¾Ý£¬ÓÃ______ÃüÁî¿ÉÒÔÐ޸ıíµÄ½á¹¹¡£ 10£®SQLµÄ²Ù×÷¹¦ÄÜÊÇÖ¸¶ÔÊý¾Ý¿âÖÐÊý¾ÝµÄ²Ù×÷¹¦ÄÜ£¬Ö÷Òª°üÀ¨Êý¾ÝµÄ______¡¢______ºÍ

______3·½ÃæµÄÄÚÈÝ¡£

11£®ÔÚSQLÓï¾äÖУ¬×Ö·û´®Æ¥ÅäÔËËã·ûÓÃ______±íʾ£»______±íʾ0¸ö»ò¶à¸ö×Ö·û£»______

±íʾһ¸ö×Ö·û¡£

12£®ÔÚALTER TABLEÖУ¬______ÓÃÀ´Ìí¼ÓÐÂ×ֶΣ»______ÓÃÀ´ÐÞ¸ÄÒÑÓÐ×ֶΡ£

13£®ÔÚSQL-SELECTÓï¾äÖУ¬¶¨ÒåÒ»¸öÇø¼ä·¶Î§µÄÌØÊâÔËËã·ûÊÇ______£¬¼ì²éÒ»¸öÊôÐÔÖµÊÇ

·ñÊôÓÚÒ»×éÖµÖеÄÌØÊâÔËËã·ûÊÇ______¡£ 14£®ÔÚVisual FoxProÖмÆËã»ú¼ìË÷µÄº¯ÊýÖУ¬______ÓÃÓÚ¼ÆÊý£¬______ÓÃÓÚÇóºÍ£¬______

ÓÃÓÚÇ󯽾ù£¬______ÓÃÓÚÇó×î´óÖµ£¬______ÓÃÓÚÇó×îСֵ¡£ 15£®ÔÚ²éѯ½á¹û´æ·Åµ½Êý×éÖеĶÌÓïÊÇ______¡£

16£®ÔÚSQLµÄǶÌײéѯÖУ¬Á¿´ÊANYºÍ______ÊÇͬÒå´Ê¡£ÔÚSQL²éѯʱ£¬Ê¹ÓÃ______×Ó¾äÖ¸

³ö²éѯÌõ¼þ¡£

17£®°Ñµ±Ç°±íµ±Ç°¼Ç¼µÄѧºÅ¡¢ÐÕÃû×Ö¶ÎÖµ¸´ÖƵ½Êý×éAµÄÃüÁîÊÇ£º SCATTER FIELDѧºÅ¡¢ÐÕÃû ______

18£®ÔÚSQL-SELECTÓï¾äÖУ¬Ìõ¼þ±í´ïʽÓÃ______×Ӿ䣬·Ö×éÓÃ______×Ӿ䣬ÅÅÐòÓÃ______

×Ӿ䡣

19£®ÔÚÓÃCREATE TABLEÃüÁÁ¢±íʱ£¬ÓÃ×Ó¾ä______Ö¸¶¨±íµÄÖ÷Ë÷Òý¡£

20£®ÔÚSQLÖУ¬ÓÃ______ÃüÁî¿ÉÒÔ´Ó±íÖÐɾ³ýÐУ¬ÓÃ______ÃüÁî¿ÉÒÔ´ÓÊý¾Ý¿âÖÐɾ³ý±í¡£ 21£®ÔÚVisual FoxProÖУ¬¼¯ºÏµÄ²¢ÔËËãÊÇÖ¸½«Á½¸öSELECTÓï¾äµÄ²éѯ½á¹ûͨ¹ý²¢ÔËËãºÏ

³É______¸ö²éѯ½á¹û¡£

22£®______ÊÇSQLÖÐ×î¼òµ¥µÄ²éѯ£¬ÕâÖÖ²éѯ»ùÓÚµ¥¸ö±í£¬ËüÊÇÓÉ______ºÍ______¶ÌÓï¹¹³É

µÄÎÞÌõ¼þ²éѯ£¬»òÊÇÓÉ______¡¢______¡¢______¶ÌÓï¹¹³ÉµÄÌõ¼þ²éѯ¡£ 23£®ÔÚVisual FoxProÖÐSQLµÄDELETEÃüÁîÊÇ______ɾ³ý¼Ç¼¡£

24£®SQLÓïÑÔÓÐÁ½ÖÖʹÓ÷½Ê½£¬Ò»ÖÖÊÇÔÚÖն˽»»¥·½Ê½ÏÂʹÓ㬳ÆÎª______£»ÁíÍâÒ»ÖÖÊÇǶ

ÈëÔڸ߼¶ÓïÑԵijÌÐòÖÐʹÓ㬳ÆÎª______¡£ 25£®SQLµÄDROP INDEXÓï¾äµÄ×÷ÓÃÊÇ______¡£