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. 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

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)
Question #2 Report Error
What is the term for a column in a database table?
A. Entity
B. Tuple
C. Relation
D. Attribute

Correct Answer: Option D


Explanation:
An attribute is a column or field in a table, representing a property of the entity.

This question belongs to: Computer Database Management System (DBMS)
Question #3 Report Error
What is the difference between a database and a database management system?
A. A database is the data; DBMS is the software that manages it
B. They are the same
C. Database is a file; DBMS is a table
D. DBMS is the data; database is the software

Correct Answer: Option A


Explanation:
A database is a collection of structured data, while a DBMS is the software used to interact with and manage that data.

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