数据库期末模拟考试试题1(AB卷)

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

ᦪ
ὃ⚪ᦪ
ᳮ⚪ஹ⚪1ᑖᐳ20ᑖ1.ᩭᦪ
Ḅ!ஹᦪ
"#$Ḅ%'ᡂ)*"#ᓄ,-Ḅ_______________________________________________O2.ᦪ
./0ᵫ2ஹ%________________45ᑖ6ᡂ஺3.8᪗Ḅ:;<=>ᣚ)O4.ᨬ0ᵨḄᦪ
ḄឮCᢈE<%o5..

16.ᦪ
QRឋ<ᢣ%QRឋ஺7.ᦪ
Uᵨ,VWXYᐹ[\ᨵஹஹஹ%8.[\ᦪ
^_ᨵ`Server%aஹ⌱c⚪d⚪1ᑖᐳ10ᑖ1.ᐵᑍgᦪ
ḄhiMjklḄ<0OA.ᑍgḄmᙠo᧕ẚrᦪ
Ḅs᦮ឋB.ᑍgḄmᙠuᦪ
Ḅvwxyz{C.jU|ᙠᦪ
Mm}~ᑍgᦪ
D.ᑍgᦪ
<ᢣᵫᦪ
Ḅᦪ
2.ᭆ.QR஺஺A.ER.B.ᜓC.EBVBD.

23.ᑡhiklḄ)஺Aṹ<ឋ;⊤ᑡBṹ<ឋ;⊤Cṹ<ឋᡈឋ;⊤ᑡDṹ<ឋᡈឋ;⊤4.ᦪ
4᪀Ḅᑜᑖᨵᑭ¡ᢝᦪ
Ḅ஺஺A.ᦪ
QRឋB.ᦪ
£ᐰឋC.᪀!ᓄD.ឋ5.ᐵMḄ᎛⌱ᐵ§¨஺A.©ªB.ªC.«¬ªD.©36.0ᵨḄᐵ®¯<ᐵ°ᦪ%஺A.ᔠ°ᦪB.²³´¯C.ᐵ´¯D.ᔠ´¯

37.ᙠµ¶ὶM¸¹.ºNḄὶ<஺A.ὶB.ªὶC.ªªὶD.ªὶ8.»X¼½ᩭ¾¿ᦪ
jÀឋ஺A.jÁᦋஹjÃCÄஹÅÄஹÆ┝B.jÃCÄஹÅÄஹÆ┝C.ÈᜫÁᦋஹÅÄஹÆ┝D,ÈᜫÁᦋஹjÃCÄஹÅÄ9.ᙠᦪ
ÊËÌͺNÎ⌴"#

41.àá<ᵨᩭâiᦪ
Ḅᱥᳮm}᪀Ḅ஺2.åᐵ.Ḅ~æᐗ6èj;ᐰå஺஺3.⊤<êQRmᙠḄ⊤ᙠëMᐵìU⊤஺4.ᦪ
î,ïIM<ᵨâi᪀ᓄòóMôõö▤øḄYᐹ஺5.úᦪ
Mûᒹýᡂ:þÿ
Ḅᑣᦪᡂᜐᐰ᝱6.ḄᢝឋᢣᒹḄᡠᨵ#$%⌕'()%⌕'(*)஺஺7.-ᵨᡝḄᩗ▲2ᑖᐹᨵ2ᱯᩗḄᵨᡝ678-ᵨᡝ8.ᦪḄ:;<=>?ḄᩩABCᨵDEFGḄH஺9.CEE⇧NXBLEQR2STUVWṹஹ᜜ṹஹ[᯿⊤%^_`abcdᙢ᡻ghij᦮ឋ6[᯿j᦮ឋlᑣ஺

510.ᑖmnᦪᦪopឋᒹᦪḄqropឋஹᦪḄᱥᳮopឋ6ᦪᑖmopឋ஺()wஹ(xy⚪3ᑖ%ᐳ15ᑖ)|ᨵᐵ^;n%ᐸ(1)஺(2)FḄᨬy஺(3)Ḅᐵ஺(4)Rᑖᐸ>?BCNFT஺(5)Rᑖᐸ>?3NFTᢝᦪ஺ஹᔠ⚪(25ᑖ)1.RUSஹR-SDᐵ^ᦪ⊤ᐵ^⊤n஺(5ᑖ)

62.ᐵ^ᦪᨵ¡ᑡ£Eᐵ^:ᖪ¦ᖪ¦§%ᖪ¦¨%¦ᕒªᦪ%ᡠᙠ¬ᖪ®ᖪ®¯§%ᖪ®¨%°ᖪ¦7ᖪ®ᖪ¦§%ᖪ®¯§%ᖪ®ᦪ±1
ᵨALHA²³jᡂ¡ᑡ#$´4ᑖµ¶├¸ᐰ¹ᖪ®Ḅᖪ¦º¨஺2
ᵨᐵ^ᦪjᡂ¡ᑡ#$´4ᑖµ¶¦ᕒªᦪᜧ23ᖪ¦§6ᖪ¦¨஺3
¼ᵨ½²¾ᑏ¡ᑡÀÁ´a
¦ᕒªᦪ*ÃÄ100ªᡈὅᙠÇÈḄᡠᨵᖪ¦Ḅ§6ᖪ¦¨஺4ᑖ

7bÂÊ=ËᒹḄᖪ¦¨஺4ᑖcÂÎÏÊ=ᖪ®§233Ḅᖪ¦ᡠÊ=Ḅᐰ¹ᖪ®Ḅᖪ¦¨஺4ᑖÒஹ|⚪xy⚪10ᑖ%ᐳ20ᑖÕªÖ
×ØÙÚpªÖÛÜ
×:஺ÝᨵÞᧇ´xEàᩭâãḄEª◤åᑏḄæªÖᐭâã⊤èé▬⊤1ëxEàᩭâãḄìí◤åᑏḄæìíÛÜâã⊤èé▬⊤2஺¼|ªÖஹîï6ìíḄhiὶ^ñ%òᭆô;<õᣚᐵ^;n஺▬⊤1´ªÖᐭâã⊤Eª¯§´âã÷øº¨ឋù

8ú÷øûüý§þí▾᪥
ᔊὶᵯᵯ

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

10#$ᦪ&'(ᳮ*⚪,ᫀ6ᔁ01.34⚪5641ᑖ9ᐳ20ᑖ01.=ᐰឋ9@᦮ឋ9⊝C᪗E2.ᦪ&F᪀9ᦪ&HI9@᦮JK஺3.NᔠP9ᓫP4.ᦪ&ST9PUᦻᭆX9ᦪ&YZ

116.ᱥᳮ9\]7.GH^Def,08.Oracle,Access_ஹᓫ⚗⌱c⚪56d⚪1ᑖ9ᐳ10ᑖ0C,C,D,A,B,C,B,D,A,eஹᑨg⚪56d⚪1ᑖ9ᐳ10ᑖ0F,T,T,F,T,F,T,T,Thஹ56d⚪3ᑖ9ᐳ15ᑖ0iߟk9x1
^CQxQ
^CQᦑu+^CDmFnopqrsឋᓫ1ᓄF1:ACCA

12BABCDADCᙠF1nwᣵyzḄ|ᦪop}~BA,ACᡠBCyzḄ}~DA,ACᡠDCyzḄF2:ACCABADA|ᦪopNḄᨬdN1Ḅ9⚪,ᫀ1஺}~F2nᡠᨵopḄrᓫsឋ9ᡠᙠopryzḄsឋ஺ᡠF:ACCA

