Home »
MCQs »
DBMS MCQs
DBMS Normalization MCQs
DBMS Normalization MCQs: This section contains multiple-choice questions and answers on normalization in DBMS.
Submitted by Anushree Goswami, on April 01, 2022
1. A ___ is normalized after it has been organized.
- Table
- Database
- Row
- Column
Answer: B) Database
Explanation:
A database is normalized after it has been organized.
Discuss this Question
2. By normalizing relations or sets of relations, one minimizes ___.
- Data
- Fields
- Redundancy
- Database
Answer: C) Redundancy
Explanation:
By normalizing relations or sets of relations, one minimizes redundancy.
Discuss this Question
3. In addition to removing undesirable characteristics, normalization also eliminates ___ anomalies.
- Insert
- Update
- Delete
- All of the above
Answer: D) All of the above
Explanation:
In addition to removing undesirable characteristics, normalization also eliminates insert, update, and delete anomalies.
Discuss this Question
4. A common approach to normalization is to ___ the larger table into smaller tables and link them together by using relationships.
- Add
- Subtract
- Multiply
- Divide
Answer: D) Divide
Explanation:
A common approach to normalization is to divide the larger table into smaller tables and link them together by using relationships.
Discuss this Question
5. Redundancy is reduced in a database table by using the ___ form.
- Abnormal
- Normal
- Special
- None
Answer: B) Normal
Explanation:
Redundancy is reduced in a database table by using the normal form.
Discuss this Question
6. In practical applications, how many types of Normal Forms are there?
- 3
- 4
- 5
- 6
Answer: B) 4
Explanation:
There are 4 types of normal forms.
Discuss this Question
7. Which of the following is not a type of Normal Form?
- 1NF
- 2NF
- 3NF
- 10NF
Answer: D) 10NF
Explanation:
10NF is not a type of Normal Form.
Discuss this Question
8. Which of the following is a type of Normal Form?
- ACNF
- BCNF
- CCNF
- DCNF
Answer: B) BCNF
Explanation:
BCNF is a type of Normal Form.
Discuss this Question
9. When a relation contains an atomic value, it is a ___ relation.
- 1NF
- 2NF
- 3NF
- BCNF
Answer: A) 1NF
Explanation:
When a relation contains an atomic value, it is a 1NF relation.
Discuss this Question
10. 2NF relations are those that are in 1NF with all the attribute types dependent on the ___ key.
- Primary
- Foreign
- Composite
- Alternate
Answer: A) Primary
Explanation:
2NF relations are those that are in 1NF with all the attribute types dependent on the primary key.
Discuss this Question
11. When a relation is in 2NF and there is ___, it is in 3NF.
- Transition Dependency
- No Transition Dependency
- Relational Dependency
- No Relational Dependency
Answer: B) No Transition Dependency
Explanation:
When a relation is in 2NF and there is no transition dependency, it is in 3NF.
Discuss this Question
12. A relation is in ___ if it is in Boyce Codd normal form and does not have any multivalued dependencies.
- 1NF
- 2NF
- 3NF
- 4NF
Answer: D) 4NF
Explanation:
A relation is in 4NF if it is in Boyce Codd normal form and does not have any multivalued dependencies.
Discuss this Question
13. If a relation has a 4NF and no join dependency, and when it joins, it should be___, it is considered 5NF.
- Lossful
- Lesser
- Lossless
- Full
Answer: C) Lossless
Explanation:
If a relation has a 4NF and no join dependency, and when it joins, it should be lossless, it is considered 5NF.
Discuss this Question
14. What is TRUE about the First Normal Form (1NF)?
- If a relation contains an atomic value, it will be 1NF.
- A table attribute cannot contain more than one value, according to this rule.
- A single-valued attribute can only be stored in it.
- All of the above
Answer: D) All of the above
Explanation:
In case of First Normal Form (1NF) -
- If a relation contains an atomic value, it will be 1NF.
- A table attribute cannot contain more than one value, according to this rule.
- A single-valued attribute can only be stored in it.
Discuss this Question
15. Neither multivalued nor composite attributes, nor their combinations, may be used in the ___ normal form.
- First
- Second
- Third
- fourth
Answer: A) First
Explanation:
Neither multivalued nor composite attributes, nor their combinations, may be used in the first normal form.
Discuss this Question
16. What is TRUE about the Second Normal Form (2NF)?
- Relational must belong to 1NF in the 2NF.
- All attributes other than the primary key are fully functional in the second normal form
- Both A and B
- None of the above
Answer: C) Both A and B
Explanation:
In case of Second Normal Form (2NF) -
- Relational must belong to 1NF in the 2NF.
- All attributes other than the primary key are fully functional in the second normal form
Discuss this Question
17. What is TRUE about the Third Normal Form (3NF)?
- When a relation is in 2NF and does not contain transitive partial dependencies, it will be in 3NF.
- Data duplication is reduced by using 3NF.
- It helps maintain the integrity of the data.
- All of the above
Answer: D) All of the above
Explanation:
In case of Third Normal Form (3NF) -
- When a relation is in 2NF and does not contain transitive partial dependencies, it will be in 3NF.
- Data duplication is reduced by using 3NF.
- It helps maintain the integrity of the data.
Discuss this Question
18. Non-prime attributes cannot be transitively dependent, so the relation must have the ___ normal form.
- First
- Second
- Third
- Fourth
Answer: C) Third
Explanation:
Non-prime attributes cannot be transitively dependent, so the relation must have the third normal form.
Discuss this Question
19. There needs to be which of the following conditions for each nontrivial dependency of function X on function Y for a relation to be in third normal form.
- A super key is X.
- Every element of Y is a part of some candidate key, i.e, Y is a prime attribute.
- Either A or B
- None of the above
Answer: C) Either A or B
Explanation:
There needs to be at least one of the following conditions for each nontrivial dependency of function X on function Y for a relation to be in third normal form.
- A super key is X.
- Every element of Y is a part of some candidate key, i.e, Y is a prime attribute.
Discuss this Question
20. What is TRUE about BCNF?
- The advanced version of 3NF is BCNF.
- BCNF is stricter than 3NF.
- The super key is X for any functional dependency of X -> Y in the table.
- All of the above
Answer: D) All of the above
Explanation:
In case of BCNF -
- The advanced version of 3NF is BCNF.
- BCNF is stricter than 3NF.
- The super key is X for any functional dependency of X -> Y in the table.
Discuss this Question
21. A relation is in ___ if it is in Boyce Codd normal form and does not have any multivalued dependencies.
- 1NF
- 2NF
- 3NF
- 4NF
Answer: D) 4NF
Explanation:
A relation is in 4NF if it is in Boyce Codd normal form and does not have any multivalued dependencies.
Discuss this Question
22. If more than one value of B is present for a single value of A in a dependency A -> B, then the relationship is ___.
- Single
- Multi-valued
- Both a and b
- None of the above
Answer: B) Multi-valued
Explanation:
If more than one value of B is present for a single value of A in a dependency A*B, then the relationship is multi-valued.
Discuss this Question
23. What is TRUE about 5NF?
- A relation is in 5NF if it is in 4NF, does not contain any join dependencies, and has lossless joining.
- In order to avoid redundancy, 5NF ensures that the tables are broken up in as many ways as possible.
- Project-join normal form (5NF) is sometimes referred to as Project-join NF.
- All of the above
Answer: D) All of the above
Explanation:
In case of 5NF -
- A relation is in 5NF if it is in 4NF, does not contain any join dependencies, and has lossless joining.
- In order to avoid redundancy, 5NF ensures that the tables are broken up in as many ways as possible.
- Project-join normal form (5NF) is sometimes referred to as Project-join NF.
Discuss this Question