Quiz
Untitled
Create a free account to finish this quiz
Save your progress and see your final score.
Already have an account? Sign in
Questions in this quiz (6)
1In general, denormalization produces
- Amore join
- Ba slower system response
- Cless data redundancy
- Dfaster performance.
2Some normalization forms are
- A1NF
- B2NF
- C3NF
- Dall of the above
- Enone of the above
3A table that displays data redundancies yields the following anomalies:
- Aupdate anomalies
- Binsertion anomalies
- Cdeletion anomalies
- Dall of the above
- Enone of the above
4The term first normal form (1NF) describes the tabular format in which:
- Aall the key attributes are defined.
- Bthere are no repeating groups in the table. Row/column intersection can contain one and only one value, not a set of values.
- Call attributes are dependent on the primary key
- Dall of the above
- Enone of the above
5A table is in the Fourth Normal Form (4NF) if
- AAll attributes must be dependent on the primary key, and must be dependent on each other.
- BAll attributes must be dependent on the primary key, but must be independent of each other.
- CNo row can contain two or more multivalued facts about an entity
- DA and C
- EB and C
6The conflicts between design efficiency, information requirements, and processing speed are often resolved through
- Aconversion from 1NF to 2NF
- Bconversion from 2NF to 3NF
- Ccompromises that include denormalization
- Dconversion from 3NF to 4NF
Information
- Description
- Quiz on Untitled, created by David Retts on 04/04/2021.
- Author
- David Retts
- Language
- English
- Views
- 0
- Rating
- No ratings yet Rate this quiz