资源描述：
《数据库系统原理》试卷-a卷-试题-答案》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。
1、北京邮电大学2007——2008学年第2学期《数据库系统原理》期末考试试题（A）考试注意事项一、学生参加考试须带学生证或学院证明，未带者不准进入考场。学生必须按照监考教师指定座位就坐。二、书本、参考资料、书包等物品一律放到考场指定位置。三、学生不得另行携带、使用稿纸，要遵守《北京邮电大学考场规则》，有考场违纪或作弊行为者，按相应规定严肃处理。四、学生必须将答题内容做在试题答卷上，做在试题及草稿纸上一律无效。五、填空题用英文答，中文答对得一半分。考试课程考试时间2008年6月16日题号一二三四五六七八九十总分满分91118122085656得分阅卷教师1.Fillinblanks.(
2、1´9points)(1)DDListhelanguageforspecifyingthedatabaseschemaandaswellasotherpropertiesofthedata.(2)WithrespecttointegritymechanismsinDBS,triggerdefinesactionstobeexecutedautomaticallywhensomeeventsoccurandcorrespondingconditionsaresatisfied.(3)Anentitysetthatdoesnothavesufficientattributestofor
3、maprimarykeyistermedaweakentityset.(4)Thecommonly-usedschemesoforganizationofrecordsinfilesareheapfileorganization,sequentialfileorganization,andhashingfileorganization.(5)Thethreestepsinqueryprocessingareparsingandtranslation,optimization,andevaluation.(6)Therecovery-managementcomponentofadat
4、abasesystemimplementsthesupportfortransactionatomicityanddurability.(7)Acascadelessscheduleensuresthattheabortofatransactiondoesnotresultincascadingabortsofothertransactions.(8)Thestrictwo-phaselockprotocolrequiresthatallexclusive-modelockstakenbyatransactionbehelduntilthattransactioncommits.(
5、9)ThethreetypesoffailuresinDBSarethetransactionfailures,systemcrash,anddiskfailures/crash.2.Choice(1´11points)(1)WithrespecttoDBSdesign,theindexisdesignedattheDphase.A.requirementanalysisB.conceptualdesignC.logicaldesignD.physicaldesign(2)FortheE-Rdiagramgivenbelow,themappingcardinalityfromAto
6、BisCR0….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
7、®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,Ccanbeusedtotakeoutrepetitiontuples.A.uniqueB.countC.distinct
