数据库试题-英文卷

哈尔滨理工大学2007－2008学年第一学期考试试题A卷软件学院、软件工程系出题教师：刘欢系主任：第1页共7页考试科目：数据库系统考试时间：120分钟试卷总分100分考试班级：软件06-1、2、3、4、5、6班题号IIIIIIIVV总分得分评卷教师I、Choicequestions.(Writeyouranswersontotheanswersheet.)(Thereare10questions,totally20marks,andeachquestionworth2marks.）1.TherelationshipamongDatabase(DB),DatabaseSystem(DBS)andDatabaseManagementSystem(DBMS)is___A_____.A.“DBSincludesDBandDBMS”B.“DBMSincludesDBandDBS”C.“DBincludesDBSandDBMS”D.“DBisDBS,alsoasDBMS”2.Inanindex,___A_____istheattributetosetofattributesusedtolookuprecordsinafile.A.searchkeyB.structuredkeyC.sequencekeyD.selectkey3.A_____D___ofanentitysetisasetofoneormoreattributeswhosevaluesuniquelydetermineeachentity.A.keyB.primarykeyC.candidatekeyD.superkey4.Fromthefollowingphysicalstoragemedia,____D___isVOLATILE.A.opticalstorageB.tapestorageC.magnetic-diskD.mainmemory5.ChoosetheonlyoneINCORRECTdescriptionfromthefollowings:__D_____A.Neithertuplesnorattributeshaveorder.B.Attributescanappearinanyorderandtherelationisstillthesame.C.Eachvalueinthedatabasemustbeamemberofsomedomain.D.Duplicatetuplescanexistinarelation.6.ThereisarelationR(A,B,C)containsthefollowingdata.WhichofthedescriptionaboutfunctionaldependencyisCORRECT?___B_______装订线班级：学号：姓名：2008年1月2日第2页共7页A.FunctionaldependenceABholdsonR.B.FunctionaldependenceBCAholdsonR.C.FunctionaldependenceBAholdsonR.D.FunctionaldependenceABCholdsonR.7.Therightfigureshows___B_____paralleldatabasearchitectures.A.‘Sharedmemory’B.‘Shareddisk’C.‘Sharednothing’D.‘Hierarchical’8.ChoosetheproperchoicetomakethefollowingSQLstatementtorealizequery“Findthenamesofallcustomerswhosestreetendwiththesubstring‘%Dajie’”A.LIKE‘\%Dajie’SELECTcustomer_nameB.LIKE‘\%Dajie%’FROMcustomerC.LIKE‘%\%Dajie’WHEREcustomer_street____C______D.LIKE‘%\Dajie%’9.SupposethattherearetworelationsR(A,B)andS(B,C).ChoosetheequivalentrelationalalgebraexpressionforthefollowingSELECTclause:_C__.A.A,B(C≠‘C56’(RS))SELECTA,BB.A,B(C≠‘C56’(RS))FROMRC.R-A,B(C=‘C56’(RS))WHEREBNOTIN(SELECTBD.R-A,B(C≠‘C56’(RS))FROMSWHEREC=’C56’)10.ChoosetheonlyoneCORRECTexpressionaboutSQLfromthefollowings:____C___.A.(some)inB.(=all)notinC.EXISTSrrØD.UNIQUErr=ØII、Blank-fillingquestions.(Writeyouranswersontotheanswersheet.)(Thereare7questionsand10blanks,totally20marks,eachblankworth2marks.)1.Todesignatriggermechanism,wemustspecifythe①underwhichthetriggeristobeexecuted;specifythe②tobetakenwhenthetriggerexecutes.①conditions,②actionsABC223234335哈尔滨理工大学2007－2008学年第一学期考试试题A卷软件学院、软件工程系出题教师：刘欢系主任：第3页共7页2.GiventwooriginalvaluesA=300,B=150;computeboththevaluesofAandBafterthetransactionsT1andT2withtherightsideschedule.A=;B=.A=225;B=2253.Thebasicqueryprocesshasbeenlistinthefollowingfigure,pleasefilltheTWOblanks.1.①parserandtranslator,②executionplan4.Inphysicallevel,thedatabaseisstoredasacollectionoffiles.Eachfileisasequenceofrecords,eachofwhichisasequenceoffields.5.Given0.3msasthetimetotransferoneblockand0.2msasthetimeforoneseek.IfweignoreCPUcostsandthecosttowritingoutputtodisk,thecostis___8______msfor20blocktransfersand10seeksforsimplicity.6.Indatabasesystem,indexingmechanismsareusedtospeedupaccesstodesireddata.7.Indistributeddatabasesystem,dataisspreadovermultiplemachines(alsoreferredtoassitesornodes).III、Brieflydescriptionquestions.(Writeyouranswersontotheanswersheet.)2008年1月2日第4页共7页(Thereare4questions,totally16marks,andeachquestionworth4marks.）1.PleasebrieflylistFOURdutiesofadatabaseadministrator.2.PleasegivethedefinitionandtheACIDpropertiesoftransaction.3.GiventherelationschemaR=(A,B,C,G,H,I),andthefunctionaldependencyF={AB,AC,CGH,CGI,BH}.ExplainwhetherAGIandCGHIarethemembersofF+?Why?AGIisamemberofF+.ByaugmentingACwithG,togetAGCGandthentransitivitywithCGI,wecangetAGI.CGHIisamemberofF+.ByaugmentingCGItoinferCGCGI,andaugmentingofCGHtoinferCGIHI,andthentransitivity,wecangetCGHI.4.GiventherelationschemaR=(A,B,C,G,H,I),andthefunctionaldependencyF={AB,AC,CGH,CGI,BH}.Compute(AG)+.Theprocessesofcomputingresultof(AG)+havebeenshownbelow.result=AGresult=ABCG(ACandAB)result=ABCGH(CGHandCGAGBC)result=ABCGHI(CGIandCGAGBCH)IV、Queryquestions.(Writeyouranswersontotheanswersheet.)(Thereare2questionswith7queries.Therearetotally28marks,eachqueryworth4marks.)1.Considertherelationaldatabaseofabankingenterprisewiththefollowingrelationschemas,wheretheprimarykeysareunderlined.branch(branch_name,branch_city,assets)customer(customer_name,customer_street,customer_city)loan(loan_number,branch_name,amount)borrower(customer_name,loan_number)account(account_number,branch_name,balance)哈尔滨理工大学2007－2008学年第一学期考试试题A卷软件学院、软件工程系出题教师：刘欢系主任：第5页共7页depositor(customer_name,account_number)Giveanexpressionintherelationalalgebratoexpresseachofthefollowingtwoqueries:Findthenamesofallcustomerswhohavealoan,anaccount,orboth,fromthebank.InsertinformationinthedatabasespecifyingthatSmithhas$4500inaccountA-911atthePerryridgebranch.2.Considertheacademicdatabasecontainsthreerelationsasthefollowing3tables,andthengiveanexpressioninSQLforeachofthefollowingqueries.Table‘S’AttributenameDatatypePrimarykeyDescriptionSnoint√Studen