SQL Normalization
1.What is the purpose of normalization?
-
A. Increase redundancy
-
B. Organize data to reduce duplication
-
C. Speed up performance only
-
D. Create large tables
Organize data to reduce duplication
Organize data to reduce duplication
2.Which normal form eliminates repeating groups?
-
A. 1NF
-
B. 2NF
-
C. 3NF
-
D. BCNF
1NF
1NF
3.What is a partial dependency?
-
A. Attribute depends on a part of a composite key
-
B. Attribute depends on full primary key
-
C. Attribute depends on nothing
-
D. Attribute is not used
Attribute depends on a part of a composite key
Attribute depends on a part of a composite key
4.Which form removes transitive dependency?
-
A. 1NF
-
B. 2NF
-
C. 3NF
-
D. 4NF
3NF
3NF
5.What is transitive dependency?
-
A. A depends on B, B depends on C
-
B. A depends on B directly
-
C. A joins B
-
D. C depends on A
A depends on B, B depends on C
A depends on B, B depends on C