Revision Test - SU 5 (Chapter 6)

RevisionTest - SU 5 (Chapter 6)  Return to Assessment List Part 1 of 3 - True | False / 10.0 Points Question 1 of 35 1.0 Points Dependencies that are based on only a part of a composite primary key are called transitive dependencies. True Fals e Question 2 of 35 1.0 Points Since a partial dependency can exist only if a table's primary key is composed of several attributes, if a table in 1NF has a single-attribute primary key, then the table is automatically in 2NF. True Fals e Question 3 of 35 1.0 Points Repeating groups must be eliminated by ensuring that each row defines a single entity. True Fals e Question 4 of 35 1.0 Points Normalization represents a micro view of the entities within the ERD. True Fals e Question 5 of 35 1.0 Points It is possible for a table in 2NF to exhibit transitive dependency (where the primary key may rely on one or more nonprime attributes to functionally determine other nonprime attributes). True Fals e Question 6 of 35 1.0 Points The combination of normalization and ER modeling yields a useful ERD, whose entities can be translated into appropriate table structures. True Fals e Question 7 of 35 1.0 Points Dependency diagrams are very helpful in getting a bird’s-eye view of all the relationships among a table’s attributes. True Fals e Question 8 of 35 1.0 Points All relational tables satisfy the 1NF requirements. True Fals e Question 9 of 35 1.0 Points In order to meet performance requirements, portions of the database design may need to be occasionally denormalized. True Fals e Question 10 of 35 1.0 Points Normalization is a process that is used for changing attributes to entities. True Fals e Part 2 of 3 - Multiple Choice / 15.0 Points Question 11 of 35 1.0 Points A table that is in 2NF and contains no transitive dependencies is said to be in _____.  A. 1NF  B. 2NF  C. 3NF  D. 4NF Question 12 of 35 1.0 Points A relational table must not contain a(n) _____.  A. entity  B. attribute  C. relationship  D. repeating group Question 13 of 35 1.0 Points Attribute A _____ attribute B if all of the rows in the table that agree in value for attribute A also agree in value for attribute B.  A. determines  B. derives from  C. controls  D. owns Question 14 of 35 1.0 Points From a system functionality point of view, _____ attribute values can be calculated when they are needed to write reports or invoices.  A. derived  B. atomic  C. granular  D. historical Question 15 of 35 1.0 Points From a structural point of view, 3NF is better than _____.  A. 2NF  B. 3NF  C. 5NF  D. 6NF Question 16 of 35 1.0 Points Improving _____ leads to more flexible queries.  A. atomicity  B. normalization  C. denormalization  D. derived attribute Question 17 of 35 1.0 Points Granularity refers to _____.  A. the size of a table  B. the level of detail represented by the values in a table's row  C. the number of attributes represented in a table  D. the number of rows in a table Question 18 of 35 1.0 Points From a structural point of view, 2NF is better than _____.  A. 1NF  B. 3NF  C. 4NF  D. BCNF Question 19 of 35 1.0 Points Data warehouse routinely uses _____ structures in its complex, multilevel, multisource data environment.  A. 1NF  B. 2NF  C. 3NF  D. 4NF Question 20 of 35 1.0 Points In a _____ situation, one key determines multiple values of two other attributes and those attributes are independent of each other.  A. multivalued dependency  B. transitive dependency  C. partial dependency  D. functional dependency Question 21 of 35 1.0 Points An atomic attribute _____.  A. cannot exist in a relational table  B. cannot be further subdivided  C. displays multiplicity  D. is always chosen to be a foreign key Question 22 of 35 1.0 Points A _____ derives its name from the fact that a collection of multiple entries of the same type can exist for any single key attribute occurrence.  A. partial dependency  B. transitive dependency  C. repeating group  D. primary key Question 23 of 35 1.0 Points A(n) _____ exists when there are functional dependencies such that Y is functionally dependent on X, Z is functionally dependent on Y, and X is the primary key.  A. partial dependency  B. repeating group  C. atomic attribute  D. transitive dependency Question 24 of 35 1.0 Points An attribute that is part of a key is known as a(n) _____ attribute.  A. important  B. nonprime  C. prime  D. entity Question 25 of 35 1.0 Points The most likely data type for a surrogate key is _____.  A. character  B. date  C. logical  D. numeric Part 3 of 3 - Fill in the Blank / 10.0 Points Question 26 of 35 1.0 Points What follows is a fill in the blank question with 1 blanks. The price paid for increased performance through denormalization is a larger amount of redundancy data redundancy . Question 27 of 35 1.0 Points What follows is a fill in the blank question with 1 blanks. In order to meet performance requirements, you may have to denormalize some portions of a database design. Question 28 of 35 1.0 Points What follows is a fill in the blank question with 1 blanks. The concept of concept of keys is central to a discussion of normalization. Question 29 of 35 1.0 Points What follows is a fill in the blank question with 1 blanks. An attribute that cannot be further subdivided is said to display atomicity . Question 30 of 35 1.0 Points What follows is a fill in the blank question with 1 blanks. According to the data-modeling checklist, entity names names should be nouns that are familiar to business, should be short and meaningful, and should document abbreviations, synonyms, and aliases for each entity. Question 31 of 35 1.0 Points What follows is a fill in the blank question with 1 blanks. All relational tables satisfy the 1NF requirements. Question 32 of 35 1.0 Points What follows is a fill in the blank question with 1 blanks. Normalization is a process to help reduce the likelihood of data anomalies. Question 33 of 35 1.0 Points What follows is a fill in the blank question with 1 blanks. In a real-world environment, changing granularity requirements might dictate changes in primary key selection, and those changes might ultimately require the use of surrogate keys. Question 34 of 35 1.0 Points What follows is a fill in the blank question with 1 blanks. It becomes difficult to create a suitable foreign key when the related table uses a composite primary key. Question 35 of 35 1.0 Points What follows is a fill in the blank question with 1 blanks. Because a partial dependency can exist only when a table's primary key is composed of several attributes, a table whose primary key consists of only a single attribute is automatically in 2NF once it is in 1NF.