关系运算（Relation operation）.docVIP

关系运算（Relation operation） The second part is relational database First, individual choice questions 1., the relation model describes the error as. A. is based on rigorous mathematical theories, set theory, and predicate calculus formulas Most of B. microcomputer DBMS adopt relational data model C. represents a relational model with a two-dimensional table, and is one of its major features D. does not have connection operations and DBMS can also be relational database systems Answer: D 2. relational database management systems should be able to implement specialized relational operations, including. A. sort, index, statistics, B. selection, projection, connection C. Association, update, sort, D. display, print, tab Answer: B In the 3. relational model, a keyword is. A. can be made up of multiple arbitrary attributes B. consists of at most one attribute C. can consist of one or more attributes whose value uniquely identifies any tuple in the relational schema No more than D. Answer: C 4. in a relation, if there is such an attribute, its value can uniquely identify each tuple in the relationship, called the attribute . A. keyword B. data item C. main property D. master property value Answer: A 5. the two tuple values of the same relational model. A. cannot be the same as B. C. must be all over D., none of them Answer: A 6. in the usual mood. In this case, the following relationship cannot be used as a relational database. A.R1 (student number, student name, gender) B.R2 (student number, student name, class number) C.R3 (student number, student name, dormitory number) D.R4 (student number, student name, CV) Answer: D 7. each record in a relational database file. The order of A. cannot be reversed at any time. It must be arranged in the order of input The order of B. can be reversed without affecting the data relation in the library The order of C. can be reversed at any time, but the sequence is different, and the result of statistical processing may be different The ord