北邮数据库试题(国外英文资料).docVIP

北邮数据库试题(国外英文资料) A single choice (a total of 10 items, a total of 100 points) 1. in the following statements about the relationship, the error is _____. The value of any two lines in the A. table cannot be the same The values of any two columns in the B. table cannot be the same The order of the rows in the C. does not matter The order in which the D. column is listed does not matter Knowledge point: Relationship Relation Student answer: [B]; Standard answer: B; Score: [10] Test score: Ten Prompt: Two 3., there is a relationship model EMP (staff number, name, age, skills). That number of workers only, each employee has a number of skills, is the primary key of the EMP table is _____. A. employee number B. name, skills C. skills D. worker number, skills Knowledge point: Code Key Student answer: [D]; Standard answer: D; Score: [10] Test score: Ten Prompt: Four 5. in the relational model, to realize the data link between the use of ____________ method. A. pointer The property of B. that contains another relation in a relationship C. file name D. father son relationship Knowledge point: Relational database connections Student answer: [B]; Standard answer: B; Score: [10] Test score: Ten Prompt: Six 7. define a foreign key implementation is ______. A. entity integrity B. referential integrity C. user defined integrity D. entity integrity, referential integrity, and user defined integrity Knowledge point: Relational integrity rule Student answer: [B]; Standard answer: B; Score: [10] Test score: Ten Prompt: Eight 9. there is a relationship between students (student number, name, Department, student number range is specified) string with 8 digits, this rule belongs to _____. A. entity integrity rules B. referential integrity constraints C. user-defined integrity rules D. keyword integrity constraint Knowledge point: Relational integrity rule Student answer: [C]; Standard answer: C; Score: [10] Test score: Ten Prompt: Ten 11. on the conceptual model of database is proper ____