文档介绍:1SQLÊý¾Ý¿âÊÔÌâÒ»¡¢µ¥ÏîÑ¡ÔñÌâ(ÿСÌâ1·Ö£¬¹²10·Ö)ÏÂÁÐËÄÏîÖУ¬²»ÊôÓÚÊý¾Ý¿âÌصãµÄÊÇ£¨C£©¡£Êý¾Ý¹²ÏíB.Êý¾ÝÍêÕûÐÔC.Êý¾ÝÈßÓàºÜ¸ßD.Êý¾Ý¶ÀÁ¢ÐÔ¸ßÏÂÁÐËÄÏîÖУ¬²»ÊôÓÚSQL2000ʵÓóÌÐòµÄÊÇ£¨D£©¡£ÆóÒµ¹ÜÀíÆ÷B.²éѯ·ÖÎöÆ÷C.·þÎñ¹ÜÀíÆ÷D.ýÌå²¥·ÅÆ÷SQLServer°²×°³ÌÐò´´½¨4¸öϵͳÊý¾Ý¿â£¬ÏÂÁÐÄĸö²»ÊÇ£¨C£©ÏµÍ³Êý¾Ý¿â¡££¨A£©ÊÇλÓÚÓû§Óë²Ù×÷ϵͳ֮¼äµÄÒ»²ãÊý¾Ý¹ÜÀíÈí¼þ£¬ËüÊôÓÚϵͳÈí¼þ£¬ËüΪÓû§»òÓ¦ÓóÌÐòÌṩ·ÃÎÊÊý¾Ý¿âµÄ·½·¨¡£Êý¾Ý¿âÔÚ½¨Á¢¡¢Ê¹ÓúÍά»¤Ê±ÓÉÆäͳһ¹ÜÀí¡¢Í³Ò»¿ØÖÆ¡£A£®DBMSB£®DBC£®DBSD£®DBAÔÚSQLÖУ¬½¨Á¢±íÓõÄÃüÁîÊÇ(B)¡£ÓïÑÔÖУ¬Ìõ¼þÄêÁäBETWEEN15AND35±íʾÄêÁäÔÚ15ÖÁ35Ö®¼ä£¬ÇÒ(A)¡£°üÀ¨15ËêºÍ35Ëê²»°üÀ¨15ËêºÍ35Ëê°üÀ¨15Ë굫²»°üÀ¨35Ëê°üÀ¨35Ë굫²»°üÀ¨15ËêÏÂÁÐËÄÏîÖУ¬²»ÕýÈ·µÄÌá·¨ÊÇ(C)¡£2SQLÓïÑÔÊǹØϵÊý¾Ý¿âµÄ¹ú¼Ê±ê×¼ÓïÑÔSQLÓïÑÔ¾ßÓÐÊý¾Ý¶¨Òå¡¢²éѯ¡¢²Ù×ݺͿØÖƹ¦ÄÜSQLÓïÑÔ¿ÉÒÔ×Ô¶¯ÊµÏÖ¹ØϵÊý¾Ý¿âµÄ¹æ·¶»¯SQLÓïÑÔ³ÆΪ½á¹¹²éѯÓïÑÔÔÚMSSQLServerÖУ¬ÓÃÀ´ÏÔʾÊý¾Ý¿âÐÅÏ¢µÄϵͳ´æ´¢¹ý³ÌÊÇ(D)¡£ÓïÑÔÖУ¬É¾³ý±íÖÐÊý¾ÝµÄÃüÁîÊÇ(A)¡£µÄÊÓͼÊÇ´Ó£¨C£©Öе¼³öµÄ¡£»ù±¾±íB.ÊÓͼ»ù±¾±í»òÊÓͼD.Êý¾Ý¿âSQLÊý¾Ý¿âÊÔÌâ2Ò»¡¢µ¥ÏîÑ¡ÔñÌâ(ÿСÌâ1·Ö£¬¹²10·Ö)ÏÂÁÐÄĸö²»ÊÇsqlÊý¾Ý¿âÎļþµÄºó׺¡£CA£®.mdfB£®.ldfC£®.tifD£®.ndfÊý¾Ý¶¨ÒåÓïÑÔµÄËõд´ÊΪ(A)¡£ÔÚSQLÓïÑÔÖУ¬½¨Á¢´æ´¢¹ý³ÌµÄÃüÁîÊÇ(A)A¡¢CREATEPROCEDUREB¡¢CREATERULEC¡¢CREATEDURED¡¢CREATEFILE3SQLÊý¾Ý¿âÊÔÌâ3Ò»¡¢µ¥ÏîÑ¡ÔñÌâ(ÿСÌâ1·Ö£¬¹²10·Ö)Ä¿Ç°£¨A£©Êý¾Ý¿âϵͳÒÑÖð½¥ÌÔÌ­ÁËÍø×´Êý¾Ý¿âºÍ²ã´ÎÊý¾Ý¿â£¬³ÉΪµ±½ñ×îΪÁ÷ÐеÄÉÌÓÃÊý¾Ý¿âϵͳ¡£A£®¹ØϵB£®ÃæÏò¶ÔÏóC£®·Ö²¼Êý¾Ý¿âÉè¼ÆÖеĸÅÄî½á¹¹Éè¼ÆµÄÖ÷Òª¹¤¾ßÊÇ£¨B£©¡£A£®Êý¾ÝÄ£ÐÍB£®E¡ªRÄ£ÐÍC£®Ð°¶ûÁ¼Ä£ÐÍD£®¸ÅÄîÄ£ÐÍÔÚSQLÖУ¬½¨Á¢ÊÓͼÓõÄÃüÁîÊÇ(C)¡£ÓïÑÔÖУ¬É¾³ýÒ»¸ö±íµÄÃüÁîÊÇ(B)¡£Ò»¡¢µ¥ÏîÑ¡ÔñÌâ(ÿСÌâ1·Ö£¬¹²10·Ö)1£®Êý¾Ý¿âÓ¦ÓÃϵͳÊÇÓÉÊý¾Ý¿â¡¢Êý¾Ý¿â¹ÜÀíϵͳ£¨¼°Æ俪·¢¹¤¾ß£©¡¢Ó¦ÓÃϵͳ¡¢£¨D£©ºÍÓû§¹¹³É¡£A£®DBMSB£®DBC£®DBSD£®DBA2£®Êý¾Ý¿â¹ÜÀíϵͳµÄÓ¢ÎÄËõдÊÇ£¨A£©¡£A£®DBMSB£®DBSC£®DBAD£®DB3£®ÔÚ¹ØϵÔËËãÖУ¬Ñ¡È¡·ûºÏÌõ¼þµÄÔª×éÊÇ£¨D£©ÔËËã¡£A£®³ý·¨B£®Í¶Ó°C£®Á¬½ÓD£®Ñ