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

Which normal form is stricter than 3NF and is often described as a configuration where every determinant must be a candidate key?
A. Boyce-Codd Normal Form (BCNF)
B. 5NF
C. 2NF
D. 4NF
Answer: Option A
Solution (By JKSSB Mock Tests)
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.

Discuss this Question (0)

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

Practice More Database Management System (DBMS) Questions

Question #1
Which of the following is a valid constraint in SQL?
A. FOREIGN KEY
B. PRIMARY KEY
C. All of the above
D. CHECK

Correct Answer: Option C


Explanation:
CHECK, PRIMARY KEY, FOREIGN KEY, UNIQUE, NOT NULL are all constraints in SQL.

This question belongs to: Computer Database Management System (DBMS)
Question #2
Which SQL function returns the average of a numeric column?
A. COUNT()
B. MEAN()
C. SUM()
D. AVG()

Correct Answer: Option D


Explanation:
AVG() calculates the average of the values in a numeric column.

This question belongs to: Computer Database Management System (DBMS)
Question #3
What geometric symbol is used in an Entity-Relationship (ER) diagram to represent a relationship between entities?
A. Oval
B. Diamond
C. Rectangle
D. Circle

Correct Answer: Option B


Explanation:
Diamonds are utilized in ER diagrams to depict relationships between two or more entities.

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