WGU C170 Exam Questions and Answers
(100% Correct )
1. Which normal form requires you to eliminate repeating groups in individual tables,
create a separate table for each set of related data, and identify each set of related
data with a primary key?
A. Second Normal Form
B. Third Normal Form
C. First Normal Form
D. Fourth Normal Form
Answer: C
2. Which normal form requires you to create separate tables for sets of values that
apply to multiple records and relate these tables with a foreign key?
A. First Normal Form
B. Second Normal Form
C. Third Normal Form
D. Fourth Normal Form
Answer: B
3. Which normal form requires you to eliminate fields that do not depend on the key?
A. First Normal Form
B. Second Normal Form
C. Third Normal Form
D. Boyce-Codd Normal Form
Answer: C
4. What is a number that cannot be negative called?
A. Signed number
B. Integer
C. Unsigned number
,D. Whole number
Answer: C
5. In database modeling, what is defined as a person, place, product, concept, or
activity?
A. Attribute
B. Relationship
C. Domain
D. Entity
Answer: D
6. What is a primary key that consists of more than one attribute called?
A. Candidate key
B. Superkey
C. Composite key
D. Foreign key
Answer: C
7. What is a relationship between two entity types called?
A. Unary relationship
B. Ternary relationship
C. Binary relationship
D. Recursive relationship
Answer: C
8. What is an attribute, or combination of attributes, that uniquely identifies a row in a
relation called?
A. Primary key
B. Candidate key
C. Foreign key
D. Composite key
,Answer: B
9. Which type of relationship associates occurrences of an entity type with other
occurrences of the same entity type?
A. Binary relationship
B. Ternary relationship
C. Unary relationship
D. Identifying relationship
Answer: C
10. Which type of relationship involves three different entity types?
A. Binary relationship
B. Unary relationship
C. Recursive relationship
D. Ternary relationship
Answer: D
11. What is a positive or negative number called?
A. Unsigned number
B. Integer
C. Signed number
D. Whole number
Answer: C
12. What is a characteristic describing a group of multiple entries of the same type
for a single key attribute occurrence called?
A. Partial dependency
B. Transitive dependency
C. Repeating group
D. Multivalued attribute
Answer: C
, 13. What is a column distribution of values or the number of different values a
column can have called?
A. Data redundancy
B. Data sparsity
C. Data integrity
D. Data cardinality
Answer: B
14. What is the condition by which a dependent table's foreign key must have either
a null entry or a matching entry in the related table called?
A. Entity integrity
B. Domain integrity
C. Referential integrity
D. Transitive dependency
Answer: C
15. What is a condition in which an attribute is dependent on another attribute that is
not part of the primary key called?
A. Partial dependency
B. Full functional dependence
C. Transitive dependency
D. Referential dependency
Answer: C
16. What is a condition in which an attribute is dependent on only a portion (subset)
of the primary key called?
A. Transitive dependency
B. Partial dependency
C. Full functional dependence
D. Referential dependency
Answer: B
(100% Correct )
1. Which normal form requires you to eliminate repeating groups in individual tables,
create a separate table for each set of related data, and identify each set of related
data with a primary key?
A. Second Normal Form
B. Third Normal Form
C. First Normal Form
D. Fourth Normal Form
Answer: C
2. Which normal form requires you to create separate tables for sets of values that
apply to multiple records and relate these tables with a foreign key?
A. First Normal Form
B. Second Normal Form
C. Third Normal Form
D. Fourth Normal Form
Answer: B
3. Which normal form requires you to eliminate fields that do not depend on the key?
A. First Normal Form
B. Second Normal Form
C. Third Normal Form
D. Boyce-Codd Normal Form
Answer: C
4. What is a number that cannot be negative called?
A. Signed number
B. Integer
C. Unsigned number
,D. Whole number
Answer: C
5. In database modeling, what is defined as a person, place, product, concept, or
activity?
A. Attribute
B. Relationship
C. Domain
D. Entity
Answer: D
6. What is a primary key that consists of more than one attribute called?
A. Candidate key
B. Superkey
C. Composite key
D. Foreign key
Answer: C
7. What is a relationship between two entity types called?
A. Unary relationship
B. Ternary relationship
C. Binary relationship
D. Recursive relationship
Answer: C
8. What is an attribute, or combination of attributes, that uniquely identifies a row in a
relation called?
A. Primary key
B. Candidate key
C. Foreign key
D. Composite key
,Answer: B
9. Which type of relationship associates occurrences of an entity type with other
occurrences of the same entity type?
A. Binary relationship
B. Ternary relationship
C. Unary relationship
D. Identifying relationship
Answer: C
10. Which type of relationship involves three different entity types?
A. Binary relationship
B. Unary relationship
C. Recursive relationship
D. Ternary relationship
Answer: D
11. What is a positive or negative number called?
A. Unsigned number
B. Integer
C. Signed number
D. Whole number
Answer: C
12. What is a characteristic describing a group of multiple entries of the same type
for a single key attribute occurrence called?
A. Partial dependency
B. Transitive dependency
C. Repeating group
D. Multivalued attribute
Answer: C
, 13. What is a column distribution of values or the number of different values a
column can have called?
A. Data redundancy
B. Data sparsity
C. Data integrity
D. Data cardinality
Answer: B
14. What is the condition by which a dependent table's foreign key must have either
a null entry or a matching entry in the related table called?
A. Entity integrity
B. Domain integrity
C. Referential integrity
D. Transitive dependency
Answer: C
15. What is a condition in which an attribute is dependent on another attribute that is
not part of the primary key called?
A. Partial dependency
B. Full functional dependence
C. Transitive dependency
D. Referential dependency
Answer: C
16. What is a condition in which an attribute is dependent on only a portion (subset)
of the primary key called?
A. Transitive dependency
B. Partial dependency
C. Full functional dependence
D. Referential dependency
Answer: B
