CIT 352 : DATABASE ADMINISTRATION II @ WKU FINAL
QUESTIONS & ANSWERS
1. can occur when there is a column in a table that is dependent on only
a portion of the primary key.
a. Update anomalies
b. Determination
c. Qualification
d. Function splitting: a. Update anomalies
2. A(n) is a property of an entity.
a. attribute
b. field
c. All of the above
d. column: c. All of the above
3. A(n) is the association between entities.
a. join
b. functional dependency
c. relationship
d. qualification: c. relationship
4. In an entity-relationship (E-R) diagram, are used to represent an
entity.
a. diamonds
b. circles
,c. ovals
d. rectangles: d. rectangles
5. is the formal term for combining two or more columns to form a
primary key.
a. Joining
b. Concatenation
c. Normalization
d. Qualification: b. Concatenation
6. A field is another term for a(n) .
a. entity
b. row
c. column
d. tuple: c. column
,7. is one of the categories of update anomalies.
a. Functional dependence
b. Functional splitting
c. Inconsistent data
d. Qualification: c. Inconsistent data
8. Which of the following symbols is used to qualify column names?
a. pound sign (#)
b. backslash (/)
c. period (.)
d. comma (,): c. period (.)
9. At TAL Distributors, there is a relationship between sales reps
and cus- tomers.
a. many-to-many
b. one-to-many
c. one-to-two
d. one-to-one: b. one-to-many
10. In a relational database each should be unique.
a. All of the above
b. tuple
c. record
d. row: a. All of the above
11. In this text, Boyce-Codd normal form is the same as .
, a. third normal form
b. first normal form
c. second normal form
d. unnormalized: a. third normal form
12. A relation is in if it does not contain any repeating groups.
a. Boyce-Codd normal form
b. second normal form
c. third normal form
d. first normal form: d. first normal form
QUESTIONS & ANSWERS
1. can occur when there is a column in a table that is dependent on only
a portion of the primary key.
a. Update anomalies
b. Determination
c. Qualification
d. Function splitting: a. Update anomalies
2. A(n) is a property of an entity.
a. attribute
b. field
c. All of the above
d. column: c. All of the above
3. A(n) is the association between entities.
a. join
b. functional dependency
c. relationship
d. qualification: c. relationship
4. In an entity-relationship (E-R) diagram, are used to represent an
entity.
a. diamonds
b. circles
,c. ovals
d. rectangles: d. rectangles
5. is the formal term for combining two or more columns to form a
primary key.
a. Joining
b. Concatenation
c. Normalization
d. Qualification: b. Concatenation
6. A field is another term for a(n) .
a. entity
b. row
c. column
d. tuple: c. column
,7. is one of the categories of update anomalies.
a. Functional dependence
b. Functional splitting
c. Inconsistent data
d. Qualification: c. Inconsistent data
8. Which of the following symbols is used to qualify column names?
a. pound sign (#)
b. backslash (/)
c. period (.)
d. comma (,): c. period (.)
9. At TAL Distributors, there is a relationship between sales reps
and cus- tomers.
a. many-to-many
b. one-to-many
c. one-to-two
d. one-to-one: b. one-to-many
10. In a relational database each should be unique.
a. All of the above
b. tuple
c. record
d. row: a. All of the above
11. In this text, Boyce-Codd normal form is the same as .
, a. third normal form
b. first normal form
c. second normal form
d. unnormalized: a. third normal form
12. A relation is in if it does not contain any repeating groups.
a. Boyce-Codd normal form
b. second normal form
c. third normal form
d. first normal form: d. first normal form
