数据库原理英文选择题.docx
- 文档编号:153266
- 上传时间:2022-10-04
- 格式:DOCX
- 页数:20
- 大小:40.86KB
数据库原理英文选择题.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
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 数据库 原理 英文 选择题