SSD7试题2008-2..docVIP

四川大学期末考试试题（闭卷） （2007-2008学年第2学期） 课程号：课序号： 课程名称： 数据库系统原理（B卷）任课教师： 张天庆 适用专业年级：软件工程2006级 学生人数： 340印题份数： 350 学号： 姓名： 考试须知 四川大学学生参加由学校组织或由学校承办的各级各类考试，必须严格执行《四川大学考试工作管理办法》和《四川大学考场规则》。有考试违纪作弊行为的，一律按照《四川大学学生考试违纪作弊处罚条例》进行处理。 四川大学各级各类考试的监考人员，必须严格执行《四川大学考试工作管理办法》、《四川大学考场规则》和《四川大学监考人员职责》。有违反学校有关规定的，严格按照《四川大学教学事故认定及处理办法》进行处理。 题 号 一 二 三 四 五 六 七 八 九 十 得 分 阅卷教师 阅卷时间 总 成 绩 100 期末卷面 50 % 半期测验 10 % 平时练习 10 % 项目练习 30 % Multiple Choices. (2points×10) If relation R has n tuples and relation S has m tuples, the minimum number of tupes that R∪S can contain is _____. A. max (n,m) B. min (n,m) C. |n-m| D. n+m Which of the following statements are true. I. 4NF implies BCNF II. BCNF implies 3NF. III. 3NF implies BCNF A. None B. I only C. I and II D. I and III The FD X - Y is a full dependency in a relation R, if there is _____ attribute A that can be _____ X and the dependency still holds. A. at least one, added to B. at least one, removed from C. no, added to C. removed from An exclusive lock on a data item represents permission to perform which of the operations, read and write, on the data item? A. Both read and write. B. Write only. C. Read only. D. Neither read nor write. In a two-phase locking protocol, what happens during the shrinking phase? The transaction cannot acquire locks, but can release its locks. The transaction can acquire locks, but cannot release its locks. The transaction can acquire locks, and can release its locks. The transaction can acquire locks, and can release its locks as long as the number of released locks is greater than the number of acquired locks. The term physical data independence refers to the ability to change the conceptual schema without changing the application programs the physical layout of the data without changing the external schemas, the conceptual schemas, or the application programs the application programs wi