DBS_Test2-questions-answers - and 存在问题-2009.docVIP

Database Systems Principles Test Two (06401?6405) (Covering Chapter 7, 11, 12, 13, 14) Class____________No____________Name____________ Fill in blanks (1 x 11 points) In the relational data model, an attribute domain is atomic if its elements are considered to be indivisible. For the relation r(R), the current values of r is called the relation instance/instance of r , and is specified by a table. . Taking the candidate key K of schema R as a attribute set, the attribute in K, i.e. the element in K, is called the primary attribute in R In a relational database, any relation that is not part of the logical model consisting of relations, but is made visible to a user as a “virtual relation”, is defined as a view . (5) If X is the attribute set of relation schema R1, and X is also the primary-key of another relation schema R2, then X is called a foreign key from R1 referencing R2 (6) With respect to integrity mechanisms in DBS, assertion is a predicate expressing a condition that we wish the database always to satisfy (7) Given R={A, B, C, D}, and F={A (B, B ( C, B( D} holds on R. The restriction of F to R1(A,C, D) isA (C，A (D, (A)+ is A、B、C、D . (8) For functional dependencies F and G, if F+= G+, then F and G are defined to be equivalent . (9)The commonly-used schemes of organization of records in files are heap file organization, sequential file organization , and hashing file organization. (10) Two main query optimization strategies are cost-based optimization and heuristic optimization Choice (1 x 14 points) (1) If we want to define an integrity constraint on the DB, and also the remedy actions taken by the DBMS when the constraint being violated, which integrity mechanism in DBS is desirable ? B A. foreign key B. trigger C. assertion D. create statement in SQL (2) In the following functional dependencies holding on R(A, B, C, D, E), A is trivial,