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

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

ᦪ
ὃ⚪ᔡ✌ᜧᦪ
ᳮ⚪Aᔁஹ⚪1ᑖᐳ20ᑖ1.ᩭ!ᦪ
Ḅ#$%ஹᦪ
&'(Ḅ--------------*----------------+ᡂ-.&'ᓄ01Ḅ---------------------------------------------O2.ᦪ
234ᵫ6----------------ஹ-------------------*--------------78ᑖ9ᡂ஺3.;᪗Ḅ=>?@----------------Aᣚ-——-----------------------------------O4.ᨬ4ᵨḄᦪ
ḄឮFᢈH?-------------*------------------------------------O5.-----------------2?IJKLᑮ----------------Nᘤ2ḄPQ᫑᫡஺

16.ᦪ
UVឋ?ᢣ___________*_____________UVឋ஺7.ᦪ
Zᵨ0[\]^ᐹ`aᨵ--------------ஹ________________ஹ_________________ஹ*_________________c஺8.`aᦪ
deᨵSQLServer*______________ஹ---------------c஺fஹ⌱h⚪i⚪1ᑖᐳ10ᑖ1.ᐵᑍlᦪ
ḄmnPopqḄ?஺A.ᑍlḄrᙠt᧕ẚwᦪ
Ḅx᦮ឋB.ᑍlḄrᙠzᦪ
Ḅ{|}~C.oZᙠᦪ
Prᑍlᦪ
D.ᑍlᦪ
?ᢣᵫᦪ
Ḅᦪ
2.ᭆ2UV஺

2A.ER2B.$ᜓC.DBMSD.3.ᑡmnpqḄ-஺A.ṹ?ឋ>⊤ᑡB.ṹ?ឋ>⊤C.ṹ?ឋᡈឋ>⊤ᑡD.ṹ?ឋᡈឋ>⊤4.ᦪ
7¡¢᪀Ḅᑜᑖᨵᑭ¦ᢝᦪ
Ḅ஺A.ᦪ
UVឋB.ᦪ
¨ᐰឋC.¢᪀%ᓄD.ឋ5.ᐵPḄ᎛⌱ᐵ¬஺A.®¯B.¯C.°±¯D.®²36.4ᵨḄᐵ³´?ᐵµᦪ*஺

3A.ᔠµᦪB.·¸¹´C.ᐵ¹´D.ᔠ¹´7.ᙠº»ὶP½¾2¿QḄὶ?஺A.ὶB.¯ὶC.¯¯ὶD.¯ὶ8.À]ÁÂᩭÃÄᦪ
oÅឋ஺A.oÆᦋஹoÈFÉஹÊÉஹË┝B.oÈFÉஹÊÉஹË┝C.ÍᜫÆᦋஹÊÉஹË┝D.ÍᜫÆᦋஹoÈFÉஹÊÉ9.ᙠᦪ
ÏÐÑÒ¿QÓ⌴&'?3Õ஺A.ᐰÖ×(B.ᐳឋ×(C.Øᐳᦪ
ÙD.ÚÛÙ10.ᦪ
Ḅ?ᢣᦪ
Ḅpqឋ*Ütឋ஺A.¨ᐰឋB.x᦮ឋC.À]ÝᑴD.ឮF7ஹᑨà⚪i⚪1ᑖᐳ10ᑖopqḄ⌕ᑏᳮᵫ

41.åDDL?ᵨᩭènᦪ
Ḅᱥᳮr¢᪀Ḅ஺2.ëᐵ2Ḅìᐗ9îo>ᐰë஺3.⊤?ðUVrᙠḄ⊤ᙠSQLPᐵóZ⊤஺4.ᦪ
õ0öDFD?ᵨèn¢᪀ᓄøùPúû$ü▤þḄ^ᐹ஺5.ᦪᒹᡂḄᑣᦪᡂᜐᐰ᝱6.Ḅᢝឋ"ᢣᒹ$Ḅᡠᨵ'()⌕+,-)⌕+,.-஺7.DBᵨᡝḄᩗ▲7ᑖᐹᨵDBAᱯᩗḄᵨᡝ<=>DBᵨᡝ8.ᦪḄ@ABCDEḄᩩG"HIᨵJKLMḄN஺9.CREATTABLEUV7WXYZ[ṹஹ᜜ṹஹ_᯿⊤)bcdef

