Devry CIS321 Week 4 Quiz Latest 2015 November 1. Question : (TCOs 9 and 10) The value that is recorded in an attribute if a user does not specify one is known as the domain. key. default value. data type. None of the above Question 2. Question : (TCOs 9 and 10) Which of the following is a category of entities? Person Place Object Concept All of the above Question 3. Question : (TCOs 9 and 10) Any candidate key that is not selected to become the primary key is called the entity key. the concatenated key. the subsetting key. the domain key. the alternate key. Question 4. Question : (TCOs 9 and 10) The problem analysis phase model that includes only entities and relationships but no attributes is known as the enterprise data model. is known as the application data model. is known as the context data model. does not exist; all data models must have attributes. None of the above Question 5. Question : (TCOs 9 and 10) A code that assigns sequentially generated numbers to entity instances is known as a serial code. a sequential code. an alphabetic code. a significant position code. None of the above Question 6. Question : (TCOs 9 and 10) Fields whose values identify one and only one record in a file are called foreign keys. primary keys. alternative keys. concatenated keys. None of the above Question 7. Question : (TCOs 9 and 10) Which defines the minimum and maximum number of occurrences of one entity that may be related to a single occurrence of the other entity? Domain Concatenation Associative entity Cardinality None of the above Question 8. Question : (TCOs 9 and 10) An entity that inherits its primary key from more than one entity is called a(n) associative entity. concatenated entity. ternary. many-to-many cardinality. None of the above Question 9. Question : (TCOs 9 and 10) When a parent entity contributes its primary key to become part of the primary key of the child entity the relationship is known as primary. associative. nonidentifying. identifying. None of the above Question 10. Question : (TCOs 9 and 10) Which normal form deals with repeating attributes? 1NF 2NF 3NF All of the above None of the above Question 11. Question : (TCOs 9 and 10) A table in which rows indicate entities (and possible attributes) the columns indicate locations and the cells indicate the document level of access including create read update or delete is known as an entity relationship table. a transitive dependency table. a data-to-location CRUD matrix. a decision table. None of the above Question 12. Question : (TCOs 9 and 10) A Gender field can hold only the values M or F. This is an example of key integrity. domain integrity. referential integrity. logical integrity. schema integrity. Question 13. Question : (TCOs 9 and 10) Students take courses and get grades. A Course can have many Students. A Student can take many Courses. For each course the student gets a Grade. How would you define the relationship between Student and Course such that it is in 3NF?
