Which normal form requires that every determinant is a candidate key? MCQ with Answer and Explanation

Question Report Error

Which normal form requires that every determinant is a candidate key?

A. 3NF

B. 2NF

C. BCNF

D. 1NF

Answer: Option C

Solution (By JKExamLibrary)

Boyce-Codd Normal Form (BCNF) is a stricter version of 3NF where every determinant must be 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 model represents data in the form of tables?

A. Relational model

B. Hierarchical model

C. Network model

D. Entity-Relationship model only

View Answer & Solution Discuss

Correct Answer: Option A

Explanation:
The relational model uses tables (relations) to represent data and relationships.

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

Question #2 Report Error

In an Entity-Relationship (ER) diagram, attributes are represented using which shape?

A. Rectangle

B. Diamond

C. Square

D. Ellipse/Oval

View Answer & Solution Discuss

Correct Answer: Option D

Explanation:
Ellipses or ovals are used to represent attributes (properties) of entities in ER diagrams.

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

Question #3 Report Error

What is a synonym in database terms?

A. A type of index

B. A data type

C. An alias for a table or view

D. A foreign key

View Answer & Solution Discuss

Correct Answer: Option C

Explanation:
A synonym is an alternative name for a database object, allowing simpler references.

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

Explore All Database Management System (DBMS) MCQs