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

Question
Which normal form eliminates transitive dependencies?
A. 3NF
B. 2NF
C. BCNF
D. 1NF
Answer: Option A
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
What is the purpose of the SQL 'JOIN' clause?
A. To combine rows from two or more tables based on a related column
B. To delete records from a table
C. To create a new table
D. To combine columns from multiple tables into a single table
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
JOIN is used to combine rows from different tables based on a common column, allowing querying across related tables.
This question belongs to: Computer Database Management System (DBMS)
Question #2
Which constraint ensures that every value in a specific column is unique across all rows in that table, but still permits a NULL value?
A. UNIQUE
B. PRIMARY KEY
C. FOREIGN KEY
D. CHECK
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
The UNIQUE constraint prevents duplicate entries in a column. Unlike a Primary Key, a UNIQUE constraint typically allows one or more rows to store NULL values depending on the database engine.
This question belongs to: Computer Database Management System (DBMS)
Question #3
What does the ROLLBACK statement do?
A. Starts a new transaction
B. Saves the changes
C. Creates a savepoint
D. Undoes all changes made in the current transaction
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
ROLLBACK reverts the database to the state it was in at the beginning of the transaction, undoing all changes.
This question belongs to: Computer Database Management System (DBMS)
Explore All Database Management System (DBMS) MCQs
Today's Top Topics
Memory and Storage Devices 438 Computer Networking 325 Computer Abbreviations 369 Database Management System (DBMS) 278 CPU (Central Processing Unit) 327
Explore Subjects
Maths 5575 Geography GK 6121 Economy GK 2220 History GK 3374 Accountancy and Statistics 3179
Practice Mix
The 'Deccani' style of painting developed in:
He ___ be very upset; he's not talking to anyone.
Which cloud type appears as thin, feathery streaks?
Two numbers are in the ratio 4:8 and their sum is 512. Find the numbers.
By the time you return, I ________ the house.