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

Question
Which normal form eliminates transitive dependencies?
A. BCNF
B. 3NF
C. 2NF
D. 1NF
Answer: Option B
Solution (By JKSSB Mock Tests)
Third Normal Form (3NF) removes transitive dependencies on non-prime 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 database structure is created to drastically speed up the retrieval of rows from a table at the expense of slower data updates?
A. Index
B. View
C. Constraint
D. Schema
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
An Index is a performance optimization structure created on table columns to search and locate matching rows quickly without performing a full table scan.
This question belongs to: Computer Database Management System (DBMS)
Question #2
What is the purpose of an index in a database?
A. To encrypt data
B. To speed up data retrieval operations
C. To enforce foreign key constraints
D. To compress data
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Indexes are used to improve the speed of data retrieval queries, at the cost of additional storage and maintenance overhead.
This question belongs to: Computer Database Management System (DBMS)
Question #3
Which of the following is a property of a well-designed database?
A. All of the above
B. Support for efficient data retrieval
C. Avoidance of data redundancy
D. Ease of data maintenance
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Good database design aims to minimize redundancy, simplify maintenance, and provide efficient access.
This question belongs to: Computer Database Management System (DBMS)
Explore All Database Management System (DBMS) MCQs
Today's Top Topics
Operating Systems 510 Memory and Storage Devices 438 CPU (Central Processing Unit) 327 Computer Software 347 Computer Fundamentals 326
Explore Subjects
Science 4430 Maths 5575 History GK 3374 Computer 5279 English 15164
Practice Mix
Which soil is generally found along the foothills of the Himalayas?
The Coromandel Coast receives most of its rainfall from:
Which of these is a famous folk dance of Tripura?
The 'BCCI' stands for:
What does the term 'cache hit' refer to?