5ghᙢ᡻klmn᦮ឋ<_᯿n᦮ឋpᑣ஺()10.ᑖstᦪᦪuvឋᒹ$ᦪḄwxuvឋஹᦪḄᱥᳮuvឋ<ᦪᑖsuvឋ஺(){ஹ(|}⚪3ᑖ)ᐳ15ᑖ)ᨵᐵbAt)ᐸ(1)஺(2)FḄᨬ}஺(3)Ḅᐵ஺(4)RᑖᐸDEBCNFX஺(5)RᑖᐸDE3NFXᢝᦪ஺ஹᔠ⚪(25ᑖ)1.RUSஹR-SJᐵbᦪ⊤¡¢ᐵb£⊤¤

6t஺5ᑖ2.ᐵbᦪᨵ¥ᑡ§Kᐵb¨ᖪªᖪª«)ᖪª¬)ªᕒ®ᦪ)ᡠᙠ°±ᖪ²ᖪ²³«)ᖪ²¬)´ᖪª=ᖪ²ᖪª«)ᖪ²³«)ᖪ²ᦪµ1ᵨALPHA¶·nᡂ¥ᑡ'(¨4ᑖ¸¹├»ᐰ¼ᖪ²Ḅᖪª½¬஺2ᵨᐵbᦪnᡂ¥ᑡ'(¨4ᑖ¸¹ªᕒ®ᦪᜧ23ᖪª«<ᖪª¬஺3¿ᵨSQL¶Àᑏ¥ᑡÂèaĪᕒ®ᦪ.ÅÆ100®ᡈὅᙠÉʱḄᡠᨵᖪªḄ«<ᖪª¬஺4ᑖ

7bÄËCÌᒹḄᖪª¬஺4ᑖc
ÄÍÎËCᖪ²«233ḄᖪªᡠËCḄᐰ¼ᖪ²Ḅᖪª¬஺4ᑖÏஹ⚪|}⚪10ᑖ)ᐳ20ᑖб®ÑÒÓÔÕv®ÑÖ×Ò@஺ØᨵÙᧇ¨|KÛᩭÝÞḄK®◤àᑏḄá®ÑᐭÝÞ⊤ãä▬⊤1æ|KÛᩭÝÞḄçè◤àᑏḄáçèÖ×ÝÞ⊤ãä▬⊤2஺¿®Ñஹéê<çèḄlmὶbì)íᭆïABðᣚᐵbAt஺▬⊤1:®ÑᐭÝÞ⊤K®³«¨ÝÞóô½¬ឋõ

8öóô÷øù«úè▾᪥ýèþᔊὶ
ᵯᵯ

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

10ᦪ"#$ᳮ&⚪(ᫀAᔁ+,-⚪./-1ᑖ1ᐳ20ᑖ+1.3ᐰឋ16᦮ឋ1⊝9᪗;2.ᦪ"<᪀1ᦪ">?16᦮@A஺3.CᔠE1ᓫE4.ᦪ"GH1EIᦻ5.ᭆL1ᦪ"MN

116.ᱥᳮ1PQ7.C++,VB,Def,C#8.Oracle,AccessRஹᓫ⚗⌱V⚪(/X⚪1ᑖ1ᐳ10ᑖ)C,C,D,A,B,C,B,D,A,BZஹᑨ\⚪(/X⚪1ᑖ1ᐳ10ᑖ)F,T,T,F,T,F,T,T,T]ஹ(/X⚪3ᑖ1ᐳ15ᑖ)^x={AD},x(0)=AD,x(l)=ACD,x(2)=ACD,ᦑ(AD)+=ACD•aFbcdefgឋᓫhᓄF1:ACCA

12BABCDADCᙠF1bkᣵmnḄpᦪcdqrBA,ACᡠtBCumnḄvqrDA,ACᡠtDCumnḄF2:ACCABADApᦪcdCḄᨬXCxuyhḄ1z⚪(ᫀxyh஺qrF2bᡠᨵcdḄ|f}uᓫgឋ1ᡠtx~ᙠcd|fmnḄgឋ஺

13ᡠtF:ACCABADA(3)qrDBᙠFbḄvpᦪcdḄefbᙳ1ᡠt᎛⌱ᐵhᒹBD,(BD)+=ABCDqBDuRhḄ᎛⌱ᐵ஺(4)ὃ⇋AC,ᡠtACxuBCNF(ACxᒹ᎛⌱ᐵBD),aABCDᑖrACABD஺ACuBCNF,hᑖABC⌱VBA,ABDᑖrABBD,ABADᙳrBCNF1ᡠtP={AC,BA,DA,BD}(5)RiABCD

