MySQLÊý¾Ý¿â¿¼ÊÔÊÔÌâ¼°´ð°¸

C£®LINK D£®UNION ´ð°¸£ºD

30£®´´½¨Êý¾Ý¿âʹÓÃÒÔÏÂÄÄÏî( ) A£®create mytest B£®create table mytest C£®database mytest D£®create database mytest ´ð°¸£ºD

31£®ÒÔÏÂÄÄÏîÓÃÀ´·Ö×é( ) A£®ORDER BY B£®ORDERED BY C£®GROUP BY D£®GROUPED BY ´ð°¸£ºD

32£®SQLÊÇÒ»ÖÖ( )ÓïÑÔ¡£ A£® º¯ÊýÐÍ B£®¸ß¼¶Ëã·¨ C£®¹ØϵÊý¾Ý¿â D£® È˹¤ÖÇÄÜ ´ð°¸£ºC

33£®É¾³ýÊý¾Ý±íÓÃÒÔÏÂÄÄÒ»Ïî( ) A£®DROP B£®UPDATE C£®DELETE D£®DELETED ´ð°¸£ºA

34£®ÈôÒªÔÚ»ù±¾±íSÖÐÔö¼ÓÒ»ÁÐCN£¨¿Î³ÌÃû£©£¬¿ÉÓÃ( A£®ADD TABLE S ALTER£¨CN CHAR£¨£¸£©£© B£®ALTER TABLE S ADD£¨CN CHAR£¨£¸£©£© C£®ADD TABLE S£¨CN CHAR£¨£¸£©£© D£®ALTER TABLE S £¨ADD CN CHAR£¨£¸£©£© ´ð°¸£ºB

35£®ÏÂÁеÄSQLÓï¾äÖУ¬( )²»ÊÇÊý¾Ý¶¨ÒåÓï¾ä¡£ A£®CREATE TABLE B£®GRANT C£®CREATE VIEW D£® DROP VIEW ´ð°¸£ºB

36£®ÒÔÏÂɾ³ý¼Ç¼ÕýÈ·µÄ( ) A£®delete from emp where name='dony'; B£®Delete * from emp where name='dony'; C£®Drop from emp where name='dony'; D£®Drop * from emp where name='dony';

) ´ð°¸£ºA

37£®É¾³ý¾­ÏúÉÌ1018µÄÊý¾Ý¼Ç¼µÄ´úÂëΪ( ) from distributors where distri_num=1018 A£®drop table B£®delete * C£®drop column D£®delete ´ð°¸£ºD

38£®°´ÕÕÐÕÃû½µÐòÅÅÁÐ( ) A£®ORDER BY DESC NAME B£®ORDER BY NAME DESC C£®ORDER BY NAME ASC D£®ORDER BY ASC NAME ´ð°¸£ºB

39£®¿ÉÒÔÔÚ´´½¨±íʱÓÃ( )À´´´½¨Î¨Ò»Ë÷Òý£¬Ò²¿ÉÒÔÓÃ( A£®Create table£¬Create index B£®ÉèÖÃÖ÷¼üÔ¼Êø£¬ÉèÖÃΨһԼÊø C£®ÉèÖÃÖ÷¼üÔ¼Êø£¬Create index D£®ÒÔÉ϶¼¿ÉÒÔ ´ð°¸£ºC

40£®ÔÚSELECTÓï¾äÖУ¬Ê¹Óùؼü×Ö( )¿ÉÒÔ°ÑÖظ´ÐÐÆÁ±Î A£®TOP B£®ALL C£®UNION D£®DISTINCT ´ð°¸£ºD

41£®ÒÔϾۺϺ¯ÊýÇóƽ¾ùÊýµÄÊÇ( ) A£®COUNT B£®MAX C£®AVG D£®SUM ´ð°¸£ºC

42£®·µ»Øµ±Ç°ÈÕÆڵĺ¯ÊýÊÇ( ) A£®curtime() B£®adddate() C£®curnow() D£®curdate() ´ð°¸£ºD

43£®ÓÃÀ´²åÈëÊý¾ÝµÄÃüÁîÊÇ( )£¬ÓÃÓÚ¸üеÄÃüÁîÊÇ( A£®INSERT£¬UPDATE B£®CREATE£¬INSERT INTO C£®DELETE£¬UPDATE D£®UPDATE,INSERT ´ð°¸£ºA

44£®SELECT COUNT(SAL) FROM EMP GROUP BY DEPTNO;Òâ˼ÊÇ( )À´´´½¨Î¨Ò»Ë÷Òý ) )

