SSD7数据库系统选择题答案.docx

Mu1.tip1.e-ChoiceQuiz11. nE-Commercesystemconsistsofthefo1.1.owingcomponents.Whichofthesesamecomponentsmustbeinc1.udedinadatabase?(C)hcdata,suchasntbrmatonaboutthegoodsavai1.ab1.etorsa1.e,customers,ordersp1.aced,shippinginibnnation,etc.Adatabasemustinc1.udeaco1.1.ectionofprograms(hatcontro1.thedata,suchasprogramscreate,maintain,andmanipu1.atethedata.Theseprogramscanbeeasi1.yusedtocreate,11ain1.ain,andmampu1.atcdatainotherdomains.Adatabasemustinc1.udeaco1.1.ectionofprogramsthatoperateontbedata,butarcspecifictotheE-Comniercesystem.T1.ieseprogramsenab1.eusers(obrowseIhrOUgh1.hestore-items,p1.aceorders,trackshipping,etc.(a) IJI.andIII(b) Iand11on1.y(¢)Ion1.y(d)I1.on1.y2. AnE-Commcrccdatabasecontainsdataaboutcustomers,products,orders,systemresponsetimes,etc.WhichofIhefo1.1.owingcanbespecifiedasintegrityconstraintsinan>-<.>'11)cr.daUbasesystem?(d)NotwoproductscanhavethesameproductID.TheDBMSresponsetimefora1.1.VVcbrequestsshou1.dbeatmost2seconds.Acustomerordercannothavemorethanoneshippingaddress.（八）Ion1.y(b)1.I1.andII1.(c) IandIIon1.y(d) 1amiIIIon1.yFeedback:Theconstraints1.IIand111specifytheapp1.icationsemanticsofthedatacapturedintheE-Commcrccdatabase.ConstraintIII.a1.thoughitseemscontrar>,tocommonsense,isnotsomethingthatcanbeprohibitedby(heDBMSbecausetheDBMSisgenera1.purpose.TheresponsetimeoftheDBMScannotbeenforcedbytheDBMS.ItdependsonfactorssuchIheprocessorspeed,memoryavai1.ab1.e,etc.3AnE-Commcrccsystemconsistsofthefo1.1.owingcomponents.Whichofthesesamecomponentswi1.1.constitutea、)、I1.1.】？(d)Thedata,suchasinformationaboutthegoodsavai1.ab1.eibrsa1.e.CUS1.Om6.ordersp1.aced,shippinginfb11nation.etc.Aco1.1.ectionofprogramsthatcontro1.thedata,suchasprogramstocreate,maintain,andmanipu1.atethedataconstitutesadatabasesystem.Theseprogramscanbeeasi1.yused(ocreate,maintain,andmanipu1.a1.cdatainotherdomainssuchasina1.ibraryinformationsystem.Aco1.1.ectionofprogramsthatoperateonthedata,butarcspecifictotheE-commerccsystem,constitutesadatabasesystem.Theseprogramsenab1.euserstobrowsethroughthestore-items,p1.aceorders,(rackshipping,etc.(a) IandI1.on1.y(b) 11on1.y(c) Ion1.y(d) hII.andIIIFeedback:databasesysteminc1.udesthedata,theDBMS,andtheapp1.ication-specificprogramsthatoperateonthatdata.5. Inadatabasesystem,whoseresponsibi1.ityisit(oprovidedataconsistency?(d)(a) thedatabaseadministrators(b) theUSerS(c) theapp1.icationprogrammer's(d)(heDBMS6. Adatabaseisneededforwhichofthefo1.1.owingapp1.icationsccna11os?(b)Avideostorethatneedstokeeptrackofdataaboutmembers,aboutvideoscarriedbythestore,aboutvideosrentedbymembers.aswe1.1.asdataconcerningborrow-date,re11bdate.andpaymentin11nation.InthehumanresourcesdepartmentOfacompany,informationaboutemp1.oyees,theirtit1.es,theirsa1.ariesandsickdays,andabouvacationdaystakenbyeachemp1.oyee.Acomputer-simu1.atedvideogamewhichneedstoca1.cu1.ateanddisp1.ay,thephysica1.(x.y)IOCdIionofeachactorinthegame,thespeedwithwhichtheyarc11odngatthecunentinstant,thedirectioninwhichtheyarcmoving,theactiontheyarcperforming,theang1.eatwhichthegame-p1.ayerisviewingthescene.(a) IandIIIon1.y(b) IandI1.on1.y(c) 1.I1.and111(d) 1on1.y7. Thephysica1.storageS1.ruc1.urcwi1.1.betotheapp1.ic<tionprogrammerinadatabaseapproach,andwi1.1.betotheapp1.icationprogrammerinafi1.esystemapproach.(b)(a) visib1.e,visib1.e(b) hidden,visib1.e(c) visib1.e,hidden(d) hidden,hiddenMu1.tip1.e-ChoiceQuiz21. 1.*hcforeignkeyinatabicT1.thesameasthecorrespondingprimarykeyintab1.eT2.(d)musthave,nameneednothave,namemusthave,domain(a) 1.I1.andIII(b) 1andII(c)1.andIII(d)1.1.and1112. T1.ic1.cgu(ofa(ab1.eisIhenumberofinthetab1.e.(c)(a) keys(b) rows(c) co1.umns(d) foreignkeys3. ThearityOfatab1.eisthenumberofinthetab1.e.(c)(a) rows(b) foreignkeys(c) co1.umns(d) keys4. Thecardina1.ityofatab1.eis(henmberofinthetab1.e.(b)(a) keys(b) rows(c) co1.umns(d) foreignkeys5. Whichofthefo1.1.owingSQ1.statementscanbeusedtoaddarowtoatab1.e?（八）CREATE(b)DD(c) INSERT(d) APPEND6. TheSQ1.c1.ausetoperfb11na、T70、op.onis(b)(a) UNITE(b) UNION(C)COMBINe(d)ME1.D7. IhcSQ1.c1.ausetoperformasetditercnccoperationis(b)(a) OMIT(b) EXCEPT(c) REJEeT(d) DIFFER8. DD1.isusedto(C)(a) addcontentsIUtab1.es.(b) definethestructureofdatabaseapp1.ications.(c) specifytheStmcturcofadatabase.(d) accessthecontentsoftab1.es.9. Ade1.etionoperationwi1.1.ifthede1.etion1.eadstothevio1.ationofarctcrcnta1.integrityconstraint.（八）(a) fai1.(b) crashthesystem(c) succeedwithwarning(d) succeedwithoutwarning10. Thetemqucr>byexamp1.erce11ito(b)(a) aqucr)forSQ1.examp1.es(b) avisua1.query1.anguagedeve1.opedbyIBM(¢)examp1.eSQ1.queriesprovidedbyotherusersthatcanbeInOdifkdtosuitcurrentneeds(d)examp1.eSQ1.queriesprovidedbytheDBMSthatusersc<nmodifytosuittheircurrentneeds11. Whatinformationisnecessarywhenspecifyingthestructureofatab1.e?(d)(a) thenameofthe(ab1.eandtheanx>untofstoragespacetobea