数据库原理英文选择题.docx

数据库原理英文选择题.docx

《数据库原理英文选择题.docx》由会员分享，可在线阅读，更多相关《数据库原理英文选择题.docx（20页珍藏版）》请在冰豆网上搜索。

MadebyChristina 2009-6-24

Multiple-ChoiceQuiz1

1.AnE-Commercesystemconsistsofthefollowingcomponents.Whichofthesesamecomponentsmustbeincludedinadatabase?

（a）

Thedata,suchasinformationaboutthegoodsavailableforsale,customers,ordersplaced,shippinginformation,etc.

Adatabasemustincludeacollectionofprogramsthatcontrolthedata,suchasprogramstocreate,maintain,andmanipulatethedata.Theseprogramscanbeeasilyusedtocreate,maintain,andmanipulatedatainotherdomains.

Adatabasemustincludeacollectionofprogramsthatoperateonthedata,butarespecifictotheE-commercesystem.Theseprogramsenableuserstobrowsethroughthestore-items,placeorders,trackshipping,etc.

（a）Ionly （b）I,II,andIII

（c）IIonly （d）IandIIonly

2.Inadatabasesystem,whoseresponsibilityisittoprovidedataconsistency?

（b）

（a）thedatabaseadministrator's （b）theDBMS's

（c）theuser's （d）theapplicationprogrammer's

3.AnE-Commercesystemconsistsofthefollowingcomponents.Whichofthesamecomponentsmustbeincludedinadatabasemanagementsystem?

（b）

Thedata,suchasinformationaboutthegoodsavailableforsale,customers,ordersplaced,shippinginformation,etc.

Acollectionofprogramsmustbeincludedthatcontrolthedata,suchasprogramstocreate,maintain,andmanipulatethedata.Theseprogramscanbeeasilyusedtocreate,maintain,andmanipulatedatainotherdomains,suchasinalibraryinformationsystem.

Acollectionofprogramsthatoperateonthedata,butarespecifictotheE-commercesystem.Theseprogramsenableuserstobrowsethroughthestore-items,placeorders,trackshipping,etc.

（a）IIandIIIonly （b）IIonly

（c）I,II,andIII （d）Ionly

4.AnE-Commercedatabasecontainsdataaboutcustomers,products,orders,systemresponsetimes,etc.WhichofthefollowingcanbespecifiedasintegrityconstraintsinanE-Commercedatabasesystem?

（d）

NotwoproductscanhavethesameproductID.

TheDBMSresponsetimeforallWebrequestsshouldbeatmost2seconds.

Acustomerordercannothavemorethanoneshippingaddress.

（a）I,II,andIII （b）IandIIonly

（c）Ionly （d）IandIIIonly

5.AnE-Commercesystemconsistsofthefollowingcomponents.Whichofthesesamecomponentswillconstituteadatabasesystem?

（c）

Thedata,suchasinformationaboutthegoodsavailableforsale,customers,ordersplaced,shippinginformation,etc.

Acollectionofprogramsthatcontrolthedata,suchasprogramstocreate,maintain,andmanipulatethedataconstitutesadatabasesystem.Theseprogramscanbeeasilyusedtocreate,maintain,andmanipulatedatainotherdomainssuchasinalibraryinformationsystem.

Acollectionofprogramsthatoperateonthedata,butarespecifictotheE-commercesystem,constitutesadatabasesystem.Theseprogramsenableuserstobrowsethroughthestore-items,placeorders,trackshipping,etc.

（a）Ionly （b）IIonly

（c）I,II,andIII （d）IandIIonly

6.Adatabaseisneededforwhichofthefollowingapplicationscenarios?

（a）

Avideostorethatneedstokeeptrackofdataaboutmembers,aboutvideoscarriedbythestore,aboutvideosrentedbymembers,aswellasdataconcerningborrow-date,return-date,andpaymentinformation.

Inthehumanresourcesdepartmentofacompany,informationaboutemployees,theirtitles,theirsalariesandsickdays,andaboutvacationdaystakenbyeachemployee.

Acomputer-simulatedvideogamewhichneedstocalculateanddisplay,thephysical（x,y）locationofeachactorinthegame,thespeedwithwhichtheyaremovingatthecurrentinstant,thedirectioninwhichtheyaremoving,theactiontheyareperforming,theangleatwhichthegame-playerisviewingthescene.

（a）IandIIonly （b）Ionly

（c）IandIIIonly （d）I,II,andIII

7.Thephysicalstoragestructurewillbe_____totheapplicationprogrammerinadatabaseapproach,andwillbe_____totheapplicationprogrammerinafilesystemapproach.（c）

（a）hidden,hidden （b）visible,visible

（c）hidden,visible （d）visible,hidden

Multiple-ChoiceQuiz2

1.Whatinformationisnecessarywhenspecifyingthestructureofatable?

（a）

（a）thenameofthetable,thenamesofthetable'sattributes,thedatatypesofattributes,andtheformatsofattributes

（b）thenameofthetableandthenamesofthetable'sattributes

（c）thenameofthetable,thenamesofthetable'sattributes,thedatatypesofthetable'sattributes,theformatsofthetable'sattributes,andthemaximumnumberofrowsthatthetablecanhave

（d）thenameofthetableandtheamountofstoragespacetobeallocatedtothetable

2.Thearityofatableisthenumberof_____inthetable.（b）

（a）keys （b）columns

（c）rows （d）foreignkeys

3.Thecardinalityofatabl