北京邮电大学2007——2008学年第2学期《数据库系统原理》期末考试试题（A）考试注意事项一、学生参加考试须带学生证或学院证明，未带者不准进入考场。学生必须按照监考教师指定座位就坐。二、书本、参考资料、书包等物品一律放到考场指定位置。三、学生不得另行携带、使用稿纸，要遵守《北京邮电大学考场规则》，有考场违纪或作弊行为者，按相应规定严肃处理。四、学生必须将答题内容做在试题答卷上，做在试题及草稿纸上一律无效。五、填空题用英文答，中文答对得一半分。考试课程考试时间2008年6月16日题号一二三四五六七八九十总分满分91118122085656得分阅卷教师Fillinblanks.(19points)(1)DDListhelanguageforspecifyingthedatabaseschemaandaswellasotherpropertiesofthedata.(2)WithrespecttointegritymechanismsinDBS,triggerdefinesactionstobeexecutedautomaticallywhensomeeventsoccurandcorrespondingconditionsaresatisfied.(3)Anentitysetthatdoesnothavesufficientattributestoformaprimarykeyistermedaweakentityset.(4)Thecommonly-usedschemesoforganizationofrecordsinfilesareheapfileorganization,sequentialfileorganization,andhashingfileorganization.(5)Thethreestepsinqueryprocessingareparsingandtranslation,optimization,andevaluation.(6)Therecovery-managementcomponentofadatabasesystemimplementsthesupportfortransactionatomicityanddurability.(7)Acascadelessscheduleensuresthattheabortofatransactiondoesnotresultincascadingabortsofothertransactions.(8)Thestrictwo-phaselockprotocolrequiresthatallexclusive-modelockstakenbyatransactionbehelduntilthattransactioncommits.(9)ThethreetypesoffailuresinDBSarethetransactionfailures,systemcrash,anddiskfailures/crash.2.Choice(111points)(1)WithrespecttoDBSdesign,theindexisdesignedattheDphase.A.requirementanalysisB.conceptualdesignC.logicaldesignD.physicaldesign(2)FortheE-Rdiagramgivenbelow,themappingcardinalityfromAtoBisCR0….13…..5ABA.one-to-manyB.one-to-oneC.many-to-oneD.many-to-many(3)ThefollowingSQLstatementcorrespondstotheexpressionC.Select*Fromr,sA.r∩sB.r∞sC.r╳sD.r—s(4)GiventheschemaR(A,B,C,D,E,F)andthefunctionaldependenciesF={ABD,BCE,DF,ABF,CEB}holdingonit,Disatransitivefunctionaldependency.A.ABDB.BCEC.DFD.ABFE.CEB(5)Givenarelationr(R),whichoneofthefollowingfunctionaldependenciesissatisfiedbyr.CA.A→BB.AC→BC.BC→AD.B→CE.noneABC162456466738910(6)InaSelectstatement,Ccanbeusedtotakeou