37£®ÏÂÁÐÄÄЩÊý¾ÝÊÇ×Ö·ûÐÍÊý¾Ý¡£( ) A£®Öйú B£®¡°1+2¡± C£®¡±can¡¯t¡± D£®¡±ÕÅÈý£ÀîËÄ¡± ´ð°¸£ºB,D,C
38£®¹ØÓÚÓï¾älimit 5,5£¬Ëµ·¨ÕýÈ·µÄÊÇ A£®±íʾ¼ìË÷³öµÚ5ÐпªÊ¼µÄ5Ìõ¼Ç¼ B£®±íʾ¼ìË÷³öÐÐ6¿ªÊ¼µÄ5Ìõ¼Ç¼ C£®±íʾ¼ìË÷³öµÚ6ÐпªÊ¼µÄ5Ìõ¼Ç¼ D£®±íʾ¼ìË÷³öÐÐ5¿ªÊ¼µÄ5Ìõ¼Ç¼ ´ð°¸£ºC,D
39£®SQLÓïÑÔ¼¯¼¸¸ö¹¦ÄÜÄ£¿éΪһÌ壬ÆäÖаüÀ¨£¨ £© A£®C. DCL B£® B. DML C£® D. DNL D£®A. DDL ´ð°¸£ºD,B,A
40£®ÏÂÁÐ˵·¨ÕýÈ·µÄÊÇ£¨£©
A£®alter table user drop column sex; B£®alter table user add sex varchar(20); C£®alter table user drop sex; D£®alter table user modify id int primary key; ´ð°¸£ºD,B,A,C
41£®ÊÓͼһ°ã²»ÓÃÓÚÏÂÁÐÄÄЩÓï¾ä( ) A£®DELETE B£®SELECT C£®INSERT D£®UPDATE ´ð°¸£ºC,D,A
42£®ÔÚËãÊõÔËËã·û¡¢±È½ÏÔËËã·û¡¢Âß¼ÔËËã·û£¬ÕâÈýÖÖ·ûºÅÖУ¬ËüÃǵÄÓÅÏȼ¶ÅÅÁв»ÕýÈ·µÄÊÇ( ) A£®ËãÊõ/Âß¼/±È½Ï B£®±È½Ï/Âß¼/ËãÊõ C£®±È½Ï/ËãÊõ/Âß¼ D£®ËãÊõ/±È½Ï/Âß¼ ´ð°¸£ºA,C,B
43£®¶Ôͬһ´æ´¢¹ý³ÌÁ¬ÐøÁ½´ÎÖ´ÐÐÃüÁîDROP PROCEDURE IF EXISTS£¬½«»á( ) A£®µÚÒ»´ÎÖ´ÐÐɾ³ý´æ´¢¹ý³Ì£¬µÚ¶þ´Î²úÉúÒ»¸ö´íÎó B£®µÚÒ»´ÎÖ´ÐÐɾ³ý´æ´¢¹ý³Ì£¬µÚ¶þ´ÎÎÞÌáʾ C£®´æ´¢¹ý³Ì²»Äܱ»É¾³ý D£®×îÖÕɾ³ý´æ´¢¹ý³Ì ´ð°¸£ºB,D
44£®¹ØÓÚ¼ìË÷½á¹ûÅÅÐò£¬ÕýÈ·µÄÊÇ( ) A£®¹Ø¼ü×ÖDESC±íʾ½µÐò£¬ASC±íʾÉýÐò B£®Èç¹ûÖ¸¶¨¶àÁÐÅÅÐò£¬Ö»ÄÜÔÚ×îºóÒ»ÁÐʹÓÃÉýÐò»ò½µÐò¹Ø¼ü×Ö C£®Èç¹ûÖ¸¶¨¶àÁÐÅÅÐò£¬¿ÉÒÔÔÚÈÎÒâÁÐʹÓÃÉýÐò»ò½µÐò¹Ø¼ü×Ö D£®¹Ø¼ü×ÖASC±íʾ½µÐò£¬DESC±íʾÉýÐò ´ð°¸£ºA,C
45£®ÒÔÏÂÓï¾ä´íÎóµÄÊÇ£¨£© ; SELECT rank, AVG(salary) FROM people HAVING AVG(salary) > 1000 GROUP BY rank; A£®SELECT rank, AVG(salary) FROM people GROUP BY rank HAVING AVG(salary) > 1000 B£®SELECT rank, AVG(salary) FROM people HAVING AVG(salary) > 1000 GROUP BY rank; C£®SELECT AVG(salary) FROM people GROUP BY rank HAVING AVG(salary) > 1000; D£®SELECT rank, AVG(salary) FROM people GROUP BY rank WHERE AVG(salary) > 1000; ´ð°¸£ºD,B
46£®´´½¨Êý¾Ý±íʱ£¬ÏÂÁÐÄÄЩÁÐÀàÐ͵Ŀí¶ÈÊÇ¿ÉÒÔÊ¡ÂԵġ£ ( ) A£®DATE B£®INT C£®CHAR D£®TEXT ´ð°¸£ºB,D,A
47£®¹ØÓÚÖ÷¼üÏÂÁÐ˵·¨ÕýÈ·µÄÊÇ£¨£©
A£®Ö÷¼üµÄÖµ¶ÔÓû§¶øÑÔÊÇûÓÐʲôÒâÒå B£®Ö÷¼üµÄÖ÷Òª×÷ÓÃÊǽ«¼Ç¼ºÍ´æ·ÅÔÚÆäËû±íÖеÄÊý¾Ý½øÐйØÁª¡£ C£®Ò»¸öÖ÷¼üÊÇΨһʶ±ðÒ»¸ö±íµÄÿһ¼Ç¼£¬ D£®Ö÷¼üÊDz»Í¬±íÖи÷¼Ç¼֮¼äµÄ¼òµ¥Ö¸Õë¡£ ´ð°¸£ºC,B,D,A
48£®ÄúÐèÒªÏÔʾ´Ó2009Äê1ÔÂ1ÈÕµ½2009Äê12ÔÂ31ÈÕ¹ÍÓ¶µÄËùÓÐÖ°Ô±µÄÐÕÃûºÍ¹ÍÓ¶ÈÕÆÚ¡£Ö°Ô±ÐÅÏ¢±ítblEmployees°üº¬ÁÐNameºÍÁÐHireDate£¬ÏÂÃæÄÄЩÓï¾äÄÜÍê³É¸Ã¹¦ÄÜ ( ) A£®SELECT Name, HireDate FROM tblEmployees B£®SELECT Name, HireDate FROM tblEmployees WHERE HireDate =¡¯2009-01-01¡¯ OR ¡®2009-12-31¡¯ C£®SELECT Name, HireDate FROM tblEmployees WHERE HireDate BETWEEN ¡¯2008-12-31¡¯ AND ¡®2010-01-01¡¯ D£®SELECT Name, HireDate FROM tblEmployees WHERE substring(HireDate,1,4)=2009; ´ð°¸£ºC,D
49£®ÒÔÏÂÄÄÏîÊÇÊÂÎñÌØÐÔ( ) A£®¶ÀÁ¢ÐÔ B£® ³Ö¾ÃÐÔ C£®Ô×ÓÐÔ
D£® Ò»ÖÂÐÔ ´ð°¸£ºC,D,A,B
50£®¶ÔÓÚÏÔʾ²Ù×÷ÒÔÏÂ˵·¨ÕýÈ·µÄÊÇ£¨£© A£®show database£»ÏÔʾËùÓÐÊý¾Ý¿â B£®show table£»ÏÔʾËùÓбí C£®show tables£»ÏÔʾËùÓбí D£®show databases£»ÏÔʾËùÓÐÊý¾Ý¿â ´ð°¸£ºD,B
51£®Óï¾äselect * from products where prod_name like '%se%'½á¹û¼¯°üÀ¨( ) A£®¼ìË÷products±íÖÐprod_name×Ö¶ÎÒÔ'se'½áβµÄÊý¾Ý B£®¼ìË÷products±íÖÐprod_name×Ö¶ÎÒÔ'se'¿ª¹ØµÄÊý¾Ý C£®¼ìË÷products±íÖÐprod_name×ֶΰüº¬'se'µÄÊý¾Ý D£®¼ìË÷products±íÖÐprod_name×ֶβ»°üº¬'se'µÄÊý¾Ý ´ð°¸£ºC,B,A
52£®ÔÚmysqlÌáʾ·ûÏ¿ÉÒÔÊäÈëÒ»¸öSQLÓï¾ä£¬²¢ÒÔ( )½áβ£¬È»ºó°´»Ø³µÖ´ÐиÃÓï¾ä( )
A£®¡°\\G¡± B£®¡°¡£¡± C£®¡°\\g¡± D£®¡°;¡± ´ð°¸£ºD,C,A
53£®¹ØÓÚinsertÓï¾äÏÂÁÐ˵·¨ÕýÈ·µÄÊÇ£¨£© A£®insert into ±íÃûvalues(×Ö¶ÎÃû1¶ÔÓ¦µÄÖµ); B£®insert into ±íÃû values(×Ö¶ÎÃû1¶ÔÓ¦µÄÖµ£¬×Ö¶ÎÃû2¶ÔÓ¦Öµ); C£®insert into ±íÃû(×Ö¶ÎÃû1) value (×Ö¶ÎÃû1¶ÔÓ¦µÄÖµ); D£® insert into ±íÃû(×Ö¶ÎÃû1£¬×Ö¶ÎÃû2) values(×Ö¶ÎÃû1¶ÔÓ¦µÄÖµ£¬×Ö¶ÎÃû2¶ÔÓ¦Öµ); ´ð°¸£ºD,B
54£® 23 ¹ØÏµÊý¾ÝÄ£ÐÍÄÄЩÓŵ㣿( ) A£®A£©½á¹¹¼òµ¥ B£® C£©Óбê×¼ÓïÑÔ C£® B£©ÊÊÓÃÓÚ¼¯ºÏ²Ù×÷ D£® D£©¿É±íʾ¸´ÔÓµÄÓïÒå ´ð°¸£ºA,C,B
55£®¶Ôij¸öÊý¾Ý¿âʹÓüǼµ¥ , ¿ÉÒÔ½øÐеļǼ²Ù×÷ÓÐ( )
A£®É¾³ý B£®Ð½¨ C£®»¹Ô D£®²åÈë ´ð°¸£ºB,A,C
56£®¹ØÓÚselectÓï¾äÏÂÁÐ˵·¨ÕýÈ·µÄÊÇ£¨£© A£® select (name) from table person: ËùÓмǼµÄname×ֶεÄÖµ B£®select (name) from person where age=12 or name=\ or »òÕß
C£® select (name) from table person where age=12; ²éÕÒage=12µÄ¼Ç¼µÄÄǸö×ֶεÄÖµ D£® select (name£¬age) from person where age=12 and name=\²¢ÇÒ ´ð°¸£ºB,D
57£®ÔÚ×Ö·û´®±È½ÏÖУ¬ÏÂÁÐÄÄЩÊDz»ÕýÈ·µÄ( ) A£®ËùÓбêµã·ûºÅ±ÈÊý×Ö´ó B£®ËùÓÐÊý×Ö¶¼±Èºº×Ö´ó C£®ËùÓÐÓ¢ÎıÈÊý×ÖС D£®ËùÓÐÓ¢ÎÄ×Öĸ¶¼±Èºº×ÖС ´ð°¸£ºB,C,A
58£®Êý¾Ý¿âÐÅÏ¢µÄÔËÐа²È«²ÉÈ¡µÄÖ÷´ëÊ©ÓÐ( )¡£ A£®±¸·ÝÓë»Ö¸´ B£®Ó¦¼± C£®·çÏÕ·ÖÎö D£®É󼯏ú×Ù ´ð°¸£ºC,D,A,B Èý¡¢Ìî¿ÕÌâ
1£®select 9/3;µÄ½á¹ûΪ_____¡£ ´ð°¸£º3.0000
2£®²¹È«Óï¾ä:select vend_id,count(*) as num_prods from products group by ____; ´ð°¸£ºvend_id
3£®ÓÃSELECT½øÐÐÄ£ºý²éѯʱ£¬¿ÉÒÔʹÓÃÆ¥Åä·û£¬µ«ÒªÔÚÌõ¼þÖµÖÐʹÓÃ____»ò%µÈͨÅä·ûÀ´ÅäºÏ²éѯ¡£ ´ð°¸£º- 4£®µ±Ëù²éѯµÄ±í²»ÔÚµ±Ç°Êý¾Ý¿âʱ£¬¿ÉÓÃ___________________________¸ñʽÀ´Ö¸³ö±í»òÊÓͼ¶ÔÏó
´ð°¸£ºÊý¾Ý¿â.ËùÓÐÕßÃû³Æ.¶ÔÏóÃû³Æ 5£®Óï¾äSELECT ¡°1+2¡±£»µÄÏÔʾ½á¹ûÊÇ£ß£ß£ß£ß ´ð°¸£º¡°1+2¡±
6£®Èç¹ûMySQL·þÎñÃûΪMySQL5£¬ÔòÔÚWindowsµÄÃüÁî´°¿ÚÖУ¬Æô¶¯MySQL·þÎñµÄÖ¸ÁîÊÇ____
´ð°¸£ºnet start mysql5
7£®MySQLÊÇÒ»Ö֣ߣߣߣߣߣߣ¨¶àÓû§¡¢µ¥Óû§£©µÄÊý¾Ý¿â¹ÜÀíϵͳ ´ð°¸£º¶àÓû§
8£®select ¡®2.5a¡¯+3;µÄ½á¹ûΪ_____¡£ ´ð°¸£º5.5
9£®select (NULL<=>NULL) is NULL;µÄ½á¹ûΪ_____¡£ ´ð°¸£º0
10£®´´½¨Êý¾Ý±íµÄÃüÁîÓï¾äÊÇ£ß£ß£ß£ß£ß£ß£ß£ß£ß ´ð°¸£ºcreate table
11£®____Óï¾ä¿ÉÒÔÐ޸ıíÖи÷ÁеÄÏȺó˳Ðò ´ð°¸£ºALTER TABLE
12£®µ±Ä³×Ö¶ÎҪʹÓÃAUTO£ßINCREMENTµÄÊôÐÔʱ£¬¸Ã×ֶαØÐëÊǣߣߣߣßÀàÐ͵ÄÊý¾Ý¡£ ´ð°¸£ºINT