Which normal form addresses partial dependencies, i.e., non-prime attributes dependent on part of a composite primary key? MCQ with Answer and Explanation

Which normal form addresses partial dependencies, i.e., non-prime attributes dependent on part of a composite primary key?
A. BCNF
B. 1NF
C. 2NF
D. 3NF
Answer: Option C
Solution (By JKSSB Mock Tests)
Second Normal Form (2NF) eliminates partial dependencies by ensuring all non-key attributes are fully functionally dependent on the entire primary key.

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 an alternate key?
A. A foreign key
B. The primary key
C. A super key with extra attributes
D. A candidate key that is not chosen as the primary key

Correct Answer: Option D


Explanation:
An alternate key is any candidate key that is not the primary key.

This question belongs to: Computer Database Management System (DBMS)
Question #2
In the relational model, what is the term used to describe the header or definition of a table specifying its name and attributes?
A. Relation Card
B. Relation Domain
C. Relation Instance
D. Relation Schema

Correct Answer: Option D


Explanation:
A Relation Schema defines the structure of a relation, specifying its name and the list of attributes along with their data types.

This question belongs to: Computer Database Management System (DBMS)
Question #3
Which constraint ensures that all values in a column are unique?
A. CHECK
B. FOREIGN KEY
C. UNIQUE
D. PRIMARY KEY

Correct Answer: Option C


Explanation:
UNIQUE constraint ensures that all values in a column are distinct, but allows NULL (unless combined with NOT NULL).

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