13BADA(3)}~ᙠFnḄ|ᦪopḄqrnᙳ9ᡠ᎛⌱ᐵ1ᒹᵪ9(n)+uWD}ᓽR1Ḅ᎛⌱ᐵ஺(4)ὃ⇋AC,ᡠA3(A2ᒹ᎛⌱ᐵᵪ)9mABCDᑖ~A3¡¢஺A2£BOW,¤1¥ᑖABC⌱cBA,¦Anᑖ~AB¡ᵪ9§AB¡¨ᙳ~BCNF,ᡠP=ª9BA,D\,ᵪ(5)RiABCD

14ABAEAa1a1a1a2a3a3a3a4«ஹ1,RUS={t|P(t)US(t)}RS{t|P(t)?S(t)}(5ᑖ)

152,(1)SECP(sno,sna,snu,citᑘG3CDS(gno,gna,pricq)SEEP-G3CD6(sno,gngnun)RangeCUBSrxSETP-GITSryGETW(5IPrxry(ry.gno=rxgnoshop.sno=ry.SDQ)(4ᑖ)Q)nsno,sna(Ssnu>23(SO))(3ᑖ)(3)Q)SELECT9SQ9^FKMSEEPWERECITr^ÒÓ'CR805=100(3ᑖ)যSELECTsna

