Êý¾Ý¿âÔ­Àí¼°Ó¦Ó㨵Ú2°æ£©Ï°Ìâ²Î¿¼´ð°¸

µÚ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

ÁªÏµ¿Í·þ£º779662525#qq.com(#Ìæ»»Îª@)