14ACBADAa1a1a1a2a3a3a3a4ஹ1,RUS={t|P(t)US(t)'}R-S={t|P(t)?S(t)'}(5ᑖ)

152,(1)SHOP(sno,sna,snu,city)GOODS(gno,gna,price)SHOPGOODS(sno,gno,num)RangeGOODSrxSHOPGOODSryGETW(SHOP.SNA)rxry(ry.gno=rx.gnoshop.sno=ry.sno)(4ᑖ)ফnsno,sna(8snu>23(SHOP))(3ᑖ)(3)(a)SELECTSNO,SNAFROMSHOPWHERECITYJÅÆzORSNO<=100(3ᑖ)(b)SELECTSHOP,sna

16FROMSHOP,SHOPGOODS,GOODSWHERESHOP.sno=SHOPGOODS.snoANDGOODS.gna=zËᒹSHOPGOODS,gno=GOODS.gno(4ᑖ)(c)SELECTsnaFROMSHOPsxWHERENOTEXIST(SELECT*FROMGOODSSHOPsyWHEREGOODSSHOP.sno=,223'ANDNOTEXIST(SELECT*FROMSHOPGOODSsz

17WHEREsy.gno=sz.gnoANDsx.sno=sz.sno))(5ᑖ)ÏஹÐÑ⚪Ò⚪hÐÑÓஹḄÔÕὶ
Ö(5ᑖ)Ò⚪RGᣚᐵ
MØ(5ᑖ)(b)Ù,1ᨬÚÛÜ1(c),1ÝÞᔊ1ÛÜ1ᜓá1(d)Ù1â1ឋã1ä1åæç1è▾᪥,Ý1Þᔊ1çË11ὶ
ᵯ1ᵯ1Ùᔊ1ᱯÅ(e)çË1çË(11ὶ
1ὶ
ᵯ1ᙢᙬ1ᙬ,ᵯ1)

18ᦪ"#$ᳮ&⚪Bᔁ+hஹ,-⚪./-2ᑖ1ᐳ20ᑖ+1ஹᐵ
bìṹḄîïðñyhòó-1ôuᵫ6᦮ឋöᑣøḄ஺2ஹùᦪ"#úẚüý1᝞ÿᐜᦪ-______________ᨵឮᦪ஺3ஹᦪḄ___________ᢣᦪḄឋឋ஺4ஹᐵᦪ!"Ḅᱯ$%&'()*ᙳ,----------ஹḄ./0ឋ1ஹ!"23ᓄஹ5678ᙠᦪ:ᳮ<=Ạ?@஺5ஹSQL2ABCᐵDᦪ------------?EḄ)᪀ᓄḄGH!"஺

196ஹ&CI2J᜜LMNᦪOPᨵ2J--------------᧜',STUV᜜LM(LM?EḄ&Wᐵ஺7ஹXY2J◤⊤NS2\TU]=⊤2᪵_GHN`--------aᨵ2TḄ▲ᑴ஺8ஹᦪd2J☢ᔣg⚪Ḅஹ____________ஹijkḄஹlmEinoᓄḄᦪpᔠ஺9ஹrst┝Ḅvᓫxyzᵨ---------------Ḅ|ᶍ஺10ஹ~OgᦪOaᦪᢈ_____________ᢈ)ᔠḄ஺ஹ⌱⚪I⚪1ᑖNᐳ10ᑖ1ஹSQLNᑡḄNiḄA.AGEISNULLB.AGEISNOTNULLC.AGE=NULLD.NOTAGEISNULL
2ஹᐵᦪLḄJᡂᑖNiᒹ

