Database management system

1. What is a multivalued dependency in a database?

a) A dependency where one attribute determines multiple values of another attribute b) A dependency where one attribute determines a single value of another attribute c) A dependency where multiple attributes determine a single value d) None of the above

2. Which normal form addresses multivalued dependencies?

a) First Normal Form (1NF) b) Second Normal Form (2NF) c) Fourth Normal Form (4NF) d) Third Normal Form (3NF)

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

a) It must be in BCNF and have no multivalued dependencies b) It must be in 3NF and have no partial dependencies c) It must be in 2NF and have no transitive dependencies d) None of the above

4. Which of the following is a common pitfall in relational database design?

a) Data redundancy b) Poor normalization c) Lack of integrity constraints d) All of the above

5. What is the main goal of Second Normal Form (2NF)?

a) Eliminate partial dependencies b) Eliminate transitive dependencies c) Eliminate multivalued dependencies d) None of the above

6. What is a partial dependency in the context of 2NF?

a) When a non-prime attribute depends on part of a candidate key b) When a non-prime attribute depends on the entire candidate key c) When a prime attribute depends on a non-prime attribute d) None of the above

7. What is the main goal of Third Normal Form (3NF)?

a) Eliminate transitive dependencies b) Eliminate partial dependencies c) Eliminate multivalued dependencies d) None of the above

8. What is a transitive dependency in the context of 3NF?

a) When a non-prime attribute depends on another non-prime attribute b) When a prime attribute depends on a non-prime attribute c) When a non-prime attribute depends on part of a candidate key d) None of the above

9. Which of the following is true about Fourth Normal Form (4NF)?

a) It eliminates multivalued dependencies b) It eliminates transitive dependencies c) It eliminates partial dependencies d) None of the above

10. What is the main purpose of normalization in database design?

a) To reduce data redundancy b) To improve data integrity c) To simplify database structure d) All of the above

11. Which of the following is a common issue caused by poor database design?

a) Data anomalies b) Poor query performance c) Difficulty in maintaining the database d) All of the above

12. What is the main difference between 3NF and BCNF?

a) BCNF is stricter than 3NF b) BCNF allows partial dependencies c) BCNF eliminates multivalued dependencies d) None of the above

13. What is the main advantage of using 4NF in database design?

a) It eliminates multivalued dependencies b) It ensures data integrity c) It simplifies database maintenance d) All of the above

14. Which of the following is a common pitfall in database design?

a) Over-normalization b) Under-normalization c) Lack of proper indexing d) All of the above

15. What is the main condition for a table to be in Third Normal Form (3NF)?

a) It must be in 2NF and have no transitive dependencies b) It must be in 1NF and have no partial dependencies c) It must be in BCNF and have no multivalued dependencies d) None of the above

Advanced Database Design MCQs

Your Score: /15