吉首大学数据库期末模拟考试试题AB卷

《吉首大学数据库期末模拟考试试题AB卷》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

ᦪ
ὃ⚪ᔡ✌ᜧᦪ
ᳮ⚪ஹ⚪1ᑖᐳ20ᑖ1.!"#$ᩭ&ᦪ
Ḅ()*ஹᦪ
+,-Ḅ./ᡂ12"#$+,ᓄ45Ḅ_______________________________________________O2.ᦪ
678ᵫ:ஹ.________________<=ᑖ>ᡂ஺3.A᪗ḄCDEFGᣚ1O4.ᨬ8ᵨḄᦪ
ḄឮMᢈOE.o5.6EQRSTᑮVᘤ6ḄXY᫑᫡஺

16.ᦪ
\]ឋEᢣ.\]ឋ஺7.ᦪ
`ᵨ4abcdᐹfgᨵஹஹஹ.i஺8.fgᦪ
jkᨵlServer.ஹ_________________i஺mஹ⌱o⚪p⚪1ᑖᐳ10ᑖ1.ᐵ!ᑍsᦪ
ḄtuXvwxḄE0oA.ᑍsḄyᙠ{᧕ẚ~ᦪ
Ḅ᦮ឋB.ᑍsḄyᙠᦪ
ḄC.v`ᙠᦪ
Xyᑍsᦪ
D.ᑍsᦪ
Eᢣᵫᦪ
Ḅᦪ
2.ᭆ6\]!஺஺

2A.ER6B.)ᜓC.EBVBD.3.ᑡtuwxḄ1஺AṹE"ឋD⊤¡ᑡBṹE"ឋD⊤¡¢CṹE"ឋᡈឋ¤D⊤¡ᑡDṹE"ឋᡈឋ¤D⊤¡¢4.ᦪ
<¥¦§¨᪀Ḅᑜᑖᨵᑭ!¬ᢝᦪ
Ḅ஺஺A.ᦪ
\]ឋB.ᦪ
®ᐰឋC.¨᪀*ᓄD.¢ឋ5."ᐵXḄ᎛⌱ᐵ²³஺A.´µ"B.µ"C.¶·µ"D.´¸3"6.8ᵨḄᐵ¹ºEᐵ»ᦪ.஺

3A.¤ᔠ»ᦪB.½¾¿ºC.ᐵ¿ºD.¤ᔠ¿º7.ᙠÀÁὶXÃÄ6ÅYḄὶE஺A.ὶB.µὶC.µµὶD.µὶ8.ÆcÇÈᩭÉÊᦪ
vËឋ஺A.vÌᦋஹvÎMÏஹÐÏஹÑ┝B.vÎMÏஹÐÏஹÑ┝C.ÓᜫÌᦋஹÐÏஹÑ┝D.ÓᜫÌᦋஹvÎMÏஹÐÏ9.ᙠᦪ
ÕÖ×ØÅYÙ⌴+,E7Û஺AᐰÜÝ-BᐳឋÝ-CÞᐳᦪ
ßDàáß10.ᦪ
ḄEᢣᦪ
Ḅwxឋ.â{ឋ஺A®ᐰឋB᦮ឋCÆcãᑴDឮM<ஹᑨæ⚪p⚪1ᑖᐳ10ᑖvwxḄ⌕ᑏᳮᵫ

41.é¦DXEᵨᩭêuᦪ
Ḅᱥᳮy¨᪀Ḅ஺2.ì"ᐵ6Ḅí"ᐗ>ïvDᐰì஺3.⊤Eð\]yᙠḄ⊤ᙠñX"ᐵò`⊤஺
4.ᦪ
ó4ôõEᵨ!êu¨᪀ᓄö÷Xøù)ú▤üḄdᐹ஺5.ýᦪ
XþᒹᡂḄᑣᦪᡂᜐᐰ᝱஺6.ḄᢝឋᢣᒹḄᡠᨵ!"#⌕%&'#⌕%&('஺஺7.)ᵨᡝḄᩗ▲.ᑖᐹᨵ1ᱯᩗḄᵨᡝ345)ᵨᡝ678.ᦪḄ89:;<=Ḅᩩ?@AᨵBCDEḄF஺679.CRE⇧TABLEHI.JKLMNṹஹ᜜ṹஹR᯿⊤#UVWXY

