The questions can come in any order, so make sure you are selecting right option for all questions.
1. Which of the following best describes the Second Normal Form (2NF) in DBMS?
(b) It ensures every non-prime attribute is dependent on the entire candidate key
2. To normalize a relation from First Normal Form (1NF) to Second Normal Form (2NF), what should be eliminated?
(c) Partial dependencies
3. According to the rules of 1NF, what does it mean for attributes to be single-valued?
(c) Each attribute must contain only one value per cell
4. What does it mean for the order of data to not matter in the context of 1NF?
(d) Data can be stored in any order within the table without affecting normalization
5. Which of the following is not a problem associated with lack of normalization in SQL databases?
(d) Data Consistency
6. Which condition must be met for a table to be considered in the First Normal Form?
(c) All attributes must be single-valued
7. What does it mean for an attribute to have a partial dependency in a relation?
(b) It depends on only part of the candidate key
8. Which scenario would violate the rule of single-valued attributes in 1NF?
(a) A column storing product categories separated by commas
9. Why is it important for every column in a table to have a unique name in 1NF?
(c) To avoid confusion during data retrieval and manipulation
10. Which of the following violates the condition of 1NF?
(a) A table with a column storing multiple author names separated by commas
11. What does the First Normal Form (1NF) ensure in a database?
(c) Atomic values and absence of repeating groups
12. What does it mean for a relation to be in Second Normal Form (2NF)?
(d) All non-prime attributes are dependent on the entire candidate key
13. What is the primary purpose of normalization in database management?
(c) To reduce redundancy and improve data integrity
14. Which of the following is a requirement for a relation to be in 2NF?
(a) Partial dependencies should be eliminated
15. Which of the following anomalies can occur if a database is not properly normalized?
(b) Insert Anomaly
16. In Second Normal Form (2NF), a relation must:
(a) Be in 1NF and have no partial dependencies
17. What does it mean for attributes to be atomic in the context of 1NF?
(c) Each attribute must contain only one value per cell
18. How does normalization contribute to database design efficiency?
(c) By simplifying the query process