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

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

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

16.ᦪ
TUឋ?ᢣ)TUឋ஺7.ᦪ
Xᵨ0YZ[\ᐹ^_ᨵஹஹஹ)a஺8.^_ᦪ
bcᨵSQLServer)ஹ_________________a஺eஹ⌱g⚪(i⚪1ᑖᐳ10ᑖ)1.ᐵᑍmᦪ
ḄnoPpqrḄ?()OA.ᑍmḄtᙠv᧕ẚyᦪ
Ḅz᦮ឋB.ᑍmḄtᙠ|ᦪ
Ḅ}~C.pXᙠᦪ
Ptᑍmᦪ
D.ᑍmᦪ
?ᢣᵫᦪ
Ḅᦪ
2.ᭆ2TU()o

2A.ER2B,$ᜓC.DBMSD.3.ᑡnoqrḄ-஺A.ṹ?ឋ>⊤ᑡB.ṹ?ឋ>⊤C.ṹ?ឋᡈឋ¡>⊤ᑡD.ṹ?ឋᡈឋ¡>⊤4.ᦪ
7¢£¤¥᪀Ḅᑜᑖᨵᑭ©ᢝᦪ
ḄoA.ᦪ
TUឋB.ᦪ
«ᐰឋC.¥᪀%ᓄD.ឋ5.ᐵPḄ᎛⌱ᐵ¯°oA.±²^B.²C.´µ²D.±¶36.4ᵨḄᐵ·¸?ᐵ¹ᦪ)஺

