Database management system

1. What is the primary condition for a table to be in First Normal Form (1NF)?

a) Each column must contain atomic values b) The table must have a primary key c) There should be no repeating groups d) Both a and c

2. Which of the following is a type of dependency in database normalization?

a) Functional Dependency b) Multivalued Dependency c) Join Dependency d) All of the above

3. What is a multivalued dependency in a database?

a) When an attribute depends on another attribute b) When an attribute depends on a set of attributes c) When an attribute has multiple independent values d) None of the above

4. Which normal form deals with multivalued dependencies?

a) First Normal Form (1NF) b) Second Normal Form (2NF) c) Fourth Normal Form (4NF) d) Fifth Normal Form (5NF)

5. What is the main condition for a table to be in Fourth Normal Form (4NF)?

a) It must be in Boyce-Codd Normal Form (BCNF) b) It must have no multivalued dependencies c) It must have no join dependencies d) Both a and b

6. What is a join dependency in a database?

a) When a table can be recreated by joining its projections b) When a table has redundant data c) When a table violates 1NF d) None of the above

7. Which normal form deals with join dependencies?

a) Third Normal Form (3NF) b) Fourth Normal Form (4NF) c) Fifth Normal Form (5NF) d) Boyce-Codd Normal Form (BCNF)

8. What is the main condition for a table to be in Fifth Normal Form (5NF)?

a) It must be in 4NF b) It must have no join dependencies c) It must have no cyclic dependencies d) Both a and b

9. Which of the following is true about functional dependencies?

a) They are used to define relationships between attributes b) They help in normalization c) They ensure data integrity d) All of the above

10. What is the main purpose of Fifth Normal Form (5NF)?

a) To eliminate redundancy caused by join dependencies b) To ensure data integrity c) To simplify database design d) All of the above

11. Which of the following is an example of a join dependency?

a) A table that can be decomposed into smaller tables b) A table that cannot be decomposed further c) A table with redundant data d) None of the above

12. What is the main difference between 4NF and 5NF?

a) 4NF deals with multivalued dependencies, while 5NF deals with join dependencies b) 4NF ensures data integrity, while 5NF eliminates redundancy c) 4NF is a subset of 5NF d) None of the above

13. Which of the following is a type of functional dependency?

a) Partial Dependency b) Transitive Dependency c) Full Functional Dependency d) All of the above

14. What is the main advantage of using 5NF in database design?

a) It eliminates redundancy caused by join dependencies b) It ensures data integrity c) It simplifies database maintenance d) All of the above

15. What is a cyclic dependency in a database?

a) When two or more attributes depend on each other b) When an attribute depends on itself c) When a table violates 1NF d) None of the above

Advanced Database Normalization MCQs

Your Score: /15