--
¢ñ£®? 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Êý¾Ý¿âϵͳʹÓö¯Ì¬Î»Í¼Ë÷ÒýÌá¸ß·ÃÎʶàάÊý¾ÝµÄÐÔÄÜ
--