数据库期中试卷(附答案).docVIP

浙江财经学院期中考试试卷 第 PAGE 6页，共 NUMPAGES 6页 专业、班级： 学号： 姓名：密 封 线浙江财经学院期中考试试卷 专业、班级： 学号： 姓名： 密 封 线 《数据库原理及应用（英）》课程试卷 考核方式： 闭 卷 考试日期：2012年11月21日 适用专业、班级：10电子商务 题 号 一 二 三 四 五 六 七 八 九 十 总分 得 分 评卷人 （共 7 大题） For each of the following questions there are four choices marked A, B, C and D. Only one of them is correct. You should decide on the correct choice and write down its mark on the answer sheet.（Points: 20 ） (1) Which of the following operations is not supported by DDL ? C A．creating some views in a database B．modifying table structures in a database C．finding some rows from a table D．creating some tables in a database (2) In relational model, entity integrity means that B . A．there must not be empty rows in every relation B．no attribute of a primary key can be null C．attributes are allowed to be null D．foreign keys are allowed to be null (3) Which of the following operations is not supported by DML ? D A．inserting some rows into a table B．deleting some rows from a table C．finding some rows from a table D．creating some tables in a database (4) If F is a foreign key of relation R that references the primary key K of relation S, then F can only take B . A．null values B．null values or values that equal to one of the values of K C．values that appear in K D．values that appear in R (5) Which of the following operations can retrieve from a relation all records that satisfy a condition to form a new relation? C A．Projection B．Join C．Selection D．Division (6) A relation schema __C____. A．can have exactly one candidate key B．can have many primary keys C．can have one or many candidate keys D．can have one or many primary keys (7) In SQL, in