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. 1NF

C. BCNF

D. 3NF

Answer: Option D

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

In the context of databases, what is a 'tuple'?

A. A column of a table

B. A table itself

C. A key constraint

D. A row of a table

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
In relational databases, a tuple is a single row or record of a table.

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

Question #2

Which of the following is NOT an aggregate function in standard SQL?

A. AVG()

B. LENGTH()

C. SUM()

D. COUNT()

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
SUM(), AVG(), and COUNT() are aggregate functions operating on multiple rows, whereas LENGTH() is a scalar function acting on a single text value.

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

Question #3

Which of the following is an example of a relational database management system (RDBMS)?

A. Oracle Database

B. MongoDB

C. Cassandra

D. Redis

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Oracle Database is a well-known RDBMS. MongoDB, Redis, and Cassandra are NoSQL databases.

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

Explore All Database Management System (DBMS) MCQs