Which normal form is stricter than 3NF and is often described as a configuration where every determinant must be a candidate key? MCQ with Answer and Explanation

Question Report Error

Which normal form is stricter than 3NF and is often described as a configuration where every determinant must be a candidate key?

A. 4NF

B. 5NF

C. Boyce-Codd Normal Form (BCNF)

D. 2NF

Answer: Option C

Solution (By JKExamLibrary)

Boyce-Codd Normal Form (BCNF) is a stronger version of 3NF. A relation is in BCNF if, for every non-trivial functional dependency X -> Y, X is a candidate key.

This question belongs to: Computer Database Management System (DBMS)

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Database Management System (DBMS) Questions

Question #1 Report Error

Which condition-tester returns TRUE if a subquery returns one or more records, and FALSE if the subquery returns no rows?

A. EXISTS

B. IN

C. ALL

D. ANY

View Answer & Solution Discuss

Correct Answer: Option A

Explanation:
The EXISTS operator is used to test for the presence of any records in a subquery, returning TRUE as soon as a single matching row is encountered.

This question belongs to: Computer Database Management System (DBMS)