È«¹ú¼ÆËã»úµÈ¼¶¿¼ÊÔÈý¼¶Êý¾Ý¿â¼¼Êõ¸´Ï°×ÊÁÏ ÏÂÔر¾ÎÄ

--

¢ñ£®? sname (?dept=¡¯IS¡¯?age<20(STUDENT)) ¢ò£®? dept=¡¯IS¡¯?age<20 (?sname (STUDENT)) ¢ó£®? sname (?dept=¡¯IS¡¯?age<20(STUDENT)) A£©½ö¢ñ B£©½ö¢ò C£©¢ñºÍ¢ò D£©¢òºÍ¢ó

£¨33£©ÔÚSQLµÄSELECTÓï¾äÖУ¬ÊµÏÖͶӰ²Ù×÷µÄÊÇÄĸö×Ӿ䣿

A£©SELECT B£©FROM C£©WHERE D£©ORDER BY

£¨34£©Éè¹ØϵRÓë¹ØϵS¾ßÓÐÏàͬµÄÊôÐÔ¸öÊý£¬ÇÒ¶ÔÓ¦ÊôÐÔµÄֵȡ×Ôͬһ¸öÓò£¬ÔòR ? S¿É¼Ç×÷

A£©{t | t ?R ? t ?S} B£©{t | t ?R ? t ?S}

C£©{t | t ?R ? t ?S} D£©{t | t ?R ? t ?S}

£¨35£©¡°°Ñ²éѯsc±íºÍ¸üÐÂsc±íµÄgradeÁеÄȨÏÞÊÚÓèÓû§user1¡±µÄÕýÈ·SQLÓï¾äÊÇ

A£©GRANT SELECT£¬UPDATE£¨grade£©ON TABLE sc TO user1 B£©GRANT SELECT sc£¬UPDATE sc. grade TO user1 C£©GRANT SELECT£¬UPDATE ON TABLE sc. grade TO user1

--

--

D£©GRANT SELECT ON TABLE sc£¬UPDATE ON TABLE sc(grade) TO user1

£¨36£©ÓйØϵR£¨A£¬B£¬C£¬D£©ºÍ¹ØϵS£¨A£¬B£¬C£¬D£¬E£¬F£©£¬¹ØϵTÊÇRÓëSµÄµÑ¿¨¶ù»ý£¬¼´£ºT = R ? S¡£Ôò¹ØϵTµÄÊôÐÔ¸öÊýÊÇ

A£©4 B£©6 C£©10 D£©24

£¨37£©¹ØϵÊý¾ÝÄ£Ð;ßÓкܶàÓŵ㣬ÏÂÁÐÄÄÒ»¸ö²»ÊÇËüµÄÓŵ㣿

A£©Äܱíʾ¸´ÔÓµÄÓïÒå B£©ÊÊÓÃÓÚ¼¯ºÏ²Ù×÷

C£©Óбê×¼ÓïÑÔÖ§³Ö D£©Êý¾Ý½á¹¹¼òµ¥

£¨38£©SQLµÄDML°üÀ¨µÄÓï¾äÓÐ A£©ROLLBACK£¬COMMIT B£©CREATE£¬DROP£¬ALTER C£©GRANT£¬REVOKE

D£©SELECT£¬INSERT£¬DELETE£¬UPDATE

£¨39£©ÔÚSQLÓïÑÔÖУ¬ÎªÁËÌá¸ß²éѯËÙ¶Èͨ³£Ó¦´´½¨ A£©ÊÓͼview B£©Ë÷Òýindex

C£©Óαêcursor D£©´¥·¢Æ÷trigger

--

--

£¨40£©ÏÂÁÐËùÊöµÄ¹¤×÷ÖУ¬ÄÄЩÊÇDBAµÄÖ°Ô𣿠¢ñ£®¾ö¶¨DB½á¹¹ºÍÐÅÏ¢ÄÚÈÝ ¢ò£®Éè¼ÆÊý¾ÝµÄ´æ´¢½á¹¹ºÍ´æÈ¡²ßÂÔ ¢ó£®¶¨ÒåÊý¾Ý°²È«ÐÔÒªÇóºÍÍêÕûÐÔÔ¼ÊøÌõ¼þ ¢ô£®Êý¾Ý¿âµÄ¸Ä½øºÍÖØ×é ¢õ£®¼à¿ØÊý¾Ý¿âµÄʹÓúÍÔËÐÐ ¢ö£®Êý¾Ý¿âµÄÐÔÄܸĽø

