数据库系统_A_闭_2018-2018-1.docVIP

311038040 数据库系统（A 闭） 2011-2012-1 I． Multiple Choices. (2points×5) 1. Overall logical structure of a database can be expressed graphically by ______________. A. ER diagram B. Records C. Relations D. Hierarchy If a relation schema is in the second normal form, it is also in _____________. A.1NF B.3NF C.BCNF D.4NF Which statement about the two-phase locking protocol is true? A. In the growing phase, the transaction cannot acquire locks, but can release its locks. B. In both growing phase and shrinking phase, the transaction can acquire locks, but cannot release its locks. C. In the shrinking phase, the transaction can not acquire locks, but can release its locks. D. In the growing phase, 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. Which of following is true? I. R∩S = R-(R-S) II. R∩S = S-(S-R) III. R∩S = (R-(R-S))∪(S-(S-R)) A. I only B. II only C.III only D. I, II, and III What is the order of execution of select, from, where and group by in a select statement? A. select-from-where-group by B. group by-where-from-select C. from-where-group by-select D. where-from-group by-select II．RelationalAlgebra and SQL (5points×8) Consider the following relational schema describe a volunteer(志愿者) database system: Service（service-id, title, location） Volunteer（volunteer-id, name, age） Participation（volunteer-id, service-id , date） Give an expression in the relational algebra for each of the following queries: A. Find all volunteers’id and name who have participated in the service titled “Care for animals”. B. Find all volunteers’id, name and age who have never participated in any service. Give a SQL statement for each of following queries: A. Find all volunteers’id and name who have participated in the service titled “Care for animals”. B. Find all volunteers’ id and name who have participated in both the service titled “Care for animals” and the service titled “To help