3A.¡ᔠ¹ᦪB.»¼½¸C.ᐵ½¸D.¡ᔠ½¸7.ᙠ¾¿ὶPÁÂ2ÃQḄὶ?஺A.ὶB.²ὶC.²²ὶD.²ὶ8.Ä[ÅÆᩭÇÈᦪ
pÉឋ஺A.pÊᦋஹpÌFÍஹÎÍஹÏ┝B.pÌFÍஹÎÍஹÏ┝C.ÑᜫÊᦋஹÎÍஹÏ┝D.ÑᜫÊᦋஹpÌFÍஹÎÍ9.ᙠᦪ
ÓÔÕÖÃQ×⌴&'?3Ù஺A.ᐰÚÛ(B.ᐳឋÛ(C.Üᐳᦪ
ÝD.ÞßÝ10.ᦪ
Ḅ?ᢣᦪ
Ḅqrឋ)àvឋ஺A.«ᐰឋB.z᦮ឋC.Ä[áᑴD.ឮF

47ஹᑨä⚪i⚪1ᑖᐳ10ᑖpqrḄ⌕ᑏᳮᵫ1.ç£DDL?ᵨᩭèoᦪ
Ḅᱥᳮt¥᪀Ḅ஺2.êᐵ2Ḅëᐗ9íp>ᐰê஺3.⊤?îTUtᙠḄ⊤ᙠSQLPᐵïX⊤஺4.ᦪ
ð0ñDFD?ᵨèo¥᪀ᓄòóPôõ$ö▤øḄ\ᐹ஺5.ùᦪ
Púᒹüᡂ=ýþÿḄᑣᦪᡂᜐᐰ᝱6.ḄᢝឋᢣᒹḄᡠᨵ!⌕#$%!⌕#$&%஺7.DBᵨᡝḄᩗ▲,ᑖᐹᨵDBAᱯᩗḄᵨᡝ012DBᵨᡝ8.ᦪḄ345678Ḅᩩ:;<ᨵ=>?@ḄA஺

59.GREATTABLECD,EFGHIṹஹ᜜ṹஹM᯿⊤!PQRSTUVᙢ᡻YZ[\᦮ឋ0M᯿\᦮ឋ^ᑣ஺()10.ᑖbcᦪᦪdeឋᒹᦪḄfgdeឋஹᦪḄᱥᳮdeឋ0ᦪᑖbdeឋ஺()jஹ(kl⚪3ᑖ!ᐳ15ᑖ)oᨵᐵP4c!ᐸ(1)rs஺(2)tFḄᨬlvwxyz஺(3)t{Ḅᐵ|}஺(4)~Rᑖᐸ78BCNFF஺(5)~Rᑖᐸ783NFFᢝᦪxy஺ஹᔠ⚪(25ᑖ)

61.~RUSஹR-S=ᐵPᦪs⊤ᐵPs⊤c஺5ᑖ2.ᐵPᦪᨵᑡ>ᐵPᖪᖪ!ᖪ!ᕒᦪ!ᡠᙠᖪ¡ᖪ¡¢!ᖪ¡!w£ᖪ-ᖪ¡ᖪ!ᖪ¡¢!ᖪ¡ᦪ¥1ᵨALPHA¦§\ᡂᑡ4ᑖ¨©├«ᐰ¬ᖪ¡Ḅᖪ஺2ᵨᐵPᦪ\ᡂᑡ4ᑖ¨©ᕒᦪᜧ23ᖪ0ᖪ஺3¯ᵨSQL¦°ᑏ{ᑡ²³

7a´{ᕒᦪ&µ¶100ᡈὅᙠ¹ºḄᡠᨵᖪḄ0ᖪ஺4ᑖb´{»6¼ᒹḄᖪ஺4ᑖc´{½¾»6ᖪ¡233Ḅᖪᡠ»6Ḅᐰ¬ᖪ¡Ḅᖪ஺4ᑖ¿ஹor⚪kl⚪10ᑖ!ᐳ20ᑖÀÁÂÃÄÅeÁÆÇÂ3஺ÈᨵÉᧇk>ËᩭÍÎḄ>◤ÐᑏḄÑÁᐭÍÎ⊤ÓÔ▬⊤1;k>ËᩭÍÎḄÖ×◤ÐᑏḄÑÖ×ÆÇÍÎ⊤ÓÔ▬⊤2஺¯orÁஹØÙ0Ö×ḄZ[ὶPÛ!Ü~ᭆÞ45ßᣚᐵP4c஺▬⊤1:ÁᐭÍÎ⊤>¢ÍÎâã

8ឋä{åâãæçèé×▾᪥ì×íᔊὶPᵯðᵯñò:

9▬⊤2:Ö×ÆÇÍÎ⊤Ö×¢ÍÎâãÖ×óᙢᙬÖ×3ᙬØÙ◤tὶPὶPᵯð

10ᵯñò:Ö×õöᦪ÷ᳮ¯⚪øᫀAᔁÐû⚪kû1ᑖ!ᐳ20ᑖ1.ᐰឋ!\᦮ឋ!⊝¥᪗þ2.ᦪ᪀ᦪ᦮஺3.ᔠᓫ4.ᦪᦻ

115.ᭆᦪ6.ᱥᳮ7.C++,VB,Def,C#8.Oracle,Accessஹᓫ⚗⌱#⚪(&'⚪1ᑖᐳ10ᑖ)C,C,D,A,B,C,B,D,A,B+ஹᑨ-⚪(&'⚪1ᑖᐳ10ᑖ)F,T,T,F,T,F,T,T,T.ஹ(&'⚪3ᑖᐳ15ᑖ)/x={AD},x(0)=AD,x(1)=ACD,x(2)=ACD,ᦑ(AD)+=ACD1F234567ឋᓫ9ᓄ;

12F1:ACCABABCDADCᙠF12=ᣵ?@ḄBᦪ34;CDBA,ACᡠFBCG?@ḄHCDDA,ACᡠFDCG?@ḄF2:ACCABADABᦪ34Ḅᨬ'JGK9ḄL⚪MᫀJK9஺CDF22ᡠᨵ34ḄP6QGᓫ7ឋᡠFJRᙠ34P6?@

13Ḅ7ឋ஺ᡠFF:ACCABADA(3)CDDBᙠF2ḄHBᦪ34Ḅ562ᙳTUVᡠF᎛⌱ᐵYZ9[ᒹ]BD,_(BD)+=ABCDC`BDGRa9Ḅ᎛⌱ᐵYZ஺(4)ὃ⇋ACᡠFACJGBCNF(ACJᒹ]᎛⌱ᐵYZBD)1ABCDᑖdDACeABD஺ACfGBCNF,g9hᑖdABC⌱#BA,iABDᑖdDABeBD,`jABeADᙳDBCNF,ᡠFP={AC,BA,DA,BD)(5)RiAB

14cDACBADAa1a1a1a2a3a3a3a4kஹ1,RUS={t|P(t)US(t)'}

15R-S={t|P(t)?S(t)')(5ᑖ)2,(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ᑖ)(2)nsno,sna(8snu>23(SHOP))(3ᑖ)(3)(a)SELECTSNO.SNAFROMSHOP

16WHERECITY='lm'ORSNO<=100(3ᑖ)(b)SELECTSHOP.snaFROMSHOP,SHOP-GOODS,GOODSWHERESHOP.sno=SHOP-GOODS.snoANDGOODS.gna='nᒹSHOP-GOODS.gno=GOODS.gno(4ᑖ)(c)SELECTsnaFROMSHOPsxWHERENOTEXIST(SELECT*FROMGOODS-SHOPsyWHEREGOODS-SHOP.sno='223'ANDNOTEXIST

17(SELECT*FROMSHOP-GOODSszWHEREsy.gno=sz.gnoANDsx.sno=sz.sno))(5ᑖ)oஹpq⚪r⚪9;pqstஹuvewxḄyzὶ|}(5ᑖ)r⚪;ᣚᐵ|(5ᑖ)(b)suvᨬ(c)wxuvxᔊᜓ(d)sឋUx▾᪥xᔊnὶ|ᵯᵯsᔊᱯl

18ennwxwxwxὶ|sὶ|ᵯᙢᙬwx¡ᙬᵯwx¢ᦪ£¤ᳮ¥⚪Bᔁ9ஹ§¨⚪&¨2ᑖᐳ20ᑖ1ஹᐵ|2©ṹḄ«¬®K9¯°¨±Gᵫ᦮ឋ³ᑣµ[Ḅ஺2ஹ¶ᦪ£·ẚ¹º᝞¼½ᐜ¿RÀᦪ£ÁLe,ÂᨵÃÄឮÆᦪ£஺3ஹᦪ£ḄGᢣᦪ£ḄÈÉឋeÊËឋ஺4ஹᐵ|ᦪÌÍḄᱯÎGÏÐÑÒ¼ᙳDஹḄ°ÓÔឋÕஹÌÍ9zᓄஹÖ¯×ØᙠᦪᳮÙÚẠÜÝ஺

195ஹSQLG9Þ¢ßᐵ|àᦪeÜáḄÒ᪀ᓄḄãäÌÍ஺6ஹÏß&9᜜ᦪ£|æQᨵ9᧜Ðè[éÀê᜜ÑÜáḄÏëᐵ|஺7ஹì}G9◤⊤è9ï[éÂÃFeÚL⊤9᪵·ãäñ1ᨵ9[Ḅ▲ᑴ஺8ஹᦪô£G9☢ᔣ©⚪ḄஹஹJÃ÷øḄஹùjáJ-úᓄḄᦪᔠ஺9ஹûüý┝Ḅᓫÿ
ᵨḄᶍ஺10ஹᦪ
ᦪᢈᢈᔠḄ஺ஹ⌱⚪(!"⚪1ᑖ$ᐳ10ᑖ)1ஹSQL'$(ᑡ*+,-Ḅ./$012Ḅ
()

20A.AGEISNULLB.AGEISNOTNULLC.AGE=NULLD.NOT(AGEISNULL)2ஹᐵᦪ45Ḅ678ᡂ:ᑖ'$0ᒹ<()A.>᦮ឋAᑣB.ᦪ᪀C.ᦪ./D.DEFᑴ3ஹDB,DBMSDBS6ὅIḄᐵ
()A.DBᒹ

216ஹ3NF()AᓄuBCNF஺A.v◀ZxឋyṹḄ:ᑖ{ᦪ|}B.v◀ZxឋyṹḄ~⌴{ᦪ|}C.v◀xឋyṹḄ:ᑖ~⌴{ᦪ|}D.v◀ZZ{ᦪ|}Ḅ-|}7ஹ()
ᙠᑁḄᨵ8$LᐳḄᦪᔠ஺A.ᦪᳮB.ᦪC.ᦪD.ᦻ88ஹo71:nὶLᣚuo7UVḄᐵ4$ᐵḄṹu()A.ḄṹB.ᔜṹḄ8ᔠC.nḄṹD.!7Ḅṹ9ஹᙠᦪ'$ERᣚᡂᐵᦪ45Ḅ¡x¢()A.◤¤ᑖ᪆▤§B.¨©▤§C.ᭆ«▤§

22D.ᱥᳮ▤§10Lᐵ>ᜓḄ
ᢣ¯°OA.±²ᢝᐵᦪ᪀$0²ᢝᔠ´Ḅ./B.±²ᢝᐵᦪ᪀6µᐵ./C.²ᢝᐵᦪ᪀ᡠᨵḄᐵ·ᦪ./D.²ᢝᐵ45Ḅᡠᨵᱯ¹6ஹº»⚪¯!"⚪5ᑖ$ᐳ20ᑖ°1ஹᦪ'Ḅ¼½ᦑ¿ᨵÀÁÂ2ஹºÃᦪ45Ḅ678ᡂ:ᑖ஺3ஹᡠᨵḄÄ
ᔲÆLSTÂuÇÈÂ4ஹÇÈ᪵ḄDEÊa
12ḄÊaÂËஹ¯ᐳ10ᑖ°bcT1T2ÌÍyAḄ-./஺AḄÎ-
50$bcT1yAḄ-Ï10,bcT2yAḄ-^Ñ$

231ஹÒÓÔ7bcDE᡻g$ÕÖLM×஺2ஹØÙÚo7LÛgᓄÊa$DÙÚ᡻g×஺Üஹ¯ᐳ10ᑖ°yÝ-ß¡ᦪᨵ᝞(ḄáâãSELECTSnameFROMStudent,Cource,SCWHEREStudent.Sno=SC.SnoANDSC.Cno=Course.Course.CnoANDCourse.Cname='ᦪ'åáâ⌕¤⌱çjᦪḄᡠᨵÝḄèé஺¯1°êëÚᵨᐵ·ᦪ⊤íḄî᪛ð¯2°ykñḄî᪛ògóᓄ$ëÚóᓄôḄ᪗öî᪛஺÷ஹ¯ᐳ20ᑖ°ᨵÝ-ß¡ᦪ$ᐸᦪ4uãÝS¯ÝùSNO$èéSN$ᡠᙠSD$úSA°ஹÊᕈC¯ß

24¡ùCNO$ß¡èéCN$ᐜçßùPCNOஹýþSC¯ÝùSNO,ß¡ùCNO$ᡂÿGo1ஹ
ᵨᐵᦪALPHAᑖᑏᑡ1⌱2ḄḄ4ᑖ2⌱'ᦪ"#ᭆ%'Ḅ&'(4ᑖ3⌱ᐰ*Ḅஹ'(஺4ᑖ2ஹ
ᵨSQLᑏᑡ1,-ᦪ2ᑖ2⌱5./0Ḅ3ᑖ3ᑤ◀‘ᦪ"4᪀'6ᡠᨵ9:Ḅ⌱;<஺3ᑖ=ஹ>ᔠ⚪ᐳ10ᑖBᨵCD*EᵨFᒹH3IJK“MN”F“P”F“Q-”

25Rᨵ/SJTUPVWRXVWCIMNTIMNY/ὺᵨ[\PF9TIPὺᵨ]^ᨵὺᵨ_▲&ὺᵨa_CIQ-Y/ᵫcdḄPeᐸghFTIPY/e[\Q-giFTjgh^ᨵkga_஺BMNḄVឋᒹHMNṹFMN(nPḄVឋᒹHoF'(&pnQ-ḄVឋᒹH'(ஹqrஹosᓫU஺1ஹ
BuE-RvFwxVឋ&ὶz{஺2ஹ|E-Rv}ᣚeḄᐵ{ᒹHᐵ(Vឋ(&ṹ஺ᦪ"#ᳮ
⚪ᫀBᔁCஹ⚪T⚪2ᑖFᐳ20ᑖ1ஹJK2ஹaᦻ3ஹ᦮ឋ4ஹᐵ5ஹᐵ6ஹ᜜/7ஹ8ஹᡂḄ9ஹᐜᩭᐜ10ஹ-oஹ⌱⚪T⚪1ᑖFᐳ10ᑖ

261ஹC2ஹD3ஹB4ஹA5ஹB6ஹC7ஹC8ஹC9ஹB10ஹCஹ⚪T⚪5ᑖFᐳ20ᑖ1ஹᫀ⌕¢ᦪ"#£¤Ḅ¥¦ᦑ¨ᨵSᑁ*Ḅᦑ¨Sᦑ¨1ᑖஹ£ᦑ¨1ᑖஹª«ᦑ¨2ᑖஹu¬Q1ᑖ஺2ஹᫀ⌕¢ᦪ"{®¥ᵫᦪ"4᪀1ᑖஹᦪ"¯s2ᑖஹ᦮ឋ°±2ᑖ*ᑖ²ᡂ஺3ஹᫀ⌕¢c³ᡠᨵḄ´vµ³YḄ2ᑖ¶eᨵ·´vḄc¸Cᙢᨵº»ᙢ}ᣚᡂ9¼E½¾⊤ᙢ3ᑖ஺4ஹᫀ⌕¢ÀISḄÁÂ᡻ijÅÆḄFÇRXÇᐸ4ÈÉᢥËCjÌÍÄ᡻Ä:Î]Ḅ4ȼd5ᑖ஺Ïஹᐳ10ᑖ1ஹ80,90

272ஹT1T2SlockAA=50Y=AUnlockAXlockAA=Y-10SlockAᑏÐA=40ÑUnlockAÑA=40

28Y=AUnlockAXlockAA=YX2ᑏÐA=80UnlockAÒஹᐳ10ᑖÓஹᐳ20ᑖ1ஹᐵᦪ(1)sno(eno='2'(SC))(2ᑖ)

29(2)Sno.Sn(Cn='ᦪ"#ᭆ%,)(2ᑖ)(3)Sno,SN(S(Cno,sno(SC)+Cno(C)))(2ᑖ)ALPHAGETW(SC.SNO):SC.CNO='2'(2ᑖ)RANGECXSCYGETW(S.SNO.S.SN):X(Y(X.CNO=Y.CNOAY.SNO=S.SNOAX.CN='ᦪ"#ᭆ%'(2ᑖ)RANGECXSCYGETW(S.SNO.S.SN):X(Y(Y.CNO=X.CNOAY.SNO=S.SNO))(2ᑖ)

302.1SELECTCOUNT*FROMSTUDENT2ᑖ2SELECTSNOFROMSCGROUPBYSNOHAVINGCOUNT*L53ᑖ3DELECTFROMSCWHERESC.CNOINSELECTC.CNOFROMCWHERECN='ᦪ"4᪀,DELETEFROMCWHERECN='ᦪ"4᪀’3ᑖ=ஹᐳ10ᑖ5ᑖMNMNṹFMN(n1ᑖPoF'(F(nFὺᵨa_Fὺᵨ_▲FMN1

31ᑖQ-QᔊF'(FqrFosᓫU1ᑖkgPoFQᔊFkga_2ᑖÂ⊤W@2008q12ᨴ29a09:41:00|Ù%4|ÚÛ|ÝÞ|ᦈàáCâ:ὃ
åæCCᙠᓽ|Câ:éITḄ;êëìᨬîïᦻðñòóôõ✌⚓¼ᐵᦻðᦪ"#ᭆ%øùúCᜩᦪ"#ᳮ6Eᵨüᦪ"#£ᭆ%ýú᱐ᦪ"#ᦪ"½Ạ-
ᭆᦪḄ
᪀ᦪᳮᵨᦪḄᳮᦈᦪḄ⌕ᱯhlf881216⊤!2009"12ᨴ9$17:05:52IP:%&'(ᑤ◀+,-----riiiqpl⊤!2009"12ᨴ21$21:51:03IP:%&'(ᑤ◀/0ᑮ2ᱏᕀ56ᵨᡝ⊤!2009"12ᨴ25$13:02:42IP:%&'(ᑤ◀ZS84102030⊤!2009"12ᨴ28$15:04:19IP:%&'(ᑤ◀

32⊤8⊤9:8ᑁ<:ᵨᡝ6:=>?@56856ᵨᡝABṹ:CDEFABṹCopyright©pengluerPoweredbyCSDNBlog