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