2012年数据库系统考试试卷(B).docVIP

华南农业大学期末考试试卷（B卷） 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. A data model consists of A. schema B. set of operations C. set of constraints D. all of A, B, and C 2. The Entity-Relationship data model is A. DBMS dependent. B. DBMS independent. C. both A and B D. neither A nor B 3. A key in a database table is A. minimal superkey B. a proper superset of a candidate key. C. proper subset of a candidate key D. neither a.) nor b.) 4. ______________ operation(s) on relation tables is/are implementation of the relationships of conceptual schema database in entity-relationship model. A. Select operation B. Cartesian product C. Projection D. Natural join 5. A database is a data collection without the following additional feature A. database contain both data and metadata, the latter being descriptive data about the raw data. B. It provides a generic mechanism for storing relationships among the data items. C. It provides a means to constrain that data to meaningful values as determined by the application. D. It provides a uniform service interface for data maintenance and query activity, such as SQL in the case of the relational model. 6. A foreign key can make reference to A. an attribute that