某大学数据库期末模拟考试试题(AB卷)

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

ᦪ
ὃ⚪ᔡ✌ᜧᦪ
ᳮ⚪Aᔁஹ⚪1ᑖᐳ20ᑖ1.ᩭ!ᦪ
Ḅ#$%ஹᦪ
&'(Ḅ--------------*----------------+ᡂ-.&'ᓄ01Ḅ---------------------------------------------O2.ᦪ
234ᵫ6----------------ஹ-------------------*--------------89ᑖ:ᡂ஺3.<᪗Ḅ>?@A----------------Bᣚ-——-----------------------------------O4.ᨬ4ᵨḄᦪ
ḄឮGᢈI@-------------*------------------------------------O5.-----------------2@JKLMᑮ----------------Oᘤ2ḄQR᫑᫡஺

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

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

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

41.åDDL@ᵨᩭènᦪ
Ḅᱥᳮr¢᪀Ḅ஺2.ëᐵ2Ḅìᐗ:îo?ᐰë஺3.⊤@ðUVrᙠḄ⊤ᙠSQLQᐵóZ⊤஺4.ᦪ
õ0öDFD@ᵨèn¢᪀ᓄøùQúû$ü▤þḄ^ᐹ஺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ᔁ234⚪5641ᑖ8ᐳ20ᑖ21.:ᐰឋ8=᦮ឋ8⊝@᪗B2.ᦪ)C᪀8ᦪ)EF8=᦮GH஺3.JᔠL8ᓫL4.ᦪ)NO8LPᦻ5.ᭆS8ᦪ)TU

116.ᱥᳮ8WX7.C++,VB,Def,C#8.Oracle,AccessYஹᓫ⚗⌱]⚪(6_⚪1ᑖ8ᐳ10ᑖ)C,C,D,A,B,C,B,D,A,Baஹᑨc⚪(6_⚪1ᑖ8ᐳ10ᑖ)F,T,T,F,T,F,T,T,Tdஹ(6_⚪3ᑖ8ᐳ15ᑖ)ex=(AD),x(0)=AD,x(l)=ACD,x(2)=ACD,ᦑ(AD)+=ACD•hFijklmnឋᓫoᓄF1:ACCA

