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

《SSD7数据库系统选择题答案.docx》由会员分享，可在线阅读，更多相关《SSD7数据库系统选择题答案.docx（18页珍藏版）》请在第壹文秘上搜索。

1、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,

2、suchasprogramscreate,maintain,andmanipu1.atethedata.Theseprogramscanbeeasi1.yusedtocreate,11ain1.ain,andmampu1.atcdatainotherdomains.Adatabasemustinc1.udeaco1.1.ectionofprogramsthatoperateontbedata,butarcspecifictotheE-Comniercesystem.T1.ieseprogramsenab1.eusers(obrowseIhrOUgh1.hestore-items,p1.aceo

3、rders,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.TheDBMSresponset

4、imefora1.1.VVcbrequestsshou1.dbeatmost2seconds.Acustomerordercannothavemorethanoneshippingaddress.（八）Ion1.y(b)1.I1.andII1.(c) IandIIon1.y(d) 1amiIIIon1.yFeedback:Theconstraints1.IIand111specifytheapp1.icationsemanticsofthedatacapturedintheE-Commcrccdatabase.ConstraintIII.a1.thoughitseemscontrar,toco

5、mmonsense,isnotsomethingthatcanbeprohibitedby(heDBMSbecausetheDBMSisgenera1.purpose.TheresponsetimeoftheDBMScannotbeenforcedbytheDBMS.ItdependsonfactorssuchIheprocessorspeed,memoryavai1.ab1.e,etc.3AnE-Commcrccsystemconsistsofthefo1.1.owingcomponents.Whichofthesesamecomponentswi1.1.constitutea、)、I1.1

6、.】？(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.cdat

7、ainotherdomainssuchasina1.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.andIIIFeedba

8、ck:databasesysteminc1.udesthedata,theDBMS,andtheapp1.ication-specificprogramsthatoperateonthatdata.5. Inadatabasesystem,whoseresponsibi1.ityisit(oprovidedataconsistency?(d)(a) thedatabaseadministrators(b) theUSerS(c) theapp1.icationprogrammers(d)(heDBMS6. Adatabaseisneededforwhichofthefo1.1.owingapp

9、1.icationsccna11os?(b)Avideostorethatneedstokeeptrackofdataaboutmembers,aboutvideoscarriedbythestore,aboutvideosrentedbymembers.aswe1.1.asdataconcerningborrow-date,re11bdate.andpaymentin11nation.InthehumanresourcesdepartmentOfacompany,informationaboutemp1.oyees,theirtit1.es,theirsa1.ariesandsickdays

10、,andabouvacationdaystakenbyeachemp1.oyee.Acomputer-simu1.atedvideogamewhichneedstoca1.cu1.ateanddisp1.ay,thephysica1.(x.y)IOCdIionofeachactorinthegame,thespeedwithwhichtheyarc11odngatthecunentinstant,thedirectioninwhichtheyarcmoving,theactiontheyarcperforming,theang1.eatwhichthegame-p1.ayerisviewing

11、thescene.(a) IandIIIon1.y(b) IandI1.on1.y(c) 1.I1.and111(d) 1on1.y7. Thephysica1.storageS1.ruc1.urcwi1.1.betotheapp1.icbyexamp1.erce11ito(b)(a) aqucr)forSQ1.examp1.es(b) avisua1.query1.anguagedeve1.opedbyIBM()examp1.eSQ1.queriesprovidedbyotherusersthatcanbeInOdifkdtosuitcurrentneeds(d)examp1.eSQ1.queriesprovidedbytheDBMSthatuserscuntofstoragespacetobea