数据库系统原理与技术（Principles and techniques of database systems ）.doc

数据库系统原理与技术4（Principles and techniques of database systems 4） First, the multiple-choice question 1 the equivalent connection is the natural connection. A. the same B. different, natural connections are two tables, common connections C. different natural join connection conditions have no equivalent requirement D. different natural connection conditions have equivalent requirements D 2 relational database management systems should be able to implement specialized relational operations, including. A. sort, index, statistics B. selection, projection, and connection C. Association, update, sort D. display, print, tab B The longest operation that takes the longest time in relational computing is (3). A. cannot be subdivided B. selection C. Cartesian product D. addition C 4, with the relationship R, according to the conditions of F to select the relationship R, the correct is (). A.R * R B.R-R C. delta f (R) D. - f (R) C 5, if we want to take out two columns from a given relation, we should take the arithmetic of relation algebra A. selection B. projection C. connection B 6 in relational algebra, the five basic operations are (). A. combination, difference, selection, projection, and natural connection B. combination, difference, intersection, selection, projection C. sum, difference, selection, projection, product D. Union, difference, intersection, choice, product C 7 natural connection is a new and effective method. In one case, when a natural connection is used between the relational R and the S, R and S are required to contain one or more common (). A. tuple B. rows C. records the D. property D 8 the operation of selecting new attributes from relationships to form new relationships is called (). A. select operation, B. projection operation C. connect arithmetic D. intersection operation B 9 relational database management systems should be able to implement specialized relational operations, including. A. sort, index, statistics, B. selection, projection, connection C