还剩3页未读,继续阅读
文本内容:
¼ª´ó15ÇïѧÆÚ¡¶Êý¾Ý¿âÓ¦Óü¼Êõ¡·ÔÚÏß×÷Òµ¶þÒ»¡¢µ¥Ñ¡Ì⣨¹²25µÀÊÔÌ⣬¹²100·Ö¡££©
1.Givntho:XSQLWITHmost_itisSSLT.i.nm.itisFROMountrystffWHR.prson=.iNitis:thrsholSLTinmitisFROMmost_itisINTO:i:nm:itisWHRitisINSLTMXitisFROMmost_itisWhihofthfollowingnrfrnMOST_ITIS.Thurrntsttmnt.Sttmntsfromnypplition.llsttmntswithinthispplition.llsttmntswithinthurrntunitofworkÕýÈ·´ð°¸£º
2.Èç¹ûÒ»¸öÓû§USR1±»ÊÚÓèÁ˱íTÉϵÄONTROLÌØȨ£¬Èç¹ûÐèÒªÏÞÖƸÃÓû§¶Ô±íµÄ´æÈ¡£¬Ó¦Ê¹ÓÃÒÔÏÂÄÄÌõÃüÁ.RVOKLLONTTOUSR
1.RVOKLLONTFROMUSR
1.RVOKONTROLONTTOUSR
1.RVOKONTROLONTFROMUSR1ÕýÈ·´ð°¸£º
3.ÊÂÎñµÄÔ×ÓÐÔÊÇÖ¸£¨£©.ÊÂÎñÖаüº¬µÄËùÓвÙ×÷Ҫô¶¼×ö£¬ÒªÃ´¶¼²»×ö.ÊÂÎñÒ»µ©Ìá½»£¬¶ÔÊý¾Ý¿âµÄ¸Ä±äÊÇÓÀ¾ÃÐÔµÄ.Ò»¸öÊÂÎñÄÚ²¿µÄ²Ù×÷¼°Ê¹ÓõÄÊý¾Ý¶Ô²¢·¢µÄÆäËûÊÂÎñÊǸôÀëµÄ.ÊÂÎñ±ØÐëÊÇʹÊý¾Ý¿â´ÓÒ»¸öÒ»ÖÂÐÔ״̬±äµ½ÁíÒ»¸öÒ»ÖÂÐÔ״̬ÕýÈ·´ð°¸£º
4.Givnthtlsthrltionshipsnthsttmnts:MPLOYPTmp_nummp_nmptpt_ipt_nm1ms11Plnning2Jons12Support3Smith24Willims1Rltionship:mploy.ptisforignkyonpt.pt_i.stmt=INSRTINTOmployVLUS5jons3;XSQLXUTIMMIT:stmt;stmt=INSRTINTOmployVLUS6jhonson2;XSQLXUTIMMIT:stmt;Howmnyrowsrsussfullyinsrt.OnrowisinsrtinMPLOY.NorowsrinsrtinMPLOY.TworowsrinsrtinMPLOY.OnrowisinsrtinPTn2rowsrinsrtinMPLOYÕýÈ·´ð°¸£º
5.ÏÂÊö¹ØÓÚÊý¾Ý¿âϵͳµÄÕýÈ·ÐðÊöÊÇ£¨£©.Êý¾Ý¿âÖÐÖ»´æÔÚÊý¾ÝÏîÖ®¼äµÄÁªÏµ.Êý¾Ý¿âµÄÊý¾ÝÏîÖ®¼äºÍ¼Ç¼֮¼ä¶¼´æÔÚÁªÏµ.Êý¾Ý¿âµÄÊý¾ÝÏîÖ®¼äÎÞÁªÏµ£¬¼Ç¼֮¼ä´æÔÚÁªÏµ.Êý¾Ý¿âµÄÊý¾ÝÏîÖ®¼äºÍ¼Ç¼֮¼ä¶¼²»´æÔÚÁªÏµÕýÈ·´ð°¸£º
6.Givnthxprssion:WITHmost_itisSSLT.i.nm.itisFROMountrystffWHR.prson=.iNitis:thrsholSLT*FROMmost_itisInwhihofthfollowingosMOST_ITISxist.usrtls.srvrmmory.usrtlsp.systmtlogtlsÕýÈ·´ð°¸£º
7.GivnnO/LIprogrmwithsinglonntiontwothrsnthfollowingtionswhihompltsussfully:Thr1:INSRTINTOmytVLUS1Thr2:INSRTINTOmytVLUS2Thr1:OMMITThr2:INSRTINTOmytVLUS3Thr1:ROLLKThr2:OMMITHowmnyrorswillinsrtnrtininthtlMYT.
0.
1.
2.3ÕýÈ·´ð°¸£º
8.Ifstorprourrturnsmultiplrowswhihofthfollowingmustthllingpplitionustossthrsultst.ursor.sltsttmnt.lrtmporrytl.tlusr-finfuntionÕýÈ·´ð°¸£º
9.¹ØϵģÐÍÖеĹØϵģʽÖÁÉÙÊÇ£¨£©.1NF.2NF.3NF.NFÕýÈ·´ð°¸£º
10.Êý¾Ý¿âϵͳµÄ²¢·¢¿ØÖƵÄÖ÷Òª·½·¨ÊDzÉÓ㨣©ÖÆ¡£.¾Ü¾ø.¸ÄΪ´®ÐÐ.Ëø.²»¼ÓÈκοØÖÆÕýÈ·´ð°¸£º
11.Whihofthfollowingisnfitofusr-finfuntions.Improvspplitiononurrny.Improvslokingofrsultsts.Simplifispplitionmintnn.RusmmoryrquirmntsonthsrvrÕýÈ·´ð°¸£º
12.WhihofthfollowingisustorunnmynmiSQLUPTsttmnt.UPT..PRPR..LR..XUTÕýÈ·´ð°¸£º
13.ʵÌåÊÇÐÅÏ¢ÊÀ½çÖеÄÊõÓÓëÖ®¶ÔÓ¦µÄÊý¾Ý¿âÊõÓïΪ£º£¨£©.Îļþ.Êý¾Ý¿â.×Ö¶Î.¼Ç¼ÕýÈ·´ð°¸£º
14.ÏÂÃæÄĸö¹¤¾ßÌṩÁ˶ÔÎı¾¡¢Í¼Ïó¡¢ÒôƵ¡¢ÊÓƵºÍXMLÎĵµµÈ·Ç´«Í³Êý¾ÝÀàÐ͵Ĵ¦ÀíÄÜÁ¦£¿.2Êý¾Ý²Ö¿âÖÐÐÄ.2Êý¾ÝÁ´½Ó¹ÜÀíÆ÷.2¹ØϵÀ©Õ¹Æ÷.2OLPStrtrKitÕýÈ·´ð°¸£º
15.Givnthfollowingtl:RTTLmploynmHR10slryNOTNULLWITHFULTINSRTINTOmploynmslryVLUSSMITH30000INSRTINTOmploynmVLUSJONSINSRTINTOmploynmslryVLUSLI35000Whihofthfollowingsttmntswillrtrivmorthnonrow.SLTslryFROMmployWHRslryINSLTslry/SLTSUMslryFROMmployFROMmploy.SLTOLSVGslryFROMmploy.SLTSUMslry/OUNT*FROMmploy.SLTslry/SLTSUMslryFROMmployFROMmployÕýÈ·´ð°¸£º
16.¶ÔÓÚÄÇЩÐèҪż¶ûÁ¬½Óµ½¹«Ë¾Êý¾ÝÉϽøÐÐÊý¾Ý½»»»µÄÓû§¿ÉÑ¡ÔñÄÄÖÖ°æ±¾µÄ2£¿¶ÔÓÚÖ§³ÖС¹æÄ£µÄ²¿Ãż¶Ó¦Óã¬ÕâЩӦÓò»ÐèÒª´æȡפÁôÔÚOS/400¡¢OS/390µÈƽ̨ÉϵÄÔ¶³ÌÊý¾Ý¿â£¬ÔòÐèÒªÄÄÖÖ¼¶±ðµÄ2²úÆ·£¿.ÆóÒµ°æ.¹¤×÷×é°æ.ÆóÒµÀ©Õ¹°æ.¸öÈË°æ.ÎÀÐÇ°æÕýÈ·´ð°¸£º
17.Givnthfollowingsttmnts:XSQLINSRTINTOmployVLUS:nw_mp:nw_nmXSQLUPTompnySTnum_mploys=num_mploys+1WHRompny_i=1XSQLOMMITWhihofthfollowingntothtssothtthompnytlwillstilluptwithoutthnforthxpliitUPTSQLsttmnt.nINSRTtriggronOMPNY.nUPTtriggronOMPNY.nINSRTtriggronMPLOY.nUPTtriggronMPLOYÕýÈ·´ð°¸£º
18.¶ÔÓÚÖ§³ÖС¹æÄ£µÄ²¿Ãż¶Ó¦Óã¬ÕâЩӦÓò»ÐèÒª´æȡפÁôÔÚOS/400¡¢OS/390µÈƽ̨ÉϵÄÔ¶³ÌÊý¾Ý¿â£¬ÔòÐèÒªÄÄÖÖ¼¶±ðµÄ2²úÆ·£¿.ÆóÒµ°æ.¹¤×÷×é°æ.ÆóÒµÀ©Õ¹°æ.¸öÈË°æ.ÎÀÐÇ°æF.΢ÐÍ°æÕýÈ·´ð°¸£º
19.´´½¨Ò»¸öMSÀàÐ͵ıí¿Õ¼ä£¬¿ÉÒÔʹÓÃÒÔÏÂÄÄÁ½ÖÖÎļþϵͳ¶ÔÏó×÷ΪÈÝÆ÷£¿.Ŀ¼.Îļþ.VIÕýÈ·´ð°¸£º
20.·¢ÈËÔ±¿ª·¢·ÃÎʺǫ́IXÉϵÄ2µÄwinows³ÌÐò£¬ÐèÒªÔÚwinows¿ª·¢Æ½Ì¨ÉÏ°²×°£º.2ÔËÐÐʱ¼ä¿Í»§¶Ë.2¹ÜÀí¿Í»§¶Ë.2Ó¦ÓóÌÐò¿ª·¢¿Í»§¶Ë.2ÊÝ¿Í»§¶ËÕýÈ·´ð°¸£º
21.Ö´ÐÐÏÂÃæÁ½ÌõSQLÓï¾äºó£ºRTTLt11hr10NOTNULLPRIMRYKY2int3hr104hr10NOTNULLONSTRINT4UNIQU14//×Ô¶¯´´½¨Ë÷ÒýRTINXInx1ONt12S±ít1ÉÏÓм¸¸öË÷Òý£¿.
0.
1.
2.
3.4ÕýÈ·´ð°¸£º
22.Ïò»ù±¾±íÔö¼ÓÒ»¸öÐÂÁкó£¬ÔÓÐÔª×éÔÚ¸ÃÁÐÉϵÄֵΪʲô£¿.TRU.FLS.¿ÕÖµ.²»È·¶¨ÕýÈ·´ð°¸£º
23.Êý¾Ý¿âϵͳµÄ¶ÀÁ¢ÐÔÊÇÖ¸£¨£©£º.²»»áÒòΪÊý¾ÝµÄ±ä»¯¶øÓ°ÏìÓ¦ÓóÌÐò.²»»áÒòΪϵͳÊý¾Ý´æ´¢½á¹¹ÓëÊý¾ÝÂß¼½á¹¹µÄ±ä»¯¶øÓ°ÏìÓ¦ÓóÌÐò.²»»áÒòΪ´æ´¢²ßÂԵı仯¶øÓ°Ïì´æ´¢½á¹¹.²»»áÒòΪijЩ´æ´¢½á¹¹µÄ±ä»¯¶øÓ°ÏìÆäËüµÄ´æ´¢½á¹¹ÕýÈ·´ð°¸£º
24.Èç¹ûÏëÔÚÊý¾Ýµ¼ÈëµÄ¹ý³ÌÖд´½¨±í£¬Ó¦¸Ã.ʹÓÃIXFÎļþ¸ñʽ½øÐÐLO.ʹÓÃWSFÎļþ¸ñʽ½øÐÐLO.ʹÓÃIXFÎļþ¸ñʽ½øÐÐIMPORT.ʹÓÃWSFÎļþ¸ñʽ½øÐÐIMPORTÕýÈ·´ð°¸£º
25.npplitionusssttiSQLtoonnttormot2srvrninsrtstintothUST.ORRStlonthtrmot2srvr.Tonlsstothrmot2srvrFOOnstortpkgwithfultoptionssothtRisthonlynon-ministrtivusrthtnusthispkgonthrmot2srvr.WhihsttmntsristhprivilgsthtFOOrquirstoomplishthis.FOOrquirsXUTprivilgonthpkg..FOOrquirsthprivilgtortthpkgonthrmot2srvr..FOOrquirsXUTprivilgonthpkgnINSRTprivilgonUST.ORRS..FOOrquirsthprivilgtortthpkgonthrmot2srvrnINSRTprivilgonUST.ORRS.ÕýÈ·´ð°¸£º。