数据库原理英文选择题.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.Thecardinalityofatableisthenumberof_____inthetable.（c）
（a）keys （b）foreignkeys
（c）rows （d）columns
4.Thedegreeofatableisthenumberof_____inthetable.（c）
（a）key （b）rows
（c）columns （d）foreignkeys
5.Fortwotablestobeunioncompatible,thetablesshouldbethesamewithrespecttowhichofthefollowing?
（c）
（a）keys （b）cardinality
（c）degree （d）name
6.WhichofthefollowingSQLstatementscanbeusedtoaddarowtoatable?
（b）
（a）CREATE （b）INSERT
（c）APPEND （d）ADD
7.WhichofthefollowingSQLstatementscanbeusedtoremovearowfromatable?
（a）
（a）DELETE （b）ERASE
（c）DESTROY （d）REMOVE
8.WhichofthefollowingSQLstatementscanbeusedtomodifyjustonerow（outofmanyrows）inatable?
（d）
（a）MODIFY （b）CHANGE
（c）ALTER （d）UPDATE
9.TheSQLclausetoperformasetUNIONoperationis（d）
（a）MELD （b）UNITE
（c）COMBINE （d）UNION
10.Thetermquerybyexamplerefersto（d）
（a）exampleSQLqueriesprovidedbyotherusersthatcanbemodifiedtosuitcurrentneeds
（b）aqueryforSQLexamples
（c）exampleSQLqueriesprovidedbytheDBMSthatuserscanmodifytosuittheircurrentneeds
（d）avisualquerylanguagedevelopedbyIBM
11.TheforeignkeyinatableT1_____thesame_____asthecorrespondingprimarykeyintableT2.（a）
musthave,name
neednothave,name
musthave,domain
（a）IIandIII （b）IandIII
（c）IandII （d）I,II,andIII
12.DMLisusedto（a）
（a）add/modify/deletedatainthedatabase.
（b）manipulatethestructureofdatabaseapplications.
（c）addanddeletetables.
（d）specifythestructureofadatabase.
13.WhatcanbespecifiedintheselectionconditionofaSELECTstatement?
（a）
（a）aBooleanoperation
（b）thetimeatwhichtheselectionshouldbeperformed
（c）anarithmeticoperation
（d）theconditionsunderwhichthestatementshouldbeexecuted
14.WhichofthefollowingSQLstatementscanbeusedtocreatearelationaltable?
（c）
（a）ADD （b）APPEND
（c）CREATE （d）INSERT
15.WithQueryByExample,auserentersaqueryby（c）
（a）placingSQLkeywords,suchasselect,underthecolumnnamestheywanttoretrieve
（b）typingasyntacticallycorrectSQLquerythatusescolumnandtablenamessimilartothecorrectcolumnandtablenamesinadatabase
（c）fillinginskeletontablesofthedatabasewithexamplesofwhatistoberetrieved
（d）writinganEnglishdescriptionofthedatathattheuserneeds
16.DDLisusedto（b）
（a）accessthecontentsoftables.
（b）specifythestructureofadatabase.
（c）addcontentstotables.
（d）definethestructureofdatabaseapplications.
17.Ajoinoperationjoins_____tablesinto_____.（c）
（a）four,two （b）three,one
（c）two,one （d）three,two
18.Adifferenceoperationcanbeappliedtotablesthat（d）
（a）havethesamename
（b）arethesamesize
（c）havethesamecolumnnames
（d）areunioncompatible
19.TheSQLclausetoperformasetdifferenceoperationis（b）
（a）REJECT （b）EXCEPT
（c）DIFFER （d）OMIT
Multiple-ChoiceQuiz3
1.WhenastringwhoselengthisstrictlylessthannisenteredasthevalueofafieldwhoseSQLdatatypeisVARCHAR（n）,thesystemrespondsby（c）
（a）paddingtheendofthestringwithNULLcharacterstolengthnbeforestoringit.
（b）paddingtheendofthestringwithspacestolengthnbeforestoringit.
（c）storingthestringasis.
（d）re-promptingfortheentryofastringwhoselengthisexactlyn.
2.InSQL,whendestroyingadatabase,theRESTRICToptionremoves（b）
（a）everythinginthespecifieddatabase:
thedata,schema,etc.
（b）theschemaifthedatabasehasnodata（emptytables）
（c）thedataandschemafromthespecifieddatabase,butnotfromrelateddatabases
（d）thedatabutnottheschema
3.InSQL,adatabasecanbedestroyedbywhichofthefollowing?
（c）
（a）thecommandDESTROYDATABASE
（b）aseriesofDESTROYTABLEcommands
（c）thecommandDROPSCHEMA
（d）thecommandDELETEDATABASE
4.InSQL,whendestroyingadatabase,theCASCADEoptionremoves（b）
（a）thedataandschemafromthespecifieddatabase,andfromrelateddatabases
（b）everythinginthespecifieddatabase:
thedata,schema,etc.
（c）theschemaifthedatabasehasnodata（emptytables）
（d）thedatabutnottheschema
5.InSQL,onefunctionoftheASoperatoristo（d）
（a）limitthecardinalityofarelation
（b）definethedomainofanattribute
（c）controltheorderinwhichaquery’srowsaresorted
（d）customizethenamesofcolumnsinaquery’sresult
6.InSQL,adatabasecanbecreatedbywhichofthefollowing?
（d）
（a）thecommandADDDATABASE
（b）thecommandINSERTDATABASE
（c）aseriesofCREATETABLEcommands
（d）thecommandCREATESCHEMA
7.Whenspecifyingaselectioncriterion
升级会员 