D£®from ´ð°¸£ºC

59£®²éÕÒÊý¾Ý¿âÖÐËùÓеÄÊý¾Ý±íÓÃÒÔÏÂÄÄÒ»Ïî( ) A£®SHOW DATABASE B£®SHOW TABLES C£®SHOW DATABASES D£®SHOW TABLE ´ð°¸£ºB

60£®´¥·¢Æ÷²»ÊÇÏìÓ¦ÒÔÏÂÄÄÒ»Óï¾ä¶ø×Ô¶¯Ö´ÐеÄMysqlÓï¾ä A£®select B£®insert C£®delete D£®update ´ð°¸£ºA

61£®( )±íʾһ¸öеÄÊÂÎñ´¦Àí¿éµÄ¿ªÊ¼ A£®START TRANSACTION B£®BEGIN TRANSACTION C£®BEGIN COMMIT D£®START COMMIT ´ð°¸£ºA

62£®ÒÔÏÂÓï¾ä²»ÕýÈ·µÄÊÇ( ) A£®select * from emp; B£®select ename,hiredate,sal from emp; C£®select * from emp order deptno; D£®select * from where deptno=1 and sal<300; ´ð°¸£ºC

63£®delete from employeeÓï¾äµÄ×÷ÓÃÊÇ( ) A£®É¾³ýµ±Ç°Êý¾Ý¿âÖÐÕû¸öemployee±í£¬°üÀ¨±í½á¹¹ B£®É¾³ýµ±Ç°Êý¾Ý¿âÖÐemployee±íÄÚµÄËùÓÐÐÐ C£®ÓÉÓÚûÓÐwhere×Ӿ䣬Òò´Ë²»É¾³ýÈκÎÊý¾Ý D£®É¾³ýµ±Ç°Êý¾Ý¿âÖÐemployee±íÄڵĵ±Ç°ÐÐ ´ð°¸£ºB

64£®°´Õհ༶½øÐзÖ×é( ) A£®ORDER BY CLASSES B£®DORDER CLASSES C£®GROUP BY CLASSES D£®GROUP CLASSES ´ð°¸£ºC

65£®¸ñʽ»¯ÈÕÆڵĺ¯ÊýÊÇ( ) A£®DATEDIFF() B£®DATE_FORMAT() C£®DAY() D£®CURDATE() ´ð°¸£ºB

66£®ÀýÈçÊý¾Ý¿âÖÐÓÐA±í£¬°üÀ¨Ñ§Éú£¬Ñ§¿Æ£¬³É¼¨ £¬ÐòºÅËĸö×ֶΠ, Êý¾Ý¿â½á¹¹Îª ѧÉú ѧ¿Æ ³É¼¨ ÐòºÅ ÕÅÈý ÓïÎÄ 60 1 ÕÅÈý Êýѧ 100 2 ÀîËÄ ÓïÎÄ 70 3 ÀîËÄ Êýѧ 80 4 ÀîËÄ Ó¢Óï 80 5

ÉÏÊöÄÄÒ»ÁпÉ×÷ΪÖ÷¼üÁÐ( ) A£®ÐòºÅ B£®³É¼¨ C£®Ñ§¿Æ D£®Ñ§Éú ´ð°¸£ºA

67£®Ñ§Éú¹Øϵģʽ S£¨ S£££¬Sname£¬Sex£¬Age£©£¬SµÄÊôÐÔ·Ö±ð±íʾѧÉúµÄѧºÅ¡¢ÐÕÃû¡¢ÐÔ±ð¡¢ÄêÁä¡£ÒªÔÚ±íSÖÐɾ³ýÒ»¸öÊôÐÔ¡°ÄêÁ䡱£¬¿ÉÑ¡ÓõÄSQLÓï¾äÊÇ£¨ £©¡£ A£® UPDATE S Age B£®DELETE Age from S C£®ALTER TABLE S ¡®Age¡¯ D£® ALTER TABLE S DROP Age ´ð°¸£ºD

68£®ÒÔÏÂÄÄÏîÓÃÓÚ×óÁ¬½Ó( ) A£®JOIN B£®RIGHT JOIN C£®LEFT JOIN D£®INNER JOIN ´ð°¸£ºC

69£®Ò»ÕűíµÄÖ÷¼ü¸öÊýΪ( ) A£®ÖÁ¶à3¸ö B£®Ã»ÓÐÏÞÖÆ C£®ÖÁ¶à1¸ö D£®ÖÁ¶à2¸ö ´ð°¸£ºC

70£®SQLÓïÑÔÊÇ( )µÄÓïÑÔ£¬ÇáÒ×ѧϰ ¡£ A£®µ¼º½Ê½ B£®¹ý³Ì»¯ C£®¸ñʽ»¯ D£®·Ç¹ý³Ì»¯ ´ð°¸£ºD

71£®ÔÚÕýÔò±í´ïʽÖУ¬Æ¥ÅäÈÎÒâÒ»¸ö×Ö·ûµÄ·ûºÅÊÇ( ) A£®. B£®* C£®? D£®- ´ð°¸£ºA

