2012年数据库系统试卷(A).doc

华南农业大学期末考试试卷（A卷） 2012学年第一学期　 考试科目： 数据库系统 考试类型：闭卷 　　　 考试时间：　120　分钟 学号 姓名 年级专业 题号 一 二 三 四 五 六 总分 得分 评阅人 Instructions to candidates: 1. 2. DO NOT write your answers on the question papers. Write them ALL ON THE ANSWER PAPERS. 3. Write your answers in either Chinese or English. If the answer in English is correct, you can get bonus marks. 3. Hand in all papers (both the question papers and the answer papers). Question 1 [45 marks, 1.5 marks for each.]: Single choice questions，select the most appropriate answer please. 1. _______ is the most widely used data model A. relational model B. entity-relationship model C. object-based data model D. semi-structured data model 2. A relation schema is a set of _______. A. tuples B. attributes C. columns D. rows 3. A set of attributes that, taken collectively, allow us to identify uniquely a tuple in the relation is called ______. A. super key B. primary key C. candidate key D. foreign key 4. Application users interact with data in the _______ level. A. physical B. logical C. view D. all of the above 5. Relational algebra is a _____ language A. procedural B. declarative C. natural D. commercial 6. The fundamental operations of relational algebra includes_______. A. generalized projection, aggregate function, outer join B. set-intersection, natural join, division, assignment C. select, project, set-union, set-difference, Cartesian product, rename D. set-intersection, set-union, set-difference 7. If table S has M columns, table T has N columns, then the Cartesian product of S and T has ____ columns. A. M*N B. M-N C. M+N D. M+N-1 8. The ______ operation in relational algebra requires the two participating relations have the same number of attributes. A. division B. join C. Cartesian produ