20A.᦮ឋᑣB.ᦪ)᪀C.ᦪD.5¡¢ᑴ3ஹDB,DBMSDBSὅEḄᐵA.DBᒹDBMSDBSB.DBSᒹDBDBMSC.DBMSᒹDBSDBD.DBS(DBஹDBMSªᐵ4ஹᦪḄ5¡¬ᩭḄ®⚪ᒹA.¯ᜫjkB.ᦪ±8ឋ²³´C..yᵨᡝḄ¶ᵨD.·¸ᦪḄᑍº»5ஹ5¡½Ḅ¾¿᡻ÁẚýḄA.ÄÅឋB.◞ÇឋC.2ÈឋD.ÉÊឋ6ஹ3NFᓄ,BCNF஺A.Ï◀.gÑឋ&ṹḄᑖÓᦪÔÕB.Ï◀.gÑឋ&ṹḄÖ⌴ÓᦪÔÕ

21C.Ï◀gÑឋ&ṹḄᑖÖ⌴ÓᦪÔÕD.Ï◀.ØÙ6.ÓᦪÔÕḄÚÔÕ7ஹ()ÝÞßᙠàáâᑁḄᨵäNᐳåḄᦪpᔠ஺A.ᦪæᳮOB.ᦪOC.ᦪD.ᦻèä8ஹ2J1:nὶ]êᣚ,2J±8ḄᐵLMNᐵḄṹ,()A.ì3ḄṹB.ᔜì3ṹḄᔠC.nîì3ḄṹD.IJì3Ḅṹ9ஹᙠᦪïàNaERYêᣚᡂᐵᦪLḄ/0ÑC()A.◤ðᑖ᪆▤óB.ôõïà▤óC.ᭆ÷ïà▤óD.ᱥᳮïà▤ó10ஹᐵᜓḄOᢣ()஺A.úûᢝᐵᦪ)᪀NiûᢝpᔠýḄB.úûᢝ

22ᐵᦪ)᪀AᐵC.ûᢝᐵᦪ)᪀ᡠᨵḄᐵDᦪD.ûᢝᐵLḄᡠᨵᱯÿஹ⚪⚪5ᑖᐳ20ᑖ1ஹᦪḄᦑᨵ2ஹᦪḄᡂ!ᑖ஺3ஹᡠᨵḄ$%&ᔲ()*+,-./4ஹ./᪵Ḅ1234&56Ḅ347ஹᐳ10ᑖ89T1:T2;<=AḄ>?@஺AḄA>&50,89T1=AḄ>B10,89T2=AḄ>CD1ஹEFG8912᡻IJK)LMN஺2ஹOPQR)SIᓄ341PQ᡻IMN஺

23Vஹᐳ10ᑖ=WX-Z[ᦪᨵ᝞]Ḅ^_:SELECTSnameFROMStudent,Cource,SCWHEREStudent.Sno=SC.SnoANDSC.Cno=Course.Course.CnoANDCourse.Cname=/ᦪ'b^_⌕d⌱fgᦪḄᡠᨵWXḄhi஺1jkQᵨᐵnᦪ⊤pḄqr᪛t2=uvḄqr᪛wIxᓄkQxᓄyḄ᪗{qr᪛஺|ஹᐳ20ᑖ}ᨵWX-Z[ᦪᐸᦪ-WXSWSNO,hiSN,ᡠᙠSD,SAஹZ[CZ[CNO,Z[hiCN,ᐜfZPCNOஹWX⌱ZSCWSNO,Z[CNOᡂG஺1ஹjᵨᐵnᦪALPHAqqᑖᑏQ]ᑡ^_:

241^_⌱fg2Z[ḄWXḄWt4ᑖ2d⌱g'ᦪᭆḄWXW:hit4ᑖ3d⌱fgᐰ!Z[ḄWXWஹhi஺4ᑖ2ஹjᵨSQLqᑏQ]ᑡ^_1^_WXᦪt2ᑖ2^_⌱fg5*Z[ḄWXWt3ᑖ3ᑤ◀'ᦪM᪀Z[ᡠᨵ=Ḅ⌱Z¡¢஺3ᑖ£ஹ¤ᔠ⚪ᐳ10ᑖ}ᨵR§!¨ᵨᒹª3«¬“®¯”“±X”“²”³ᨵ*]8«´±Xµ¶³·µ¶R®¯t®¯)*ὺᵨE¹±X=±Xὺᵨ<ºᨵὺᵨ»▲:ὺᵨ½»tR²)*ᵫ¿;Ḅ±X-ᐸÀÁ±X)*-E¹²ÀÂÃÀÁºᨵÄÀ½»஺}®¯Ḅµឋᒹª®¯nṹ®¯iÇt±XḄµឋᒹªÈhi:ÉÇt²ḄµឋᒹªhiஹஹÈ@ᓫ´஺

