Which normal form is responsible for removing transitive dependency in database normalization?

D. Boyce-Codd Normal Form (BCNF)

Which normal form is considered stronger than the 3rd Normal Form in database normalization?

A. Boyce-Codd Normal Form (BCNF)

Computer · Database Management System · page 1 of 1

Includes 1 past paper MCQs (marked).

Timed quizzes, instant results, track your progress — free

5 MCQs with answers and a short one-liner. Hide answers to test yourself.

Answers and one-liners are hidden. Tap an option to check that question, or show all.

1.
In database normalization, what is the normal form called where every non-prime attribute must be completely dependent on every candidate key?
Correct Answer: B. 2NF
One-liner
The normal form where every non-prime attribute must be fully functionally dependent on every candidate key is 2NF (Second Normal Form).
2.
What is the term for the process of organizing a database into smaller, more manageable tables to reduce redundancy and improve data integrity?
Correct Answer: D. Normalization
One-liner
The process of organizing a database into smaller, manageable tables to reduce redundancy and improve data integrity is called Normalization.
3.
Which normal form is responsible for removing transitive dependency in database normalization?
Correct Answer: C. Third Normal Form (3NF)
One-liner
Third Normal Form (3NF) is responsible for removing transitive dependency in database normalization.
4.
Which normal form is considered stronger than the 3rd Normal Form in database normalization?
Correct Answer: A. Boyce-Codd Normal Form (BCNF)
One-liner
Boyce-Codd Normal Form (BCNF) is considered stronger than 3NF because it addresses certain anomalies that 3NF does not handle.
5.
Past Paper MCQ
Database normalization reduces?
Correct Answer: C. Data redundancy
One-liner
Database normalization reduces data redundancy by organizing data into well-structured tables and eliminating duplicate information.