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. 2NF
B. 3NF
C. BCNF
D. 1NF
Answer: Option A
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 a foreign key in a database table?
A. A column that references the primary key of another table
B. A key that is always indexed
C. A key that allows null values
D. A key used to uniquely identify records in the same table

Correct Answer: Option A


Explanation:
A foreign key is a field in one table that links to the primary key of another table, establishing a relationship between tables.

This question belongs to: Computer Database Management System (DBMS)
Question #2
Which clause is used in SQL to sort the final query result set in ascending or descending order?
A. SORT BY
B. GROUP BY
C. ORDER BY
D. ARRANGE BY

Correct Answer: Option C


Explanation:
The ORDER BY clause is used to sort the result set of a query in either ascending (default) or descending (using DESC) order.

This question belongs to: Computer Database Management System (DBMS)
Question #3
Which of the following is not a type of database model?
A. Hierarchical
B. Flat-file
C. Object-oriented
D. Network

Correct Answer: Option B


Explanation:
Flat-file is not a database model; it is a simple file containing records. Hierarchical, Network, Relational, and Object-oriented are database models.

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