251ஹj}ËE-R%Ì͵ឋ:ὶÏ஺2ஹÐE-R%Ñᣚ-ÓÔḄᐵᒹªᐵiµឋi:ṹ஺ᦪuᳮj⚪ᫀBᔁRஹØÙ⚪⚪2ᑖᐳ20ᑖ1ஹ«¬2ஹ½ÚᦻÜ3ஹÝ᦮ឋ4ஹᐵ5ஹᐵßà6ஹ᜜/7ஹ+,8ஹãᡂḄ9ஹᐜᩭᐜå910ஹÈæLçஹ⌱è⚪⚪1ᑖᐳ10ᑖ1ஹC2ஹD3ஹB4ஹA5ஹB6ஹC7ஹC8ஹC9ஹB10ஹCஹ⚪⚪5ᑖᐳ20ᑖ

261ஹᫀ⌕éᦪḄᦑᨵ89ᑁ!Ḅᦑ89ᦑ1ᑖஹᦑ1ᑖஹëìᦑ2ᑖஹËàí²î1ᑖ஺2ஹᫀ⌕éᦪïᵫᦪM᪀1ᑖஹᦪ?@2ᑖஹÝ᦮ឋðñ2ᑖ!ᑖᡂ஺3ஹᫀ⌕é¿&ᡠᨵḄ$%(&)+,Ḅ2ᑖtò-ᨵ$%Ḅ+,¿LóRᙢᨵõöᙢÑᣚᡂ=÷¨øù⊤ᙢ+,3ᑖ஺4ஹᫀ⌕éú89Ḅ12᡻I&56Ḅû³·ûᐸMNüᢥþRÃÿ
᡻
Ḅ5ᑖ஺ஹᐳ10ᑖ1ஹ80,902ஹT1T2SlockA

27A=50Y=AUnlockAXlockAA=Y-10SlockAᑏA=40UnlockAA=40Y=AUnlockA

28XlockAA=YX2ᑏA=80UnlockA%ஹ(ᐳ10ᑖ))ஹ(ᐳ20ᑖ)1ஹᐵ+,ᦪ.(1)sno(eno='22(SC))(2ᑖ)(2)Sno,Sn(Cn=zᦪ78ᭆ:z)(2ᑖ)(3)Sno,SN(S(Cno,sno(SC)Cno(C)))(2ᑖ)

29ALPHA@AGETW(SC.SNO):SC.CNO='2'(2ᑖ)•RANGECXSCYGETW(S.SNO.S.SN):X(Y(X.CNO=Y.CNOAY.SNO=S.SNOAX.CN='ᦪ78ᭆ:2(2ᑖ)RANGECXSCYGETW(S.SNO,S.SN):X(Y(Y.CNO=X.CNOAY.SNO=S.SNO))(2ᑖ)2.(1)SELECTCOUNT(*)FROMSTUDENT(2ᑖ)ফSELECTSNOFROMSC

30GROUPBYSNOHAVINGCOUNT*S53ᑖবDELECTFROMSCWHERESC.CNOINSELECTC.CNOFROMCWHERECN='ᦪ7᪀'DELETEFROMCWHERECN=2ᦪ7᪀23ᑖWஹᐳ10ᑖ5ᑖXYXY,ṹ2XY[\1ᑖ]^_`2a[2[\2ὺᵨde2ὺᵨe▲2XY1ᑖghgᔊ`2a[2jk2_lᓫnaᑖpq]^_`2gᔊ`2pqde2ᑖ

31r⊤ta2008j12ᨴ29d09:41:00Iv:4|xy|z{Iᦈ}~:ὃ——ᙠᓽI.ITḄ^ᨬᦻ✌⚓ᐵᦻᦪ78ᭆ:ᜩᦪ78ᳮ¢£ᵨ¤ᦪ78+¥ᭆ:¦§᱐ᦪ78ᦪ7©Ạ©«ᭆ¬ᦪ78Ḅ©«᪀§®¯ᦪ78ᳮ°£ᵨᦪ78±²Ḅᳮ:°³´ᦈ}ᦪ78Ḅµ⌕ᱯ¸hlf881216r⊤t2009j12ᨴ9d17:05:52IP:z{¹ᑤ◀¼½¾¾¾¾¾riiiqplr⊤t2009j12ᨴ21d21:51:03IP:z{¹ᑤ◀¿ᑮÁᱏᕀÄ[ᵨᡝr⊤t2009j12ᨴ25d13:02:42IP:z{¹ᑤ◀ZS84102030r⊤t2009j12ᨴ28d15:04:19IP:z{¹ᑤ◀r⊤v:⊤.v:ᑁÇ.ᵨᡝ[.ÈÉÊËÄ[v:Ä[ᵨᡝÌÍṹ.ÎÏÐÌÍṹCopyright©pengluerPoweredbyCSDNBlog