16FKMSEI^SETP-OII^GIDSVHERESIPsno=^FCP-G3CE8sno×DG3CDSgna=^ØᒹSETP-GIE8gno=COCDSgno(4ᑖ)©SELECTsnaFKMSEEPsxWERENDTEXISr(SELECT*FKMG3CDS-SrPsyWIEREG3CDS-SETP.sno^223’ÙDN3JE3ST(SELECT*FRCMSETP-G3CESsz

17VHEREsy.gno=sz.gno/NDsxsno=sz.SHQ))(5ᑖ)ÚஹÛÜ⚪Ý⚪1ÛÜ!Þஹ¡Ḅßàὶá(5ᑖ)Ý⚪_SᣚᐵYã(5ᑖ)(b)ä!99ᨬåæç(c)9
ᔊ9æç9ᜓé9(d)ä!ê9ឋë9Ù9ìíî9ï▾᪥,
9ᔊ9îØ99ὶᵯ9ᵯ9ä!#ᔊ9ᱯÒ(e)îØ9îØ(99ὶ!9ὶᵯ9ᙢᙬ9ᙬ,ᵯ9#$)

18ᦪ&'(ᳮ*⚪Ꮨ01ஹ34⚪5642ᑖ9ᐳ20ᑖ01ஹᐵnóṹḄõö÷ø1ùú49ûᵫ@᦮ឋýᑣÿḄ஺2ஹᦪẚ᝞ᐜᦪ,ᨵឮᦪ஺4ᦪḄᢣᦪḄ!"ឋ$%ឋ஺4ᐵ'ᦪ()*+Ḅᱯ-.()/012ᙳ4ஹ()Ḅ567ឋ8ஹ*+9:ᓄஹ<=>?ᙠᦪAᳮCDẠFG஺HI9JKLᐵ'MᦪFNḄ2᪀ᓄḄPQ*+஺&/LS9T᜜VWᦪ'XYᨵ9T᧜0,

19[\]᜜VW1VWFNḄ/^ᐵ'஺7ஹ_`9T◤⊤[9c\dD⊤9᪵PQf()gᨵ9Ḅ▲ᑴ஺&ᦪj9T☢ᔣm⚪ḄஹஹopqḄஹrsNotuᓄḄᦪvᔠ஺\xyz┝Ḅ|ᓫ~ᵨḄᶍ஺10ஹ'Xmᦪ'Xgᦪᢈᢈ$2ᔠḄ஺ஹ⌱⚪S⚪1ᑖᐳ10ᑖ1ஹᑡḄ()o!"Ḅ஺A.AEISNULLB.AEISNJTNULLC.AZE^ULLD.NDT0GEISMH
2ᐵ'ᦪVḄTᡂᑖoᒹ¡஺

20A.¢᦮ឋ¤ᑣB.ᦪ2᪀C.ᦪ()D.<¦§ᑴ¨IE@▭ὅNḄᐵ'A.IBᒹ¡ZEVBLBSB.▭ᒹ¡¬EEC.:ffiVBᒹ¡▭¬D.®S1EBஹIEVE¯ᐵ4ᦪḄ<¦()°ᩭḄ²⚪ᒹ¡஺A.³ᜫpqB.ᦪµ?ឋ¶·¸C.5ᵨᡝḄºᵨD.»¼ᦪḄᑍ¾¿H<¦ÀḄÁÂ᡻ÄẚÀḄA.ÅÆឋB.◞ÈឋC.9ÉឋD.ÊËឋ6.3NF()¤ᓄ4BOToA.Í◀5mÏឋ/ṹḄᑖÑᦪÒÓB.Í◀5mÏឋ/ṹḄÔ⌴ÑᦪÒÓC.Í◀mÏឋ/ṹḄᑖÔ⌴ÑᦪÒÓD.Í◀5Ö×

