µÚ1Õ Êý¾Ý¸ÅÊö Ò»£®Ñ¡ÔñÌâ
1£®ÏÂÁйØÓÚÊý¾Ý¿â¹ÜÀíϵͳµÄ˵·¨£¬´íÎóµÄÊÇ C
A£®Êý¾Ý¿â¹ÜÀíϵͳÓë²Ù×÷ϵͳÓйأ¬²Ù×÷ϵͳµÄÀàÐ;ö¶¨ÁËÄܹ»ÔËÐеÄÊý¾Ý¿â¹ÜÀíϵͳµÄÀàÐÍ B£®Êý¾Ý¿â¹ÜÀíϵͳ¶ÔÊý¾Ý¿âÎļþµÄ·ÃÎʱØÐë¾¹ý²Ù×÷ϵͳʵÏÖ²ÅÄÜʵÏÖ ´íÎóµÄÊÇ£ºC£®Êý¾Ý¿âÓ¦ÓóÌÐò¿ÉÒÔ²»¾¹ýÊý¾Ý¿â¹ÜÀíϵͳ¶øÖ±½Ó¶ÁÈ¡Êý¾Ý¿âÎļþ D£®Êý¾Ý¿â¹ÜÀíϵͳ¶ÔÓû§Òþ²ØÁËÊý¾Ý¿âÎļþµÄ´æ·ÅλÖúÍÎļþÃû 2£®ÏÂÁйØÓÚÓÃÎļþ¹ÜÀíÊý¾ÝµÄ˵·¨£¬´íÎóµÄÊÇ D A£®ÓÃÎļþ¹ÜÀíÊý¾Ý£¬ÄÑÒÔÌṩӦÓóÌÐò¶ÔÊý¾ÝµÄ¶ÀÁ¢ÐÔ
B£®µ±´æ´¢Êý¾ÝµÄÎļþÃû·¢Éú±ä»¯Ê±£¬±ØÐëÐ޸ķÃÎÊÊý¾ÝÎļþµÄÓ¦ÓóÌÐò C£®ÓÃÎļþ´æ´¢Êý¾ÝµÄ·½Ê½ÄÑÒÔʵÏÖÊý¾Ý·ÃÎʵݲȫ¿ØÖÆ
¡¤1¡¤ ´íÎóµÄÊÇ£ºD£®½«Ïà¹ØµÄÊý¾Ý´æ´¢ÔÚÒ»¸öÎļþÖУ¬ÓÐÀûÓÚÓû§¶ÔÊý¾Ý½øÐзÖÀ࣬Òò´ËÒ²¿ÉÒÔ¼Ó¿ìÓû§²Ù×÷Êý¾ÝµÄ
ЧÂÊ
3£®ÏÂÁÐ˵·¨ÖУ¬²»ÊôÓÚÊý¾Ý¿â¹ÜÀíÏµÍ³ÌØÕ÷µÄÊÇ C A£®ÌṩÁËÓ¦ÓóÌÐòºÍÊý¾ÝµÄ¶ÀÁ¢ÐÔ
B£®ËùÓеÄÊý¾Ý×÷Ϊһ¸öÕûÌ忼ÂÇ£¬Òò´ËÊÇÏ໥¹ØÁªµÄÊý¾ÝµÄ¼¯ºÏ C£®Óû§·ÃÎÊÊý¾Ýʱ£¬ÐèÒªÖªµÀ´æ´¢Êý¾ÝµÄÎļþµÄÎïÀíÐÅÏ¢
D£®Äܹ»±£Ö¤Êý¾Ý¿âÊý¾ÝµÄ¿É¿¿ÐÔ£¬¼´Ê¹ÔÚ´æ´¢Êý¾ÝµÄÓ²Å̳öÏÖ¹ÊÕÏʱ£¬Ò²ÄÜ·ÀÖ¹Êý¾Ý¶ªÊ§ 5£®ÔÚÊý¾Ý¿âϵͳÖУ¬Êý¾Ý¿â¹ÜÀíϵͳºÍ²Ù×÷ϵͳ֮¼äµÄ¹ØÏµÊÇ D A£®Ï໥µ÷ÓÃ
B£®Êý¾Ý¿â¹ÜÀíϵͳµ÷ÓòÙ×÷ϵͳ C£®²Ù×÷ϵͳµ÷ÓÃÊý¾Ý¿â¹ÜÀíϵͳ D£®²¢·¢ÔËÐÐ
6£®Êý¾Ý¿âϵͳµÄÎïÀí¶ÀÁ¢ÐÔÊÇÖ¸ D A£®²»»áÒòΪÊý¾ÝµÄ±ä»¯¶øÓ°ÏìÓ¦ÓóÌÐò B£®²»»áÒòΪÊý¾Ý´æ´¢½á¹¹µÄ±ä»¯¶øÓ°ÏìÓ¦ÓóÌÐò C£®²»»áÒòΪÊý¾Ý´æ´¢²ßÂԵı仯¶øÓ°ÏìÊý¾ÝµÄ´æ´¢½á¹¹ D£®²»»áÒòΪÊý¾ÝÂß¼½á¹¹µÄ±ä»¯¶øÓ°ÏìÓ¦ÓóÌÐò
7£®Êý¾Ý¿â¹ÜÀíϵͳÊÇÊý¾Ý¿âϵͳµÄºËÐÄ£¬Ëü¸ºÔðÓÐЧµØ×éÖ¯¡¢´æ´¢ºÍ¹ÜÀíÊý¾Ý£¬ËüλÓÚÓû§ºÍ²Ù×÷ϵͳ֮¼ä£¬ÊôÓÚ A
A£®ÏµÍ³Èí¼þ C£®Ó¦ÓÃÈí¼þ
B£®¹¤¾ßÈí¼þ D£®Êý¾ÝÈí¼þ
8£®Êý¾Ý¿âϵͳÊÇÓÉÈô¸É²¿·Ö×é³ÉµÄ¡£ÏÂÁв»ÊôÓÚÊý¾Ý¿âϵͳ×é³É²¿·ÖµÄÊÇ B A£®Êý¾Ý¿â C£®Ó¦ÓóÌÐò
B£®²Ù×÷ϵͳ
D£®Êý¾Ý¿â¹ÜÀíϵͳ
9£®ÏÂÁйØÓÚ¿Í»§/·þÎñÆ÷½á¹¹ºÍÎļþ·þÎñÆ÷½á¹¹µÄÃèÊö£¬´íÎóµÄÊÇ D
A£®¿Í»§/·þÎñÆ÷½á¹¹½«Êý¾Ý¿â´æ´¢ÔÚ·þÎñÆ÷¶Ë£¬Îļþ·þÎñÆ÷½á¹¹½«Êý¾Ý´æ´¢ÔÚ¿Í»§¶Ë
B£®¿Í»§/·þÎñÆ÷½á¹¹·µ»Ø¸ø¿Í»§¶ËµÄÊÇ´¦ÀíºóµÄ½á¹ûÊý¾Ý£¬Îļþ·þÎñÆ÷½á¹¹·µ»Ø¸ø¿Í»§¶ËµÄÊǰüº¬¿Í»§ËùÐèÊý¾Ý
µÄÎļþ
C£®¿Í»§/·þÎñÆ÷½á¹¹±ÈÎļþ·þÎñÆ÷½á¹¹µÄÍøÂ翪ÏúС
1
¡¤2¡¤ ´íÎóµÄÊÇ£ºD£®¿Í»§/·þÎñÆ÷½á¹¹¿ÉÒÔÌṩÊý¾Ý¹²Ïí¹¦ÄÜ£¬¶øÓÃÎļþ·þÎñÆ÷½á¹¹´æ´¢µÄÊý¾Ý²»Äܹ²Ïí
Êý¾Ý¿âÊÇÏ໥¹ØÁªµÄÊý¾ÝµÄ¼¯ºÏ£¬ËüÓÃ×ۺϵķ½·¨×éÖ¯Êý¾Ý£¬¾ßÓнÏСµÄÊý¾ÝÈßÓ࣬¿É¹©¶à¸öÓû§¹²Ïí£¬¾ßÓÐ
½Ï¸ßµÄÊý¾Ý¶ÀÁ¢ÐÔ£¬¾ßÓа²È«¿ØÖÆ»úÖÆ£¬Äܹ»±£Ö¤Êý¾ÝµÄ°²È«¡¢¿É¿¿£¬ÔÊÐí²¢·¢µØÊ¹ÓÃÊý¾Ý¿â£¬ÄÜÓÐЧ¡¢¼°Ê±µØ´¦ÀíÊý¾Ý£¬²¢Äܱ£Ö¤Êý¾ÝµÄÒ»ÖÂÐÔºÍÍêÕûÐÔ¡£
10£®ÏÂÁйØÓÚÊý¾Ý¿â¼¼ÊõµÄÃèÊö£¬´íÎóµÄÊÇ B
A£®Êý¾Ý¿âÖв»µ«ÐèÒª±£´æÊý¾Ý£¬¶øÇÒ»¹ÐèÒª±£´æÊý¾ÝÖ®¼äµÄ¹ØÁª¹ØÏµ
´íÎóµÄÊÇ£ºB£®ÓÉÓÚÊý¾ÝÊÇ´æ´¢ÔÚ´ÅÅÌÉϵģ¬Òò´ËÓû§ÔÚ·ÃÎÊÊý¾Ý¿âÊý¾ÝʱÐèÒªÖªµÀÊý¾ÝµÄ´æ´¢Î»Öà C£®Êý¾Ý¿âÖÐÊý¾Ý´æ´¢½á¹¹µÄ±ä»¯²»»áÓ°Ïìµ½Ó¦ÓóÌÐò D£® Êý¾Ý¿âÖеÄÊý¾Ý¾ßÓнÏСµÄÊý¾ÝÈßÓà
¶þ£®Ìî¿ÕÌâ
1£®Êý¾Ý¹ÜÀíµÄ·¢Õ¹Ö÷Òª¾ÀúÁË_______ºÍ_______Á½¸ö½×¶Î¡£Îļþ¹ÜÀí Êý¾Ý¿â¹ÜÀí 2£®ÔÚÀûÓÃÊý¾Ý¿â¼¼Êõ¹ÜÀíÊý¾Ýʱ£¬ËùÓеÄÊý¾Ý¶¼±»_______ͳһ¹ÜÀí¡£Êý¾Ý¿â¹ÜÀíϵͳ
3£®Êý¾Ý¿â¹ÜÀíϵͳÌṩµÄÁ½¸öÊý¾Ý¶ÀÁ¢ÐÔÊÇ_______¶ÀÁ¢ÐÔºÍ_______¶ÀÁ¢ÐÔ¡£ ÎïÀí Âß¼ 4£®Êý¾Ý¿âϵͳÄܹ»±£Ö¤½øÈëµ½Êý¾Ý¿âÖеÄÊý¾Ý¶¼ÊÇÕýÈ·µÄÊý¾Ý£¬¸ÃÌØÕ÷³ÆÎª_______¡£Êý¾ÝÍêÕûÐÔ 5£®ÔÚ¿Í»§/·þÎñÆ÷½á¹¹ÖУ¬Êý¾ÝµÄ´¦ÀíÊÇÔÚ________¶ËÍê³ÉµÄ¡£ ·þÎñÆ÷
6£®Êý¾Ý¿âϵͳ¾ÍÊÇ»ùÓÚÊý¾Ý¿âµÄ¼ÆËã»úÓ¦ÓÃϵͳ£¬ËüÖ÷ÒªÓÉ________¡¢________ºÍ________Èý²¿·Ö×é³É¡£ ¾Ý¿â¡¢Êý¾Ý¿â¹ÜÀíϵͳºÍÓ¦ÓóÌÐò
7£®ÓëÓÃÊý¾Ý¿â¼¼Êõ¹ÜÀíÊý¾ÝÏà±È£¬Îļþ¹ÜÀíϵͳµÄÊý¾Ý¹²ÏíÐÔ________£¬Êý¾Ý¶ÀÁ¢ÐÔ________¡£ ²î µÍ
8£®ÔÚÊý¾Ý¿â¼¼ÊõÖУ¬µ±±í´ïÏÖʵÊÀ½çµÄÐÅÏ¢ÄÚÈÝ·¢Éú±ä»¯Ê±£¬¿ÉÒÔ±£Ö¤²»Ó°ÏìÓ¦ÓóÌÐò£¬Õâ¸öÌØÐÔ³ÆÎª______¡£ Âß¼¶ÀÁ¢ÐÔ
9£®µ±Êý¾Ý¿âÊý¾ÝÓÉÓÚ»úÆ÷Ó²¼þ¹ÊÕ϶øÔâµ½ÆÆ»µÊ±£¬Êý¾Ý¿â¹ÜÀíϵͳÌṩÁ˽«Êý¾Ý¿â»Ö¸´µ½Õýȷ״̬£¬²¢¾¡¿ÉÄÜʹÊý¾Ý²»¶ªÊ§µÄ¹¦ÄÜ£¬ÕâÊÇÊý¾Ý¿â¹ÜÀíϵͳµÄ______ÌØÐÔ±£Ö¤µÄ¡£
¿É¿¿ÐÔ
10£®Êý¾Ý¿âÖеÄÊý¾ÝÊÇÏ໥¹ØÁªµÄÊý¾Ý¼¯ºÏ£¬¾ßÓнÏСµÄÊý¾ÝÈßÓ࣬¿É¹©¶à¸öÓû§¹²Ïí£¬¾ßÓнϸߵÄÊý¾Ý¶ÀÁ¢ÐÔ£¬ÇÒ¾ßÓа²È«ÐԺͿɿ¿ÐÔ£¬ÕâÐ©ÌØÕ÷¶¼ÊÇÓÉ______±£Ö¤µÄ¡£ Êý¾Ý¿â¹ÜÀíϵͳ
Êý
2
µÚ2Õ Êý¾ÝÄ£ÐÍÓëÊý¾Ý¿âϵͳ½á¹¹ Ò»£®Ñ¡ÔñÌâ
1£®Êý¾Ý¿âÈý¼¶Ä£Ê½½á¹¹µÄ»®·Ö£¬ÓÐÀûÓÚ
A. Êý¾ÝµÄ¶ÀÁ¢ÐÔ C. ½¨Á¢Êý¾Ý¿â
A
¡¤3¡¤ B. ¹ÜÀíÊý¾Ý¿âÎļþ D. ²Ù×÷ϵͳ¹ÜÀíÊý¾Ý¿â
B
2£®ÔÚÊý¾Ý¿âµÄÈý¼¶Ä£Ê½ÖУ¬ÃèÊöÊý¾Ý¿âÖÐÈ«ÌåÊý¾ÝµÄÂß¼½á¹¹ºÍÌØÕ÷µÄÊÇ
A£®ÄÚģʽ B.ģʽ C. Íâģʽ
D. ÆäËû
3£®Êý¾Ý¿âϵͳÖн«Êý¾Ý·ÖΪÈý¸öģʽ£¬´Ó¶øÌṩÁËÊý¾ÝµÄ¶ÀÁ¢ÐÔ£¬ÏÂÁйØÓÚÊý¾ÝÂß¼¶ÀÁ¢ÐÔµÄ˵·¨£¬ÕýÈ·µÄÊÇ
A. B. C. D.
C
µ±ÄÚģʽ·¢Éú±ä»¯Ê±£¬Ä£Ê½¿ÉÒÔ²»±ä µ±ÄÚģʽ·¢Éú±ä»¯Ê±£¬Ó¦ÓóÌÐò¿ÉÒÔ²»±ä µ±Ä£Ê½·¢Éú±ä»¯Ê±£¬Ó¦ÓóÌÐò¿ÉÒÔ²»±ä µ±Ä£Ê½·¢Éú±ä»¯Ê±£¬ÄÚģʽ¿ÉÒÔ²»±ä
4£®Îª×î´óÏ޶ȵر£Ö¤Êý¾Ý¿âÊý¾ÝµÄÕýÈ·ÐÔ£¬¹ØÏµÊý¾Ý¿âʵÏÖÁËÈý¸öÍêÕûÐÔÔ¼Êø£¬ÏÂÁÐÓÃÓÚ±£Ö¤ÊµÌåÍêÕûÐÔµÄÊÇ
B
B.Ö÷Âë
C. CHECKÔ¼Êø
D
D. UNIQUEÔ¼Êø
A. ÍâÂë
5£®ÏÂÁйØÓÚ¹ØÏµÖÐÖ÷ÊôÐÔµÄÃèÊö£¬´íÎóµÄÊÇ
A. Ö÷ÂëËù°üº¬µÄÊôÐÔÒ»¶¨ÊÇÖ÷ÊôÐÔ B. ÍâÂëËùÒýÓõÄÊôÐÔÒ»¶¨ÊÇÖ÷ÊôÐÔ C. ºòÑ¡ÂëËù°üº¬µÄÊôÐÔ¶¼ÊÇÖ÷ÊôÐÔ
D. ÈκÎÒ»¸öÖ÷ÊôÐÔ¶¼¿ÉÒÔΨһµØ±êʶ±íÖеÄÒ»ÐÐÊý¾Ý
6£®ÉèÓйØÏµÄ£Ê½ÏúÊÛ£¨¹Ë¿ÍºÅ£¬ÉÌÆ·ºÅ£¬ÏúÊÛʱ¼ä£¬ÏúÊÛÊýÁ¿£©£¬ÈôÔÊÐíÒ»¸ö¹Ë¿ÍÔÚ²»Í¬Ê±¼ä¶Ôͬһ¸ö²úÆ·¹ºÂò¶à
´Î£¬Ôò´Ë¹ØÏµÄ£Ê½µÄÖ÷ÂëÊÇ A£®¹Ë¿ÍºÅ
C£®£¨¹Ë¿ÍºÅ£¬ÉÌÆ·ºÅ£©
D
B£®²úÆ·ºÅ
D£®£¨¹Ë¿ÍºÅ¡¢ÉÌÆ·ºÅ¡¢ÏúÊÛʱ¼ä£©
B
7£®¹ØÏµÊý¾Ý¿âÓöþά±íÀ´´æ´¢Êý¾Ý¡£ÏÂÁйØÓÚ¹ØÏµ±íÖмǼµÄ˵·¨£¬ÕýÈ·µÄÊÇ
A£®Ë³ÐòºÜÖØÒª£¬²»Äܽ»»» C£®°´ÊäÈëÊý¾ÝµÄ˳ÐòÅÅÁÐ
B£®Ë³Ðò²»ÖØÒª D£®Ò»¶¨ÊÇÓÐÐòµÄ
C
8£®ÏÂÁÐģʽÖУ¬ÓÃÓÚÃèÊöµ¥¸öÓû§Êý¾ÝÊÓͼµÄÊÇ
A£®ÄÚģʽ C£®Íâģʽ
B£®¸ÅÄîģʽ D£®´æ´¢Ä£Ê½
9£®ÔÚÀûÓøÅÄî²ãÊý¾ÝÄ£ÐÍÃèÊöÊý¾Ýʱ£¬Ò»°ãÒªÇóÄ£ÐÍÒªÂú×ãÈý¸öÒªÇó¡£ÏÂÁÐÃèÊöÖУ¬²»ÊôÓÚ¸ÅÄî²ãÊý¾ÝÄ£ÐÍÓ¦Âú×ãµÄÒªÇóµÄÊÇ
A
B£®Äܹ»ÕæÊµµØÄ£ÄâÏÖʵÊÀ½ç D£®Äܹ»·½±ãµØÔÚ¼ÆËã»úÉÏʵÏÖ
A£®Äܹ»ÃèÊö²¢·¢Êý¾Ý
C£®ÈÝÒ×±»ÒµÎñÈËÔ±Àí½â
B
10£®Êý¾ÝÄ£ÐÍÈýÒªËØÊÇÖ¸
A£®Êý¾Ý½á¹¹¡¢Êý¾Ý¶ÔÏóºÍÊý¾Ý¹²Ïí
3
¡¤4¡¤ B£®Êý¾Ý½á¹¹¡¢Êý¾Ý²Ù×÷ºÍÊý¾ÝÍêÕûÐÔÔ¼Êø
C£®Êý¾Ý½á¹¹¡¢Êý¾Ý²Ù×÷ºÍÊý¾ÝµÄ°²È«¿ØÖÆ D£®Êý¾Ý½á¹¹¡¢Êý¾Ý²Ù×÷ºÍÊý¾ÝµÄ¿É¿¿ÐÔ
11£®ÏÂÁйØÓÚʵÌåÁªÏµÄ£ÐÍÖÐÁªÏµµÄ˵·¨£¬´íÎóµÄÊÇ D
A£®Ò»¸öÁªÏµ¿ÉÒÔÖ»ÓëÒ»¸öʵÌåÓÐ¹Ø B£®Ò»¸öÁªÏµ¿ÉÒÔÓëÁ½¸öʵÌåÓÐ¹Ø C£®Ò»¸öÁªÏµ¿ÉÒÔÓë¶à¸öʵÌåÓÐ¹Ø D£®Ò»¸öÁªÏµÒ²¿ÉÒÔ²»ÓëÈκÎʵÌåÓйØ
12£®Êý¾Ý¿âϵͳÖеÄÈý¼¶Ä£Ê½ÒÔ¼°Ä£Ê½¼äµÄÓ³ÏñÌṩÁËÊý¾ÝµÄ¶ÀÁ¢ÐÔ¡£ÏÂÁйØÓÚÁ½¼¶Ó³ÏñµÄ˵·¨£¬ÕýÈ·µÄÊÇ
C
A£®Íâģʽµ½Ä£Ê½µÄÓ³ÏñÊÇÓÉÓ¦ÓóÌÐòʵÏֵģ¬Ä£Ê½µ½ÄÚģʽµÄÓ³ÏñÊÇÓÉDBMSʵÏÖµÄ B£®Íâģʽµ½Ä£Ê½µÄÓ³ÏñÊÇÓÉDBMSʵÏֵģ¬Ä£Ê½µ½ÄÚģʽµÄÓ³ÏñÊÇÓÉÓ¦ÓóÌÐòʵÏÖµÄ C£®Íâģʽµ½Ä£Ê½µÄÓ³ÏñÒÔ¼°Ä£Ê½µ½ÄÚģʽµÄÓ³Ïñ¶¼ÊÇÓÉDBMSʵÏÖµÄ D£®Íâģʽµ½Ä£Ê½µÄÓ³ÏñÒÔ¼°Ä£Ê½µ½ÄÚģʽµÄÓ³Ïñ¶¼ÊÇÓÉÓ¦ÓóÌÐòʵÏÖµÄ
D
13£®ÏÂÁв»ÊôÓÚÊý¾ÝÍêÕûÐÔÔ¼ÊøµÄÊÇ
A£®ÊµÌåÍêÕûÐÔ C£®ÓòÍêÕûÐÔ
B£®²ÎÕÕÍêÕûÐÔ
D£®Êý¾Ý²Ù×÷ÍêÕûÐÔ
A
14£®ÏÂÁйØÓÚ¹ØÏµ²Ù×÷µÄ˵·¨£¬ÕýÈ·µÄÊÇ
A£®¹ØÏµ²Ù×÷ÊǷǹý³Ì»¯µÄ
B£®ÔÚ½øÐйØÏµ²Ù×÷ʱ£¬Óû§ÐèÒªÖªµÀÊý¾ÝµÄ´æ´¢Î»Öà C£®ÔÚ½øÐйØÏµ²Ù×÷ʱ£¬Óû§ÐèÒªÖªµÀÊý¾ÝµÄ´æ´¢½á¹¹ D£®Óû§¿ÉÒÔÔÚ¹ØÏµÉÏÖ±½Ó½øÐÐÐж¨Î»²Ù×÷ 14£®ÏÂÁйØÓÚ¸ÅÄî²ãÊý¾ÝÄ£Ð͵Ä˵·¨£¬´íÎóµÄÊÇ
C
A£®¸ÅÄî²ãÊý¾ÝÄ£ÐÍÓ¦¸Ã²ÉÓÃÒ×ÓÚÓû§Àí½âµÄ±í´ï·½Ê½ B£®¸ÅÄî²ãÊý¾ÝÄ£ÐÍÓ¦¸Ã±È½ÏÒ×ÓÚת»»³É×éÖ¯²ãÊý¾ÝÄ£ÐÍ
C£®ÔÚ½øÐиÅÄî²ãÊý¾ÝÄ£ÐÍÉè¼ÆÊ±£¬ÐèÒª¿¼ÂǾßÌåµÄDBMSµÄÌØµã D£®ÔÚ½øÐиÅÄî²ãÊý¾ÝÄ£ÐÍÉè¼ÆÊ±£¬Öص㿼ÂǵÄÄÚÈÝÊÇÓû§µÄÒµÎñÂß¼
15£®ÏÂÁйØÓÚÍâÂëµÄ˵·¨£¬ÕýÈ·µÄÊÇ
A£®ÍâÂë±ØÐëÓëÆäËùÒýÓõÄÖ÷ÂëͬÃû B£®ÍâÂëÁв»ÔÊÐíÓпÕÖµ
C
C£®ÍâÂëºÍËùÒýÓõÄÖ÷ÂëÃû×Ö¿ÉÒÔ²»Í¬£¬µ«ÓïÒ屨ÐëÏàͬ D£®ÍâÂëµÄȡֵ±ØÐëÒªÓëËùÒýÓùØÏµÖÐÖ÷ÂëµÄij¸öÖµÏàͬ
16£®ÏÂÁйØÓÚ¹ØÏµµÄ˵·¨£¬´íÎóµÄÊÇ
¶þ£®Ìî¿ÕÌâ
D
A£®¹ØÏµÖеÄÿ¸öÊôÐÔ¶¼ÊDz»¿ÉÔٷֵĻù±¾ÊôÐÔ B£®¹ØÏµÖв»ÔÊÐí³öÏÖÖµÍêÈ«ÏàͬµÄÔª×é C£®¹ØÏµÖв»ÐèÒª¿¼ÂÇÔª×éµÄÏȺó˳Ðò
D£®¹ØÏµÖÐÊôÐÔ˳ÐòµÄ²»Í¬£¬¹ØÏµËù±í´ïµÄÓïÒåÒ²²»Í¬
1£®Êý¾Ý¿â¿ÉÒÔ×î´óÏ޶ȵر£Ö¤Êý¾ÝµÄÕýÈ·ÐÔ£¬ÕâÔÚÊý¾Ý¿âÖб»³ÆÎª______¡£ Êý¾ÝÍêÕûÐÔ 2£®ÊµÌå-ÁªÏµÄ£ÐÍÖ÷Òª°üº¬______¡¢______ºÍ______Èý²¿·ÖÄÚÈÝ¡£ÊµÌå ÊôÐÔ ÁªÏµ
4
3£®Èç¹ûʵÌåAÓëʵÌåBÊÇÒ»¶Ô¶àÁªÏµ£¬ÔòʵÌåBÖеÄÒ»¸öʵÀý×î¶à¿É¶ÔӦʵÌåAÖеÄ______ʵÀý¡£
Ò»¸ö
4£®Êý¾ÝÍêÕûÐÔÔ¼Êø°üÀ¨______ÍêÕûÐÔ¡¢______ÍêÕûÐÔºÍ______ÍêÕûÐÔ¡£ ʵÌå ²ÎÕÕ Óû§¶¨Òå 5£®¹ØÏµÊý¾ÝÄ£Ð͵Ä×éÖ¯ÐÎʽÊÇ______¡£ ¶þά±í
6£®Êý¾Ý¿âϵͳµÄ______ºÍ______Ö®¼äµÄÓ³Ïñ£¬ÌṩÁËÊý¾ÝµÄÎïÀí¶ÀÁ¢ÐÔ¡£ 7£®Êý¾ÝµÄÂß¼¶ÀÁ¢ÐÔÊÇÖ¸µ±______±ä»¯Ê±¿ÉÒÔ±£³Ö______²»±ä¡£ ÄÚģʽ ģʽ
8£®Êý¾ÝÄ£ÐÍÈýÒªËØ°üÀ¨______¡¢______ºÍ______¡£ Êý¾Ý½á¹¹ Êý¾Ý²Ù×÷ Êý¾ÝÍêÕûÐÔÔ¼Êø 9£®ÊµÌåÁªÏµÄ£ÐÍÊôÓÚ______²ãÊý¾ÝÄ£ÐÍ£¬ËüÓë¾ßÌåµÄDBMS______¡£¸ÅÄî ÎÞ¹Ø 10£®¹ØÏµ²Ù×÷µÄÌØµãÊÇ»ùÓÚ______µÄ²Ù×÷¡£ ¼¯ºÏ
¡¤5¡¤ 11£®µ±Êý¾ÝµÄÎïÀí´æ´¢Î»Ö÷¢Éú±ä»¯Ê±£¬Í¨¹ýµ÷Õû______Ó³Ïñ£¬¿ÉÒÔ±£Ö¤______²»±ä»¯£¬´Ó¶ø±£Ö¤Êý¾ÝµÄÎïÀí¶ÀÁ¢ÐÔ¡£ ģʽ/ÄÚģʽ ģʽ
12£®²ÎÕÕÍêÕûÐÔÔ¼ÊøÊÇͨ¹ý______±£Ö¤µÄ¡£ ÍâÂë
5
¡¤6¡¤ µÚ3Õ SQLÓïÑÔ»ù´¡¼°Êý¾Ý¶¨Ò幦ÄÜ Ò»£®Ñ¡ÔñÌâ
1£®ÏÂÁйØÓÚSQLÓïÑÔÌØ¶¨µÄÐðÊö£¬´íÎóµÄÊÇ B
A£®Ê¹ÓÃSQLÓïÑÔ·ÃÎÊÊý¾Ý¿â£¬Óû§Ö»ÐèÌá³ö×öʲô£¬¶øÎÞÐèÃèÊöÈçºÎʵÏÖ B£®SQLÓïÑԱȽϸ´ÔÓ£¬Òò´ËÔÚʹÓÃÉϱȽÏÄÑ
C£®SQLÓïÑÔ¿ÉÒÔÔÚÊý¾Ý¿â¹ÜÀíϵͳÌṩµÄÓ¦ÓóÌÐòÖÐÖ´ÐУ¬Ò²¿ÉÒÔÔÚDOS»·¾³ÏÂÖ´ÐÐ D£®Ê¹ÓÃSQLÓïÑÔ¿ÉÒÔÍê³ÉÈκÎÊý¾Ý¿â²Ù×÷ 2£®ÏÂÁÐËùÊö¹¦ÄÜÖУ¬²»ÊôÓÚSQLÓïÑÔ¹¦ÄܵÄÊÇ D A£®Êý¾Ý¿âºÍ±íµÄ¶¨Ò幦ÄÜ B£®Êý¾Ý²éѯ¹¦ÄÜ C£®Êý¾ÝÔö¡¢É¾¡¢¸Ä¹¦ÄÜ
D£®Ìṩ·½±ãµÄÓû§²Ù×÷½çÃæ¹¦ÄÜ
3£®Éèijְ¹¤±íÖÐÓÐÓÃÓÚ´æ·ÅÄêÁ䣨ÕûÊý£©µÄÁУ¬ÏÂÁÐÀàÐÍÖÐ×îºÏÊÊÄêÁäÁеÄÊÇ C A£®int C£®tinyint
B£®smallint D£®bit
4£®SQL ServerÊý¾Ý¿âÊÇÓÉÎļþ×é³ÉµÄ¡£ÏÂÁйØÓÚÊý¾Ý¿âËù°üº¬µÄÎļþµÄ˵·¨£¬ÕýÈ·µÄÊÇ D A£®Ò»¸öÊý¾Ý¿â¿É°üº¬¶à¸öÖ÷Êý¾ÝÎļþºÍ¶à¸öÈÕÖ¾Îļþ B£®Ò»¸öÊý¾Ý¿âÖ»Äܰüº¬Ò»¸öÖ÷Êý¾ÝÎļþºÍÒ»¸öÈÕÖ¾Îļþ
C£®Ò»¸öÊý¾Ý¿â¿É°üº¬¶à¸ö´ÎÒªÊý¾ÝÎļþ£¬µ«Ö»Äܰüº¬Ò»¸öÈÕÖ¾Îļþ D£®Ò»¸öÊý¾Ý¿â¿É°üº¬¶à¸ö´ÎÒªÊý¾ÝÎļþºÍ¶à¸öÈÕÖ¾Îļþ
5£®ÔÚSQL ServerÖд´½¨Óû§Êý¾Ý¿â£¬ÆäÖ÷Êý¾ÝÎļþµÄ´óС±ØÐë´óÓÚ B A£®masterÊý¾Ý¿âµÄ´óС C£®msdbÊý¾Ý¿âµÄ´óС
B£®modelÊý¾Ý¿âµÄ´óС D£®3MB
6£®ÔÚSQL ServerϵͳÊý¾Ý¿âÖУ¬´æ·ÅÓû§Êý¾Ý¿â¹«¹²ÐÅÏ¢µÄÊÇ D A£®master
C£®msdbÊý¾Ý¿âµÄ´óС
B£®model D£®tempdb
7£®ÔÚSQL ServerÖд´½¨Óû§Êý¾Ý¿âʵ¼Ê¾ÍÊǶ¨ÒåÊý¾Ý¿âËù°üº¬µÄÎļþÒÔ¼°ÎļþµÄÊôÐÔ¡£ÏÂÁв»ÊôÓÚÊý¾Ý¿âÎļþÊôÐÔµÄÊÇ C A£®³õʼ´óС C£®Îļþ½á¹¹
B£®ÎïÀíÎļþÃû D£® ×î´ó´óС
8£®ÔÚSQL ServerÖд´½¨Óû§Êý¾Ý¿âʵ¼Ê¾ÍÊǶ¨ÒåÊý¾Ý¿âËù°üº¬µÄÎļþÒÔ¼°ÎļþµÄÊôÐÔ¡£ÏÂÁв»ÊôÓÚÊý¾Ý¿âÎļþÊôÐÔµÄÊÇ C A£®³õʼ´óС C£®Îļþ½á¹¹
B£®ÎïÀíÎļþÃû D£® ×î´ó´óС
9£®ÏÂÁÐÔ¼ÊøÖÐÓÃÓÚÏÞÖÆÁеÄȡֵ·¶Î§µÄÔ¼ÊøÊÇ B A£®PRIMARY KEY C£®DEFAULT
B£®CHECK D£® UNIQUE
10£®ÏÂÁÐÔ¼ÊøÖÐÓÃÓÚÏÞÖÆÁеÄȡֵ²»ÖصÄÔ¼ÊøÊÇ D A£®PRIMARY KEY
B£®CHECK 6
C£®DEFAULT
D£® UNIQUE
¡¤7¡¤ 11£®ÏÂÁÐÔ¼ÊøÖÐÓÃÓÚʵÏÖʵÌåÍêÕûÐÔµÄÔ¼ÊøÊÇ A A£®PRIMARY KEY C£®DEFAULT
B£®CHECK D£® UNIQUE
12£®ÏÂÁйØÓÚDEFAULTÔ¼ÊøµÄ˵·¨£¬´íÎóµÄÊÇ D A£®Ò»¸öDEFAULTÔ¼ÊøÖ»ÄÜÔ¼Êø±íÖеÄÒ»¸öÁÐ B£®ÔÚÒ»¸ö±íÉÏ¿ÉÒÔ¶¨Òå¶à¸öDEFAULTÔ¼Êø C£®DEFAULTÖ»Äܶ¨ÒåÔÚÁм¶ÍêÕûÐÔÔ¼Êø´¦
D£®ÔÚÁм¶ÍêÕûÐÔÔ¼ÊøºÍ±í¼¶ÍêÕûÐÔÔ¼Êø´¦¶¼¿ÉÒÔ¶¨ÒåDEFAULTÔ¼Êø
7
¡¤8¡¤ µÚ 4 Õ Êý¾Ý²Ù×÷Óï¾ä Ò»£® Ñ¡ÔñÌâ
1£® µ±¹ØÏµRºÍS½øÐÐÁ¬½Ó²Ù×÷ʱ£¬Èç¹ûRÖеÄÔª×é²»Âú×ãÁ¬½ÓÌõ¼þ£¬ÔÚÁ¬½Ó½á¹ûÖÐÒ²»á½«ÕâЩ¼Ç¼±£ÁôÏÂÀ´µÄ²Ù
×÷ÊÇ A A£®×óÍâÁ¬½Ó C£®ÄÚÁ¬½Ó C
A£®Grade IS NOT NULL C£®Grade = NULL
B£®Grade IS NULL D£®NOT (Grade IS NULL) D
B£®MAX(ÁÐÃû)
D£®COUNT(*)
A
B£®ÓÒÍâÁ¬½Ó D£®×ÔÁ¬½Ó
2£® ÉèÔÚijSELECTÓï¾äµÄWHERE×Ó¾äÖУ¬ÐèÒª¶ÔGradeÁеĿÕÖµ½øÐд¦Àí¡£ÏÂÁйØÓÚ¿ÕÖµµÄ²Ù×÷£¬´íÎóµÄÊÇ
3£® ÏÂÁоۺϺ¯ÊýÖУ¬²»ºöÂÔ¿ÕÖµµÄÊÇ
A£®SUM(ÁÐÃû) C£®AVG(ÁÐÃû)
4£®SELECT ¡ INTO ¡FROMÓï¾äµÄ¹¦ÄÜÊÇ
A£® ½«²éѯ½á¹û²åÈëµ½Ò»¸öбíÖÐ C£® ºÏ²¢²éѯµÄ½á¹û
D£® ÏòÒÑ´æÔڵıíÖÐÌí¼ÓÊý¾Ý 5£®ÏÂÁÐÀûÓÃSC±íµÄ²éѯÓï¾äÖУ¬´íÎóµÄÊÇ
B£® ½«²éѯ½á¹û²åÈëµ½Ò»¸öÒѽ¨ºÃµÄ±íÖÐ
B
A£® SELECT Sno, COUNT(*) FROM SC GROUP BY Sno
B£® SELECT Sno FROM SC GROUP BY Sno WHERE COUNT(*) > 3 C£® SELECT Sno FROM SC GROUP BY Sno HAVING COUNT(*) > 3 D£® SELECT Sno FROM SC GROUP BY Sno
6£®ÏÖÒªÀûÓÃStudent±í²éѯÄêÁä×îСµÄѧÉúÐÕÃûºÍÄêÁä¡£ÏÂÁÐʵÏִ˹¦ÄܵIJéѯÓï¾äÖУ¬ÕýÈ·µÄÊÇ
A£® SELECT Sname, MIN(Sage) FROM Student
B£® SELECT Sname, Sage FROM Student WHERE Sage = MIN(Sage) C£® SELECT TOP 1 Sname, Sage FROM Student
D£® SELECT TOP 1 Sname, Sage FROM Student ORDER BY Sage
7£®ÉèSC±íÖмǼ³É¼¨µÄÁÐΪ£ºGrade£¬ÀàÐÍΪint¡£ÈôÔÚ²éѯ³É¼¨Ê±£¬Ï£Íû½«³É¼¨°´¡®ÓÅ¡¯¡¢¡®Á¼¡¯¡¢¡®ÖС¯¡¢¡®¼°¸ñ¡¯ºÍ¡®²»¼°¸ñ¡¯ÐÎʽÏÔʾ£¬ÕýÈ·µÄCaseº¯ÊýÊÇ
A.
Case Grade
When 90~100 THEN 'ÓÅ' When 80~89 THEN 'Á¼' When 70~79 THEN 'ÖÐ' When 60~69 THEN '¼°¸ñ' Else '²»¼°¸ñ' End B.
Case
When Grade between 90 and 100 THEN Grade = 'ÓÅ' When Grade between 80 and 89 THEN Grade = 'Á¼'
8
C
D
When Grade between 70 and 79 THEN Grade = 'ÖÐ' When Grade between 60 and 69 THEN Grade = '¼°¸ñ' Else Grade = '²»¼°¸ñ' End C.
Case
When Grade between 90 and 100 THEN 'ÓÅ' When Grade between 80 and 89 THEN 'Á¼' When Grade between 70 and 79 THEN 'ÖÐ' When Grade between 60 and 69 THEN '¼°¸ñ' Else '²»¼°¸ñ' End D.
Case Grade
When 90~100 THEN Grade = 'ÓÅ' When 80~89 THEN Grade = 'Á¼' When 70~79 THEN Grade = 'ÖÐ' When 60~69 THEN Grade = '¼°¸ñ' Else Grade = '²»¼°¸ñ'
End
8£®ÏÂÊöÓï¾äµÄ¹¦ÄÜÊǽ«Á½¸ö²éѯ½á¹ûºÏ²¢ÎªÒ»¸ö½á¹û¡£ÆäÖÐÕýÈ·µÄÊÇ Order by sage Union
select sno,sname,sage from student where sdept = 'is' Order by sage
B£®select sno,sname,sage from student where sdept = 'cs' Union
select sno,sname,sage from student where sdept = 'is' Order by sage
C£®select sno,sname,sage from student where sdept = 'cs' Union
select sno,sname from student where sdept = 'is' Order by sage
D£®select sno,sname,sage from student where sdept = 'cs' Order by sage Union
select sno,sname,sage from student where sdept = 'is' 9£®ÏÂÁÐSQLÓï¾äÖУ¬ÓÃÓÚÐ޸ıíÊý¾ÝµÄÓï¾äÊÇ
A£®ALTER C£®UPDATE
C
B£®SELECT D£®INSERT
B
¡¤9¡¤ A£®select sno,sname,sage from student where sdept = 'cs'
10£®ÉèÓÐTeachers±í£¬¸Ã±íµÄ¶¨ÒåÈçÏ£º
CREATE TABLE Teachers( Tno CHAR(8) PRIMARY KEY,
Tname VARCHAR(10) NOT NULL,
9
¡¤10¡¤ Age TINYINT CHECK(Age BETWEEN 25 AND 65) )
ÏÂÁвåÈëÓï¾äÖУ¬²»ÄÜÕýÈ·Ö´ÐеÄÊÇ
D
A£®INSERT INTO Teachers VALUES('T100','Õźè',NULL)
B£®INSERT INTO Teachers(Tno,Tname,Age) VALUES('T100','Õźè',30) C£®INSERT INTO Teachers(Tno,Tname) VALUES('T100','Õźè') D£®INSERT INTO TeachersVALUES('T100','Õźè')
11£®ÉèÊý¾Ý¿âÖÐÒÑÓбí4-1ÖÁ4-3ËùʾµÄStudent¡¢CourseºÍSC±í¡£ÏÖÒª²éѯѧÉúÑ¡µÄµÚ2ѧÆÚ¿ªÉè¿Î³ÌµÄÇé¿ö£¬Ö»ÐèÁгöѧºÅ¡¢ÐÕÃû¡¢ËùÔÚϵºÍËùÑ¡µÄ¿Î³ÌºÅ¡£¸Ã²éÑ¯Éæ¼°µ½µÄ±íÊÇ D
A£®½öStudent±í
C£®½öStudentºÍCourse±í
B£®½öStudentºÍSC±í D£®Student¡¢SCºÍCourse±í
12£®É¾³ý¼ÆËã»úϵѧÉú£¨ÔÚstudent±íÖУ©µÄÐ޿μǼ£¨ÔÚSC±íÖУ©µÄÕýÈ·µÄÓï¾äÊDZíÊÇ B
A£®DELETE FROM SC JOIN Student b ON S.Sno = b.Sno WHERE Sdept = '¼ÆËã»úϵ'
B£®DELETE FROM SC FROM SC JOIN Student b ON SC.Sno = b.Sno WHERE Sdept = '¼ÆËã»úϵ'
C£®DELETE FROM Student WHERE Sdept = '¼ÆËã»úϵ' D£®DELETE FROM SC WHERE Sdept = '¼ÆËã»úϵ'
¶þ£® Ìî¿ÕÌâ
1£® ÔÚÏà¹Ø×Ó²éѯÖУ¬×Ó²éѯµÄÖ´ÐдÎÊýÊÇÓÉ_________¾ö¶¨µÄ¡£Íâ²ã±íµÄÐÐÊý
2£® ¶Ô°üº¬»ùÓÚ¼¯ºÏ²âÊÔ×Ó²éѯµÄ²éѯÓï¾ä£¬ÊÇÏÈÖ´ÐÐ_________²ã²éѯ£¬ÔÚÖ´ÐÐ_________²ã²éѯ¡£ÄÚ£¬Íâ 3£® ¶Ô°üº¬Ïà¹Ø×Ó²éѯµÄ²éѯÓï¾ä£¬ÊÇÏÈÖ´ÐÐ_________²ã²éѯ£¬ÔÚÖ´ÐÐ_________²ã²éѯ¡£Í⣬ÄÚ 4£® ¾ÛºÏº¯ÊýCOUNT(*)Êǰ´_________ͳ¼ÆÊý¾Ý¸öÊý¡£ÐÐ
5£® ÉèGradeÁÐĿǰÓÐÈý¸öÖµ£º90¡¢80ºÍNULL£¬ÔòAVG(Grade)µÄÖµÊÇ_________£¬MIN(Grade)µÄÖµÊÇ_________¡£
85£¬80
6£® ÉèÓÐѧÉú±í£¨Ñ§ºÅ£¬ÐÕÃû£¬ËùÔÚϵ£©ºÍÑ¡¿Î±í£¨Ñ§ºÅ£¬¿Î³ÌºÅ£¬³É¼¨£©£¬ÏÖÒª½¨Á¢Í³¼ÆÃ¿¸öϵµÄÑ¡¿ÎÈËÊý¡£Çë²¹
È«ÏÂÁÐÓï¾ä£º COUNT(DISTINCT Ñ¡¿Î±í.ѧºÅ) SELECT ËùÔÚϵ, _________ FROM Ñ¡¿Î±í JOIN ѧÉú±í ON Ñ¡¿Î±í.ѧºÅ = ѧÉú±í.ѧºÅ GROUP BY ËùÔÚϵ
7£® ÉèÓÐÑ¡¿Î±í£¨Ñ§ºÅ£¬¿Î³ÌºÅ£¬³É¼¨£©£¬ÏÖÒª²éѯ¿¼ÊԳɼ¨×î¸ßµÄÈý¸öѧÉúµÄѧºÅ¡¢¿Î³ÌºÅºÍ³É¼¨£¬°üÀ¨²¢ÁÐÇé¿ö¡£
Ç벹ȫÏÂÁÐÓï¾ä£º TOP 3 WITH TIES, ORDER BY ³É¼¨ DESC SELECT _________ ѧºÅ£¬¿Î³ÌºÅ£¬³É¼¨ FROM Ñ¡¿Î±í _________
8£® UNION²Ù×÷ÓÃÓںϲ¢¶à¸ö²éѯÓï¾äµÄ½á¹û£¬Èç¹ûÔںϲ¢½á¹ûʱ²»Ï£ÍûÈ¥µôÖØ¸´µÄÊý¾Ý£¬ÔòÔÚÓÃUNION²Ù×÷ʱ
ӦʹÓÃ_________¹Ø¼ü×Ö¡£ Æð±ðÃû
10£® FROM A LEFT JOIN B ON ¡Óï¾ä±íʾÔÚÁ¬½Ó½á¹ûÖв»ÏÞÖÆ_________±íÊý¾Ý±ØÐëÂú×ãÁ¬½ÓÌõ¼þ¡£ A 11£® ¶Ô·Ö×éºóµÄͳ¼Æ½á¹ûÔÙ½øÐÐɸѡʹÓõÄ×Ó¾äÊÇ_________¡£HAVING
12£® ÈôSELECTÓï¾äÖÐͬʱ°üº¬WHERE×Ó¾äºÍGROUP×Ӿ䣬ÔòÏÈÖ´ÐеÄÊÇ_________×Ӿ䡣WHERE
Èý£® ¼ò´ðÌâ 1.
ÔھۺϺ¯ÊýÖУ¬Äĸöº¯ÊýÔÚͳ¼ÆÊ±²»¿¼ÂÇNULL¡£
10
ALL
9£® ½øÐÐ×ÔÁ¬½Ó²Ù×÷µÄÁ½¸ö±íÔÚÎïÀíÉÏΪһÕÅ±í¡£Í¨¹ý_________·½·¨¿É½«ÎïÀíÉϵÄÒ»ÕűíÔÚÂß¼ÉϳÉΪÁ½ÕÅ±í¡£
´ð£ºCOUNT(*) 2. 3. 4.
WHERE Sdept NOT IN (¡®CS¡¯,¡¯IS¡¯,¡¯MA¡¯)£¬²éÕÒµÄÊý¾ÝÊÇʲô£¿ 5.
×ÔÁ¬½ÓÓëÆÕͨÄÚÁ¬½ÓµÄÖ÷񻂿±ðÊÇʲô£¿ 6.
ÍâÁ¬½ÓÓëÄÚÁ¬½ÓµÄÖ÷񻂿±ðÊÇʲô£¿ 7.
ÔÚʹÓÃUNIONºÏ²¢¶à¸ö²éѯÓï¾äµÄ½á¹ûʱ£¬¶Ô¸÷¸ö²éѯÓï¾äµÄÒªÇóÊÇʲô£¿ 8.
Ïà¹Ø×Ó²éѯÓëǶÌ××Ó²éѯÔÚÖ´Ðз½ÃæµÄÖ÷񻂿±ðÊÇʲô£¿ ´ð£º¸÷¸ö²éѯÓï¾äµÄÁиöÊý±ØÐëÏàͬ£¬¶ÔÓ¦ÁеÄÓïÒåÏàͬ£¬ÀàÐͼæÈÝ¡£
´ð£º×ÔÁ¬½ÓÖнøÐÐÁ¬½Ó²Ù×÷µÄ±íÔÚÎïÀíÉÏÊÇÒ»ÕÅ±í£¬¶øÆÕͨÄÚÁ¬½Ó½øÐÐÁ¬½ÓµÄ±íÔÚÎïÀíÉÏÊÇÁ½ÕÅ±í¡£ ´ð£º²éÕÒ¡®CS¡¯,¡¯IS¡¯,¡¯MA¡¯Èý¸öϵ֮ÍâµÄÆäËûϵ
WHERE Age BETWEEN 20 AND 30×Ӿ䣬²éÕÒµÄAge·¶Î§ÊǶàÉÙ£¿ ´ð£ºAge´óÓÚµÈÓÚ20²¢ÇÒСÓÚµÈÓÚ30
ÔÚLIKEÔËËã·ûÖС°%¡±µÄ×÷ÓÃÊÇʲô£¿ ´ð£ºÆ¥Åä0¸ö»ò¶à¸ö×Ö·û¡£
¡¤11¡¤ ´ð£º½øÐÐÍâÁ¬½ÓµÄÁ½¸ö±íÖУ¬¿ÉÒÔÓÐÒ»ÕÅ±í²»Âú×ãÁ¬½ÓÌõ¼þ£¬¶ø½øÐÐÄÚÁ¬½ÓµÄÁ½¸ö±í±ØÐë¶¼Âú×ãÁ¬½ÓÌõ¼þ¡£
´ð£ºÏà¹Ø×Ó²éѯµÄÖ´Ðйý³ÌÊÇÏÈÍâºóÄÚ£¬¶øÇ¶Ì××Ó²éѯµÄÖ´Ðйý³ÌÊÇÏÈÄÚºóÍâ¡£¶øÇÒÏà¹Ø×Ó²éѯÖбØÐëÓÐÓëÍâ²ã²éѯµÄ¹ØÁª£¬¶øÇ¶Ì××Ó²éѯÖУ¬ÄÚ¡¢Íâ²ã²éѯ֮¼äûÓйØÁª¹ØÏµ¡£
9.
Ö´ÐÐSELECT ¡ INOT ±íÃû FROM ¡Óï¾äʱ£¬¶Ô±íÃûµÄÒªÇóÊÇʲô£¿
10. ¶Ôͳ¼Æ½á¹ûµÄɸѡӦ¸ÃʹÓÃÄĸö×Ó¾äÍê³É£¿ ´ð£ºÊ¹ÓÃHAVING×Ó¾ä
11. ÔÚÅÅÐò×Ó¾äÖУ¬ÅÅÐòÒÀ¾ÝÁеÄǰºó˳ÐòÊÇ·ñÖØÒª£¿ORDER BY C1,C2×Ó¾ä¶ÔÊý¾ÝµÄÅÅÐò˳ÐòÊÇʲô£¿ ´ð£ºÖØÒª£¬ÏµÍ³»á°´ÁеÄÏȺó˳Ðò½øÐÐÅÅÐò¡£
ÏȰ´C1ÁнøÐÐÅÅÐò£¬ÔÚC1ÁÐÖµÏàͬʱÔÙ°´C2ÁнøÐÐÅÅÐò¡£
12. TOP ×Ó¾äµÄ×÷ÓÃÊÇʲô£¿
´ð£ºÔÚ²éѯ½á¹û²úÉúºó£¬ÌáÈ¡½á¹ûµÄǰÈô¸ÉÐÐÊý¾Ý¡£
ËÄ£®ÉÏ»úÁ·Ï°
1£®²éѯѧÉúÑ¡¿Î±íÖеÄÈ«²¿Êý¾Ý¡£ ´ð£ºselect * from SC
2£®²éѯ¼ÆËã»úϵµÄѧÉúµÄÐÕÃû¡¢ÄêÁä¡£
´ð£ºselect sname,sage from student where sdept = '¼ÆËã»úϵ'
3. ²éѯ³É¼¨ÔÚ70¡«80·ÖÖ®¼äµÄѧÉúµÄѧºÅ¡¢¿Î³ÌºÅºÍ³É¼¨¡£
11
´ð£º±ØÐëÊÇÒ»¸ö²»´æÔÚµÄбíÃû¡£
¡¤12¡¤ ´ð£ºselect sno,cno,grade from sc on where grade between 70 and 80
4£® ²éѯ¼ÆËã»úϵÄêÁäÔÚ18¡«20Ö®¼äÇÒÐÔ±ðΪ¡°ÄС±µÄѧÉúµÄÐÕÃû¡¢ÄêÁä¡£ ´ð£ºselect sname,sage from student
where sdept = '¼ÆËã»úϵ' and sage between 18 and 20 and ssex = 'ÄÐ'
5£® ²éѯ¡°C001¡±ºÅ¿Î³ÌµÄ×î¸ß·Ö¡£
´ð£ºselect max(grade) from sc where cno = 'C001'
6. ²éѯ¼ÆËã»úϵѧÉúµÄ×î´óÄêÁäºÍ×îСÄêÁä¡£
´ð£ºselect max(sage) as max_age, min(sage) as min_age from student where sdept = '¼ÆËã»úϵ'
7. ͳ¼ÆÃ¿¸öϵµÄѧÉúÈËÊý¡£
´ð£ºselect sdept,count(*) from student group by sdept
8. ͳ¼ÆÃ¿Ãſγ̵ÄÑ¡¿ÎÈËÊýºÍ¿¼ÊÔ×î¸ß·Ö¡£
´ð£ºselect cno, count(*),max(grade) from sc group by cno
9. ͳ¼ÆÃ¿¸öѧÉúµÄÑ¡¿ÎÃÅÊýºÍ¿¼ÊÔ×ܳɼ¨£¬²¢°´Ñ¡¿ÎÃÅÊýÉýÐòÏÔʾ½á¹û¡£ ´ð£ºselect sno,count(*), sum(grade) from sc group by sno
order by count(*) asc
10. ²éѯ×ܳɼ¨³¬¹ý200·ÖµÄѧÉú£¬ÒªÇóÁгöѧºÅºÍ×ܳɼ¨¡£ ´ð£ºselect sno,sum(grade) from sc group by sno
having sum(grade) > 200
11. ²éѯѡ¿ÎÃÅÊý³¬¹ý2ÃŵÄѧÉúµÄѧºÅ¡¢Æ½¾ù³É¼¨ºÍÑ¡¿ÎÃÅÊý¡£
´ð£ºselect sno, avg(grade), count(*) from sc having count(*) > 2
12. ²éѯѡÁË¡°C002¡±¿Î³ÌµÄѧÉúµÄÐÕÃûºÍËùÔÚϵ¡£
´ð£ºselect sname,sdept from student s join sc on s.sno = sc.sno where cno = 'C002'
13. ²éѯ³É¼¨80·ÖÒÔÉϵÄѧÉúµÄÐÕÃû¡¢¿Î³ÌºÅºÍ³É¼¨£¬²¢°´³É¼¨½µÐòÅÅÁнá¹û¡£
´ð£ºselect sname,cno,grade from student s join sc on s.sno = sc.sno where grade > 80 order by grade desc
14. ²éѯ¼ÆËã»úϵÄÐÉúÐÞÁË¡°Êý¾Ý¿â»ù´¡¡±µÄѧÉúµÄÐÕÃû¡¢ÐÔ±ðºÍ³É¼¨¡£
´ð£ºselect sname,ssex,grade from student s join sc on s.sno = sc.sno join course c on c.cno = sc.cno
where sdept = '¼ÆËã»úϵ' and ssex = 'ÄÐ' and cname = 'Êý¾Ý¿â»ù´¡'
15. ²éѯѧÉúµÄÑ¡¿ÎÇé¿ö£¬ÒªÇóÁгöÿλѧÉúµÄÑ¡¿ÎÇé¿ö£¨°üÀ¨Î´Ñ¡¿ÎµÄѧÉú£©£¬²¢ÁгöѧÉúµÄѧºÅ¡¢ÐÕÃû¡¢¿Î³ÌºÅ
ºÍ¿¼ÊԳɼ¨¡£
12
´ð£ºselect s.sno,sname,cno,grade from student s
left join sc on s.sno = sc.sno
16. ²éѯÄÄЩ¿Î³ÌûÓÐÈËÑ¡£¬ÒªÇóÁгö¿Î³ÌºÅºÍ¿Î³ÌÃû¡£
´ð£ºselect c.cno,cname from course c left join sc on c.cno = sc.cno
where sc.cno is null
17£®²éѯ¼ÆËã»úϵûÓÐÑ¡¿ÎµÄѧÉú£¬ÁгöѧÉúÐÕÃû¡£
´ð£ºselect sname from student s left join sc on s.sno = sc.sno Where sdept = '¼ÆËã»úϵ' and sc.sno is null
18. Áгö¡°Êý¾Ý¿â»ù´¡¡±¿Î³Ì¿¼ÊԳɼ¨Ç°ÈýÃûµÄѧÉúµÄѧºÅ¡¢ÐÕÃû¡¢ËùÔÚϵºÍ¿¼ÊԳɼ¨¡£ ´ð£ºselect top 3 s.sno, sname, sdept, grade from Student s join SC on s.Sno = SC.Sno join Course c on c.Cno = SC.Cno where cname = 'Êý¾Ý¿â»ù´¡' order by grade desc
19£®²éѯVB¿¼ÊԳɼ¨×îµÍµÄѧÉúµÄÐÕÃû¡¢ËùÔÚϵºÍVB³É¼¨¡£
´ð£ºselect top 1 with ties sname,sdept,grade from student s join sc on s.sno = sc.sno join course c on c.cno = sc.cno where cname = 'VB' order by grade asc
¡¤13¡¤ 20. ²éѯÓп¼ÊԳɼ¨µÄËùÓÐѧÉúµÄÐÕÃû¡¢ÐÞ¿ÎÃû³Æ¼°¿¼ÊԳɼ¨£¬ÒªÇ󽫲éѯ½á¹û·ÅÔÚÒ»ÕÅеÄÓÀ¾Ã±íÖУ¬¼ÙÉèбí
ÃûΪnew_sc¡£
´ð£ºselect sname, cname, grade into new_sc from student s join sc on s.sno = sc.sno join course c on c.cno = sc.cno where grade is not null
21. ·Ö±ð²éѯÐÅÏ¢¹ÜÀíϵºÍ¼ÆËã»úϵµÄѧÉúµÄÐÕÃû¡¢ÐÔ±ð¡¢ÐÞ¿ÎÃû³Æ¡¢Ð޿γɼ¨£¬²¢ÒªÇó½«ÕâÁ½¸ö²éѯ½á¹ûºÏ²¢³É
Ò»¸ö½á¹û¼¯£¬²¢ÒÔϵÃû¡¢ÐÕÃû¡¢ÐÔ±ð¡¢ÐÞ¿ÎÃû³Æ¡¢Ð޿γɼ¨µÄ˳ÐòÏÔʾ¸÷ÁС£
´ð£ºselect sdept ϵÃû, sname ÐÕÃû, ssex ÐÔ±ð, cname ÐÞ¿ÎÃû³Æ, grade Ð޿γɼ¨ from student s join sc on s.sno=sc.sno join course c on c.cno=sc.cno where sdept = 'ÐÅÏ¢¹ÜÀíϵ'
UNION
select sdept , sname, ssex, cname, grade from student s join sc on s.sno=sc.sno join course c on c.cno=sc.cno where sdept = '¼ÆËã»úϵ'
22£®²éѯѡÁËVBµÄѧÉúѧºÅ¡¢ÐÕÃû¡¢ËùÔÚϵºÍ³É¼¨£¬²¢¶ÔËùÔÚϵ½øÐÐÈçÏ´¦Àí£º
13
¡¤14¡¤ µ±ËùÔÚϵΪ¡°¼ÆËã»úϵ¡±Ê±£¬ÏÔʾ¡°CS¡±£» µ±ËùÔÚϵΪ¡°ÐÅÏ¢¹ÜÀíϵ¡±Ê±£¬ÏÔʾ¡°IS¡±£» µ±ËùÔÚϵΪ¡°Í¨Ðʤ³Ìϵ¡±Ê±£¬ÏÔʾ¡°CO¡±£»
¶ÔÆäËûϵ£¬¾ùÏÔʾ¡°OTHER¡±¡£
´ð£ºselect s.sno ѧºÅ,sname ÐÕÃû, case sdept when '¼ÆËã»úϵ' then 'CS' when 'ÐÅϢϵ' then 'IS' when 'Êýѧϵ' then 'CO' else 'OTHER'
end as ËùÔÚϵ,grade ³É¼¨
from student s join sc on s.sno = sc.sno join course c on c.cno = sc.cno where cname = 'vb'
23. ÓÃ×Ó²éѯʵÏÖÈçϲéѯ:
£¨1£©²éѯѡÁË¡°C001¡±¿Î³ÌµÄѧÉúÐÕÃûºÍËùÔÚϵ¡£
´ð£ºselect sname,sdept from student where sno in( select sno from sc where cno = ' C001')
£¨2£©²éѯͨÐŹ¤³Ìϵ³É¼¨80·ÖÒÔÉϵÄѧÉúѧºÅºÍÐÕÃû¡£ ´ð£ºselect sno,sname from student where sno in( select sno from sc where grade > 80) and sdept = 'ͨÐŹ¤³Ìϵ'
£¨3£©²éѯ¼ÆËã»úϵ¿¼ÊԳɼ¨×î¸ßµÄѧÉúÐÕÃû¡£
´ð£ºselect sname from student s join sc on s.sno = sc.sno where sdept = '¼ÆËã»úϵ' and grade = (
select max(grade) from sc join student s on s.sno = sc.sno where sdept = '¼ÆËã»úϵ')
£¨4£©²éѯÄêÁä×î´óµÄÄÐÉúµÄÐÕÃûºÍÄêÁä¡£ ´ð£ºselect sname,sage from student
Where sage = (select max(sage) from student and ssex = 'ÄÐ') and ssex = 'ÄÐ'
£¨5£©²éѯ¡°C001¡±¿Î³ÌµÄ¿¼ÊԳɼ¨¸ßÓÚ¡°C001¡±¿Î³ÌµÄƽ¾ù³É¼¨µÄѧÉúµÄѧºÅºÍ¡°C001¡±¿Î³Ì³É¼¨¡£ ´ð£ºselect sno,grade from sc where cno = ' C001'
And grade > (select avg(grade) from sc where cno = ' C001')
24. ´´½¨Ò»¸öÐÂ±í£¬±íÃûΪtest_t£¬Æä½á¹¹Îª£º£¨COL1, COL 2, COL 3£©£¬ÆäÖУº
COL1£ºÕûÐÍ£¬ÔÊÐí¿ÕÖµ¡£
COL2£º×Ö·ûÐÍ£¬³¤¶ÈΪ10 £¬²»ÔÊÐí¿ÕÖµ¡£ COL3£º×Ö·ûÐÍ£¬³¤¶ÈΪ10 £¬ÔÊÐí¿ÕÖµ¡£
ÊÔд³ö°´ÐвåÈëÈçÏÂÊý¾ÝµÄÓï¾ä£¨¿Õ°×´¦±íʾ¿ÕÖµ£©¡£
14
COL1 1 2 COL1 int,
COL2 char(10) not null, COL3 char(10) )
insert into test_t values(NULL, 'B1', NULL) insert into test_t values(1, 'B2', 'C2') insert into test_t(COL1, COL2) values(2, 'B3')
25. ½« ¡°C001¡±¿Î³ÌµÄ¿¼ÊԳɼ¨¼Ó10·Ö¡£
´ð£ºupdate sc set grade = grade + 10 where cno = 'C001'
B1 B2 B3 COL2 C2 COL3 ¡¤15¡¤ ´ð£ºcreate table test_t (
26. ½«¼ÆËã»úϵËùÓÐÑ¡ÐÞÁË¡°¼ÆËã»úÎÄ»¯Ñ§¡±¿Î³ÌµÄѧÉú³É¼¨¼Ó10·Ö£¬·Ö±ðÓÃ×Ó²éѯºÍ¶à±íÁ¬½ÓÐÎʽʵÏÖ¡£ ´ð£º£¨1£©×Ó²éѯ
update sc set grade = grade + 10 where sno in(
select sno from student where sdept = '¼ÆËã»úϵ') and cno in(
select cno from course where cname = '¼ÆËã»úÎÄ»¯Ñ§')
£¨2£©¶à±íÁ¬½Ó
update sc set grade = grade + 10
from sc join student s on sc.sno = s.sno join course c on c.cno = sc.cno
where sdept = '¼ÆËã»úϵ' and canem = '¼ÆËã»úÎÄ»¯Ñ§'
27. ɾ³ýÐ޿γɼ¨Ð¡ÓÚ50·ÖµÄѧÉúµÄÑ¡¿Î¼Ç¼¡£ ´ð£ºdelete from sc where grade < 50
28. ɾ³ýÐÅÏ¢¹ÜÀíϵ¿¼ÊԳɼ¨Ð¡ÓÚ50·ÖµÄѧÉúµÄ¸ÃÃſγ̵ÄÐ޿μͼ£¬·Ö±ðÓÃ×Ó²éѯºÍ¶à±íÁ¬½ÓÐÎʽʵÏÖ¡£ ´ð£º£¨1£© ÓÃÁ¬½Ó²éѯʵÏÖ
delete from sc from sc join student s on s.sno=sc.sno where sdept = 'ÐÅÏ¢¹ÜÀíϵ' and grade < 50 £¨2£©ÓÃ×Ó²éѯʵÏÖ
delete from sc where sno in (
select sno from student where sdept = 'ÐÅÏ¢¹ÜÀíϵ' ) and grade < 50
29£®É¾³ýVB¿¼ÊԳɼ¨×îµÍµÄѧÉúµÄVBÐ޿μǼ¡£ ´ð£ºdelete from sc
15
¡¤16¡¤ where grade = (
select min(grade) from sc
join course c on c.cno = sc.cno where cname = 'vb') and cno in(
select cno from course where cname = 'vb')
16
µÚ5Õ ÊÓͼºÍË÷Òý Ò»£® Ñ¡ÔñÌâ
1£®ÏÂÁйØÓÚÊÓͼµÄ˵·¨£¬ÕýÈ·µÄÊÇ B
A£®ÊÓͼÓë»ù±¾±íÒ»Ñù£¬Ò²´æ´¢Êý¾Ý
B£®¶ÔÊÓͼµÄ²Ù×÷×îÖÕ¶¼×ª»»Îª¶Ô»ù±¾±íµÄ²Ù×÷ C£®ÊÓͼµÄÊý¾ÝÔ´Ö»ÄÜÊÇ»ù±¾±í
D£®ËùÓÐÊÓͼ¶¼¿ÉÒÔʵÏÖ¶ÔÊý¾ÝµÄÔö¡¢É¾¡¢¸Ä¡¢²é²Ù×÷ 2£®ÔÚÊÓͼµÄ¶¨ÒåÓï¾äÖУ¬Ö»Äܰüº¬
A
A£®Êý¾Ý²éѯÓï¾ä B£®Êý¾ÝÔö¡¢É¾¡¢¸ÄÓï¾ä C£®´´½¨±íµÄÓï¾ä
D£®È«²¿¶¼¿ÉÒÔ
3£®ÊÓͼ¶ÔÓ¦Êý¾Ý¿âÈý¼¶Ä£Ê½ÖеÄ_________¡£
A. Íâģʽ B. ÄÚģʽ C. ģʽ D. ÆäËû
4£®ÏÂÁйØÓÚͨ¹ýÊÓͼ¸üÐÂÊý¾ÝµÄ˵·¨£¬´íÎóµÄÊÇ A
A£®Èç¹ûÊÓͼµÄ¶¨ÒåÉæ¼°µ½¶àÕÅ±í£¬Ôò¶ÔÕâÖÖÊÓͼһ°ãÇé¿öÏÂÔÊÐí½øÐиüвÙ×÷ B£®Èç¹û¶¨ÒåÊÓͼµÄ²éѯÓï¾äÖк¬ÓÐGROUP BY×Ӿ䣬Ôò¶ÔÕâÖÖÊÓͼ²»ÔÊÐí½øÐиüвÙ×÷ C£®Èç¹û¶¨ÒåÊÓͼµÄ²éѯÓï¾äÖк¬ÓÐͳ¼Æº¯Êý£¬Ôò¶ÔÕâÖÖÊÓͼ²»ÔÊÐí½øÐиüвÙ×÷ D£®Èç¹ûÊÓͼÊý¾ÝÀ´×Ôµ¥¸ö»ù±¾±íµÄÐС¢ÁÐÑ¡Ôñ½á¹û£¬ÔòÒ»°ãÇé¿öÏÂÔÊÐí½øÐиüвÙ×÷ 5£®ÏÂÁйØÓÚÊÓͼµÄ˵·¨£¬ÕýÈ·µÄÊÇ
B
A£®Í¨¹ýÊÓͼ¿ÉÒÔÌá¸ßÊý¾Ý²éѯЧÂÊ
B£®ÊÓͼÌṩÁËÊý¾ÝµÄÂß¼¶ÀÁ¢ÐÔ C£®ÊÓͼֻÄܽ¨Á¢ÔÚ»ù±¾±íÉÏ
D£®¶¨ÒåÊÓͼµÄÓï¾ä¿ÉÒÔ°üº¬Êý¾Ý¸ü¸ÄÓï¾ä 6£®´´½¨ÊÓͼµÄÖ÷Òª×÷ÓÃÊÇ
D
A£®Ìá¸ßÊý¾Ý²éѯЧÂÊ B£®Î¬»¤Êý¾ÝµÄÍêÕûÐÔÔ¼Êø C£®Î¬»¤Êý¾ÝµÄÒ»ÖÂÐÔ D£®ÌṩÓû§ÊӽǵÄÊý¾Ý
7£®½¨Á¢Ë÷Òý¿ÉÒÔ¼Ó¿ìÊý¾ÝµÄ²éѯЧÂÊ¡£ÔÚÊý¾Ý¿âµÄÈý¼¶Ä£Ê½½á¹¹ÖУ¬Ë÷ÒýÊôÓÚ A
A£®ÄÚģʽ B£®Ä£Ê½ C£®Íâģʽ
D£®¸ÅÄîģʽ
8£®ÉèÓÐѧÉú±í£¨Ñ§ºÅ£¬ÐÕÃû£¬ËùÔÚϵ£©¡£ÏÂÁн¨Á¢Í³¼ÆÃ¿¸öϵµÄѧÉúÈËÊýµÄÊÓͼÓï¾äÖУ¬ÕýÈ·µÄÊÇA£®CREATE VIEW v1 AS
SELECT ËùÔÚϵ, COUNT(*) FROM ѧÉú±í GROUP BY ËùÔÚϵ B£®CREATE VIEW v1 AS
SELECT ËùÔÚϵ, SUM(*) FROM ѧÉú±í GROUP BY ËùÔÚϵ C£®CREATE VIEW v1(ϵÃû,ÈËÊý) AS
SELECT ËùÔÚϵ, SUM(*) FROM ѧÉú±í GROUP BY ËùÔÚϵ D£®CREATE VIEW v1(ϵÃû,ÈËÊý) AS
SELECT ËùÔÚϵ, COUNT(*) FROM ѧÉú±í GROUP BY ËùÔÚϵ
17
¡¤17¡¤ D
¡¤18¡¤
A
9£®ÉèÓû§ÔÚijÊý¾Ý¿âÖо³£ÐèÒª½øÐÐÈçϲéѯ²Ù×÷£º
SELECT * FROM T WHERE C1=¡¯A¡¯ ORDER BY C2
ÉèT±íÖÐÒÑÔÚC1ÁÐÉϽ¨Á¢ÁËÖ÷ÂëÔ¼Êø£¬ÇҸñíÖ»½¨ÓиÃÔ¼Êø¡£ÎªÌá¸ß¸Ã²éѯµÄÖ´ÐÐЧÂÊ£¬ÏÂÁз½·¨ÖпÉÐеÄÊÇ
C
A£®ÔÚC1ÁÐÉϽ¨Á¢Ò»¸ö¾Û¼¯Ë÷Òý£¬ÔÚC2ÁÐÉϽ¨Á¢Ò»¸ö·Ç¾Û¼¯Ë÷Òý B£®ÔÚC1ºÍC2ÁÐÉÏ·Ö±ð½¨Á¢Ò»¸ö·Ç¾Û¼¯Ë÷Òý C£®ÔÚC2ÁÐÉϽ¨Á¢Ò»¸ö·Ç¾Û¼¯Ë÷Òý
D£®ÔÚC1ºÍC2ÁÐÉϽ¨Á¢Ò»¸ö×éºÏµÄ·Ç¾Û¼¯Ë÷Òý 10£®ÏÂÁйØÓÚË÷ÒýµÄ˵·¨£¬ÕýÈ·µÄÊÇ
C
A£®Ö»Òª½¨Á¢ÁËË÷Òý¾Í¿ÉÒÔ¼Ó¿ìÊý¾ÝµÄ²éѯЧÂÊ
B£®µ±Ò»¸ö±íÉÏÐèÒª´´½¨¾Û¼¯ºÍ·Ç¾Û¼¯Ë÷Òýʱ£¬Ó¦¸ÃÏÈ´´½¨·Ç¾Û¼¯Ë÷Òý£¬È»ºóÔÙ´´½¨¾Û¼¯Ë÷Òý£¬ÕâÖÖ˳Ðò»áʹ´´½¨Ë÷ÒýµÄЧÂʱȽϸß
C£®ÔÚÒ»¸ö±íÉÏ¿ÉÒÔ½¨Á¢¶à¸öΨһµÄ·Ç¾Û¼¯Ë÷Òý
D£®Ë÷Òý»áÓ°ÏìÊý¾Ý²åÈëºÍ¸üÐÂÊý¾ÝµÄÖ´ÐÐЧÂÊ£¬µ«²»»áÓ°Ïìɾ³ýÊý¾ÝµÄÖ´ÐÐЧÂÊ
11£®ÏÂÁйØÓÚCREATE UNIQUE INDEX IDX1 ON T(C1,C2)Óï¾ä×÷ÓõÄ˵·¨£¬ÕýÈ·µÄÊÇ D
A£®ÔÚC1ºÍC2ÁÐÉÏ·Ö±ð½¨Á¢Ò»¸öΨһ¾Û¼¯Ë÷Òý B£®ÔÚC1ºÍC2ÁÐÉÏ·Ö±ð½¨Á¢Ò»¸öΨһ·Ç¾Û¼¯Ë÷Òý C£®ÔÚC1ºÍC2ÁеÄ×éºÏÉϽ¨Á¢Ò»¸öΨһ¾Û¼¯Ë÷Òý D£®ÔÚC1ºÍC2ÁеÄ×éºÏÉϽ¨Á¢Ò»¸öΨһ·Ç¾Û¼¯Ë÷Òý
¶þ£® Ìî¿ÕÌâ
1£®¶ÔÊÓͼµÄ²Ù×÷×îÖÕ¶¼×ª»»Îª¶Ô_____²Ù×÷¡£ »ù±¾±í
2£®ÊÓͼÊÇÐé±í£¬ÔÚÊý¾Ý¿âÖÐÖ»´æ´¢ÊÓͼµÄ_____£¬²»´æ´¢ÊÓͼµÄÊý¾Ý¡£ ¶¨Òå 3£®ÐÞ¸ÄÊÓͼ¶¨ÒåµÄÓï¾äÊÇ_____¡£ ALTER VIEW 4£®ÊÓͼ¶ÔÓ¦Êý¾Ý¿âÈý¼¶Ä£Ê½ÖеÄ_____ģʽ¡£ Íâ
5£®ÔÚÒ»¸ö±íÉÏ×î¶à¿ÉÒÔ½¨Á¢_____¸ö¾Û¼¯Ë÷Òý£¬¿ÉÒÔ½¨Á¢_____¸ö·Ç¾Û¼¯Ë÷Òý¡£ Ò» ,¶à
6£®µ±ÔÚT±íµÄC1ÁÐÉϽ¨Á¢¾Û¼¯Ë÷Òýºó£¬Êý¾Ý¿â¹ÜÀíϵͳ»á½«T±íÊý¾Ý°´ _____ ÁнøÐÐ _____¡£
C1 ÎïÀíÅÅÐò
7£®Ë÷Òý½¨Á¢µÄºÏÊÊ£¬¿ÉÒÔ¼Ó¿ìÊý¾Ý_____²Ù×÷µÄÖ´ÐÐЧÂÊ¡£ ²éѯ
8£®ÔÚemployees±íµÄphoneÁÐÉϽ¨Á¢Ò»¸ö·Ç¾Û¼¯Ë÷ÒýµÄSQLÓï¾äÊÇ_____
CREATE INDEX IDX1 ON employees(phone)
»ò£ºCREATE NONCLUSTERED INDEX IDX1 ON employees(phone)
9£®ÉèÓÐstudent±í£¬½á¹¹ÎªStudent(Sno,Sname,Sdept)¡£ÏÖÒªÔڸñíÉϽ¨Á¢Ò»¸öͳ¼ÆÃ¿¸öϵµÄѧÉúÈËÊýµÄÊÓͼ£¬ÊÓͼÃûΪV_dept£¬ÊÓͼ½á¹¹Îª£¨ÏµÃû,ÈËÊý£©¡£Ç벹ȫÏÂÁж¨Òå¸ÃÊÓͼµÄSQLÓï¾ä V_dept (ϵÃû,ÈËÊý) , GROUP BY Sdept CREATE VIEW _____ AS
SELECT Sdept, COUNT(*) _____
10£®·Ç¾Û¼¯Ë÷ÒýµÄB-Ê÷ÖУ¬Ò¶¼¶½ÚµãÖÐÿ¸öË÷ÒýÐÐÓÉË÷Òý¼üÖµºÍ_____×é³É¡£ ÐÐָʾÆ÷
Èý£® ¼ò´ðÌâ
18
1. ÊÔ˵Ã÷ʹÓÃÊÓͼµÄºÃ´¦¡£
¡¤19¡¤ ´ð£ºÀûÓÃÊÓͼ¿ÉÒÔ¼ò»¯¿Í»§¶ËµÄÊý¾Ý²éѯÓï¾ä£¬Ê¹Óû§ÄÜ´Ó¶à½Ç¶È¿´´ýͬһÊý¾Ý£¬¿ÉÒÔÌá¸ßÊý¾ÝµÄ°²È«ÐÔ£¬ÊÓͼ¶ÔÓ¦Êý¾Ý¿âÈý¼¶Ä£Ê½ÖеÄÍâģʽ£¬Òò´ËÌṩÁËÒ»¶¨³Ì¶ÈµÄÂß¼¶ÀÁ¢ÐÔ¡£
2. ÊÔ˵Ã÷ÄÄÀàÊÓͼ¿ÉʵÏÖ¸üÐÂÊý¾ÝµÄ²Ù×÷£¬ÄÄÀàÊÓͼ²»¿ÉʵÏÖ¸üÐÂÊý¾ÝµÄ²Ù×÷¡£
´ð£ºÒ»°ãֻɿ¼°µ½Ò»ÕűíµÄÐÐÁÐ×Ó¼¯£¬ÇÒ²»º¬·Ö×顢ͳ¼Æ¼ÆËãµÈ²Ù×÷µÄÊÓͼÊǿɸüÐÂÊý¾ÝµÄ£¬ÆäËûÇé¿öÒ»°ã¶¼²»ÄÜʵÏÖÊý¾ÝµÄ¸üвÙ×÷¡£
3. ʹÓÃÊÓͼ¿ÉÒÔ¼Ó¿ìÊý¾ÝµÄ²éѯËÙ¶È£¬Õâ¾ä»°¶ÔÂð£¿ÎªÊ²Ã´£¿
´ð£º²»¶Ô£¬ÒòΪͨ¹ýÊÓͼ²éѯÊý¾Ýʱ£¬±ÈÖ±½ÓÕë¶Ô»ù±¾±í²éѯÊý¾Ý¶àÁËÒ»¸öת»»¹ý³Ì£¬¼´´ÓÍâģʽµ½Ä£Ê½µÄת»»¡£
4. Ë÷ÒýµÄ×÷ÓÃÊÇʲô£¿
´ð£ºË÷Òý¿ÉÒÔ¼Ó¿ìÊý¾ÝµÄ²éѯЧÂÊ¡£
5. Ë÷Òý·ÖΪÄļ¸ÖÖÀàÐÍ£¿·Ö±ðÊÇʲô£¿ËüÃǵÄÖ÷񻂿±ðÊÇʲô
´ð£º·ÖΪ¾Û¼¯Ë÷ÒýºÍ·Ç¾Û¼¯Ë÷ÒýÁ½ÖÖ¡£¾Û¼¯Ë÷Òý»á¶ÔÊý¾Ý½øÐÐÎïÀíÅÅÐò£¬·Ç¾Û¼¯Ë÷Òý²»¶ÔÊý¾Ý½øÐÐÎïÀíÅÅÐò¡£
6. ¾Û¼¯Ë÷ÒýÒ»¶¨ÊÇΨһÐÔË÷Òý£¬¶ÔÂ𣿷´Ö®ÄØ£¿ ´ð£º²»¶Ô¡£·´Ö®Ò²²»¶Ô¡£
7. ÔÚ½¨Á¢¾Û¼¯Ë÷Òýʱ£¬Êý¾Ý¿â¹ÜÀíϵͳÊ×ÏÈÒª½«Êý¾Ý°´¾Û¼¯Ë÷ÒýÁнøÐÐÎïÀíÅÅÐò¡£¶ÔÂ𣿠´ð£º¶Ô¡£
8. ÔÚ½¨Á¢·Ç¾Û¼¯Ë÷Òýʱ£¬Êý¾Ý¿â¹ÜÀíϵͳ²¢²»¶ÔÊý¾Ý½øÐÐÎïÀíÅÅÐò¡£¶ÔÂ𣿠´ð£º¶Ô¡£
9. ²»¹Ü¶Ô±í½øÐÐʲôÀàÐ͵IJÙ×÷£¬ÔÚ±íÉϽ¨Á¢µÄË÷ÒýÔ½¶àÔ½ÄÜÌá¸ß²Ù×÷ЧÂÊ¡£¶ÔÂ𣿠10. ´ð£º²»¶Ô¡£
11. ÊʺϽ¨Á¢Ë÷ÒýµÄÁÐÊÇʲô£¿ ´ð£ºÊʺϽ¨Á¢Ë÷ÒýµÄÇé¿ö£º
? ? ? ?
ËÄ£®ÉÏ»úÁ·Ï°
1£® д³ö´´½¨Âú×ãÏÂÊöÒªÇóµÄÊÓͼµÄSQLÓï¾ä£¬²¢Ö´ÐÐÕâЩÓï¾ä¡£½«ËùдÓï¾ä±£´æµ½Ò»¸öÎļþÖС£ £¨1£© ²éѯѧÉúµÄѧºÅ¡¢ÐÕÃû¡¢ËùÔÚϵ¡¢¿Î³ÌºÅ¡¢¿Î³ÌÃû¡¢¿Î³Ìѧ·Ö¡£ ´ð£ºCreate view v1 As
Select s.sno,sname,sdept,c.cno,cname,credit From student s join sc on s.sno = sc.sno Join course c on c.cno = sc.cno
£¨2£© ²éѯѧÉúµÄѧºÅ¡¢ÐÕÃû¡¢Ñ¡Ð޵ĿγÌÃûºÍ¿¼ÊԳɼ¨¡£
19
°üº¬´óÁ¿·ÇÖØ¸´ÖµµÄÁС£
ÔÚWHERE×Ó¾äÖо³£ÓÃÓÚ½øÐÐBETWEEN AND¡¢>¡¢>=¡¢< ºÍ <=µÈ²Ù×÷µÄÁС£ ¾³£±»ÓÃ×÷Á¬½Ó²Ù×÷µÄÁС£
ORDER BY»òGROUP BY×Ó¾äÖÐÉæ¼°µÄÁС£
¡¤20¡¤ ´ð£ºCreate view v2 As
Select s.sno,sname,cname,grade
From student s join sc on s.sno = sc.sno Join course c on c.cno = sc.cno
£¨3£© ͳ¼ÆÃ¿¸öѧÉúµÄÑ¡¿ÎÃÅÊý£¬ÁгöѧÉúѧºÅºÍÑ¡¿ÎÃÅÊý¡£ ´ð£ºCreate view v3 As
Select sno,count(*) as total From sc group by sno
£¨4£© ͳ¼ÆÃ¿¸öѧÉúµÄÐÞ¿Î×Üѧ·Ö£¬ÁгöѧÉúѧºÅºÍ×Üѧ·Ö£¨ËµÃ÷£º¿¼ÊԳɼ¨´óÓÚµÈÓÚ60²Å¿É»ñµÃ´ËÃſγ̵Äѧ
·Ö£©¡£
´ð£ºCreate view v4 As
Select sno,sum(credit) as total_credit From sno join course c on c.cno = sc.cno Where grade >= 60 Group by sno
2£® ÀûÓõÚ1Ì⽨Á¢µÄÊÓͼ£¬Ð´³öÍê³ÉÈçϲéѯµÄSQLÓï¾ä£¬²¢Ö´ÐÐÕâЩÓï¾ä£¬²é¿´Ö´Ðнá¹û¡£½«²éѯÓï¾äºÍÖ´ÐÐ
½á¹û±£´æµ½Ò»¸öÎļþÖС£
£¨1£© ²éѯ¿¼ÊԳɼ¨´óÓÚµÈÓÚ90·ÖµÄѧÉúµÄÐÕÃû¡¢¿Î³ÌÃûºÍ³É¼¨¡£ ´ð£ºSelect sname,cname,grade From v2 where grade >= 90
£¨2£© ²éѯѡ¿ÎÃÅÊý³¬¹ý3ÃŵÄѧÉúµÄѧºÅºÍÑ¡¿ÎÃÅÊý¡£ ´ð£ºSelect * from v3 where total >= 3
£¨3£© ²éѯ¼ÆËã»úϵѡ¿ÎÃÅÊý³¬¹ý3ÃŵÄѧÉúµÄÐÕÃûºÍÑ¡¿ÎÃÅÊý¡£
´ð£ºSelect sname,total from v3 join student s on s.sno = v3.sno Where sdept = ¡®¼ÆËã»úϵ¡¯ and total >= 3
£¨4£© ²éѯÐÞ¿Î×Üѧ·Ö³¬¹ý10·ÖµÄѧÉúµÄѧºÅ¡¢ÐÕÃû¡¢ËùÔÚϵºÍÐÞ¿Î×Üѧ·Ö¡£ ´ð£ºSelect v4.sno,sname,sdept,total_credit From v4 join student s on s.sno = v4.sno Where total_credit >= 10
£¨5£© ²éѯÄêÁä´óÓÚµÈÓÚ20ËêµÄѧÉúÖУ¬ÐÞ¿Î×Üѧ·Ö³¬¹ý10·ÖµÄѧÉúµÄÐÕÃû¡¢ÄêÁä¡¢ËùÔÚϵºÍÐÞ¿Î×Üѧ·Ö¡£ ´ð£ºSelect sname,sage,sdept,total_credit From v4 join student s on s.sno = v4.sno Where sage >= 20 and total_credit >= 10
3£® Ð޸ĵÚ1Ì⣨4£©¶¨ÒåµÄÊÓͼ£¬Ê¹Æä²éѯÿ¸öѧÉúµÄѧºÅ¡¢×Üѧ·ÖÒÔ¼°×ܵÄÑ¡¿ÎÃÅÊý¡£ ´ð£º Alter view v4 As
Select sno,sum(credit) as total_credit,count(*) as total_cno
From sc join course c on c.cno = sc.cno Group by sno
20
4£® д³öʵÏÖÏÂÁвÙ×÷µÄSQLÓï¾ä£¬Ö´ÐÐÕâЩÓï¾ä£¬²¢ÔÚSSMS¹¤¾ßÖй۲ìÓï¾äÖ´Ðнá¹û¡£ £¨1£© ÔÚStudent±íµÄSdeptÁÐÉϽ¨Á¢Ò»¸ö°´½µÐòÅÅÐòµÄ·Ç¾Û¼¯Ë÷Òý£¬Ë÷ÒýÃûΪ£ºIdx_Sdept¡£
´ð£ºCreate index Idx_Sdept on student(Sdept DESC)
£¨2£© ÔÚStudent±íµÄSnameÁÐÉϽ¨Á¢Ò»¸öΨһµÄ·Ç¾Û¼¯Ë÷Òý£¬Ë÷ÒýÃûΪ£ºIdx_Sname¡£ ´ð£ºCreate unique index Idx_Sname on student(Sname)
£¨3£© ÔÚCourse±íÉÏΪCnameÁн¨Á¢Ò»¸ö·Ç¾Û¼¯Ë÷Òý£¬Ë÷ÒýÃûΪ£º Idx_Cname ´ð£ºCreate index Idx_Cname on Course(Cname)
£¨4£© ÔÚSC±íÉÏΪSnoºÍCno½¨Á¢Ò»¸ö×éºÏµÄ·Ç¾Û¼¯Ë÷Òý£¬Ë÷ÒýÃûΪ£ºIdx_SnoCno¡£ ´ð£ºCreate index Idx_SnoCno on SC(Sno,Cno)
£¨5£© ɾ³ýÔÚSnameÁÐÉϽ¨Á¢µÄIdx_SnameË÷Òý¡£ ´ð£ºdrop index Idx_Sname on Student
¡¤21¡¤ 21
¡¤22¡¤
µÚ6Õ ¹ØÏµÊý¾ÝÀíÂÛ
Ò»£®Ñ¡ÔñÌâ
1£®¶Ô¹ØÏµÄ£Ê½½øÐй淶»¯µÄÖ÷ҪĿµÄÊÇ
B
A£®Ìá¸ßÊý¾Ý²Ù×÷ЧÂÊ B£®Î¬»¤Êý¾ÝµÄÒ»ÖÂÐÔ
C£®¼ÓÇ¿Êý¾ÝµÄ°²È«ÐÔ D£®ÎªÓû§Ìṩ¸ü¿ì½ÝµÄÊý¾Ý²Ù×÷
2£®¹ØÏµÄ£Ê½ÖеIJåÈëÒì³£ÊÇÖ¸
D
A£®²åÈëµÄÊý¾ÝÎ¥·´ÁËʵÌåÍêÕûÐÔÔ¼Êø B£®²åÈëµÄÊý¾ÝÎ¥·´ÁËÓû§¶¨ÒåµÄÍêÕûÐÔÔ¼Êø C£®²åÈëÁ˲»¸Ã²åÈëµÄÊý¾Ý D£®Ó¦¸Ã±»²åÈëµÄÊý¾Ý²»Äܱ»²åÈë
3£®Èç¹ûÓк¯ÊýÒÀÀµX¡úY£¬²¢ÇÒ¶ÔXµÄÈÎÒâÕæ×Ó¼¯X¡¯£¬¶¼ÓÐX¡¯
Y£¬Ôò³Æ C
A£®XÍêÈ«º¯ÊýÒÀÀµÓÚY B£®X²¿·Öº¯ÊýÒÀÀµÓÚY C£®YÍêÈ«º¯ÊýÒÀÀµÓÚX
D£®Y²¿·Öº¯ÊýÒÀÀµÓÚX
4£®Èç¹ûÓк¯ÊýÒÀÀµX¡úY£¬²¢ÇÒ¶ÔXµÄij¸öÕæ×Ó¼¯X¡¯£¬ÓÐX¡¯¡úY³ÉÁ¢£¬Ôò³Æ B
A£®YÍêÈ«º¯ÊýÒÀÀµÓÚX B£®Y²¿·Öº¯ÊýÒÀÀµÓÚX C£®XÍêÈ«º¯ÊýÒÀÀµÓÚY
D£®X²¿·Öº¯ÊýÒÀÀµÓÚY
5£®ÈôX¡úYºÍY¡úZÔÚ¹ØÏµÄ£Ê½RÉϳÉÁ¢£¬ÔòX¡úZÔÚRÉÏÒ²³ÉÁ¢¡£¸ÃÍÆÀí¹æÔò³ÆÎª C
A£®×Ô·´¹æÔò B£®Ôö¹ã¹æÔò C£®´«µÝ¹æÔò
D£®Î±´«µÝ¹æÔò
6£®Èô¹ØÏµÄ£Ê½RÖÐÊôÐÔA½ö³öÏÖÔÚº¯ÊýÒÀÀµµÄ×󲿣¬ÔòAΪ A
A£®LÀàÊôÐÔ B£®RÀàÊôÐÔ C£®NÀàÊôÐÔ
D£®LRÀàÊôÐÔ
7£®Èô¹ØÏµÄ£Ê½RÖÐÊôÐÔAÊÇNÀàÊôÐÔ£¬ÔòA D
A£®Ò»¶¨²»°üº¬ÔÚRÈκκòÑ¡ÂëÖÐ B£®¿ÉÄܰüº¬Ò²¿ÉÄܲ»°üº¬ÔÚRµÄºòÑ¡ÂëÖÐ C£®Ò»¶¨°üº¬ÔÚRµÄij¸öºòÑ¡ÂëÖÐ D£®Ò»¶¨°üº¬ÔÚRµÄÈκκòÑ¡ÂëÖÐ
8£®ÉèFÊÇij¹ØÏµÄ£Ê½µÄ¼«Ð¡º¯ÊýÒÀÀµ¼¯¡£ÏÂÁйØÓÚFµÄ˵·¨£¬´íÎóµÄÊÇ
B
A£®FÖÐÿ¸öº¯ÊýÒÀÀµµÄÓÒ²¿¶¼±ØÐëÊǵ¥¸öÊôÐÔ B£®FÖÐÿ¸öº¯ÊýÒÀÀµµÄ×󲿶¼±ØÐëÊǵ¥¸öÊôÐÔ C£®FÖв»ÄÜÓÐÈßÓàµÄº¯ÊýÒÀÀµ
D£®FÖÐÿ¸öº¯ÊýÒÀÀµµÄ×󲿲»ÄÜÓÐÈßÓàÊôÐÔ
9£®ÓйØÏµÄ£Ê½£ºÑ§Éú£¨Ñ§ºÅ£¬ÐÕÃû£¬ËùÔÚϵ£¬ÏµÖ÷ÈΣ©£¬ÉèÒ»¸öϵֻÓÐÒ»¸öϵÖ÷ÈΣ¬Ôò¸Ã¹ØÏµÄ£Ê½ÖÁÉÙÊôÓÚA£®µÚÒ»·¶Ê½ B£®µÚ¶þ·¶Ê½ C£®µÚÈý·¶Ê½
D£®BC·¶Ê½
10£®ÉèÓйØÏµÄ£Ê½R(X, Y, Z)£¬ÆäF={Y¡úZ, Y¡úX, X¡úYZ}£¬Ôò¸Ã¹ØÏµÄ£Ê½ÖÁÉÙÊôÓÚ
D
A£®µÚÒ»·¶Ê½
B£®µÚ¶þ·¶Ê½ 22
B
C£®µÚÈý·¶Ê½
11£®ÏÂÁйØÓÚ¹ØÏµÄ£Ê½Ó뷶ʽµÄ˵·¨£¬´íÎóµÄÊÇ
A£®ÈκÎÒ»¸öÖ»°üº¬Á½¸öÊôÐԵĹØÏµÄ£Ê½Ò»¶¨ B£®ÈκÎÒ»¸öÖ»°üº¬Á½¸öÊôÐԵĹØÏµÄ£Ê½Ò»¶¨ C£®ÈκÎÒ»¸öÖ»°üº¬Á½¸öÊôÐԵĹØÏµÄ£Ê½Ò»¶¨ D£®ÈκÎÒ»¸öÖ»°üº¬Èý¸öÊôÐԵĹØÏµÄ£Ê½Ò»¶¨
D£®BC·¶Ê½ D ÊôÓÚ3NF ÊôÓÚBCNF ÊôÓÚ2NF ÊôÓÚ3NF
¡¤23¡¤ 12£®ÓйØÏµÄ£Ê½£º½èÊ飨ÊéºÅ£¬ÊéÃû£¬¿â´æÁ¿£¬¶ÁÕߺţ¬½èÊéÈÕÆÚ£¬»¹ÊéÈÕÆÚ)£¬ÉèÒ»¸ö¶ÁÕß¿ÉÒÔ¶à´Î½èÔÄͬһ±¾Ê飬µ«¶ÔÒ»ÖÖÊ飨ÓÃÊéºÅΨһ±êʶ£©²»ÄÜͬʱ½è¶à±¾¡£¸Ã¹ØÏµÄ£Ê½µÄÖ÷ÂëÊÇ
A£®£¨ÊéºÅ£¬¶ÁÕߺţ¬½èÊéÈÕÆÚ£© B£® £¨ÊéºÅ£©
¶þ£®Ìî¿ÕÌâ
1£®ÔÚ¹ØÏµÄ£Ê½RÖУ¬ÈôÊôÐÔAÖ»³öÏÖÔÚº¯ÊýÒÀÀµµÄÓÒ²¿£¬ÔòAÊÇ_____ÀàÊôÐÔ¡£ R 2£®Èô¹ØÏµÄ£Ê½R¡Ê2NF£¬ÔòRÖÐÒ»¶¨²»´æÔÚ·ÇÖ÷ÊôÐÔ¶ÔÖ÷ÂëµÄ_____º¯ÊýÒÀÀµ¡£ ²¿·Ö 3£®Èô¹ØÏµÄ£Ê½R¡Ê3NF£¬ÔòRÖÐÒ»¶¨²»´æÔÚ·ÇÖ÷ÊôÐÔ¶ÔÖ÷ÂëµÄ_____º¯ÊýÒÀÀµ¡£ ´«µÝ
4£®ÉèÓйØÏµÄ£Ê½X(S, SN, D)ºÍY(D, DN, M)£¬XµÄÖ÷ÂëÊÇS£¬YµÄÖ÷ÂëÊÇD£¬ÔòDÔÚ¹ØÏµÄ£Ê½XÖб»³ÆÎª_____¡£ ÍâÂë
5£®ÉèÓйØÏµÄ£Ê½R(U, F)£¬U={X, Y, Z, W}£¬F={XY¡úZ, W¡úX}£¬Ôò(ZW)+ = _____£¬RµÄºòÑ¡ÂëΪ_____£¬¸Ã¹ØÏµÄ£Ê½ÊôÓÚ_____·¶Ê½¡£XZW YW
µÚÒ»
6£®ÔÚ¹ØÏµÄ£Ê½RÖУ¬ÈôÊôÐÔA²»ÔÚÈκκ¯ÊýÒÀÀµÖгöÏÖ£¬ÔòAÊÇ_____ÀàÊôÐÔ¡£ N
7£®ÔÚ¹ØÏµÄ£Ê½RÖУ¬ÈôÓÐX¡úY£¬ÇÒZ?Y£¬ÔòX¡úZÔÚRÉÏÒ²³ÉÁ¢£¬¸ÃÍÆÀí¹æÔòΪArmstrong¹«ÀíϵͳÖеÄ_____¡£·Ö½â¹æÔò
8£®¸ù¾ÝArmstrong¹«ÀíϵͳÖеÄ×Ô·´¹æÔò£¬¶Ô¹ØÏµÄ£Ê½RÖеÄÊôÐÔ¼¯X£¬ÈôY?X£¬ÔòÒ»¶¨ÓÐ_____¡£X¡úY 9£®¹ØÏµÊý¾Ý¿âÖеĹØÏµ±íÖÁÉÙ¶¼Âú×ã_____·¶Ê½ÒªÇó¡£ µÚÒ»
10£®¹ØÏµ¹æ·¶»¯µÄ¹ý³ÌÊǽ«¹ØÏµÄ£Ê½´ÓµÍ·¶Ê½¹æ·¶»¯µ½¸ß·¶Ê½µÄ¹ý³Ì£¬Õâ¸ö¹ý³Ìʵ¼ÊÉÏÊÇͨ¹ý_____ʵÏֵġ£ ģʽ·Ö½â
11£® Èô¹ØÏµÄ£Ê½RµÄÖ÷ÂëÖ»°üº¬Ò»¸öÊôÐÔ£¬ÔòRÖÁÉÙÊôÓÚµÚ_____·¶Ê½¡£ ¶þ
12£®Èô¹ØÏµÄ£Ê½RÖÐËùÓеķÇÖ÷ÊôÐÔ¶¼ÍêÈ«º¯ÊýÒÀÀµÓÚÖ÷Â룬ÔòRÖÁÉÙÊôÓÚµÚ_____·¶Ê½¡£ ¶þ
Èý£®¼ò´ðÌâ
1£® ¹ØÏµ¹æ·¶»¯ÖеIJÙ×÷Òì³£ÓÐÄÄЩ£¿ËüÊÇÓÉʲôÒýÆðµÄ£¿½â¾öµÄ°ì·¨ÊÇʲô£¿ 2£®µÚÒ»·¶Ê½¡¢µÚ¶þ·¶Ê½ºÍµÚÈý·¶Ê½¹ØÏµÄ£Ê½µÄ¶¨Òå·Ö±ðÊÇʲô£¿ 3£®Ê²Ã´ÊDz¿·Öº¯ÊýÒÀÀµ£¿Ê²Ã´ÊÇ´«µÝº¯ÊýÒÀÀµ£¿Çë¾ÙÀý˵Ã÷¡£ 4£®µÚÈý·¶Ê½µÄ¹ØÏµÄ£Ê½ÊÇ·ñÒ»¶¨²»°üº¬²¿·Öº¯ÊýÒÀÀµ¹ØÏµ£¿ 5£®ÉèÓйØÏµÄ£Ê½R(A, B, C, D)£¬F={D¡úA, D¡úB} £¨1£©ÇóD¡£
£¨2£©ÇóRµÄÈ«²¿ºòÑ¡Âë¡£ ´ð£º£¨1£©D=DAB
£¨2£©ÒòΪDÊÇLÀàÊôÐÔ£¬Òò´ËDÒ»¶¨³öÏÖÔÚRµÄÈκκòÑ¡ÂëÖУ» ÒòΪCÊÇNÀàÊôÐÔ£¬Òò´ËDÒ»¶¨³öÏÖÔÚRµÄÈκκòÑ¡ÂëÖУ» (CD) = CDAB = RµÄÈ«²¿ÊôÐÔ£¬Òò´ËRµÄΨһºòÑ¡ÂëÊÇCD¡£
6.ÉèÓйØÏµÄ£Ê½R(W, X, Y, Z)£¬F={X¡úZ, WX¡úY}£¬¸Ã¹ØÏµÄ£Ê½ÊôÓÚµÚ¼¸·¶Ê½£¬Çë˵Ã÷ÀíÓÉ¡£
½â£ºRÊÇ1NF£¬RµÄºòÑ¡ÂëΪWX,Òò´ËY,ZÊÇ·ÇÖ÷ÊôÐÔ£¬ÓÖÓÉÓÚ´æÔÚX¡úZ£¬Òò´ËFÖдæÔÚ·ÇÖ÷ÊôÐÔ¶ÔÖ÷ÂëµÄ²¿·Öº¯Êý
23
+
++
A
B£®£¨ÊéºÅ£¬¶ÁÕߺţ© D£®£¨¶ÁÕߺţ©
¡¤24¡¤ ÒÀÀµ£¬Òò´ËR²»ÊÇ2NF¡£
7£®ÉèÓйØÏµÄ£Ê½R(A, B, C, D)£¬F = {A¡úC, C¡úA, B¡úAC, D¡úAC} £¨1£©ÇóB+£¬(AD)+¡£
£¨2£©ÇóRµÄÈ«²¿ºòÑ¡Â룬ÅжÏRÊôÓÚµÚ¼¸·¶Ê½¡£ £¨3£©ÇóFµÄ¼«Ð¡º¯ÊýÒÀÀµ¼¯Fmin¡£ ´ð£º
£¨1£© B+ = BAC
(AD)+ = ADC
£¨2£© ÓÉÓÚB¡¢DÊÇLÀàÊôÐÔ£¬Òò´ËB¡¢D»áÔÚÈκκòÑ¡ÂëÖУ»
(BD)+ = BDAC = RµÄÈ«²¿ÊôÐÔ£¬Òò´ËRµÄºòÑ¡ÂëÊÇBD¡£ RÊǵÚ1·¶Ê½£¬ÒòΪ´æÔÚ²¿·Öº¯ÊýÒÀÀµ£º
£¨3£©¢Ù ½«ËùÓк¯ÊýÒÀÀµµÄÓұ߸ÄΪµ¥¸öÊôÐÔ£¬µÃµ½£ºB¡úAC, D¡úAC
F1 = { A¡úC, C¡úA, B¡úA, B¡úC, D¡úA, D¡úC }
¢Ú È¥µôº¯ÊýÒÀÀµ×󲿵ĶàÓàÊôÐÔ£º¸Ã¹ØÏµÄ£Ê½µÄÈ«²¿º¯ÊýÒÀÀµ¼¯×󲿾ùΪһ¸öÊôÐÔ£¬Òò´Ë²»´æÔÚ×ó²¿ÓжàÓà
ÊôÐÔµÄÇé¿ö¡£ ¢Û È¥µô¶àÓàµÄº¯ÊýÒÀÀµ¡£
È¥µôA¡úC£¬µÃµ½F2 = { C¡úA, B¡úA, B¡úC, D¡úA, D¡úC }
A+F2 = AC£¬°üº¬C£¬Òò´ËΪ¶àÓຯÊýÒÀÀµ£¬Ó¦È¥µô£»
È¥µôC¡úA£¬µÃµ½F3 = { B¡úA, B¡úC, D¡úA, D¡úC }
C+F3 = C£¬²»°üº¬A£¬Òò´ËC¡úA²»ÊǶàÓຯÊýÒÀÀµ£»
È¥µôB¡úA£¬µÃµ½F4 = { C¡úA, B¡úC, D¡úA, D¡úC }
B+F4 = BCA£¬°üº¬A£¬Òò´ËB¡úAÊǶàÓຯÊýÒÀÀµ£¬Ó¦È¥µô£»
È¥µôB¡úC£¬µÃµ½F5 = { C¡úA, D¡úA, D¡úC }
B+F5 = B£¬²»°üº¬C£¬Òò´ËB¡úC²»ÊǶàÓຯÊýÒÀÀµ£»
È¥µôD¡úA£¬µÃµ½F6 = { C¡úA, B¡úC, D¡úC }
D+F5 = DCA£¬²»°üº¬A£¬Òò´ËD¡úAÊǶàÓຯÊýÒÀÀµ£¬Ó¦È¥µô£»
È¥µôD¡úC£¬µÃµ½F7 = { C¡úA, B¡úC }
D+F5 = D£¬²»°üº¬C£¬Òò´ËD¡úC²»ÊǶàÓຯÊýÒÀÀµ¡£
ËÄ£® Éè¼ÆÌâ
1£® ÉèÓйØÏµÄ£Ê½£ºÑ§ÉúÐ޿Σ¨Ñ§ºÅ£¬ÐÕÃû£¬ËùÔÚϵ£¬ÐԱ𣬿γ̺ţ¬¿Î³ÌÃû£¬Ñ§·Ö£¬³É¼¨£©¡£ÉèÒ»¸öѧÉú¿ÉÒÔÑ¡¶à
Ãſγ̣¬Ò»Ãſγ̿ÉÒÔ±»¶àÃûѧÉúÑ¡¡£Ò»¸öѧÉúÓÐΨһµÄËùÔÚϵ£¬Ã¿ÃſγÌÓÐΨһµÄ¿Î³ÌÃûºÍѧ·Ö¡£Ã¿¸öѧÉú¶ÔÿÃſγÌÓÐΨһµÄ³É¼¨¡£ £¨1£© ÇëÖ¸³ö´Ë¹ØÏµÄ£Ê½µÄºòÑ¡Âë¡£ £¨2£© д³ö¸Ã¹ØÏµÄ£Ê½µÄ¼«Ð¡º¯ÊýÒÀÀµ¼¯¡£ £¨3£© ¸Ã¹ØÏµÄ£Ê½ÊôÓÚµÚ¼¸·¶Ê½£¿²¢¼òµ¥ËµÃ÷ÀíÓÉ¡£
£¨4£© Èô²»ÊǵÚÈý·¶Ê½µÄ£¬Ç뽫Æä¹æ·¶»¯ÎªµÚÈý·¶Ê½¹ØÏµÄ£Ê½£¬²¢Ö¸³ö·Ö½âºóµÄÿ¸ö¹ØÏµÄ£Ê½µÄÖ÷ÂëºÍÍâÂë¡£ ´ð£º£¨1£©ºòÑ¡Â룺£¨Ñ§ºÅ£¬¿Î³ÌºÅ£©
£¨2£©Ñ§ºÅ¡úÐÕÃû£¬Ñ§ºÅ¡úËùÔÚϵ£¬Ñ§ºÅ¡úÐԱ𣬿γ̺šú¿Î³ÌÃû£¬¿Î³ÌºÅ¡úѧ·Ö£¬ £¨Ñ§ºÅ£¬¿Î³ÌºÅ£©¡ú³É¼¨
£¨3£©ÊôÓÚµÚ¶þ·¶Ê½£¬ÒòΪ´æÔÚ²¿·Öº¯ÊýÒÀÀµ£ºÑ§ºÅ¡úÐÕÃû¡£ £¨4£©µÚÈý·¶Ê½¹ØÏµÄ£Ê½£º
ѧÉú£¨Ñ§ºÅ£¬ÐÕÃû£¬ËùÔÚϵ£¬ÐԱ𣩠¿Î³Ì£¨¿Î³ÌºÅ£¬¿Î³ÌÃû£¬Ñ§·Ö£©
24
×îÖÕFmin =£ûC¡úA, B¡úC, D¡úC£ý
¿¼ÊÔ£¨Ñ§ºÅ£¬¿Î³ÌºÅ£¬³É¼¨£©£¬Ñ§ºÅΪÒýÓÃѧÉúµÄÍâÂ룬¿Î³ÌºÅΪÒýÓÿγ̵ÄÍâÂë¡£
¡¤25¡¤ 2£® ÉèÓйØÏµÄ£Ê½£ºÑ§Éú£¨Ñ§ºÅ£¬ÐÕÃû£¬ËùÔÚϵ£¬°àºÅ£¬°àÖ÷ÈΣ¬ÏµÖ÷ÈΣ©£¬ÆäÓïÒåΪ£ºÒ»¸öѧÉúÖ»ÔÚÒ»¸öϵµÄÒ»¸ö
°àѧϰ£¬Ò»¸öϵֻÓÐÒ»¸öϵÖ÷ÈΣ¬Ò»¸ö°àÖ»ÓÐÒ»Ãû°àÖ÷ÈΣ¬Ò»¸öϵ¿ÉÒÔÓжà¸ö°à¡£ £¨1£© ÇëÖ¸³ö´Ë¹ØÏµÄ£Ê½µÄºòÑ¡Âë¡£ £¨2£© д³ö¸Ã¹ØÏµÄ£Ê½µÄ¼«Ð¡º¯ÊýÒÀÀµ¼¯¡£ £¨3£© ¸Ã¹ØÏµÄ£Ê½ÊôÓÚµÚ¼¸·¶Ê½£¿²¢¼òµ¥ËµÃ÷ÀíÓÉ¡£
£¨4£© Èô²»ÊǵÚÈý·¶Ê½µÄ£¬Ç뽫Æä¹æ·¶»¯ÎªµÚÈý·¶Ê½¹ØÏµÄ£Ê½£¬²¢Ö¸³ö·Ö½âºóµÄÿ¸ö¹ØÏµÄ£Ê½µÄÖ÷ÂëºÍÍâÂë¡£ ½â£º£¨1£©ºòÑ¡Â룺ѧºÅ
£¨2£©Ñ§ºÅ¡úÐÕÃû£¬Ñ§ºÅ¡úËùÔÚϵ£¬Ñ§ºÅ¡ú°àºÅ£¬°àºÅ¡ú°àÖ÷ÈΣ¬ËùÔÚϵ¡úϵÖ÷ÈÎ £¨3£©µÚ¶þ·¶Ê½£¬ÒòΪÓУºÑ§ºÅ¡ú°àºÅ£¬°àºÅ¡ú°àÖ÷ÈΣ¬Òò´Ë´æÔÚ´«µÝº¯ÊýÒÀÀµ£º
ѧºÅ
´«µÝ°àÖ÷ÈÎ
£¨4£©µÚÈý·¶Ê½¹ØÏµÄ£Ê½£º
ѧÉú£¨Ñ§ºÅ£¬ÐÕÃû£¬ËùÔÚϵ£¬°àºÅ£©£¬°àºÅΪÒýÓðàµÄÍâÂ룬ËùÔÚϵΪÒýÓÃϵµÄÍâÂë¡£ °à£¨°àºÅ£¬°àÖ÷ÈΣ© ϵ£¨ÏµÃû£¬ÏµÖ÷ÈΣ©
3£® ÉèÓйØÏµÄ£Ê½£º½ÌʦÊڿΣ¨¿Î³ÌºÅ£¬¿Î³ÌÃû£¬Ñ§·Ö£¬ÊڿνÌʦºÅ£¬½ÌʦÃû£¬ÊÚ¿ÎʱÊý£©£¬ÆäÓïÒåΪ£ºÒ»Ãſγ̣¨ÓÉ
¿Î³ÌºÅ¾ö¶¨£©ÓÐÈ·¶¨µÄ¿Î³ÌÃûºÍѧ·Ö£¬Ã¿Ãû½Ìʦ£¨ÓɽÌʦºÅ¾ö¶¨£©ÓÐÈ·¶¨µÄ½ÌʦÃû£¬Ã¿Ãſγ̿ÉÒÔÓɶàÃû½Ìʦ½²ÊÚ£¬Ã¿Ãû½ÌʦҲ¿ÉÒÔ½²ÊÚ¶àÃſγ̣¬Ã¿Ãû½Ìʦ¶ÔÿÃſγÌÓÐÈ·¶¨µÄÊÚ¿ÎʱÊý¡£ £¨1£© Ö¸³ö´Ë¹ØÏµÄ£Ê½µÄºòÑ¡Âë¡£ £¨2£© д³ö¸Ã¹ØÏµÄ£Ê½µÄ¼«Ð¡º¯ÊýÒÀÀµ¼¯¡£ £¨3£© ¸Ã¹ØÏµÄ£Ê½ÊôÓÚµÚ¼¸·¶Ê½£¿²¢¼òµ¥ËµÃ÷ÀíÓÉ
£¨4£© Èô²»ÊôÓÚµÚÈý·¶Ê½£¬Ç뽫Æä¹æ·¶»¯ÎªµÚÈý·¶Ê½¹ØÏµÄ£Ê½£¬²¢Ö¸³ö·Ö½âºóµÄÿ¸ö¹ØÏµÄ£Ê½µÄÖ÷ÂëºÍÍâÂë¡£ ´ð£º£¨1£©ºòÑ¡Â룺£¨¿Î³ÌºÅ£¬ÊڿνÌʦºÅ£©
£¨2£©¿Î³ÌºÅ¡ú¿Î³ÌÃû£¬¿Î³ÌºÅ¡úѧ·Ö£¬ÊڿνÌʦºÅ¡ú½ÌʦÃû£¬£¨¿Î³ÌºÅ£¬ÊڿνÌʦºÅ£©¡úÊÚ¿ÎʱÊý £¨3£©ÊôÓÚµÚÒ»·¶Ê½¡£ÒòΪÓУº¿Î³ÌºÅ¡ú¿Î³ÌÃû£¬Òò´Ë´æÔÚ²¿·Öº¯ÊýÒÀÀµ¹ØÏµ£º
£¨¿Î³ÌºÅ£¬ÊڿνÌʦºÅ£©£¨4£©µÚÈý·¶Ê½¹ØÏµÄ£Ê½£º
¿Î³Ì£¨¿Î³ÌºÅ£¬¿Î³ÌÃû£¬Ñ§·Ö£© ½Ìʦ£¨½ÌʦºÅ£¬½ÌʦÃû£©
ÊڿΣ¨¿Î³ÌºÅ£¬½ÌʦºÅ£¬ÊÚ¿ÎʱÊý£©£¬¿Î³ÌºÅΪÒýÓÿγ̵ÄÍâÂ룬½ÌʦºÅΪÒýÓýÌʦµÄÍâÂë¡£
P¿Î³ÌÃû
25
¡¤26¡¤ µÚ7Õ Êý¾Ý¿âÉè¼Æ Ò»£® Ñ¡ÔñÌâ
1£® ÔÚÊý¾Ý¿âÉè¼ÆÖУ¬½«E-Rͼת»»Îª¹ØÏµÊý¾ÝÄ£ÐÍÊÇÏÂÊöÄĸö½×¶ÎÍê³ÉµÄ¹¤×÷ A£®ÐèÇó·ÖÎö½×¶Î C£®Âß¼Éè¼Æ½×¶Î
B£®¸ÅÄîÉè¼Æ½×¶Î D£®ÎïÀíÉè¼Æ½×¶Î
D
C
2£®ÔÚ½øÐÐÊý¾Ý¿âÂß¼½á¹¹Éè¼ÆÊ±£¬²»ÊôÓÚÂß¼Éè¼ÆÓ¦×ñÊØµÄÔÔòµÄÊÇ A£®¾¡¿ÉÄܱÜÃâ²åÈëÒì³£ C£®¾¡¿ÉÄܱÜÃâÊý¾ÝÈßÓà
B£®¾¡¿ÉÄܱÜÃâɾ³ýÒì³£ D£®¾¡¿ÉÄܱÜÃâ¶à±íÁ¬½Ó²Ù×÷
A
3. ÔÚ½øÐÐÊý¾Ý¿âÂß¼½á¹¹Éè¼ÆÊ±£¬ÅжÏÉè¼ÆÊÇ·ñºÏÀíµÄ³£ÓÃÒÀ¾ÝÊÇ A£®¹æ·¶»¯ÀíÂÛ C£®Êý¾Ý×Öµä
B£®¸ÅÄîÊý¾ÝÄ£ÐÍ D£®Êý¾ÝÁ÷ͼ
4£®ÔÚ½«E-Rͼת»»Îª¹ØÏµÄ£ÐÍʱ£¬Ò»°ã¶¼½«m:nÁªÏµ×ª»»³ÉÒ»¸ö¶ÀÁ¢µÄ¹ØÏµÄ£Ê½¡£ÏÂÁйØÓÚÕâÖÖÁªÏµ²úÉúµÄ¹ØÏµÄ£Ê½µÄÖ÷ÂëµÄ˵·¨£¬ÕýÈ·µÄÊÇ
C
A£®Ö»Ðè°üº¬m¶Ë¹ØÏµÄ£Ê½µÄÖ÷Âë¼´¿É B£®Ö»Ðè°üº¬n¶Ë¹ØÏµÄ£Ê½µÄÖ÷Âë¼´¿É C£®ÖÁÉÙ°üº¬m¶ËºÍn¶Ë¹ØÏµÄ£Ê½µÄÖ÷Âë D£®±ØÐëÌí¼ÓеÄÊôÐÔ×÷ΪÖ÷Âë
5. Êý¾ÝÁ÷ͼÊÇ´Ó¡°Êý¾Ý¡±ºÍ¡°´¦Àí¡±Á½·½Ãæ±í´ïÊý¾Ý´¦ÀíµÄÒ»ÖÖͼÐλ¯±íʾ·½·¨£¬¸Ã·½·¨Ö÷ÒªÓÃÔÚÊý¾Ý¿âÉè¼ÆµÄ
A
A£®ÐèÇó·ÖÎö½×¶Î C£®Âß¼½á¹¹Éè¼Æ½×¶Î
B£®¸ÅÄî½á¹¹Éè¼Æ½×¶Î D£®ÎïÀí½á¹¹Éè¼Æ½×¶Î
B
6. ÔÚ½«¾Ö²¿E-RͼºÏ²¢ÎªÈ«¾ÖE-Rͼʱ£¬¿ÉÄÜ»á²úÉúһЩ³åÍ»¡£ÏÂÁгåÍ»Öв»ÊôÓںϲ¢E-Rͼ³åÍ»µÄÊÇ A£®½á¹¹³åÍ» C£®ÊôÐÔ³åÍ»
B£®Óï·¨³åÍ» D£®ÃüÃû³åÍ»
7. Ò»¸öÒøÐÐÓªÒµËù¿ÉÒÔÓжà¸ö¿Í»§£¬Ò»¸ö¿Í»§Ò²¿ÉÒÔÔÚ¶à¸öÓªÒµËù½øÐдæÈ¡¿îÒµÎñ£¬Ôò¿Í»§ºÍÒøÐÐÓªÒµËùÖ®¼äµÄÁªÏµÊÇ
D
B£®Ò»¶Ô¶à D£®¶à¶Ô¶à
B
A£®Ò»¶ÔÒ» C£®¶à¶ÔÒ»
8£®ÔÚ¹ØÏµÊý¾Ý¿âÖУ¬¶þά±í½á¹¹ÊÇ A£®¹ØÏµÊý¾Ý¿â²ÉÓõĸÅÄî²ãÊý¾ÝÄ£ÐÍ B. ¹ØÏµÊý¾Ý¿â²ÉÓõÄ×éÖ¯²ãÊý¾ÝÄ£ÐÍ C£®Êý¾Ý¿âÎļþµÄ×éÖ¯·½Ê½ D£®ÄÚģʽ²ÉÓõÄÊý¾Ý×éÖ¯·½Ê½
9£®ÉèʵÌåAÓëʵÌåBÖ®¼äÊÇÒ»¶Ô¶àÁªÏµ¡£ÏÂÁнøÐеÄÂß¼½á¹¹Éè¼Æ·½·¨ÖУ¬×îºÏÀíµÄÊÇ A£®ÊµÌåAºÍʵÌåB·Ö±ð¶ÔÓ¦Ò»¸ö¹ØÏµÄ£Ê½£¬ÇÒÍâÂë·ÅÔÚʵÌåBµÄ¹ØÏµÄ£Ê½ÖÐ B. ʵÌåAºÍʵÌåB·Ö±ð¶ÔÓ¦Ò»¸ö¹ØÏµÄ£Ê½£¬ÇÒÍâÂë·ÅÔÚʵÌåAµÄ¹ØÏµÄ£Ê½ÖÐ C£®ÎªÊµÌåAºÍʵÌåBÉè¼ÆÒ»¸ö¹ØÏµÄ£Ê½£¬¸Ã¹ØÏµÄ£Ê½°üº¬Á½¸öʵÌåµÄÈ«²¿ÊôÐÔ
D£®·Ö±ðΪʵÌåA¡¢ÊµÌåBºÍËüÃÇÖ®¼äµÄÁªÏµÉè¼ÆÒ»¸ö¹ØÏµÄ£Ê½£¬ÍâÂëÔÚÁªÏµ¶ÔÓ¦µÄ¹ØÏµÄ£Ê½ÖÐ
A
26
¡¤27¡¤ 10. ÉèÓÐÃèÊöͼÊé³ö°æÇé¿öµÄ¹ØÏµÄ£Ê½£º³ö°æ£¨ÊéºÅ£¬³ö°æÈÕÆÚ£¬Ó¡Ë¢ÊýÁ¿£©£¬ÉèÒ»±¾Êé¿ÉÒÔ±»³ö°æ¶à´Î£¬Ã¿´Î³ö°æ¶¼ÓÐÒ»¸ö³ö°æÊýÁ¿¡£¸Ã¹ØÏµÄ£Ê½µÄÖ÷ÂëÊÇ A£®ÊéºÅ
C£®£¨ÊéºÅ£¬Ó¡Ë¢ÊýÁ¿£©
B
B£®£¨ÊéºÅ£¬³ö°æÈÕÆÚ£©
D£®£¨ÊéºÅ£¬³ö°æÈÕÆÚ£¬Ó¡Ë¢ÊýÁ¿£©
11. ÉèÓÐÃèÊöѧÉú½èÊéÇé¿öµÄ¹ØÏµÄ£Ê½£º½èÊ飨ÊéºÅ£¬¶ÁÕߺţ¬½èÊéÈÕÆÚ£¬»¹ÊéÈÕÆÚ£©£¬ÉèÒ»¸ö¶ÁÕß¿ÉÔÚ²»Í¬ÈÕÆÚ¶à´Î½èÔÄͬһ±¾Ê飬µ«²»ÄÜÔÚͬһÌì¶Ôͬһ±¾Êé½èÔĶà´Î¡£¸Ã¹ØÏµÄ£Ê½µÄÖ÷ÂëÊÇ C A£®ÊéºÅ
C£®£¨ÊéºÅ£¬¶ÁÕߺţ¬½èÊéÈÕÆÚ£© 12. ÉèÓÐÈçÏÂÁ½¸ö¹ØÏµÄ£Ê½
Ö°¹¤£¨Ö°¹¤ºÅ£¬ÐÕÃû£¬ËùÔÚ²¿ÃűàºÅ£©
²¿ÃÅ£¨²¿ÃűàºÅ£¬²¿ÃÅÃû³Æ£¬ÁªÏµµç»°£¬°ì¹«µØµã£©
Ϊ±í´ïÖ°¹¤Ó벿ÃÅÖ®¼äµÄ¹ØÁª¹ØÏµ£¬Ð趨ÒåÍâÂë¡£ÏÂÁйØÓÚÕâÁ½¸ö¹ØÏµÄ£Ê½ÖÐÍâÂëµÄ˵·¨£¬ÕýÈ·µÄÊÇ A£®¡°Ö°¹¤¡±¹ØÏµÄ£Ê½Öеġ°ËùÔÚ²¿ÃűàºÅ¡±ÊÇÒýÓá°²¿ÃÅ¡±µÄÍâÂë B£®²¿ÃŹØÏµÄ£Ê½Öеġ°²¿ÃűàºÅ¡±ÊÇÒýÓá°Ö°¹¤¡±µÄÍâÂë C£®²»Äܶ¨ÒåÍâÂ룬ÒòΪÁ½¸ö¹ØÏµÄ£Ê½ÖÐûÓÐͬÃûÊôÐÔ
D£®½«¡°Ö°¹¤¡±¹ØÏµÄ£Ê½Öеġ°ËùÔÚ²¿ÃűàºÅ¡±¶¨ÒåΪÍâÂ룬»òÕß½«¡°²¿ÃÅ¡±¹ØÏµÄ£Ê½Öеġ°²¿ÃűàºÅ¡±¶¨ÒåΪ
ÍâÂë¾ù¿É
13. ÔÚÊý¾Ý¿âÉè¼ÆÖУ¬½øÐÐÓû§×ÓģʽÉè¼ÆÊÇÏÂÊöÄĸö½×¶ÎÒªÍê³ÉµÄ¹¤×÷ B A£®ÐèÇó·ÖÎö½×¶Î C£®Âß¼½á¹¹Éè¼Æ½×¶Î
14.ÏÂÊö²»ÊôÓÚÊý¾Ý¿âÎïÀí½á¹¹Éè¼ÆÄÚÈݵÄÊÇ A£®È·¶¨Êý¾ÝµÄ´æ´¢½á¹¹ C£®È·¶¨Êý¾ÝµÄ´æ´¢·ÖÅä
B£®¸ÅÄî½á¹¹Éè¼Æ½×¶Î D£®ÎïÀí½á¹¹Éè¼Æ½×¶Î C
B£®È·¶¨Êý¾Ý´æ´¢Î»Öà D£®È·¶¨Êý¾Ý¿â±í½á¹¹
A
B£®£¨ÊéºÅ£¬¶ÁÕߺţ©
D£®£¨ÊéºÅ£¬¶ÁÕߺţ¬½èÊéÈÕÆÚ£¬»¹ÊéÈÕÆÚ£©
15£®Êý¾Ý¿âÎïÀí½á¹¹Éè¼ÆÍê³Éºó¾Í½øÈëµ½Êý¾Ý¿âʵʩ½×¶Î¡£ÏÂÁв»ÊôÓÚÊý¾Ý¿âʵʩ½×¶Î¹¤×÷µÄ D A£®µ÷ÊÔÓ¦ÓóÌÐò C£®¼ÓÔØÊý¾Ý ¶þ£® Ìî¿ÕÌâ
1£® Ò»°ã½«Êý¾Ý¿âÉè¼Æ·ÖΪ______¡¢______¡¢______¡¢______¡¢______¼¸¸ö½×¶Î¡£
ÐèÇó·ÖÎö ½á¹¹Éè¼Æ ÐÐΪÉè¼Æ Êý¾Ý¿âʵʩ Êý¾Ý¿âÔËÐкÍά»¤ 2£® Êý¾Ý¿â½á¹¹Éè¼Æ°üÀ¨______¡¢______ºÍ______Èý¸ö¹ý³Ì¡£
¸ÅÄî½á¹¹Éè¼Æ Âß¼½á¹¹Éè¼Æ ÎïÀí½á¹¹Éè¼Æ
3£® ½«¾Ö²¿E-RͼºÏ²¢ÎªÈ«¾ÖE-Rͼʱ£¬¿ÉÄÜÓöµ½µÄ³åÍ»ÓÐ______¡¢______ºÍ______¡£
ÊôÐÔ³åÍ» ÃüÃû³åÍ» ½á¹¹³åÍ»
4£® ÔÚÊý¾Ý¿âʵʩ½×¶Î³ýÁË´´½¨Êý¾Ý¿â¡¢¹ØÏµ±íµÈÖ®Í⣬»¹°üÀ¨Á½ÏîÖØÒªµÄ¹¤×÷£¬Ò»ÏîÊÇ______£¬ÁíÒ»ÏîÊÇ______¡£
¼ÓÔØÊý¾Ý µ÷ÊÔºÍÔËÐÐÓ¦ÓóÌÐò
5£® ______Éè¼ÆÊǽ«ÐèÇó·ÖÎöµÃµ½µÄÓû§ÐèÇó½øÐиÅÀ¨ºÍ³éÏ󣬵õ½¸ÅÄî²ãÊý¾ÝÄ£ÐÍ¡£
¸ÅÄ½á¹¹£©
6£® ½«E-Rͼת»»ÎªÄ³¸öÊý¾Ý¿â¹ÜÀíϵͳ֧³ÖµÄ×éÖ¯²ãÊý¾ÝÄ£ÐÍÊÇ______Éè¼Æ½×¶ÎÍê³ÉµÄ¹¤×÷¡£
Âß¼£¨½á¹¹£©
7£® Êý¾ÝÁ÷ͼ±í´ïÁËÊý¾Ý¿âÓ¦ÓÃϵͳÖÐ______ºÍ______µÄ¹ØÏµ¡£ Êý¾Ý ´¦Àí
8£® ÔÚÊý¾Ý¿âÉè¼ÆÖУ¬ÔÚÐèÇó·ÖÎö½×¶ÎÓÃÎĵµÀ´ÃèÊöÊý¾ÝÐèÇ󣬰üÀ¨¶ÔÊý¾ÝÏî¡¢Êý¾Ý½á¹¹¡¢Êý¾ÝÁ÷¡¢Êý¾Ý´æ´¢ºÍÊý
27
B£®ÊÔÔËÐÐÓ¦ÓóÌÐò D£®À©³äϵͳ¹¦ÄÜ
¡¤28¡¤ ¾Ý´¦Àí¹ý³ÌµÄÃèÊö£¬Í¨³£½«Õâ¸öÎĵµ³ÆÎª______¡£ Êý¾Ý×Öµä
9£® ²ÉÓÃE-R·½·¨µÄ¸ÅÄî½á¹¹Éè¼ÆÍ¨³£°üÀ¨______¡¢______ºÍ______Èý¸ö²½Öè¡£
Éè¼Æ¾Ö²¿E-Rͼ£¬Éè¼ÆÈ«¾ÖE-Rͼ ÓÅ»¯È«¾ÖE-Rͼ
10£® ¸ù¾ÝÓ¦ÓÃÒªÇóÈ·¶¨ÔÚÄÄЩ±íµÄÄĸö»òÄÄЩÊôÐÔÉϽ¨Á¢Ë÷ÒýµÄ¹¤×÷ÊÇÔÚÊý¾Ý¿âÉè¼ÆµÄ______½×¶ÎÍê³ÉµÄ¡£ Îï
ÀíÉè¼Æ
Èý£® ¼ò´ðÌâ
1£®Êý¾Ý¿âÉè¼Æ·ÖΪÄö½×¶Î£¿Ã¿¸ö½×¶ÎµÄÖ÷Òª¹¤×÷ÊÇʲô¡£ 2£®ÐèÇó·ÖÎö½×¶ÎµÄÈÎÎñÊÇʲô£¿ÆäÖз¢ÏÖÊÂʵµÄ·½·¨ÓÐÄÄЩ£¿ 3£®¸ÅÄî½á¹¹Ó¦¸Ã¾ßÓÐÄÄÐ©ÌØµã£¿ 4£®¸ÅÄî½á¹¹Éè¼ÆµÄ²ßÂÔÓÐÄÄЩ£¿
5£®Ê²Ã´ÊÇÊý¾Ý¿âµÄÂß¼½á¹¹Éè¼Æ£¿¼òÊöÆäÉè¼Æ²½Öè¡£ 6£®°ÑE-RÄ£ÐÍת»»Îª¹ØÏµÄ£Ê½µÄת»»¹æÔòÓÐÄÄЩ£¿ 7£®Êý¾ÝÄ£Ð͵ÄÓÅ»¯°üº¬ÄÄЩ·½·¨£¿
8£®¼òÊöÊý¾Ý¿âÎïÀí½á¹¹Éè¼Æ½×¶ÎµÄÖ÷Òª¹¤×÷¡£ 9. ¼òÊöÊý¾Ý¿âʵʩ½×¶ÎµÄÖ÷Òª¹¤×÷¡£ 10.¼òÊöÊý¾Ý¿âÐÐΪÉè¼Æ°üº¬µÄÄÚÈÝ¡£ ËÄ£® Éè¼ÆÌâ
1£® ½«¸ø¶¨µÄE-Rͼת»»Îª·ûºÏ3NFµÄ¹ØÏµÄ£Ê½£¬²¢Ö¸³öÿ¸ö¹ØÏµÄ£Ê½µÄÖ÷ÂëºÍÍâÂë¡£ £¨1£©Í¼7-25ËùʾΪÃèÊöͼÊé¡¢¶ÁÕßÒÔ¼°¶ÁÕß½èÔÄͼÊéµÄE-Rͼ¡£
³ö°æÈÕÆÚͼÊé×÷ÕßÃû½èÊéÈÕÆÚÁªÏµµç»°ËùÔÚµ¥Î»Í¼7-25 ͼÊé½èÔÄE-Rͼ
´ð£ºÏÂÁи÷¹ØÏµÄ£Ê½ÖÐÓÃÏ»®Ïß±êʶÖ÷Âë¡£
ͼÊ飨ÊéºÅ£¬ÊéÃû£¬³ö°æÈÕÆÚ£¬×÷ÕßÃû£© ¶ÁÕߣ¨¶ÁÕߺţ¬¶ÁÕßÃû£¬ÁªÏµµç»°£¬ËùÔÚµ¥Î»£©
ÊéºÅm½èÔÄn¶ÁÕß¶ÁÕßÃû ÊéÃû»¹ÊéÈÕÆÚ¶ÁÕߺŽèÔÄ£¨ÊéºÅ£¬¶ÁÕߺţ¬½èÊéÈÕÆÚ£¬»¹ÊéÈÕÆÚ£©£¬ÊéºÅΪÒýÓÃͼÊé¹ØÏµÄ£Ê½µÄÍâÂ룬¶ÁÕߺÅΪÒýÓöÁÕß¹ØÏµÄ£Ê½µÄÍâÂë¡£
£¨2£©Í¼7-26ËùʾΪÃèÊöÉ̵ê´ÓÉú²ú³§¼Ò¶©¹ºÉÌÆ·µÄE-Rͼ¡£ ´ð£ºÏÂÁи÷¹ØÏµÄ£Ê½ÖÐÓÃÏ»®Ïß±êʶÖ÷Âë¡£
É̵꣨É̵ê±àºÅ£¬É̵êÃû£¬ÁªÏµµç»°£©¡Ê3NF
ÉÌÆ·£¨ÉÌÆ·±àºÅ£¬ÉÌÆ·Ãû³Æ£¬¿â´æÁ¿£¬ÉÌÆ··ÖÀࣩ¡Ê3NF ³§¼Ò£¨³§¼Ò±àºÅ£¬ÁªÏµµØÖ·£¬ÁªÏµµç»°£©¡Ê3NF
¶©¹º£¨É̵ê±àºÅ£¬³§¼Ò±àºÅ£¬ÉÌÆ·±àºÅ£¬¶©¹ºÈÕÆÚ£¬¶©¹ºÊýÁ¿£©£¬É̵ê±àºÅΪÒýÓÃÉÌµê¹ØÏµÄ£Ê½µÄÍâÂ룬³§¼Ò±àºÅΪÒýÓó§¼Ò¹ØÏµÄ£Ê½µÄÍâÂ룬ÉÌÆ·±àºÅΪÒýÓÃÉÌÆ·¹ØÏµÄ£Ê½µÄÍâÂë¡£¡Ê3NF
28
¡¤29¡¤ É̵ê±àºÅÁªÏµµç»°É̵êm¶©¹ºÈÕÆÚ¶©¹º¶©¹ºÊýÁ¿n¿â´æÁ¿ÉÌÆ··ÖÀàÉÌÆ·ÉÌÆ·±àºÅÉÌÆ·Ãû³Æ
ͼ7-26 ÉÌÆ·¶©¹ºE-Rͼ
£¨3£©Í¼7-27ΪÃèÊöѧÉú²Î¼ÓѧУÉçÍŵÄE-Rͼ¡£
É̵êÃû³§¼Ò±àºÅp³§¼ÒÁªÏµµØÖ·ÁªÏµµç»°ÐÔ±ðѧÉúרҵm²Î¼Óµç»°ÐÔÖÊ1ÉçÍÅѧºÅÐÕÃû²Î¼ÓÈÕÆÚÉçÍźÅÉçÍÅÃû
ͼ7-27 ѧÉú²Î¼ÓÉçÍÅE-Rͼ
´ð£ºÏÂÁи÷¹ØÏµÄ£Ê½ÖÐÓÃÏ»®Ïß±êʶÖ÷Âë¡£
ÉçÍÅ£¨ÉçÍźţ¬ÉçÍÅÃû£¬µç»°£¬ÐÔÖÊ£©¡Ê3NF
ѧÉú£¨Ñ§ºÅ£¬ÐÕÃû£¬ÐÔ±ð£¬×¨Òµ£¬ÉçÍźţ¬²Î¼ÓÈÕÆÚ£©£¬ÉçÍźÅΪÒýÓÃÉçÍŵÄÍâÂë¡£¡Ê3NF
³É£¬²»Í¬µÄÁã¼þËùÓõÄÔ²ÄÁÏ¿ÉÒÔÏàͬ¡£Áã¼þ°´ËùÊô²úÆ·µÄ²»Í¬±»·Ö±ð´æ·ÅÔÚ²»Í¬µÄ²Ö¿âÖУ¬Ò»¸ö²Ö¿â¿ÉÒÔ´æ·Å¶àÖÖ²»Í¬µÄÁã¼þ¡£Ô²ÄÁϰ´Àà±ð´æ·ÅÔÚÈô¸É²Ö¿âÖУ¬Ò»¸ö²Ö¿âÒ²¿ÉÒÔ´æ·Å²»Í¬Àà±ðµÄ²ÄÁÏ¡£»³ö¸Ã¹¤³§µÄE-Rͼ£¨×¢£ºÖ»»³öʵÌåºÍÁªÏµ¼´¿É£¬²»ÓñêʶÊôÐÔ£©¡£
´ð£º¢Ù È·¶¨ÊµÌå¡£±¾ÏµÍ³¹²ÓÐËĸöʵÌ壺²úÆ·¡¢Áã¼þ¡¢²ÄÁÏ¡¢²Ö¿â¡£ ÒòΪֻÃèÊöµÄÊÇÒ»¸ö¹¤³§µÄÇé¿ö£¬Òò´Ë²»ÐèÒª½«¹¤³§ÉèΪʵÌå¡£
¢Ú È·¶¨ÊµÌå¼äµÄÁªÏµ¡£ ? ? ? ?
²úÆ·ÓëÁã¼þ£º¶à¶Ô¶àÁªÏµ£¬¿É½«ÁªÏµÃüÃûΪ¡°×é³É¡±¡£ Áã¼þÓë²ÄÁÏ£º¶à¶Ô¶àÁªÏµ£¬¿É½«ÁªÏµÃüÃûΪ¡°ÖƳɡ±¡£ Áã¼þÓë²Ö¿â£º¶à¶Ô¶àÁªÏµ£¬¿É½«ÁªÏµÃüÃûΪ¡°´æ·Å¡±¡£ ²ÄÁÏÓë²Ö¿â£º¶à¶Ô¶àÁªÏµ£¬¿É½«ÁªÏµÃüÃûΪ¡°´æ·Å¡±¡£
2£® Éèij¹¤³§Éú²úÈô¸É²úÆ·£¬Ã¿ÖÖ²úÆ·ÓÉÈô¸ÉÁã¼þ×é³É£¬Í¬Ò»ÖÖÁã¼þ¿ÉÓÃÔÚ²»Í¬µÄ²úÆ·ÉÏ¡£Áã¼þÓɲ»Í¬µÄÔ²ÄÁÏÖÆ
¢Û »æÖÆE-Rͼ
29
¡¤30¡¤ ²ÄÁÏmmÖÆ³Énm´æ·ÅÁã¼þm×é³Én²úÆ·´æ·Ån²Ö¿ân
3£® ÉèÒª½¨Á¢ÃèÊö¹Ë¿ÍÔÚÉ̵êµÄ¹ºÎïÇé¿öµÄÊý¾Ý¿âÓ¦ÓÃϵͳ£¬¸ÃϵͳÓÐÈçÏÂÒªÇó£ºÒ»¸öÉ̵ê¿ÉÓжàÃû¹Ë¿Í¹ºÎһ
¸ö¹Ë¿Í¿Éµ½¶à¸öÉ̵깺Î¹Ë¿Íÿ´Î¹ºÎïÓÐÒ»¸ö¹ºÎï½ð¶îºÍ¹ºÎïÈÕÆÚ¡£¹æ¶¨Ã¿¸ö¹Ë¿ÍÿÌìÔÚÿ¸öÉ̵ê×î¶àÓÐÒ»´Î¹ºÎÿ´Î¹ºÎï¿É¹ºÂò¶àÖÖÉÌÆ·¡£ÐèÒªÃèÊöµÄ¡°É̵ꡱÐÅÏ¢°üÀ¨£ºÉ̵ê±àºÅ¡¢É̵êÃû¡¢µØÖ·¡¢ÁªÏµµç»°£»ÐèÒªÃèÊöµÄ¹Ë¿ÍÐÅÏ¢°üÀ¨£º¹Ë¿ÍºÅ¡¢ÐÕÃû¡¢×¡Ö·¡¢Éí·ÝÖ¤ºÅ¡¢ÐÔ±ð¡£
Ç뻳öÃèÊö¸ÃÓ¦ÓÃϵͳµÄE-Rͼ£¬²¢×¢Ã÷¸÷ʵÌåµÄÊôÐÔ¡¢±êʶÊôÐÔÒÔ¼°ÁªÏµµÄÖÖÀà¡£ ´ð£º
¹Ë¿ÍºÅÐÔ±ðÐÕÃûm¹ºÎïÈÕÆÚnÉ̵ê±àºÅÉ̵êÃûÉÌµêµØÖ·¹Ë¿ÍסַÉí·ÝÖ¤ºÅ¹ºÎﹺÎï½ð¶îÁªÏµµç»° 4£® ͼ7-28£¨a£©~£¨d£©ËùʾΪijÆóÒµÐÅÏ¢¹ÜÀíϵͳÖеľֲ¿E-Rͼ£¬Ç뽫ÕâЩ¾Ö²¿E-RͼºÏ²¢ÎªÒ»¸öÈ«¾ÖE-Rͼ£¬
²¢Ö¸Ã÷¸÷ʵÌåÒÔ¼°ÁªÏµµÄÊôÐÔ£¬±êÃ÷ÁªÏµµÄÖÖÀࣨע£ºÎªÊ¹Í¼Ðμò½àÃ÷ÁË£¬ÔÚÈ«¾ÖE-RͼÖпÉÖ»»³öʵÌåºÍÁªÏµ£¬ÊôÐÔµ¥¶ÀÓÃÎÄ×ÖÃèÊö£©¡£½«ºÏ²¢ºóµÄE-Rͼת»»Îª·ûºÏ3NFÒªÇóµÄ¹ØÏµÄ£Ê½£¬²¢ËµÃ÷Ö÷ÂëºÍÍâÂë¡£
Ö°ÎñÖ°¹¤ÐÔ±ðmÊôÓÚÁªÏµµç»°°ì¹«µØµã1²¿ÃÅÖ°¹¤±àºÅÐÕÃûµç»°³§É̵ØÖ·mÉú²ú³§É̺ų§ÉÌÃûÉú²úÈÕÆÚÁã¼þºÅÁã¼þÃû²¿ÃźŲ¿ÃÅÃû¹æ¸ñ¼Û¸ñnÁã¼þ £¨b£© £¨a£© 30
¡¤31¡¤ µ¥Î»ºÅµç»°°ì¹«µØµãÉ豸´¦1ÓµÓÐÐÔ±ðÄêÁäm¹¤ÈËÐÕÃû £¨c£©
1¹ÜÀímÉ豸É豸ºÅÃû³Æ¹æ¸ñ¹¤È˱àºÅ¹æ¸ñÉ豸¼Û¸ñm×°Å乿¸ñ¼Û¸ñ£¨d£©
ͼ7-28 ¸÷¾Ö²¿E-Rͼ
´ð£º·ÖÎö£º
É豸ºÅÉ豸ÃûÁã¼þÊýÁ¿Áã¼þºÅÁã¼þÃû nÁã¼þ¢Ù ¹¤ÈËʵÌå¿ÉÒÔÓëÖ°¹¤ÊµÌåºÏ²¢£¬½«¹¤È˵ÄÊôÐԺϲ¢µ½Ö°¹¤ÊµÌåÖУ¬²¢ÔÚÖ°¹¤ÊµÌåÖÐÔö¼Ó¡°Éí·Ý¡±ÊôÐÔ£¬À´
±êʶÊǹ¤ÈË»¹ÊÇÆäËûÖ°¹¤¡£
¢Ú É豸´¦¿ÉºÏ²¢µ½²¿ÃÅʵÌåÖУ¬ÒòÉ豸´¦Ò²ÊÇÒ»¸ö²¿ÃÅ¡£¿ÉÔÚʵÏÖʱÔö¼ÓÔ¼Êø£ºÖ»ÓÐÉ豸´¦²ÅÄܹÜÀíÉ豸¡£ ¢Û ºÏ²¢ºóµÄÉ豸ʵÌåÊôÐÔÊÇͼ£¨c£©ºÍ£¨d£©ÖÐÉ豸ÊôÐԵIJ¢¼¯¡£
ºÏ²¢ºóµÄ½á¹û£º
31
¡¤32¡¤ Ö°ÎñÐÔ±ðÄêÁäÖ°¹¤mÊôÓÚÁªÏµµç»°°ì¹«µØµã1²¿ÃÅ1¹ÜÀíÉ豸ºÅÉ豸Ãû¹æ¸ñ¼Û¸ñ
¹ØÏµÄ£Ê½£¨Ö÷ÂëÓÃÏ»®Ïß±êʶ£©
²¿ÃÅ£¨²¿Ãźţ¬²¿ÃÅÃû£¬ÁªÏµµç»°£¬°ì¹«µØµã£©
Ö°¹¤±àºÅÐÕÃûÉí·ÝµØÖ·²¿ÃźŲ¿ÃÅÃûµç»°³§É̺ų§ÉÌmÉú²únm×°ÅänÁã¼þ³§ÉÌÃûÉú²úÈÕÆÚÁã¼þºÅÁã¼þÃû¹æ¸ñmÉ豸Áã¼þÊýÁ¿¼Û¸ñ Ö°¹¤£¨Ö°¹¤±àºÅ£¬ÐÕÃû£¬Éí·Ý£¬Ö°Îñ£¬ÐÔ±ð£¬ÄêÁ䣬ËùÊô²¿Ãźţ©£¬ËùÊô²¿ÃźÅΪÒýÓò¿ÃŵÄÍâÂë É豸£¨É豸ºÅ£¬É豸Ãû£¬¹æ¸ñ£¬¼Û¸ñ£¬±»¹Ü²¿Ãźţ©£¬±»¹Ü²¿ÃźÅΪÒýÓò¿ÃŵÄÍâÂë Áã¼þ£¨Áã¼þºÅ£¬Áã¼þÃû£¬¹æ¸ñ£¬¼Û¸ñ£© ³§ÉÌ£¨³§É̺ţ¬³§ÉÌÃû£¬µØÖ·£¬µç»°£©
×°Å䣨É豸ºÅ£¬Áã¼þºÅ£¬Áã¼þÊýÁ¿£©£¬É豸ºÅΪÒýÓÃÉ豸µÄÍâÂ룬Áã¼þºÅΪÒýÓÃÁã¼þµÄÍâÂë Éú²ú£¨³§É̺ţ¬Áã¼þºÅ£¬Éú²úÈÕÆÚ£©»ò Éú²ú£¨³§É̺ţ¬Áã¼þºÅ£¬Éú²úÈÕÆÚ£©
32
µÚ8Õ ÊÂÎñÓë²¢·¢¿ØÖÆ Ò»£® Ñ¡ÔñÌâ
1£® Èç¹ûÊÂÎñT»ñµÃÁËÊý¾ÝÏîAÉϵÄÅÅËûËø£¬ÔòÆäËûÊÂÎñ¶ÔA D
A£®Ö»ÄܶÁ²»ÄÜд
B£®Ö»ÄÜд²»ÄܶÁ
C£®¿ÉÒÔдҲ¿ÉÒÔ¶Á
D£®²»ÄܶÁÒ²²»ÄÜд
¡¤33¡¤ 2£® ÉèÊÂÎñT1ºÍT2Ö´ÐÐÈçͼ8-15ËùʾµÄ²¢·¢²Ù×÷£¬ÕâÖÖ²¢·¢²Ù×÷´æÔÚµÄÎÊÌâÊÇ B
ʱ¼ä ¢Ù ¢Ú ÊÂÎñT1 ¶ÁA=100£¬B=10 ¶ÁA=100 A=A*2=200 д»ØA=200 ¢Û ¢Ü ¼ÆËãA+B ¶ÁA=100£¬B=10 ÑéÖ¤A+B ͼ8-15 ²¢·¢²Ù×÷
A£®¶ªÊ§ÐÞ¸Ä C£®¶ÁÔàÊý¾Ý
B£®²»ÄÜÖØ¸´¶Á D£®²úÉúÓÄÁéÊý¾Ý
C
ÊÂÎñT2 3£® ÏÂÁйØÓÚÊý¾Ý¿âËÀËøµÄ˵·¨£¬ÕýÈ·µÄÊÇ
A£®ËÀËøÊÇÊý¾Ý¿âÖв»¿ÉÅжϵÄÒ»ÖÖÏÖÏó
B£®ÔÚÊý¾Ý¿âÖзÀÖ¹ËÀËøµÄ·½·¨ÊǽûÖ¹¶à¸öÓû§Í¬Ê±²Ù×÷Êý¾Ý¿â C£®Ö»ÓÐÔÊÐí²¢·¢²Ù×÷ʱ£¬²ÅÓпÉÄܳöÏÖËÀËø D£®µ±Á½¸ö»ò¶à¸öÓû§¾ºÕùÏàͬ×ÊԴʱ¾Í»á²úÉúËÀËø 4£® ÏÂÁв»ÊôÓÚÊÂÎñÌØÕ÷µÄÊÇ
A£®ÍêÕûÐÔ C£®¸ôÀëÐÔ
A B£®Ò»ÖÂÐÔ D£®Ô×ÓÐÔ
A
5£® ÈôÊÂÎñT¶ÔÊý¾ÝÏîDÒѼÓÁËSËø£¬ÔòÆäËûÊÂÎñ¶ÔÊý¾ÝÏîD
A£®¿ÉÒÔ¼ÓSËø£¬µ«²»ÄܼÓXËø B£®¿ÉÒÔ¼ÓXËø£¬µ«²»ÄܼÓSËø C£®¿ÉÒÔ¼ÓSËø£¬Ò²¿ÉÒÔ¼ÓXËø D£®²»ÄܼÓÈκÎËø
6£® ÔÚÊý¾Ý¿â¹ÜÀíϵͳµÄÈý¼¶·âËøÐÒéÖУ¬¶þ¼¶·âËøÐÒéµÄ¼ÓËøÒªÇóÊÇ C
A£®¶Ô¶ÁÊý¾Ý²»¼ÓËø£¬¶ÔдÊý¾ÝÔÚÊÂÎñ¿ªÊ¼Ê±¼ÓXËø£¬ÊÂÎñÍê³ÉºóÊÍ·ÅXËø B£®¶ÁÊý¾Ýʱ¼ÓSËø£¬¶ÁÍê¼´ÊÍ·ÅSËø£»Ð´Êý¾Ýʱ¼ÓXËø£¬Ð´Íê¼´ÊÍ·ÅXËø
C£®¶ÁÊý¾Ýʱ¼ÓSËø£¬¶ÁÍê¼´ÊÍ·ÅSËø£»¶ÔдÊý¾ÝÊÇÔÚÊÂÎñ¿ªÊ¼Ê±¼ÓXËø£¬ÊÂÎñÍê³ÉºóÊÍ·ÅXËø D£®ÔÚÊÂÎñ¿ªÊ¼Ê±¼´¶ÔÒª¶Á¡¢Ð´µÄÊý¾Ý¼ÓËø£¬µÈÊÂÎñ½áÊøºóÔÙÊÍ·ÅÈ«²¿Ëø 7£® ÔÚÊý¾Ý¿â¹ÜÀíϵͳµÄÈý¼¶·âËøÐÒéÖУ¬Ò»¼¶·âËøÐÒéÄܹ»½â¾öµÄÎÊÌâÊÇ
A£®¶ªÊ§ÐÞ¸Ä C£®¶ÁÔàÊý¾Ý
B£®²»¿ÉÖØ¸´¶Á D£®ËÀËø
A
8£® ÈôϵͳÖдæÔÚ4¸öµÈ´ýÊÂÎñT0¡¢T1¡¢T2ºÍT3£¬ÆäÖÐT0ÕýµÈ´ý±»T1Ëø×¡µÄÊý¾ÝÏîA1£¬T1ÕýµÈ´ý±»T2Ëø×¡µÄÊý
33
¡¤34¡¤ ¾ÝÏîA2£¬T2ÕýµÈ´ý±»T3Ëø×¡µÄÊý¾ÝÏîA3£¬ B
A£®»îËø C£®·âËø
B£®ËÀËø D£®Õý³£
T3ÕýµÈ´ý±»T0Ëø×¡µÄÊý¾ÝÏîA0¡£Ôò´ËʱϵͳËù´¦µÄ״̬ÊÇ
9£® ÊÂÎñÒ»µ©Ìá½»£¬Æä¶ÔÊý¾Ý¿âÖÐÊý¾ÝµÄÐ޸ľÍÊÇÓÀ¾ÃµÄ£¬ÒÔºóµÄ²Ù×÷»ò¹ÊÕϲ»»á¶ÔÊÂÎñµÄ²Ù×÷½á¹û²úÉúÈκÎÓ°Ïì¡£
Õâ¸öÌØÐÔÊÇÊÂÎñµÄ A£®Ô×ÓÐÔ C£® ¸ôÀëÐÔ
D
B£®Ò»ÖÂÐÔ
D£®³Ö¾ÃÐÔ
10£® ÔÚ¶à¸öÊÂÎñ²¢·¢Ö´ÐÐʱ£¬Èç¹ûÊÂÎñT1¶ÔÊý¾ÝÏîAµÄÐ޸ĸ²¸ÇÁËÊÂÎñT2¶ÔÊý¾ÝÏîAµÄÐ޸ģ¬ÕâÖÖÏÖÏó³ÆÎª
A
A£®¶ªÊ§ÐÞ¸Ä C£®²»¿ÉÖØ¸´¶Á
B£®¶ÁÔàÊý¾Ý D£®Êý¾Ý²»Ò»ÖÂ
11£® ÔÚ¶à¸öÊÂÎñ²¢·¢Ö´ÐÐʱ£¬Èç¹û²¢·¢¿ØÖÆ´ëÊ©²»ºÃ£¬Ôò¿ÉÄÜ»áÔì³ÉÊÂÎñT1¶ÁÁËÊÂÎñT2µÄ¡°ÔࡱÊý¾Ý¡£ÕâÀïµÄ¡°Ôࡱ
Êý¾ÝÊÇÖ¸
D
B£®T1»Ø¹öºóµÄÊý¾Ý D£®T2»Ø¹öºóµÄÊý¾Ý
B
A£®T1»Ø¹öǰµÄÊý¾Ý C£®T2»Ø¹öǰµÄÊý¾Ý
12£® ÔÚÅжÏËÀËøµÄÊÂÎñµÈ´ýͼÖУ¬Èç¹ûµÈ´ýͼÖгöÏÖÁË»·Â·£¬Ôò˵Ã÷ϵͳ
A£®´æÔÚ»îËø C£®ÊÂÎñÖ´Ðгɹ¦
¶þ£® Ìî¿ÕÌâ
B£®´æÔÚËÀËø D£®ÊÂÎñÖ´ÐÐʧ°Ü
1£®Îª·ÀÖ¹²¢·¢²Ù×÷µÄÊÂÎñ²úÉúÏ໥¸ÉÇé¿ö£¬Êý¾Ý¿â¹ÜÀíϵͳ²ÉÓüÓËø»úÖÆÀ´±ÜÃâÕâÖÖÇé¿ö¡£ËøµÄÀàÐͰüÀ¨______ºÍ______¡£ ¹²ÏíËø£¨»òSËø£©
ÅÅËûËø£¨»òXËø£©
2£®Ò»¸öÊÂÎñ¿Éͨ¹ýÖ´ÐÐ______Óï¾äÀ´È¡ÏûÆäÒÑÍê³ÉµÄÊý¾ÝÐ޸IJÙ×÷¡£ ROLLBACK 3£®ÊÂÎñÓ¦¶ÔÒª¶ÁÈ¡µÄÊý¾Ý¼Ó______Ëø£¬¶ÔÒªÐ޸ĵÄÊý¾Ý¼Ó______Ëø¡£
¹²Ïí£¨»òS£© ÅÅËû£¨»òX£©
4£®ÒªÇóÊÂÎñÔÚ¶ÁÊý¾ÝÏî֮ǰ±ØÐëÏȶÔÊý¾ÝÏî¼ÓSËø£¬Ö±µ½ÊÂÎñ½áÊø²ÅÊͷŸÃËøµÄ·âËøÐÒéÊÇ______¼¶·âËøÐÒé¡£ Èý 5£®¼ÙÉèÓÐÁ½¸öÊÂÎñT1ºÍT2£¬ËüÃÇÒª¶ÁÈëͬһÊý¾Ý²¢½øÐÐÐ޸ģ¬Èç¹ûT2Ìá½»µÄ½á¹û¸²¸ÇÁËT1Ìá½»µÄ½á¹û£¬µ¼ÖÂT1Ð޸ĵĽá¹ûÎÞЧ¡£ÕâÖÖÏÖÏó³ÆÎª______¡£ ¶ªÊ§ÐÞ¸Ä 6£®ÔÚÊý¾Ý¿â»·¾³Ï£¬½øÐв¢·¢¿ØÖƵÄÖ÷Òª·½Ê½ÊÇ_____¡£ ¼ÓËø
7£®Èç¹û×ÜÊǽ«ÊÂÎñΪÁ½¸ö½×¶Î£¬Ò»¸öÊǼÓËøÆÚ£¬Ò»¸öÊǽâËøÆÚ£¬ÔÚ¼ÓËøÆÚ²»ÔÊÐí½âËø£¬ÔÚ½âËøÆÚ²»ÔÊÐí¼ÓËø£¬Ôò½«
¸Ã¹æ¶¨³ÆÎª_____¡£ Á½¶ÎËøÐÒé
8£®Èç¹û²¢·¢Ö´ÐеÄËùÓÐÊÂÎñ¶¼×ñÊØÁ½¶ÎËøÐÒ飬ÔòÕâЩÊÂÎñµÄÈκβ¢·¢µ÷¶ÈÒ»¶¨ÊÇ_____¡£ ¿É´®Ðл¯µÄ 9£®Ò»¸öÊÂÎñÖ»ÒªÖ´ÐÐÁË_____Óï¾ä£¬Æä¶ÔÊý¾Ý¿âµÄ²Ù×÷¾ÍÊÇÓÀ¾ÃµÄ¡£ COMMIT
10£®ÔÚµ¥CPUϵͳÖУ¬Èç¹û´æÔÚ¶à¸öÊÂÎñ£¬ÔòÕâЩÊÂÎñÖ»Äܽ»²æµØÊ¹ÓÃCPU£¬½«ÕâÖÖ²¢·¢·½Ê½³ÆÎª_____¡£ ½»²æ²¢
·¢ Èý£® ¼ò´ðÌâ
5£®ÉèÓÐÈçÏÂÈý¸öÊÂÎñ£º
T1£ºB = A + 1£» T2£ºB = B * 2£» T3£ºA = B + 1
£¨1£©ÉèAµÄ³õֵΪ2£¬BµÄ³õֵΪ1£¬Èç¹ûÕâÈý¸öÊÂÎñ²¢·¢µÄÖ´ÐУ¬Ôò¿ÉÄܵÄÕýÈ·µÄÖ´Ðнá¹ûÓÐÄÄЩ£¿
T1?T2?T3£ºA=7, B=6
34
T1?T3?T2£ºA=4, B=8 T2?T1?T3£ºA=4, B=3 T2?T3?T1£ºA=3, B=4 T3?T1?T2£ºA=2, B=6 T3?T2?T1£ºA=2, B=3
£¨2£©¸ø³öÒ»ÖÖ×ñÊØÁ½¶ÎËøÐÒéµÄ²¢·¢µ÷¶È²ßÂÔ¡£
6£®ÉèÓÐÈçͼ8-16ËùʾµÄÁ½¸öÊÂÎñµÄµ÷¶È¹ý³Ì£¬¸ù¾Ý´ËͼÍê³ÉÏÂÁи÷Ìâ¡£ ¡¤35¡¤ £¨1£©Ð´³öÊÂÎñT1ºÍT2°üº¬µÄ²Ù×÷¡£ T1£ºA = B+20
T2£ºB =A +30
£¨2£©ÊÂÎñT1¡¢T2¿ªÊ¼Ö®Ç°BµÄ³õÖµÊǶàÉÙ£¿ B = 100
£¨3£©ÉèAµÄ³õֵΪ20£¬ÔòÕâÁ½¸öÊÂÎñËùÓпÉÄܵÄÕýÈ·Ö´Ðнá¹ûÓÐÄÄЩ£¿ T1?T2£ºA = 120£¬B = 150 T2?T1£ºA = 70£¬B = 50
£¨4£©¸Ãµ÷¶È·½Ê½ÊÇ·ñ×ñÊØÁ½¶ÎËøÐÒ飿 ÊÇ
35
ͼ8-16 ÊÂÎñµ÷¶Èͼ
¡¤36¡¤ µÚ9Õ Êý¾Ý¿â±à³Ì Ò»£® Ñ¡ÔñÌâ
1£®´´½¨´æ´¢¹ý³ÌµÄÓô¦Ö÷ÒªÊÇ
A£®Ìá¸ßÊý¾Ý²Ù×÷ЧÂÊ C£®ÊµÏÖ¸´ÔÓµÄÒµÎñ¹æÔò
2£®ÏÂÁйØÓÚ´æ´¢¹ý³ÌµÄ˵·¨£¬ÕýÈ·µÄÊÇ
A
A
B£®Î¬»¤Êý¾ÝµÄÒ»ÖÂÐÔ D£®ÔöÇ¿ÒýÓÃÍêÕûÐÔ
A£®ÔÚ¶¨Òå´æ´¢¹ý³ÌµÄ´úÂëÖпÉÒÔ°üº¬Êý¾ÝµÄÔö¡¢É¾¡¢¸Ä¡¢²éÓï¾ä B£®Óû§¿ÉÒÔÏò´æ´¢¹ý³Ì´«µÝ²ÎÊý£¬µ«²»ÄÜÊä³ö´æ´¢¹ý³Ì²úÉúµÄ½á¹û C£®´æ´¢¹ý³ÌµÄÖ´ÐÐÊÇÔÚ¿Í»§¶ËÍê³ÉµÄ D£®´æ´¢¹ý³ÌÊÇ´æ´¢ÔÚ¿Í»§¶ËµÄ¿ÉÖ´ÐдúÂë¶Î
3£®ÉèÒª¶¨ÒåÒ»¸ö°üº¬2¸öÊäÈë²ÎÊýºÍ2¸öÊä³ö²ÎÊýµÄ´æ´¢¹ý³Ì£¬¸÷²ÎÊý¾ùΪÕûÐÍ¡£ÏÂÁж¨Òå¸Ã´æ´¢¹ý³ÌµÄÓï¾ä£¬ÕýÈ·µÄÊÇ
A£®CREATE PROC P1 @x1, @x2 int,
@x3 , @x4 int output
B£®CREATE PROC P1 @x1 int, @x2 int,
@x2, @x4 int output
C£®CREATE PROC P1 @x1 int, @x2 int,
@x3 int, @x4 int output
D£®CREATE PROC P1 @x1 int, @x2 int,
@x3 int output, @x4 int output t
4£®ÉèÓд洢¹ý³Ì¶¨ÒåÓï¾ä£ºCREATE PROC P1 @x int, @y int output, @z int output¡£ÏÂÁе÷Óøô洢¹ý³ÌµÄÓï¾äÖУ¬ÕýÈ·µÄÊÇ
B£®EXEC P1 10, @a int, @b int output C£®EXEC P1 10, @a output, @b output D£®EXEC P1 10, @a, @b output
5£®ÏÂÁÐÐ޸Ĵ洢¹ý³ÌP1µÄÓï¾ä£¬ÕýÈ·µÄÓï¾äÊÇ
A£®ALTER P1 C£®MODIFY P1
6£® ÏÂÁÐɾ³ý´æ´¢¹ý³ÌP1µÄÓï¾ä£¬ÕýÈ·µÄÓï¾äÊÇ
A£®DELETE P1 C£®DROP P1
7£®¶¨Òå´¥·¢Æ÷µÄÖ÷Òª×÷ÓÃÊÇ D
A£®Ìá¸ßÊý¾ÝµÄ²éѯЧÂÊ C£®¼ÓÇ¿Êý¾ÝµÄ±£ÃÜÐÔ
8£®ÏÖÓÐѧÉú±íºÍÐÞ¿Î±í£¬Æä½á¹¹Îª£º
ѧÉú±í£¨Ñ§ºÅ£¬ÐÕÃû£¬ÈëѧÈÕÆÚ£¬±ÏÒµÈÕÆÚ£© ÐÞ¿Î±í£¨Ñ§ºÅ£¬¿Î³ÌºÅ£¬¿¼ÊÔÈÕÆÚ£¬³É¼¨£©
ÏÖÒªÇóÐ޿αíÖеĿ¼ÊÔÈÕÆÚ±ØÐëÔÚѧÉú±íÖÐÏàӦѧÉúµÄÈëѧÈÕÆÚºÍ±ÏÒµÈÕÆÚÖ®¼ä¡£ÏÂÁÐʵÏÖ·½·¨ÖУ¬ÕýÈ·µÄÊÇ
B
36
B£®ÔöÇ¿Êý¾ÝµÄ°²È«ÐÔ D£®ÊµÏÖ¸´ÔÓµÄÔ¼Êø
B
B£®ALTER PROC P1 D£®MODIFY PROC P1
D
B£®DELETE PROC P1 D£®DROP PROC P1 C
A£®EXEC P1 10, @a int output, @b int output
D
A£®ÔÚÐ޿αíµÄ¿¼ÊÔÈÕÆÚÁÐÉ϶¨ÒåÒ»¸öCHECKÔ¼Êø B£®ÔÚÐ޿αíÉϽ¨Á¢Ò»¸ö²åÈëºÍ¸üвÙ×÷µÄ´¥·¢Æ÷ C£®ÔÚѧÉú±íÉϽ¨Á¢Ò»¸ö²åÈëºÍ¸üвÙ×÷µÄ´¥·¢Æ÷ D£®ÔÚÐ޿αíµÄ¿¼ÊÔÈÕÆÚÁÐÉ϶¨ÒåÒ»¸öÍâÂëÒýÓÃÔ¼Êø
¡¤37¡¤ 9£®ÉèÓнÌʦ±í£¨½ÌʦºÅ£¬½ÌʦÃû£¬Ö°³Æ£¬»ù±¾¹¤×Ê£©£¬ÆäÖлù±¾¹¤×ʵÄȡֵ·¶Î§Óë½Ìʦְ³ÆÓйأ¬±ÈÈ磬½ÌÊڵĻù±¾¹¤×ÊÊÇ6000~10000£¬¸±½ÌÊڵĻù±¾¹¤×ÊÊÇ4000~8000¡£ÏÂÁÐʵÏÖ¸ÃÔ¼ÊøµÄ·½·¨ÖУ¬¿ÉÐеÄÊÇ C
A£® ¿Éͨ¹ýÔÚ½Ìʦ±íÉ϶¨Òå²åÈëºÍÐ޸IJÙ×÷µÄ´¥·¢Æ÷ʵÏÖ B£® ¿Éͨ¹ýÔÚ»ù±¾¹¤×ÊÁÐÉ϶¨ÒåÒ»¸öCHECKÔ¼ÊøÊµÏÖ C£® AºÍB¶¼¿ÉÒÔ D£® AºÍB¶¼²»¿ÉÒÔ
10£®ÉèÔÚSC(Sno,Cno,Grade)±íÉ϶¨ÒåÁË´¥·¢Æ÷£º
CREATE TRIGGER tri1 ON SC INSTEAD OF INSERT ¡ µ±Ö´ÐÐÓï¾ä£ºINSERT INTO SC VALUES('s001', 'c01',90)
»áÒý·¢¸Ã´¥·¢Æ÷Ö´ÐС£ÏÂÁйØÓÚ´¥·¢Æ÷Ö´ÐÐʱ±íÖÐÊý¾ÝµÄ˵·¨£¬ÕýÈ·µÄÊÇ D A£®SC±íºÍINERTED±íÖоù°üº¬Ð²åÈëµÄÊý¾Ý B£®SC±íºÍINERTED±íÖоù²»°üº¬Ð²åÈëµÄÊý¾Ý
C£®SC±íÖаüº¬Ð²åÈëµÄÊý¾Ý£¬INERTED±íÖв»°üº¬Ð²åÈëµÄÊý¾Ý D£®SC±íÖв»°üº¬Ð²åÈëµÄÊý¾Ý£¬INERTED±íÖаüº¬Ð²åÈëµÄÊý¾Ý 11£®ÉèÔÚSC(Sno,Cno,Grade)±íÉ϶¨ÒåÁË´¥·¢Æ÷£º
CREATE TRIGGER tri1 ON SC AFTER INSERT ¡ µ±Ö´ÐÐÓï¾ä£ºINSERT INTO SC VALUES('s001', 'c01',90)
»áÒý·¢¸Ã´¥·¢Æ÷Ö´ÐС£ÏÂÁйØÓÚ´¥·¢Æ÷Ö´ÐÐʱ±íÖÐÊý¾ÝµÄ˵·¨£¬ÕýÈ·µÄÊÇ A A£®SC±íºÍINERTED±íÖоù°üº¬Ð²åÈëµÄÊý¾Ý B£®SC±íºÍINERTED±íÖоù²»°üº¬Ð²åÈëµÄÊý¾Ý
C£®SC±íÖаüº¬Ð²åÈëµÄÊý¾Ý£¬INERTED±íÖв»°üº¬Ð²åÈëµÄÊý¾Ý D£®SC±íÖв»°üº¬Ð²åÈëµÄÊý¾Ý£¬INERTED±íÖаüº¬Ð²åÈëµÄÊý¾Ý
12£®µ±Ö´ÐÐÓÉUPDATEÓï¾äÒý·¢µÄ´¥·¢Æ÷ʱ£¬ÏÂÁйØÓڸô¥·¢Æ÷ÁÙʱ¹¤×÷±íµÄ˵·¨£¬ÕýÈ·µÄÊÇ C
A£®ÏµÍ³»á×Ô¶¯²úÉúUPDATED±íÀ´´æ·Å¸ü¸ÄǰµÄÊý¾Ý B£®ÏµÍ³»á×Ô¶¯²úÉúUPDATED±íÀ´´æ·Å¸ü¸ÄºóµÄÊý¾Ý
C£®ÏµÍ³»á×Ô¶¯²úÉúINSERTED±íºÍDELETED±í£¬ÓÃINSERTED±í´æ·Å¸ü¸ÄºóµÄÊý¾Ý£¬ÓÃDELETED±í´æ·Å¸ü¸ÄǰµÄÊý¾Ý
D£®ÏµÍ³»á×Ô¶¯²úÉúINSERTED±íºÍDELETED±í£¬ÓÃINSERTED±í´æ·Å¸ü¸ÄǰµÄÊý¾Ý£¬ÓÃDELETED±í´æ·Å¸ü¸ÄºóµÄÊý¾Ý
13£®ÏÂÁйØÓÚÓαêµÄ˵·¨£¬´íÎóµÄÊÇ D
A£®ÓαêÔÊÐíÓû§¶¨Î»µ½½á¹û¼¯ÖеÄijÐÐ B£®ÓαêÔÊÐíÓû§¶ÁÈ¡½á¹û¼¯Öе±Ç°ÐÐλÖõÄÊý¾Ý C£®ÓαêÔÊÐíÓû§Ð޸Ľá¹û¼¯Öе±Ç°ÐÐλÖõÄÊý¾Ý
D£®ÓαêÖÐÓиöµ±Ç°ÐÐÖ¸Õ룬¸ÃÖ¸ÕëÖ»ÄÜÔÚ½á¹û¼¯Öе¥ÏòÒÆ¶¯
14£®¶ÔÓαêµÄ²Ù×÷Ò»°ã°üÀ¨ÉùÃ÷¡¢´ò¿ª¡¢´¦Àí¡¢¹Ø±Õ¡¢Êͷż¸¸ö²½Ö裬ÏÂÁйØÓڹرÕÓαêµÄ˵·¨£¬´íÎóµÄÊÇ
A£®Óα걻¹Ø±ÕÖ®ºó£¬»¹¿ÉÒÔͨ¹ýOPENÓï¾äÔٴδò¿ª B£®ÓαêÒ»µ©±»¹Ø±Õ£¬ÆäËùÕ¼ÓõÄ×ÊÔ´¼´±»ÊÍ·Å C£®Óα걻¹Ø±ÕÖ®ºó£¬ÆäËùÕ¼ÓõÄ×ÊԴûÓб»ÊÍ·Å
37
B
¡¤38¡¤ D£®¹Ø±ÕÓαêÖ®ºóµÄÏÂÒ»¸ö²Ù×÷¿ÉÒÔÊÇÊÍ·ÅÓα꣬Ҳ¿ÉÒÔÊÇÔٴδò¿ª¸ÃÓαê
¶þ£® Ìî¿ÕÌâ
1£®ÀûÓô洢¹ý³Ì»úÖÆ£¬¿ÉÒÔ_____Êý¾Ý²Ù×÷ЧÂÊ¡£ Ìá¸ß
2£®´æ´¢¹ý³Ì¿ÉÒÔ½ÓÊÜÊäÈë²ÎÊýºÍÊä³ö²ÎÊý£¬¶ÔÓÚÊä³ö²ÎÊý£¬±ØÐëÓÃ_____´ÊÀ´±êÃ÷¡£ OUTPUT 3£®Ö´Ðд洢¹ý³ÌµÄSQLÓï¾äÊÇ_____¡£ EXEC (EXECUTE)
4£®µ÷Óô洢¹ý³Ìʱ£¬Æä²ÎÊý´«µÝ·½Ê½ÓÐ_____ºÍ_____Á½ÖÖ¡£°´²ÎÊýλÖà °´²ÎÊýÃû 5£®Ð޸Ĵ洢¹ý³ÌµÄSQLÓï¾äÊÇ_____¡£ALTER PROC
6£®SQL ServerÖ§³ÖÁ½ÖÖÀàÐ͵Ĵ¥·¢Æ÷£¬ËüÃÇÊÇ_____´¥·¢ÐÍ´¥·¢Æ÷ºÍ_____´¥·¢ÐÍ´¥·¢Æ÷¡£ ǰ ºó 7£®ÔÚÒ»¸ö±íÉÏÕë¶Ôÿ¸ö²Ù×÷£¬¿ÉÒÔ¶¨Òå_____¸öǰ´¥·¢ÐÍ´¥·¢Æ÷¡£ Ò»
8£®Èç¹ûÔÚij¸ö±íµÄINSERT²Ù×÷É϶¨ÒåÁË´¥·¢Æ÷£¬Ôòµ±Ö´ÐÐINSERTÓï¾äʱ£¬ÏµÍ³²úÉúµÄÁÙʱ¹¤×÷±íÊÇ_____¡£ INSERTED
9£®¶ÔÓÚºó´¥·¢ÐÍ´¥·¢Æ÷£¬µ±´¥·¢Æ÷Ö´ÐÐʱ£¬Òý·¢´¥·¢Æ÷µÄ²Ù×÷Óï¾ä£¨ÒÑÖ´ÐÐÍê/δִÐУ©_____¡£ ÒÑÖ´ÐÐÍê 10£®¶ÔÓÚºó´¥·¢ÐÍ´¥·¢Æ÷£¬µ±ÔÚ´¥·¢Æ÷Öз¢ÏÖÒý·¢´¥·¢Æ÷Ö´ÐеIJÙ×÷Î¥·´ÁËÔ¼ÊøÊ±£¬ÐèҪͨ¹ý_____Óï¾ä³·ÏúÒÑÖ´ÐеIJÙ×÷¡£ ROLLBACK
11£®´ò¿ªÓαêµÄÓï¾äÊÇ_____¡£ OPEN cursor_name
12£®ÔÚ²Ù×÷Óαêʱ£¬ÅжÏÊý¾ÝÌáȡ״̬µÄÈ«¾Ö±äÁ¿_____¡£ @@fetch_status ËÄ£®ÉÏ»úÁ·Ï°
ÒÔϸ÷Ìâ¾ùÀûÓõÚ3¡¢4Õ½¨Á¢µÄStudentsÊý¾Ý¿âÒÔ¼°Student¡¢CourseºÍSC±íʵÏÖ¡£ 1£® ´´½¨Âú×ãÏÂÊöÒªÇóµÄ´æ´¢¹ý³Ì£¬²¢²é¿´´æ´¢¹ý³ÌµÄÖ´Ðнá¹û¡£ £¨1£© ²éѯÿ¸öѧÉúµÄÐÞ¿Î×Üѧ·Ö£¬ÒªÇóÁгöѧÉúѧºÅ¼°×Üѧ·Ö¡£
create proc p1 as
select sno,SUM(credit) as ×Üѧ·Ö
from SC join Course c on c.Cno=SC.Cno group by sno
£¨2£© ²éѯѧÉúµÄѧºÅ¡¢ÐÕÃû¡¢Ð޵Ŀγ̺š¢¿Î³ÌÃû¡¢¿Î³Ìѧ·Ö£¬½«Ñ§ÉúËùÔÚϵ×÷ΪÊäÈë²ÎÊý£¬Ä¬ÈÏֵΪ¡°¼ÆËã»ú
ϵ¡±¡£Ö´Ðд˴洢¹ý³Ì£¬²¢·Ö±ðÖ¸¶¨Ò»Ð©²»Í¬µÄÊäÈë²ÎÊýÖµ£¬²é¿´Ö´Ðнá¹û¡£ create proc p2
@dept varchar(20) = '¼ÆËã»úϵ' as
select s.sno,sname,c.cno,cname,credit from Student s join SC on s.Sno=SC.Sno join Course c on c.Cno=SC.Cno
where Sdept = @dept Ö´ÐÐʾÀý1£ºEXEC P2
Ö´ÐÐʾÀý2£ºEXEC P2 'ͨÐŹ¤³Ìϵ'
£¨3£© ²éѯָ¶¨ÏµµÄÄÐÉúÈËÊý£¬ÆäÖÐϵΪÊäÈë²ÎÊý£¬ÈËÊýΪÊä³ö²ÎÊý¡£
create proc p3
@dept varchar(20),@rs int output as
select @rs = COUNT(*) from Student where Sdept = @dept and Ssex = 'ÄÐ'
38
£¨4£© ɾ³ýÖ¸¶¨Ñ§ÉúµÄÐ޿μǼ£¬ÆäÖÐѧºÅΪÊäÈë²ÎÊý¡£
create proc p4 @sno char(7) as
delete from SC where Sno = @sno
£¨5£© ÐÞ¸ÄÖ¸¶¨¿Î³ÌµÄ¿ª¿ÎѧÆÚ¡£ÊäÈë²ÎÊýΪ£º¿Î³ÌºÅºÍÐ޸ĺóµÄ¿ª¿ÎѧÆÚ¡£
create proc p5
@cno char(6),@x tinyint as
update Course set Semester = @x where Cno = @cno
2£® ´´½¨Âú×ãÏÂÊöÒªÇóµÄ´¥·¢Æ÷£¨Ç°´¥·¢Æ÷¡¢ºó´¥·¢Æ÷¾ù¿É£©£¬²¢ÑéÖ¤´¥·¢Æ÷Ö´ÐÐÇé¿ö¡£ £¨1£© ÏÞÖÆÑ§ÉúµÄÄêÁäÔÚ15~45Ö®¼ä¡£
create trigger tri1
on student after insert,update as
if exists(select * from inserted where sage not between 15 and 45) rollback
£¨2£© ÏÞÖÆÑ§ÉúËùÔÚϵµÄȡֵ·¶Î§Îª{¼ÆËã»úϵ£¬ÐÅÏ¢¹ÜÀíϵ£¬Êýѧϵ£¬Í¨Ðʤ³Ìϵ}
create trigger tri2
on student after insert,update as
if exists(select * from student where sdept not in ('¼ÆËã»úϵ','ÐÅÏ¢¹ÜÀíϵ','Êýѧϵ','ͨÐŹ¤³Ìϵ'))
Rollback
£¨3£© ÏÞÖÆÃ¿¸öѧÆÚ¿ªÉèµÄ¿Î³Ì×Üѧ·ÖÔÚ20~30·¶Î§ÄÚ¡£
create trigger tri3
on course after insert,update as
if exists(select sum(credit) from course
where semester in (select semester from inserted ) having sum(credit) not between 20 and 30 ) Rollback
£¨4£© ÏÞÖÆÃ¿¸öѧÉúÿѧÆÚÑ¡¿ÎÃÅÊý²»Äܳ¬¹ý6ÃÅ£¨ÉèÖ»Õë¶Ô²åÈë²Ù×÷£©¡£
create trigger tri4 on sc after insert as
if exists(select * from sc join course c on sc.cno = c.cno where sno in (select sno from inserted) group by sno,semester
39
¡¤39¡¤ ¡¤40¡¤ having count(*) > 6 ) rollback
3£® ´´½¨Âú×ãÏÂÊöÒªÇóµÄÓα꣬²¢²é¿´ÓαêµÄÖ´Ðнá¹û¡£
£¨1£© ÁгöVB¿¼ÊԳɼ¨×î¸ßµÄǰ2ÃûºÍ×îºó1ÃûѧÉúµÄѧºÅ¡¢ÐÕÃû¡¢ËùÔÚϵºÍVB³É¼¨¡£
declare @sno char(10),@sname char(10),@dept char(14),@grade char(4) declare c1 SCROLL cursor for select s.sno,sname,sdept,grade
from student s join sc on s.sno = sc.sno join course c on c.cno = sc.cno where cname = 'vb' order by grade desc open c1
print ' ѧºÅ ÐÕÃû ËùÔÚϵ VB³É¼¨'
print '---------------------------------------' fetch next from c1 into @sno ,@sname ,@dept ,@grade if @@FETCH_STATUS = 0
print @sno + @sname + @dept + @grade
fetch next from c1 into @sno ,@sname ,@dept ,@grade if @@FETCH_STATUS = 0
print @sno + @sname + @dept + @grade
fetch last from c1 into @sno ,@sname ,@dept ,@grade if @@FETCH_STATUS = 0
print @sno + @sname + @dept + @grade close c1 deallocate c1
£¨2£© Áгöÿ¸öϵÄêÁä×î´óµÄÃûѧÉúµÄÐÕÃûºÍÄêÁ䣬½«½á¹û°´ÄêÁä½µÐòÅÅÐò¡£
declare @sname char(10),@age char(4),@dept char(20) declare c1 cursor for select distinct sdept from student open c1
fetch next from c1 into @dept while @@FETCH_STATUS = 0 begin
print @dept
declare c2 cursor for
select top 2 with ties sname,sage from student where sdept = @dept order by sage desc open c2
fetch next from c2 into @sname ,@age if @@FETCH_STATUS = 0 print @sname + @age fetch next from c2 into @sname ,@age if @@FETCH_STATUS = 0 print @sname + @age print '' close c2 deallocate c2
fetch next from c1 into @dept
40
end close c1 deallocate c1
¡¤41¡¤ 41
¡¤42¡¤
µÚ10Õ °²È«¹ÜÀí Ò»£®Ñ¡ÔñÌâ
1£®ÏÂÁйØÓÚSQL ServerÊý¾Ý¿âÓû§È¨ÏÞµÄ˵·¨£¬´íÎóµÄÊÇ
A
A£®Êý¾Ý¿âÓû§×Ô¶¯¾ßÓиÃÊý¾Ý¿âÖÐÈ«²¿Óû§Êý¾ÝµÄ²éѯȨ
B£®Í¨³£Çé¿öÏ£¬Êý¾Ý¿âÓû§¶¼À´Ô´ÓÚ·þÎñÆ÷µÄµÇ¼ÕÊ»§ C£®Ò»¸öµÇ¼ÕÊ»§¿ÉÒÔ¶ÔÓ¦¶à¸öÊý¾Ý¿âÖеÄÓû§
D£®Êý¾Ý¿âÓû§¶¼×Ô¶¯¾ßÓиÃÊý¾Ý¿âÖÐpublic½ÇÉ«µÄȨÏÞ 2£®ÏÂÁйØÓÚSQL ServerÊý¾Ý¿â·þÎñÆ÷µÇ¼ÕÊ»§µÄ˵·¨£¬´íÎóµÄÊÇ
B
A£®µÇ¼ÕÊ»§µÄÀ´Ô´¿ÉÒÔÊÇWindowsÓû§£¬Ò²¿ÉÒÔÊÇ·ÇWindowsÓû§
B£®ËùÓеÄWindowsÓû§¶¼×Ô¶¯ÊÇSQL ServerµÄºÏ·¨ÕÊ»§
C£®ÔÚWindowsÉí·ÝÑé֤ģʽÏ£¬²»ÔÊÐí·ÇWindowsÉí·ÝµÄÓû§µÇ¼µ½SQL Server·þÎñÆ÷ D£®saÊÇSQL ServerÌṩµÄÒ»¸ö¾ßÓÐϵͳ¹ÜÀíԱȨÏÞµÄĬÈϵǼÕÊ»§ 3£®ÏÂÁйØÓÚSQL Server 2008Éí·ÝÈÏ֤ģʽµÄ˵·¨£¬ÕýÈ·µÄÊÇ
C A£®Ö»ÄÜÔÚ°²×°¹ý³ÌÖÐÖ¸¶¨Éí·ÝÈÏ֤ģʽ£¬°²×°Íê³ÉÖ®ºó²»ÄÜÔÙÐÞ¸Ä B£®Ö»ÄÜÔÚ°²×°Íê³ÉºóÖ¸¶¨Éí·ÝÈÏ֤ģʽ£¬°²×°¹ý³ÌÖв»ÄÜÖ¸¶¨
C£®ÔÚ°²×°¹ý³ÌÖпÉÒÔÖ¸¶¨Éí·ÝÈÏ֤ģʽ£¬°²×°Íê³ÉÖ®ºó»¹¿ÉÒÔÔÙ¶ÔÆä½øÐÐÐÞ¸Ä D£®Éí·ÝÈÏ֤ģʽÊÇϵͳ¹æ¶¨ºÃµÄ£¬ÔÚ°²×°¹ý³ÌÖм°°²×°Íê³Éºó¶¼²»ÄܽøÐÐÐÞ¸Ä 4£®ÏÂÁÐSQL ServerÌṩµÄϵͳ½ÇÉ«ÖУ¬¾ßÓÐÊý¾Ý¿â·þÎñÆ÷ÉÏÈ«²¿²Ù×÷ȨÏ޵ĽÇÉ«ÊÇ D
A£®db_owner B£®dbcreator C£®db_datawriter
D£®sysadmin
5£®ÏÂÁнÇÉ«ÖУ¬¾ßÓÐÊý¾Ý¿âÖÐÈ«²¿Óû§±íÊý¾ÝµÄ²åÈ롢ɾ³ý¡¢ÐÞ¸ÄȨÏÞÇÒÖ»¾ßÓÐÕâЩȨÏ޵ĽÇÉ«ÊÇ A£®db_owner B£®db_datareader C£®db_datawriter
D£®public
6£®´´½¨SQL ServerµÇ¼ÕÊ»§µÄSQLÓï¾äÊÇ A
A£®CREATE LOGIN B£®CREATE USER C£®ADD LOGIN
D£®ADD USER 7£® ÏÂÁÐSQLÓï¾äÖУ¬ÓÃÓÚÊÕ»ØÒÑÊÚÓèÓû§È¨ÏÞµÄÓï¾äÊÇ C
A£®DROP B£®DELETE C£®REVOKE
D£®ALTER
8£®ÔÚSQL ServerÖУ¬ÏòÊý¾Ý¿â½ÇÉ«Ìí¼Ó³ÉÔ±µÄSQLÓï¾äÊÇ D
A£®ADD member B£®ADD rolemember C£®sp_addmember
D£®sp_addrolemember
9£®ÏÂÁйØÓÚÊý¾Ý¿âÖÐÆÕͨÓû§µÄ˵·¨£¬ÕýÈ·µÄÊÇ
C
A£®Ö»Äܱ»ÊÚÓè¶ÔÊý¾ÝµÄ²éѯȨÏÞ
B£®Ö»Äܱ»ÊÚÓè¶ÔÊý¾ÝµÄ²åÈë¡¢Ð޸ĺÍɾ³ýȨÏÞ C£®Ö»Äܱ»ÊÚÓè¶ÔÊý¾ÝµÄ²Ù×÷ȨÏÞ D£®²»ÄܾßÓÐÈκÎȨÏÞ
10£®ÏÂÁйØÓÚÓû§¶¨ÒåµÄ½ÇÉ«µÄ˵·¨£¬´íÎóµÄÊÇ A
42
C
A£®Óû§¶¨Òå½ÇÉ«¿ÉÒÔÊÇÊý¾Ý¿â¼¶±ðµÄ½ÇÉ«£¬Ò²¿ÉÒÔÊÇ·þÎñÆ÷¼¶±ðµÄ½ÇÉ« B£®Óû§¶¨ÒåµÄ½ÇɫֻÄÜÊÇÊý¾Ý¿â¼¶±ðµÄ½ÇÉ« C£®¶¨ÒåÓû§¶¨Òå½ÇÉ«µÄÄ¿µÄÊǼò»¯¶ÔÓû§µÄȨÏÞ¹ÜÀí E£® Óû§½ÇÉ«¿ÉÒÔÊÇϵͳÌṩ½ÇÉ«µÄ³ÉÔ± ¶þ£®Ìî¿ÕÌâ
1£® Êý¾Ý¿âÖеÄÓû§°´²Ù×÷ȨÏ޵IJ»Í¬£¬Í¨³£·ÖΪ_____¡¢_____ºÍ_____ÈýÖÖ¡£
ϵͳ¹ÜÀíÔ± Êý¾Ý¿â¶ÔÏóÓµÓÐÕß ÆÕͨÓû§
2£® ÔÚSQL Server 2008ÖУ¬ÏµÍ³ÌṩµÄ¾ßÓйÜÀíԱȨÏ޵ĽÇÉ«ÊÇ_____¡£ sysadmin 3£®ÔÚSQL Server 2008ÖУ¬ÏµÍ³ÌṩµÄĬÈϹÜÀíÔ±ÕÊ»§ÊÇ_____¡£ sa
4£®SQL Server µÄÉí·ÝÑé֤ģʽÓÐ_____ºÍ_____Á½ÖÖ¡£ ½öWindows »ìºÏģʽ 5£®SQL Server µÄµÇ¼ÕÊ»§À´Ô´ÓÐ_____ºÍ_____Á½ÖÖ¡£ Windows ·ÇWindows 6£®ÔÚSQL Server 2008ÖУ¬ËùµÄÊý¾Ý¿âÓû§¶¼×Ô¶¯ÊÇ_____½ÇÉ«µÄ³ÉÔ±¡£ public
7£®ÔÚSQL Server 2008ÖУ¬ÏµÍ³ÌṩµÄ¾ßÓд´½¨Êý¾Ý¿âȨÏ޵ķþÎñÆ÷½ÇÉ«ÊÇ_____¡£ dbcreator 8£®ÔÚSQL Server 2008ÖУ¬´´½¨Óû§¶¨Òå½ÇÉ«µÄSQLÓï¾äÊÇ_____¡£ CREATE ROLE 9£®SQL Server 2008½«È¨ÏÞ·ÖΪ_____¡¢_____ºÍ_____ÈýÖÖ¡£ ¶ÔÏóȨÏÞ Óï¾äȨÏÞ Òþº¬È¨ÏÞ 10£®ÔÚSQL Server 2008ÖУ¬½ÇÉ«·ÖΪÖÖ_____ºÍ_____Á½´óÀà¡£ ¹Ì¶¨½ÇÉ« Óû§½ÇÉ«
¡¤43¡¤
43
¡¤44¡¤ µÚ11Õ ±¸·ÝºÍ»Ö¸´ Ò»£®Ñ¡ÔñÌâ
1£®±¸·ÝÊý¾Ý¿âµÄÖ÷ҪĿµÄÊÇΪÁË·ÀÖ¹Êý¾Ý¶ªÊ§¡£ÏÂÁÐÓпÉÄÜÔì³ÉÊý¾Ý¶ªÊ§µÄÊÇ
A£®´æ´¢Êý¾ÝµÄ´ÅÅ̳öÏÖ¹ÊÕÏ B£®´æ´¢Êý¾ÝµÄ·þÎñÆ÷³öÏÖ¹ÊÕÏ C£®Óû§µÄ²»Õý³£²Ù×÷¶ø¸ü¸ÄÁËÊý¾Ý D£®Êý¾Ý¿âÎļþ±»Òƶ¯
2£®ÏÂÁйØÓÚÊý¾Ý¿â±¸·ÝµÄ˵·¨£¬ÕýÈ·µÄÊÇ
C
D
A£®¶ÔϵͳÊý¾Ý¿âºÍÓû§Êý¾Ý¿â¶¼Ó¦²ÉÓö¨ÆÚ±¸·ÝµÄ²ßÂÔ B£®¶ÔϵͳÊý¾Ý¿âºÍÓû§Êý¾Ý¿â¶¼Ó¦²ÉÓÃÐ޸ĺ󼴱¸·ÝµÄ²ßÂÔ
C£®¶ÔϵͳÊý¾Ý¿âÓ¦²ÉÓÃÐ޸ĺ󼴱¸·ÝµÄ²ßÂÔ£¬¶ÔÓû§Êý¾Ý¿âÓ¦²ÉÓö¨ÆÚ±¸·ÝµÄ²ßÂÔ D£®¶ÔϵͳÊý¾Ý¿âÓ¦²ÉÓö¨ÆÚ±¸·ÝµÄ²ßÂÔ£¬¶ÔÓû§Êý¾Ý¿âÓ¦²ÉÓÃÐ޸ĺ󼴱¸·ÝµÄ²ßÂÔ 3£®ÏÂÁйØÓÚSQL Server±¸·ÝÉ豸µÄ˵·¨£¬ÕýÈ·µÄÊÇ A
A£®±¸·ÝÉ豸¿ÉÒÔÊÇ´ÅÅÌÉϵÄÒ»¸öÎļþ
B£®±¸·ÝÉ豸ÊÇÒ»¸öÂß¼É豸£¬ËüÖ»Äܽ¨Á¢ÔÚ´ÅÅÌÉÏ C£®±¸·ÝÉ豸ÊÇһ̨ÎïÀí´æÔÚµÄÓÐÌØ¶¨ÒªÇóµÄÉ豸 D£®Ò»¸ö±¸·ÝÉ豸ֻÄÜÓÃÓÚÒ»¸öÊý¾Ý¿âµÄÒ»´Î±¸·Ý 4£®ÔÚ¼òµ¥»Ö¸´Ä£Ê½Ï£¬¿ÉÒÔ½øÐеı¸·ÝÊÇ
A£®½öÍêÕû±¸·Ý B£®½öÊÂÎñÈÕÖ¾±¸·Ý C£®½öÍêÕû±¸·ÝºÍ²îÒ챸·Ý
D£®ÍêÕû±¸·Ý¡¢²îÒ챸·ÝºÍÈÕÖ¾±¸·Ý 5£®ÏÂÁйØÓÚ²îÒ챸·ÝµÄ˵·¨£¬ÕýÈ·µÄÊÇ
B C
A£®²îÒ챸·Ý±¸·ÝµÄÊÇ´ÓÉϴα¸·Ýµ½µ±Ç°Ê±¼äÊý¾Ý¿â±ä»¯µÄÄÚÈÝ B£®²îÒ챸·Ý±¸·ÝµÄÊÇ´ÓÉÏ´ÎÍêÕû±¸·Ýµ½µ±Ç°Ê±¼äÊý¾Ý¿â±ä»¯µÄÄÚÈÝ C£®²îÒ챸·Ý½ö±¸·ÝÊý¾Ý£¬²»±¸·ÝÈÕÖ¾
D£®Á½´ÎÍêÕû±¸·ÝÖ®¼ä½øÐеĸ÷²îÒ챸·ÝµÄ±¸·Ýʱ¼ä¶¼ÊÇÒ»ÑùµÄ 6£®ÏÂÁйØÓÚÈÕÖ¾±¸·ÝµÄ˵·¨£¬´íÎóµÄÊÇ
A£®ÈÕÖ¾±¸·Ý½ö±¸·ÝÈÕÖ¾£¬²»±¸·ÝÊý¾Ý
B£®ÈÕÖ¾±¸·ÝµÄÖ´ÐÐЧÂÊͨ³£±È²îÒ챸·ÝºÍÍêÕû±¸·Ý¸ß C£®ÈÕÖ¾±¸·ÝµÄʱ¼ä¼ä¸ôͨ³£±È²îÒ챸·Ý¶Ì D£®µÚÒ»´Î¶ÔÊý¾Ý¿â½øÐеı¸·Ý¿ÉÒÔÊÇÈÕÖ¾±¸·Ý 7£®ÏÂÁйØÓÚ»Ö¸´Êý¾Ý¿âµÄ˵·¨£¬ÕýÈ·µÄÊÇ
A£®ÔÚ»Ö¸´Êý¾Ý¿âʱ²»ÔÊÐíÓÐÓû§·ÃÎÊÊý¾Ý¿â
B£®»Ö¸´Êý¾Ý¿âʱ±ØÐë°´ÕÕ±¸·ÝµÄ˳Ðò»¹ÔÈ«²¿µÄ±¸·Ý C£®»Ö¸´Êý¾Ý¿âʱ£¬¶ÔÊÇ·ñÓÐÓû§ÔÚʹÓÃÊý¾Ý¿âûÓÐÒªÇó D£®Ê×ÏȽøÐлָ´µÄ±¸·Ý¿ÉÒÔÊDzîÒ챸·ÝºÍÈÕÖ¾±¸·Ý
A D
44
8£®ÉèÓÐÈçϱ¸·Ý²Ù×÷£º
ÈÕÖ¾ ÍêÕû±¸·Ý1 ±¸·Ý1 ÈÕÖ¾ ±¸·Ý2 ²îÒì ±¸·Ý1 ÈÕÖ¾ ±¸·Ý3 ÈÕÖ¾ ±¸·Ý4 ¡¤45¡¤ t ÖÜÈÕ 0:00 ÖÜÒ» 10:00 ÖÜÒ» 15:00 ÖÜÒ» 0:00 Öܶþ 10:00
Öܶþ 15:00 B
Öܶþ 17:00¹ÊÕÏ ÏÖ´Ó±¸·ÝÖжÔÊý¾Ý¿â½øÐлָ´£¬ÕýÈ·µÄ»Ö¸´Ë³ÐòΪ
A£®ÍêÕû±¸·Ý1£¬ÈÕÖ¾±¸·Ý1£¬ÈÕÖ¾±¸·Ý2£¬²îÒ챸·Ý1£¬ÈÕÖ¾±¸·Ý3£¬ÈÕÖ¾±¸·Ý4 B£®ÍêÕû±¸·Ý1£¬²îÒ챸·Ý1£¬ÈÕÖ¾±¸·Ý3£¬ÈÕÖ¾±¸·Ý4 C£®ÍêÕû±¸·Ý1£¬²îÒ챸·Ý1 D£®ÍêÈ«±¸·Ý1£¬ÈÕÖ¾±¸·Ý4 ¶þ£® Ìî¿ÕÌâ
3£® SQL Server 2008Ö§³ÖµÄÈýÖÖ»Ö¸´Ä£Ê½ÊÇ_____¡¢_____ºÍ_____¡£
¼òµ¥»Ö¸´Ä£Ê½ ÍêÕû»Ö¸´Ä£Ê½ ´óÈÝÁ¿ÈÕÖ¾»Ö¸´Ä£Ê½
4£® ¶ÔÓÚÊý¾Ý¿â±¸·Ý£¬SQL Server 2008Ö§³ÖµÄÈýÖÖ±¸·Ý·½Ê½ÊÇ_____¡¢_____ºÍ_____¡£
ÍêÕû±¸·Ý ²îÒ챸·Ý ÈÕÖ¾±¸·Ý
5£® µÚÒ»´Î¶ÔÊý¾Ý¿â½øÐеı¸·Ý±ØÐëÊÇ_____¡£ÍêÕû±¸·Ý
6£® SQL Server 2008ÖУ¬´´½¨±¸·ÝÉ豸µÄϵͳ´æ´¢¹ý³ÌÊÇ_____¡£sp_addumpdevice 7£® SQL Server 2008ÖУ¬µ±»Ö¸´Ä£Ê½Îª¼òµ¥Ä£Ê½Ê±£¬²»ÄܽøÐÐ_____±¸·Ý¡£ÈÕÖ¾ 8£® SQL Server 2008ÖУ¬»¹ÔÊý¾Ý¿âµÄSQLÓï¾äÊÇ_____¡£RESTORE DATABASE 9£® ͨ³£Çé¿öÏ£¬ÍêÕû±¸·Ý¡¢²îÒ챸·ÝºÍÈÕÖ¾±¸·ÝÖУ¬±¸·Ýʱ¼ä×µÄÊÇ_____¡£ÍêÕû±¸·Ý 10£® SQL Server 2008ÖУ¬ÔÚ½øÐÐÊý¾Ý¿â±¸·Ýʱ£¨ÔÊÐí/²»ÔÊÐí£©_____Óû§²Ù×÷Êý¾Ý¿â¡£ÔÊÐí
45