数据库系统原理》试卷-A卷-试题-答案.doc

北京邮电大学2007——2008学年第2学期 《数据库系统原理》期末考试试题（A） 考试注意事项 一、学生参加考试须带学生证或学院证明，未带者不准进入考场。学生必须按照监考教师指定座位就坐。 二、书本、参考资料、书包等物品一律放到考场指定位置。 三、学生不得另行携带、使用稿纸，要遵守《北京邮电大学考场规则》，有考场违纪或作弊行为者，按相应规定严肃处理。 四、学生必须将答题内容做在试题答卷上，做在试题及草稿纸上一律无效。 五、填空题用英文答，中文答对得一半分。 考试 课程 考试时间 2008 年 6月 16日 题号 一 二 三 四 五 六 七 八 九 十 总分 满分 9 11 18 12 20 8 5 6 5 6 得分 阅卷 教师 Fill in blanks. (1(9 points) (1) DDL is the language for specifying the database schema and as well as other properties of the data. (2) With respect to integrity mechanisms in DBS, trigger defines actions to be executed automatically when some events occur and corresponding conditions are satisfied. (3) An entity set that does not have sufficient attributes to form a primary key is termed a weak entity set . (4) The commonly-used schemes of organization of records in files are heap file organization , sequential file organization, and hashing file organization. (5) The three steps in query processing are parsing and translation, optimization, and evaluation . (6) The recovery-management component of a database system implements the support for transaction atomicity and durability . (7) A cascadeless schedule ensures that the abort of a transaction does not result in cascading aborts of other transactions. (8) The stric two-phase lock protocol requires that all exclusive-mode locks taken by a transaction be held until that transaction commits. (9) The three types of failures in DBS are the transaction failures, system crash, and disk failures/crash . 2. Choice (1(11 points) (1) With respect to DBS design , the index is designed at the D phase. A. requirement analysis B. conceptual design C. logical design D. physical design (2) For the E-R diagram given below, the mapping cardinality from A to B is C 0….1 3…..5 A. one-to-many B. one-to-one C. many-to-one D. many-to-many (3) The following SQL s