二级ACCESS选择题（国外英文资料）.doc

二级ACCESS选择题（国外英文资料） The secondary access simulated test choice In relational data models, domains refer to (). Answer: D A. A tuple B. properties C. The number of units The range of properties The following is a description of the characteristics of the database system, and the error is (). Answer: B You can implement data sharing The data redundancy can be completely eliminated C. can be standardized D. can guarantee data integrity In the third level schema structure of the database system, the view pattern that the user sees is called (). Answer: A, A. outside pattern B. within the model Conceptual model Storage mode The following description of the nature of the relational model is wrong (). Answer: D There are two identical property names that are not allowed in A relationship There are two completely identical tuples in a relationship The values of each attribute in the relationship are not decomposed The tuple in the relationship cannot be changed in order Have the following two relationships: Student (number, name, sex, date of birth, professional) Major (professional, professional, professional) In these two relationships, the student and the professional are the primary keys of the student relationship and the professional relationship, and the foreign key is (). Answer: B The number of student relations Professional in student relationship Professional Professional name for professional relationships The primary key attribute of all tuples in the relationship is not null. Answer: B Referential integrity Entity integrity Referential integrity User-defined integrity The Access database () is the basis for other database objects. Answer: C A. report B. the query C. table D. data access page In e-r diagrams, use () to represent properties. Answer: B A. the rectangular B. the oval C. a triangle D. the diamond A tree structure is used to represent the data model of the relationship between entities and entities. Answer: B A. Network data model The b. hierarchica