72£®Ìõ¼þ¡°BETWEEN 20 AND 30¡±±íʾÄêÁäÔÚ20µ½30Ö®¼ä£¬ÇÒ( ) A£®°üÀ¨20Ëê²»°üÀ¨30Ëê B£®²»°üÀ¨20Ëê°üÀ¨30Ëê C£®²»°üÀ¨20ËêºÍ30Ëê D£®°üÀ¨20ËêºÍ30Ëê ´ð°¸£ºD

73£®ÒÔϱíʾ¿É±ä³¤¶È×Ö·û´®µÄÊý¾ÝÀàÐÍÊÇ( ) A£®TEXT B£®CHAR C£®VARCHAR D£®EMUM ´ð°¸£ºC

74£®ÒÔÏÂ˵·¨´íÎóµÄÊÇ( ) A£®SELECT max(sal),deptno,job FROM EMP group by sal; B£®SELECT max(sal),deptno,job FROM EMP group by deptno; C£®SELECT max(sal),deptno,job FROM EMP; D£®SELECT max(sal),deptno,job FROM EMP group by job; ´ð°¸£ºC

75£®ÒÔÏÂÆ¥Åä'1 ton'ºÍ'2 ton'¼°'3 ton'µÄÕýÔò±í´ïʽÊÇ( ) A£®'123 ton' B£®'1,2,3 ton' C£®'[123] ton' D£®'1|2|3 ton' ´ð°¸£ºC

76£®Æ´½Ó×ֶεĺ¯ÊýÊÇ( ) A£®SUBSTRING() B£®TRIM() C£®SUM£¨£© D£®CONCAT() ´ð°¸£ºD

77£®ÒÔÏÂɾ³ý±íÕýÈ·µÄ( ) A£®Delete * from emp B£®Drop database emp C£®Drop * from emp D£®delete database emp ´ð°¸£ºB

78£®ÏÂÁÐ˵·¨´íÎóµÄÊÇ( ) A£®GROUP BY ×Ó¾äÓÃÀ´·Ö×é WHERE ×Ó¾äµÄÊä³ö B£®WHERE ×Ó¾äÓÃÀ´É¸Ñ¡ FROM ×Ó¾äÖÐÖ¸¶¨µÄ²Ù×÷Ëù²úÉúµÄÐС£ C£®¾ÛºÏº¯ÊýÐèÒªºÍgroup by Ò»ÆðʹÓà D£®HAVING ×Ó¾äÓÃÀ´´ÓFROMµÄ½á¹ûÖÐɸѡÐÐ ´ð°¸£ºD

79£®Ìõ¼þÄêÁäBETWEEN 15 AND 35±íʾÄêÁäÔÚ15ÖÁ35Ö®¼ä£¬ÇÒ( A£®²»°üÀ¨15ËêºÍ35Ëê

) B£®°üÀ¨15Ë굫²»°üÀ¨35Ëê C£®°üÀ¨15ËêºÍ35Ëê D£®°üÀ¨35Ë굫²»°üÀ¨15Ëê ´ð°¸£ºC

80£®´´½¨ÊÓͼµÄÃüÁîÊÇ( ) A£®alter view B£®alter table C£®create table D£®create view ´ð°¸£ºD

81£®´æ´¢¹ý³ÌÊÇÒ»×éÔ¤Ïȶ¨Òå²¢( )µÄTransact-SQLÓï¾ä A£®±£´æ B£®±àд C£®±àÒë D£®½âÊÍ ´ð°¸£ºC

82£®·µ»Ø×Ö·û´®³¤¶ÈµÄº¯ÊýÊÇ( ) A£®len() B£®length() C£®left() D£®long() ´ð°¸£ºB

83£®´ÓÊý¾Ý±íÖвéÕҼǼÓÃÒÔÏÂÄÄÒ»Ïî( ) A£®UPDATE B£®FIND C£®SELECT D£®CREATE ´ð°¸£ºC 84£®SQLÓïÑÔ¼¯Êý¾Ý²éѯ¡¢Êý¾Ý²Ù×Ý¡¢Êý¾Ý¶¨ÒåºÍÊý¾Ý¿ØÖƹ¦ÄÜÓÚÒ»Ì壬ÆäÖУ¬CREATE¡¢DROP¡¢ALTERÓï¾äÊÇʵÏÖÄÄÖÖ¹¦ÄÜ( ) A£®Êý¾Ý²Ù×Ý B£®Êý¾Ý¿ØÖÆ C£®Êý¾Ý¶¨Òå D£®Êý¾Ý²éѯ ´ð°¸£ºC

85£®ÒÔÏÂÄÄÏî²»ÊôÓÚDML²Ù×÷( ) A£®insert B£®update C£®delete D£®create ´ð°¸£ºD

86£®°´ÕÕÐÕÃûÉýÐòÐòÅÅÁÐ( ) A£®ORDER BY NAME ASC B£®ORDER BY ASC NAME