Which normal form eliminates all transitive dependencies? MCQ with Answer and Explanation

Question

Share Report Error

Which normal form eliminates all transitive dependencies?

A. 2NF

B. 3NF

C. BCNF

D. 1NF

Answer: Option B

Solution (By JKSSB Mock Tests)

Third Normal Form (3NF) eliminates transitive dependencies, where non-key attributes depend on other non-key attributes.

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

Which SQL function is used to find the maximum value in a column?

A. MAX()

B. MIN()

C. SUM()

D. AVG()

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
MAX() returns the highest value in a selected column.

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

Question #2

Which aggregate function is used to count the number of rows in a table?

A. COUNT

B. SUM

C. MAX

D. AVG

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
COUNT returns the number of rows in a table or group.

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

Question #3

Which of the following is a collection of related data that is stored in a structured format?

A. Data warehouse

B. DBMS

C. Information

D. Database

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
A database is an organized collection of related data, typically stored electronically and accessed through a DBMS.

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

Explore All Database Management System (DBMS) MCQs