Which normal form enforces that no non-prime attribute depends on a subset of a candidate key? MCQ with Answer and Explanation

Question

Share Report Error

Which normal form enforces that no non-prime attribute depends on a subset of a candidate key?

A. 3NF

B. BCNF

C. 1NF

D. 2NF

Answer: Option D

Solution (By JKSSB Mock Tests)

2NF eliminates partial dependencies, i.e., non-prime attributes dependent on part of any candidate key.

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

Request complete Subject PDF

Discuss this Question (0)

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

Practice More Database Management System (DBMS) Questions

Question #1

What is the purpose of the SQL 'CHECK' constraint?

A. To define relationships

B. To set a default value

C. To enforce uniqueness

D. To validate data based on a condition

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
CHECK constraint ensures that values in a column meet a specified condition, such as age > 0.

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

Question #2

Which schema architecture level describes how the data is physically stored on disk storage media?

A. Internal Level

B. Logical Level

C. External Level

D. Conceptual Level

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
The Internal (or Physical) level of the three-schema architecture describes the physical storage structure and access paths of the database.

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

Question #3

The total number of attributes (columns) present in a relation determines its what?

A. Degree

B. Domain

C. Cardinality

D. Schema

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
The number of attributes or columns in a relation is defined as the degree of that relation.

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

Explore All Database Management System (DBMS) MCQs