21=5ÑᦪÒÓḄØÒÓ7.()ÛÜÝᙠÞßàᑁḄᨵâᐳãḄᦪvᔠ஺A.ᦪäᳮ'XB.ᦪ'XC.ᦪD.ᦻæâ&9T1:nὶ'dèᣚ49Tµ?Ḅᐵ'VWᐵ'Ḅṹ4()A.ê:ḄṹBᔜê:ṹḄᔠCnìê:ḄṹDSTê:Ḅṹ9.ᙠᦪíÞgER`èᣚᡂᐵ'ᦪVḄ67ÏL()A◤îᑖ᪆▤ñBòóíÞ▤ñCᭆõíÞ▤ñDᱥᳮíÞ▤ñ1Qᐵ'¢ᜓḄ'Xᢣ()஺Aøùᢝᐵ'ᦪ2᪀oùᢝvᔠûḄ()Bøùᢝᐵ'ᦪ2᪀Jᐵ'()

22Cùᢝᐵ'ᦪ2᪀ᡠᨵḄᐵ'Mᦪ()Dùᢝᐵ'VḄᡠᨵᱯýஹ|þ⚪S⚪5ᑖᐳ20ᑖ1ஹᦪ'XḄÿᦑᨵ2ஹᦪḄᡂᑖ஺3ஹᡠᨵḄᔲ!"4ஹ!"᪵Ḅ$%&'()Ḅ&'*ஹ+ᐳ10ᑖ-./T10T2123AḄ456஺AḄ7450,./T13AḄ4810,./T23AḄ49:;1ஹ<=>./$%᡻@;ABCDE஺2FGHIJ@ᓄ&';$GH᡻@DE஺Lஹ+ᐳ10ᑖ-3MNIOPᦪQᨵ᝞SḄTU:

23SELECTSnameFRCMStudent,Cource,SCWEREStudent.Sno=SCSnoSCCno=Course.CourseCnoCourse.CnamoᦪQ'qTU⌕s⌱uvᦪQḄᡠᨵMNḄwx஺+1-z{Hᵨᐵ~ᦪ⊤Ḅ᪛+2-3Ḅ᪛@ᓄ;{HᓄḄ᪗᪛஺ஹ+ᐳ20ᑖ-ᨵMNIOPᦪQ;ᐸᦪQMNS+M8஺;wxSN,ᡠᙠ~SD,SA-ஹOPC+OPCN3,OPwx+N,ᐜuOPCND-ஹMN⌱OSC+MSND,OPCND,ᡂG-஺1ஹzᵨᐵ~ᦪ;ALPHA¢¢ᑖ£ᑏHSᑡTU+1-TU⌱uv2OPḄMNḄM+4ᑖ-

24+2-s⌱§v'ᦪQᭆ©’ḄMNM0wx+4ᑖ-+3-s⌱uvᐰOPḄMNMஹwx஺+4ᑖ-2ஹzᵨ&¢ᑏHSᑡTU+1-TUMN®¯ᦪ+2ᑖ-+2-TU⌱uv5±²OPḄMNM+3ᑖ-+3-ᑤ◀‘ᦪD᪀'OP·ᡠᨵ3¸Ḅ⌱O¹º஺+3ᑖ-»ஹ¼ᔠ⚪+ᐳ10ᑖ-ᨵI¿Àᵨ;ᒹÂ3ÃÄ“ÆÇ”;“ÉN”;“ʯ”;ËᨵS.ÃÌÍÉNÎÏËÐÎÏIÆÇÌÆÇὺᵨ<ÒÉN;3ÌÉNὺᵨ2ÓᨵὺᵨÔ▲0ὺᵨÖÔIʯᵫØ1ḄÉNᐸÙÚ;ÌÉN<ÒʯÙÛ;ÌÜÙÚÓᨵÝÙÖÔ஺ÆÇḄÎឋᒹÂÆÇṹ;ÆÇxàÉNḄÎឋᒹÂ;wx0áàʯḄÎឋᒹÂwxஹஹ6ᓫÍ஺

