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

View Answer & Solution Discuss

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;

View Answer & Solution Discuss

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

View Answer & Solution Discuss

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)

Explore All Database Management System (DBMS) MCQs