A£©½ö¢ò¡¢¢ô¡¢¢õºÍ¢ö B£©½ö¢ñ¡¢¢ò¡¢¢ó¡¢¢ôºÍ¢õ C£©½ö¢ñ¡¢¢ò¡¢¢ô¡¢¢õºÍ¢ö D£©¶¼ÊÇ

£¨41£©DBMS°Ñ¾­¹ý±àÒëºóµÄÊý¾Ý¶¨Òå´æ´¢ÔÚÄÄÀ A£©³ÌÐòÖÐ B£©Ë÷ÒýÖÐ C£©Êý¾Ý×ÖµäÖÐ D£©ÈÕÖ¾ÖÐ

£¨42£©¶ÔÊý¾Ý¿âµÄ½á¹¹¡¢ÍêÕûÐÔ¡¢°²È«±£ÃÜÐÔ¡¢´æȡ·¾¶µÈÐÅÏ¢µÄÃèÊöÊÇÓÉÏÂÁÐÄÄÒ»¸ö¹¦ÄÜÄ£¿éʵÏֵģ¿

A£©Êý¾Ý¿â¶¨ÒåÄ£¿é B£©Êý¾Ý¿âά»¤Ä£¿é C£©Êý¾Ý¿â´æÈ¡Ä£¿é D£©Êý¾Ý¿âÔËÐÐÄ£¿é

--

--

£¨43£©ÏÂÁйØÓÚÊý¾Ý¿â¹ÜÀíϵͳDBMSºÍ²Ù×÷ϵͳ֮¼ä¹ØϵµÄÐðÊöÖУ¬ÄÄÒ»¸öÊDz»ÕýÈ·µÄ£¿

A£©DBMSÊǽ¨Á¢ÔÚ²Ù×÷ϵͳ֮Éϵģ¬ÊDzÙ×÷ϵͳµÄÓû§ B£©DBMSÓöµ½¶Áд´ÅÅ̲Ù×÷ʱ»áÇëÇó²Ù×÷ϵͳ·þÎñ C£©²Ù×÷ϵͳ±£Ö¤DBMS¶ÔÊý¾ÝÂß¼­ÉϵĶÁдÕæʵµØÓ³Éäµ½ÎïÀíÎļþÉÏ

D£©²Ù×÷ϵͳÌṩµÄ´æÈ¡Ô­ÓïºÍ»ù±¾µÄ´æÈ¡·½·¨Í¨³£×÷ΪÓëDBMSÓ¦ÓòãµÄ½Ó¿Ú

£¨44£©ÏÂÁйØÓÚOracleÊý¾Ý¿âÎïÀí´æ´¢µÄÐðÊöÖУ¬ÄÄÒ»¸öÊDz»ÕýÈ·µÄ£¿

A£©ÅÌÇø£¨extent£©ÊÇÌض¨ÊýÁ¿µÄÁ¬ÐøÊý¾Ý¿é B£©Ò»¸ö¶ÎÊÇÒ»×é·ÖÅäÁËÌض¨Êý¾Ý½á¹¹µÄÅÌÇø

C£©´æ´¢¿Õ¼ä´óСµÄÑ¡ÔñÊÇÒԶζø²»ÊÇÒÔÊý¾Ý¿éΪµ¥Î» D£©¶ÔÓÚÒ»ÕŸø¶¨µÄ±í£¬Êý¾Ý¿ÉÄÜ´æ·ÅÔÚÊý¾Ý¶ÎÖУ¬¶øË÷Òý¿ÉÄÜ´æ·ÅÔÚË÷Òý¶ÎÖÐ

£¨45£©ÏÂÁÐÄÄÒ»¸ö˵·¨ÊDz»ÕýÈ·µÄ£¿ A£©SYBASE IQ²úÆ·Ö§³ÖBitwiseË÷Òý¼¼Êõ

B£©SYBASE IQ MultiplexÊÇΪÌá¸ßSYBASEÊý¾Ý¿âË÷ÒýµÄЧÂʶøÉè¼ÆµÄ

C£©DB2Êý¾Ý¿âϵͳʹÓö¯Ì¬Î»Í¼Ë÷ÒýÌá¸ß·ÃÎʶàάÊý¾ÝµÄÐÔÄÜ

--