251ஹzãE—R;äåÎឋ0ὶ~ç஺ZèE—RéᣚëìḄᐵ~+ᒹÂᐵ~x;Îឋx0ṹ-஺ᦪQᳮz⚪îᫀðᔁ-Iஹòó⚪+Ì⚪2ᑖ;ᐳ20ᑖ-1ஹÃÄ2Öôᦻö3.÷᦮ឋ4ᐵ~ᐵ~ùú6.᜜/ý&þᡂḄ9ᐜᩭᐜ
1Qஹ⌱⚪⚪1ᑖᐳ10ᑖ1ஹC2ஹD3ஹB4ஹA5ஹB6ஹC7ஹC8ஹC9ஹB10ஹCஹ⚪⚪5ᑖᐳ20ᑖ1ஹᫀ⌕ᦪḄ!"ᦑ$ᨵ&ᑁ(Ḅᦑ$&ᦑ$1ᑖஹᦑ$1ᑖஹ)*ᦑ$2ᑖஹ+,

26-./1ᑖ஺2ஹᫀ⌕ᦪ123!ᵫᦪ5᪀1ᑖஹᦪ782ᑖஹ9᦮ឋ<=2ᑖ(ᑖ>ᡂ஺3ஹᫀ⌕@AᡠᨵḄCDEAFGHḄ2ᑖIJKᨵLCDḄGH@MNᙢᨵPQᙢRᣚᡂTUVWX⊤ᙢGH3ᑖ஺4ஹᫀ⌕Z[&Ḅ\]᡻_A`aḄbcdbᐸ5fgᢥiNjkl_᡻_mnoḄ5fUp5ᑖ஺qஹᐳ10ᑖ1ஹ80,902ஹT1T2SlockArA=50

27Y=AUilockAXlockAA^IOSlockAᑏtA=40uvUilockAuvrA=40Y=AUilockAXlockA

282ᑏtA=80UnlockAஹ(ᐳ10ᑖ)ஹ(ᐳ20ᑖ)1ஹᐵᦪ(1)sno(eno='2'(SQ)(2ᑖ)ঝSno,Sn(CHᦪᭆ’)(2ᑖ)(3)Snqᵫ6(Cno,sno@04-Cno(C)))(2ᑖ)ALᵪA

29GETW6C8OSCZ2ᑖRASGECXSCYGETWSS:XY60^60SS0=SSOX2ᦪᭆ’2ᑖRASGECXSCYGETW69SQSডXY^CN^53ᑖ

306)EELECTFRCMSCWERESC60IN6ELECTCCN஺FRCMCWEREᦪ5᪀'EELETEFRCMCW1ERECN=ᦪ5᪀‘3ᑖ¤ஹᐳ10ᑖ5ᑖ¥¦¥¦ṹ¥¦¨©1ᑖª«¬¨¨©ὺᵨ°±ὺᵨ±▲¥¦1ᑖ..ᔊ¬¨´µ8ᓫ·1ᑖ¸¹ª«¬.ᔊ¬¸¹°±஺ᑖ]⊤º@2008´12ᨴ29°0941:00|¼4
|¾¿|ÀÁIᦈÃ

31ÄNÅ:ὃÈÉÊ——ᙠᓽIHNÅ:ÎÏḄÐÑ«ÒÓÔᨬHÖ×ᦻÙÚÛÜÝÞ✌⚓UᐵᦻÙᦪᭆáâãNᜩᦪåᳮçVᵨèᦪᭆéã᱐ᦪᦪWẠTXᭆíᦪḄWX5᪀[îjᦪåᳮgVᵨᦪï+ḄᳮgðñᦈÃᦪḄò⌕ᱯhlf881216]⊤º2009´12ᨴ9°17:05:52IRÀÁtôᑤ◀÷øùùùùùriiiqpl]⊤º2009´12ᨴ21°21:51:03IPÀÁtôᑤ◀Ô@ᑮDᱏᕀý¨ᵨᡝ]⊤º2009´12ᨴ25°13:0242IRÀÁtôᑤ◀zs84102030]⊤º2009´12ᨴ28°15:0419IEÀÁtôᑤ◀]⊤¼⊤мᑁÿᵨᡝᵨᡝṹ:ṹCopyright©pengluerPcweredbyCSCNBlog