5[\ᙢ᡻_`ab᦮ឋ3R᯿b᦮ឋdᑣ஺()10.ᑖghᦪᦪijឋᒹᦪḄklijឋஹᦪḄᱥᳮijឋ3ᦪᑖgijឋ஺()oஹ(pq⚪3ᑖ#ᐳ15ᑖ)tᨵᐵU9h#ᐸ5(1)wx஺(2)yFḄᨬq{|}~஺(3)yḄᐵ஺(4)Rᑖᐸ<=BCNFK஺(5)Rᑖᐸ<=3NFKᢝᦪ}~஺ஹᔠ⚪(25ᑖ)1.RUSஹR-SBᐵUᦪx⊤ᐵUx⊤

6h஺65ᑖ72.ᐵUᦪᨵᑡCᐵUᖪ6ᖪ#ᖪ¡#ᕒ£ᦪ#ᡠᙠ¥¦7ᖪ§6ᖪ§¨#ᖪ§¡#|©7ᖪ4ᖪ§6ᖪ#ᖪ§¨#ᖪ§ᦪª761ᵨALᵪA¬bᡂᑡ!"64ᑖ7®¯├±ᐰ²ᖪ§Ḅᖪ³¡஺
2ᵨᐵUᦪbᡂᑡ!"64ᑖ7®¯ᕒ£ᦪᜧ23ᖪ3ᖪ¡஺
3µᵨ¶¬·ᑏᑡ¹º
a»ᕒ£ᦪ(¼½100£ᡈὅᙠÀÁ¦ḄᡠᨵᖪḄ3ᖪ¡஺64ᑖ7

76b7»Ã;ÄᒹḄᖪ¡஺64ᑖ76c7»ÇÈÃ;ᖪ§233ḄᖪᡠÃ;Ḅᐰ²ᖪ§Ḅᖪ¡஺64ᑖ7Ëஹtw⚪6pq⚪10ᑖ#ᐳ20ᑖ7Φ£ÏÐÑÒÓj£ÏÔÕÐ8஺Öᨵ×ᧇpCÙᩭÛÜḄC£◤ÞᑏḄߣÏᐭÛÜ⊤á6â▬⊤17äpCÙᩭÛÜḄåæ◤ÞᑏḄßåæÔÕÛÜ⊤á6â▬⊤27஺µtw£Ïஹçè3åæḄ`aὶUê#ëᭆí9:îᣚᐵU9h஺▬⊤1£ÏᐭÛÜ⊤C£¨ÛÜðñ³¡ឋò

8óðñôõö÷æ▾᪥úæûᔊὶUᵯþᵯÿ

9▬⊤2:⊤ᙢᙬᙬ◤ὶὶᵯᵯ

10ᦪ"#$ᳮ&⚪(ᫀ6ᔁ,--./⚪01/1ᑖ4ᐳ20ᑖ,1.9ᐰឋ4<᦮ឋ4⊝?᪗A2.ᦪ"B᪀4ᦪ"DE4<᦮FG஺3.JᔠL4ᓫL4.ᦪ"OP4LQᦻ
ᭆT4ᦪ"UV

116.ᱥᳮ4XY7.GHEef,Cfr8.Oracle,AccessZஹᓫ⚗⌱^⚪01_⚪1ᑖ4ᐳ10ᑖ,C,C,D,A,B,C,B,D,A,`ஹᑨb⚪01_⚪1ᑖ4ᐳ10ᑖ,F,T,T,F,T,F,T,T,Tcஹ01_⚪3ᑖ4ᐳ15ᑖ,de4X஺᝞xl
=CRxQ
=£QᦑḄ+^CD•iFjklmnoឋᓫpᓄF1:ACCA

12BABCDADCᙠF1jtᣵvwḄxᦪklyzBA,ACᡠ|BC}vwḄ~yzDA,ACᡠ|DC}vwḄF2:ACCABADAxᦪklJḄᨬ_J}pḄ4⚪(ᫀp஺yzF2jᡠᨵklḄn}ᓫoឋ4ᡠ|ᙠklnvwḄoឋ஺

13ᡠ|F:ACCABADA(3)yzEBᙠFjḄ~xᦪklḄmnjᙳ4ᡠ|᎛⌱ᐵpᒹᵪ4(ᵪ)+uWCDyᓽ}RpḄ᎛⌱ᐵ஺(4)ὃ⇋AC,ᡠ|A3}BO*(A2ᒹ᎛⌱ᐵBD),iABCDᑖzA3⚪஺}BCNF,pᑖABC⌱^BA,AjᑖzABᵪ4¡AB¢)ᙳzBCNF,ᡠ|P=▬4BA,ᵪ(5)RiABCD

14A3BAHAa1a1a1a2a3a3a3a4¤ஹ1,RLS={t|P(t)US(t)}R-^{t|P(t)?S(t))(5ᑖ)

152,(1)9CP(snQsna,snu,cit±G32DS(gnQgna,pricq)SETP-G3CES(sno,gngnun)RangeCUESrxSECP-GJESryGEIW9^rxry(ry.gno=rxgnoshop.sno=ry.snQ)(4ᑖ)Q)nsno,sna(Ssnu>23(3U))(3ᑖ)(3)Q)SELECT9^FRCMSETPWERECITr^ÊËZCR9ND^=100(3ᑖ)যSELECTSEIPsna

16FRCMSEI^G3CDSVHERESCP.sno==SFCP-G3CE8sno?iNDGXDSgna=^ÏᒹSETP-G3CE8gno=G3CDSgno4ᑖ,©SELECTsnaFRCMSETPsx'ᵪEREbOTEXISrSELECT*FKMG3CD8-aiPsyMEREOrDS-SKPsnÑ223'TWNDIEXISrSELECT*HOd9EP-G3CESsz

17W1EREsy.gno=szgnosxsno=sz.sn஺,5ᑖ,ÒஹÓÔ⚪Õ⚪pÓÔÖஹḄ×ØὶÙ(5ᑖ)Õ⚪ZOᣚᐵUÛ(5ᑖ)(b)Ü4ᨬÝÞß4(c)4àáᔊ4Þß4ᜓä4(d)Üå4ឋæ4ç4èéê4ë▾᪥,à4áᔊ4êÏ44ὶᵯ4ᵯ
4Üᔊ4ᱯÊ(e)êÏ4êÏ(44ὶ4ὶᵯ4ᙢᙬ4ᙬ,ᵯ
4)

18ᦪ"#$ᳮ&⚪Ꮙ,pஹ./⚪01/2ᑖ4ᐳ20ᑖ,1ஹᐵjðṹḄòóôõpö÷/4ø}ᵫ<᦮ឋúᑣüḄ஺2ஹýᦪ"#þẚ
᝞ᐜᦪ,ᨵឮᦪ஺ᐭᦪḄᢣᦪḄឋឋ஺4ᐵ"ᦪ#$%&Ḅᱯ()#$*+,-ᙳ/ஹ#$Ḅ123ឋ4ஹ%&56ᓄஹ89:;ᙠᦪ=ᳮ?@ẠBC஺DE5FGHᐵ"IᦪBJḄ-᪀ᓄḄLM%&஺

196*HN5O᜜QR,ᦪ"STᨵ5O᧜+VWXY᜜QR,QRBJḄ*Eᐵ"஺7ஹZ[5O◤⊤V5^WX_@⊤5᪵aLMb#$cᨵ5WḄ▲ᑴ஺&ᦪg5O☢ᔣj⚪ḄஹஹlmnḄஹopJlqrᓄḄᦪsᔠ஺9uvw┝Ḅyᓫ{|}ᵨḄᶍ஺10ஹ"Sjᦪ"Scᦪᢈᢈ-ᔠḄ஺ஹ⌱⚪(N⚪1ᑖᐳ10ᑖ)1ஹᑡḄ#$lḄ஺A.A3EISNULLB.A3EISN3TNULLC.D.NDT(^GEISMil)2ᐵ"ᦪQḄOᡂᑖlᒹ஺

20A.᦮ឋ¡ᑣB.ᦪ-᪀C.ᦪ#$D.8£¤ᑴ
¥ᵪ§¨ὅJḄᐵ"ª«A.▢ᒹ▢VEB.▭ᒹEBIEVEC.▭6ᒹ¯D.°,EBஹZEVB±ᐵ4ᦪḄ8£#$²ᩭḄ´⚪ᒹ஺A.µᜫmnB.ᦪ¸;ឋ¹º»C.1|ᵨᡝḄ½ᵨD.¾¿ᦪḄᑍÁÂ'8£ÄḄÅÆ᡻ÈẚÄḄª«A.ÊËឋB.◞ÍឋC.5ÎឋD.ÏÐឋ6.3NF()¡ᓄ/BOToA.Ò◀1jÔឋ*ṹḄᑖÖᦪ×ØB.Ò◀1jÔឋ*ṹḄÙ⌴Öᦪ×Ø

21C.Ò◀jÔឋ*ṹḄᑖÙ⌴Öᦪ×ØD.Ò◀1ÛÜ91Öᦪ×ØḄÝ×Ø7ஹ()ÞßàᙠáâãᑁḄᨵåᐳæḄᦪsᔠ஺A.ᦪçᳮ"SB.ᦪ"SC.ᦪD.ᦻéå&5O1:nὶ"_ëᣚ/5O¸;Ḅᐵ"QRᐵ"Ḅṹ/()A.í6ḄṹBᔜí6ṹḄᔠCnïí6ḄṹDNOí6Ḅṹ᜛ᙠᦪñácER[ëᣚᡂᐵ"ᦪQḄ23ÔH()A◤òᑖ᪆▤õBö÷ñá▤õCᭆùñá▤õDᱥᳮñá▤õ1Qᐵ"ᜓḄ"Sᢣ()஺Aüýᢝᐵ"ᦪ-᪀lýᢝsᔠÿḄ
Bᢝ

22ᐵᦪ᪀ᐵ
Cᢝᐵᦪ᪀ᡠᨵḄᐵᦪ
DᢝᐵḄᡠᨵᱯஹ⚪⚪5ᑖᐳ20ᑖ!1ஹᦪ"#$Ḅ%&ᦑ(ᨵ)*+2ஹ,ᦪḄ-.ᡂ0ᑖ஺3ஹᡠᨵḄ234ᔲ6789:+;<=+4ஹ<=᪵Ḅ?@AB4CDḄAB+Eஹᐳ10ᑖ!FGT1T2HIJAḄK
஺AḄLK450,FGT1JAḄKM10,FGT2JAḄKNO1ஹPQR-FG?@᡻TUV7WX஺2YZ[\-7]TᓄAB?Z[᡻TX஺

23_ஹᐳ10ᑖ!J`a\bcᦪ"ᨵ᝞eḄfg:SELECTSnameFRCMStudent,Cource,SCVHEREStudent.Sno=SCSnoSCCno=Course.CourseCnoCourse.Cnamiᦪ"'kfg⌕m⌱opᦪ"Ḅᡠᨵ`aḄqr஺1
st[ᵨᐵᦪ⊤wḄxy᪛{2
J|}Ḅxy᪛~Tᓄt[ᓄḄ᪗xy᪛஺ஹᐳ20ᑖ!ᨵ`a-bcᦪ"ᐸᦪ";`aS`qrᵫᡠᙠSD,SA
ஹbcCbcCN3,bcqrCN,ᐜobPCND
ஹ`a⌱bSC`SND,bcCND,ᡂG
஺1ஹsᵨᐵᦪAL"xxᑖᑏ[eᑡfg:

241!fg⌱op2bcḄ`aḄ`{4ᑖ!2!m⌱p'ᦪ"ᭆ'Ḅ`a`qr{4ᑖ!3!m⌱opᐰ0bcḄ`a`ஹqr஺4ᑖ!2ஹsᵨxᑏ[eᑡfg1!fg`aᦪ{2ᑖ!2!fg⌱op58¡bcḄ`a`{3ᑖ!3!ᑤ◀‘ᦪ᪀'bc¥ᡠᨵJ¦Ḅ⌱b§¨஺3ᑖ!©ஹªᔠ⚪ᐳ10ᑖ!ᨵ\0®ᵨᒹ°3-±²“´µ”“·a”“¸”¹ᨵ8eF±º·a»¼¹»¼\-´µ{-´µ78ὺᵨP¾·aJ-·aὺᵨI¿ᨵὺᵨÀ▲ὺᵨÂÀ{\-¸78ᵫÃHḄ·a;ᐸÄÅ-·a78;P¾¸ÄÆÇÄÅ¿ᨵÈÄÂÀ஺´µḄ»ឋᒹ°´µṹ´µrË{·aḄ»ឋᒹ°ÌqrÍË{¸Ḅ»ឋᒹ°qrஹஹÌᓫº஺

251ஹsÏE—R3ÐÑ»ឋὶÓ஺2ÔE—R3Õᣚ;×ØḄᐵᒹ°ᐵr»ឋrṹ!஺ᦪ"|ᳮs⚪ᫀ}ᔁ!\ஹÜÝ⚪⚪2ᑖᐳ20ᑖ!1ஹ±²2ÂÞᦻàIá᦮ឋ4ᐵÌᐵãä&᜜/è9:&éᡂḄ᜛ᐜᩭᐜìG10.ÌíWîஹ⌱ï⚪⚪1ᑖᐳ10ᑖ!1ஹC2ஹD3ஹB4ஹA5ஹB6ஹC7ஹC8ஹC9ஹB10ஹCஹ⚪⚪5ᑖᐳ20ᑖ!

261ஹᫀ⌕ðᦪ"#$Ḅ%&ᦑ(ᨵFGᑁ0Ḅᦑ(FGᦑ(!1ᑖ!ஹ#ᦑ(1ᑖ!ஹòóᦑ(2ᑖ!ஹÏäô¸õ1ᑖ!஺2ஹᫀ⌕ð:ᦪö%ᵫᦪ᪀1ᑖ!ஹᦪ
2ᑖ!ஹá᦮ឋ÷ø2ᑖ!0ᑖ.ᡂ஺3ஹᫀ⌕ðÃ4ᡠᨵḄ236479:Ḅ2ᑖ!{ù;ᨵ*23Ḅ9:ÃWú\ᙢᨵüýᙢÕᣚᡂJþ®ÿ⊤ᙢ3ᑖ஺4ஹᫀ⌕Ḅ᡻Ḅᐸ!"ᢥ$%&'(᡻)*+Ḅ!,-5ᑖ஺.ஹᐳ10ᑖ1ஹ80,902ஹT1T2SlockA

271A=50Y=AUnlockAXlockA2¥40SlockAᑏ4A=4056IhlockA561A=40Y=AUnlockA

28XlockA2ᑏ4A=80UilockACஹᐳ10ᑖEஹᐳ20ᑖ1ஹᐵGHᦪ1snoeno='2'ব2ᑖঝSno,SnCGᦪTUᭆW’2ᑖ(3)Snq]6(Cno,sno@04-Cno(C)))(2ᑖ)

29ALPHAbcGETWSCd஺SCZ2ᑖ•R^CECXSCYGETWSS:XYa60^CNDeYQOS80eXMᦪTUᭆW'2ᑖR^GECXSCYGETWe^QS^:XYMQO^CNDfYS\O=SW

2ᑖ2ஹ1SELECTaiNTOFRCMSILEENT2ᑖঝSELECTdOFKZMSC

30BYSNDHAVIN3GONT0>53ᑖ3
DELECTFKMSCWERESC60IN6ghiCQOFKMCWEREQBᦪT᪀'EELEIEFRCMCWIERECN=ᦪT᪀‘3ᑖlஹᐳ10ᑖ5ᑖmnmnHṹmnpq1ᑖrstuvppqὺᵨyzὺᵨz▲mn1ᑖ|e|ᔊuvp~tᓫ1ᑖrstu|ᔊuyzQᑖ

31⊤@2008~12ᨴ29y0941:00|W4
||Iᦈ%:ὃ——ᙠᓽI%:nḄsᨬ¡¢ᦻ¤¥¦§¨©✌⚓,ᐵᦻ¤ᦪTUᭆW¬®%ᜩᦪTU°ᳮ²³ᵨ´ᦪTUGµᭆW¶®·᱐ᦪTUᦪT¹ẠTᭆ¼ᦪTUḄ¹᪀·½&ᦪTU°ᳮ"³ᵨᦪTU¾¿ḄᳮW"ÀÁᦈᦪTUḄÂ⌕ᱯhlf881216⊤2009~12ᨴ9y17:05:52IR4Äᑤ◀ÇÈÉÉÉÉÉriiiqpl⊤2009~12ᨴ21y21:51:03IP4Äᑤ◀ÊᑮÌᱏᕀÏpᵨᡝ⊤2009~12ᨴ25y13:0242IR4Äᑤ◀zs84102030⊤2009~12ᨴ28y15:0419IR4Äᑤ◀⊤W⊤WᑁÒᵨᡝpÓÔÕÖÏpWÏpᵨᡝ×ØṹÙÚÛ×ØṹCopyright©pengluerPoweredbyCSLNBlog