A£®Çóÿ¸ö²¿ÃÅÖеŤ×Ê B£®Çóÿ¸ö²¿ÃÅÖй¤×ʵĴóС C£®Çóÿ¸ö²¿ÃÅÖй¤×ʵÄ×ÛºÏ D£®Çóÿ¸ö²¿ÃÅÖй¤×ʵĸöÊý ´ð°¸£ºD

45£®ÒÔϱí´ï½µÐòÅÅÐòµÄÊÇ( ) A£®ASC B£®ESC C£®DESC D£®DSC ´ð°¸£ºC

46£®ÒÔÏÂÄÄÏî²»ÊôÓÚÊý¾ÝÄ£ÐÍ( ) A£®¹ØϵģÐÍ B£®Íø×´Ä£ÐÍ C£®²ã´ÎÄ£ÐÍ D£®ÍøÂçÄ£ÐÍ ´ð°¸£ºA

47£®ÓÐÈý¸ö±í£¬ËüÃǵļǼÐÐÊý·Ö±ðÊÇ10ÐС¢2ÐкÍ6ÐУ¬Èý¸ö±í½øÐн»²æÁ¬½Óºó£¬½á¹û¼¯Öй²ÓÐ( )ÐÐÊý¾Ý A£®18 B£®26 C£®²»È·¶¨ D£®120 ´ð°¸£ºD

48£®´ÓGROUP BY·Ö×éµÄ½á¹û¼¯ÖÐÔÙ´ÎÓÃÌõ¼þ±í´ïʽ½øÐÐɸѡµÄ×Ó¾äÊÇ( ) A£®FROM B£®ORDER BY C£®HAVING D£®WHERE ´ð°¸£ºC

49£®ÎªÊý¾Ý±í´´½¨Ë÷ÒýµÄÄ¿µÄÊÇ( ) A£®Ìá¸ß²éѯµÄ¼ìË÷ÐÔÄÜ B£®¹éÀà C£®´´½¨Î¨Ò»Ë÷Òý D£®´´½¨Ö÷¼ü ´ð°¸£ºA

50£®Èç¹ûÒª»Ø¹öÒ»¸öÊÂÎñ£¬ÔòҪʹÓÃ( )Óï¾ä¡£ A£®commit transaction B£® begin transaction C£® revoke D£®rollback transaction ´ð°¸£ºD

51£®²éÕÒÊý¾Ý±íÖеļǼÓÃÒÔÏÂÄÄÒ»Ïî( ) A£®ALTRE

B£®UPDATE C£®SELECT D£®DELETE ´ð°¸£ºC

52£®ÔÚMySQLÖУ¬½¨Á¢Êý¾Ý¿âÓÃ( ) A£®CREATE TABLEÃüÁî B£®CREATE TRIGGERÃüÁî C£®CREATE INDEXÃüÁî D£®CREATE DATABASEÃüÁî ´ð°¸£ºD

53£®MySQLÖУ¬Ô¤ÉèµÄ¡¢ÓµÓÐ×î¸ßȨÏÞ³¬¼¶Óû§µÄÓû§ÃûΪ( ) A£®test B£®Administrator C£®DA D£®root ´ð°¸£ºD

54£®ÒÔϲåÈë¼Ç¼ÕýÈ·µÄ( ) A£®insert into emp(ename,hiredate,sal) values (value1,value2,value3); B£®insert into emp (ename,sal)values(value1,value2,value3); C£®insert into emp (ename)values(value1,value2,value3); D£®insert into emp (ename,hiredate,sal)values(value1,value2); ´ð°¸£ºA

55£®ÔÚSQLÓïÑÔÖеÄÊÓͼVIEWÊÇÊý¾Ý¿âµÄ( ) A£®Íâģʽ B£®´æ´¢Ä£Ê½ C£®Ä£Ê½ D£® ÄÚģʽ ´ð°¸£ºA

56£®ÒÔÏÂÄÄÏîÓÃÀ´ÅÅÐò( ) A£®ORDERED BY B£®ORDER BY C£®GROUP BY D£®GROUPED BY ´ð°¸£ºB

57£®ÒÔϾۺϺ¯ÊýÇó¸öÊýµÄÊÇ( ) A£®AVG B£®SUM C£®MAX D£®COUNT ´ð°¸£ºD

58£®ÔÚselectÓï¾äÖУ¬ÊµÏÖÑ¡Ôñ²Ù×÷µÄ×Ó¾äÊÇ( ) A£®select B£®group by C£®where