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. 2NF
B. Boyce-Codd Normal Form (BCNF)
C. 5NF
D. 4NF
Answer: Option B
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
What is the purpose of the SQL 'WITH' clause (Common Table Expression)?
A. To delete data
B. To create a view
C. To update data
D. To define a temporary result set that can be referenced within a query

Correct Answer: Option D


Explanation:
A Common Table Expression (CTE) provides a temporary named result set that can be used within a SELECT, INSERT, UPDATE, or DELETE statement.

This question belongs to: Computer Database Management System (DBMS)
Question #2 Report Error
Which of the following is a valid SQL statement to update a record?
A. CHANGE table_name SET column1 = value1 WHERE condition;
B. MODIFY table_name SET column1 = value1 WHERE condition;
C. UPDATE table_name column1 = value1 WHERE condition;
D. UPDATE table_name SET column1 = value1 WHERE condition;

Correct Answer: Option D


Explanation:
The correct syntax for UPDATE is: UPDATE table_name SET column1 = value1 WHERE condition;

This question belongs to: Computer Database Management System (DBMS)
Question #3 Report Error
Which data model uses objects, classes, and inheritance features, mirroring concepts from object-oriented programming?
A. Object-Oriented Data Model
B. Network Data Model
C. Relational Data Model
D. Flat Data Model

Correct Answer: Option A


Explanation:
The Object-Oriented Data Model integrates object-oriented programming languages directly with databases, storing data as objects with attributes and methods.

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