12BABCDADCᙠF1irᣵtuḄwᦪjkxyBA,ACᡠ{BC|tuḄ}xyDA,ACᡠ{DC|tuḄF2ACCABADAwᦪjkJḄᨬ_J|oḄ8⚪/ᫀo஺xyF2iᡠᨵjkḄm|ᓫnឋ8ᡠ{ᙠjkmtuḄnឋ஺

13ᡠ{F:ACCABADA(3)xyDBᙠFiḄ}wᦪjkḄlmiᙳ8ᡠ{᎛⌱ᐵoᒹBD,(BD)+=ABCDxBD|RoḄ᎛⌱ᐵ஺(4)ὃ⇋AC,ᡠ{AC|BCNF(ACᒹ᎛⌱ᐵBD),hABCDᑖyACABD஺AC|BCNF,oᑖABC⌱]BA,ABDᑖyABBD,ABADᙳyBCNF8ᡠ{P={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)SHOP-GOODS(sno,gno,num)RangeGOODSrxSHOP-GOODSryGETW(SHOP.SNA)rxry(ry.gno=rx.gnoshop.sno=ry.sno)(4ᑖ)ফnsno,sna(8snu>23(SHOP))(3ᑖ)(3)(a)SELECTSNO,SNAFROMSHOPWHERECITYJÌÍ8ORSNO<=100(3ᑖ)(b)SELECTSHOP,sna

16FROMSHOP,SHOP-GOODS,GOODSWHERESHOP.sno=SHOP-GOODS.snoANDGOODS.gna=‘ÒᒹSHOP-GOODS,gno=GOODS.gno(4ᑖ)(c)SELECTsnaFROMSHOPsxWHERENOTEXIST(SELECT*FROMGOODS-SHOPsyWHEREGOODS-SHOP.sno=,223'ANDNOTEXIST(SELECT*FROMSHOP-GOODSsz

17WHEREsy.gno=sz.gnoANDsx.sno=sz.sno))(5ᑖ)×ஹØÙ⚪Ú⚪oØÙ$Ûஹ!ḄÜÝὶÞ(5ᑖ)Ú⚪YNᣚᐵTà(5ᑖ)(b)á$
,!8ᨬâãä8(c)
,!8ᔊ8ãä8ᜓæ8(d)á$
8ç8ឋè8é8êë
8▾᪥,8ᔊ8Ò88ὶᵯ8ᵯ8á$&ᔊ8ᱯÌ(e)Ò8Ò
(
88ὶ$8ὶᵯ8ᙢᙬ8ᙬ,ᵯ8&')

18ᦪ)*+ᳮ-⚪Bᔁ2oஹ34⚪5642ᑖ8ᐳ20ᑖ21ஹᐵiíṹḄïðñòoóô48õ|ᵫ----------=᦮ឋ÷ᑣùḄ஺2ஹúᦪ)*ûẚýþ8᝞
ᐜᦪ-______________ᨵឮᦪ஺3ஹᦪḄ___________ᢣᦪḄឋឋ஺4ஹᐵ!ᦪ"#$%Ḅᱯ'("#)*+,ᙳ.----------ஹ"#Ḅ/01ឋ2ஹ$%34ᓄஹ6789ᙠᦪ;ᳮ=>Ạ@A஺5ஹSQL3BCDᐵ!Eᦪ------------@FḄ,᪀ᓄḄHI$%஺

196ஹ)DJ3K᜜MNᦪ!OPᨵ3K--------------᧜*,STUV᜜MN+MN@FḄ)Wᐵ!஺7ஹXY3K◤⊤S3\TU]>⊤3᪵_HI`--------"#aᨵ3TḄ▲ᑴ஺8ஹᦪd3K☢ᔣg⚪Ḅஹ____________ஹijkḄஹlmFinoᓄḄᦪpᔠ஺9ஹrst┝Ḅvᓫxyzᵨ---------------Ḅ|ᶍ஺10ஹ~!Ogᦪ!Oaᦪᢈ-------------ᢈ,ᔠḄ஺ஹ⌱⚪J⚪1ᑖᐳ10ᑖ1ஹSQLᑡḄ"#iḄA.AGEISNULLB.AGEISNOTNULLC.AGE=NULLD.NOTAGEISNULL
2ஹᐵ!ᦪMḄKᡂᑖiᒹ

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

21C.Ï◀gÑឋ)ṹḄᑖÖ⌴ÓᦪÔÕD.Ï◀/ØÙ7/ÓᦪÔÕḄÚÔÕ7ஹ()ÝÞßᙠàáâᑁḄᨵäᐳåḄᦪpᔠ஺A.ᦪæᳮ!OB.ᦪ!OC.ᦪD.ᦻèä8ஹ3K1:nὶ!]êᣚ.3K±9Ḅᐵ!MNᐵ!Ḅṹ.()A.ì4ḄṹB.ᔜì4ṹḄᔠC.nîì4ḄṹD.JKì4Ḅṹ9ஹᙠᦪïàaERYêᣚᡂᐵ!ᦪMḄ01ÑD()A.◤ðᑖ᪆▤óB.ôõïà▤óC.ᭆ÷ïà▤óD.ᱥᳮïà▤ó10ஹᐵ!ᜓḄ!Oᢣ()஺A.úûᢝᐵ!ᦪ,᪀iûᢝpᔠýḄ"#B.úûᢝ

22ᐵ!ᦪ,᪀Bᐵ!"#C.ûᢝᐵ!ᦪ,᪀ᡠᨵḄᐵ!Eᦪ"#D.ûᢝᐵ!MḄᡠᨵᱯÿஹ⚪⚪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