ORACLE DATABASE INTERVIEW QUESTIONS

What is the Third Normal Form (3NF) in database normalization?

Why is the Third Normal Form (3NF) important in database design?

How does a table in Second Normal Form (2NF) differ from a table in Third Normal Form (3NF)?

What is a transitive dependency in the context of 3NF?

How do you convert a table that is in 2NF to 3NF?

Can a table with a single-column primary key be in violation of 3NF? Explain.

How does 3NF improve data integrity in a relational database?

How do you identify tables that violate 3NF in an existing database schema?

Explain the relationship between 3NF and functional dependency.

Describe the process of normalizing a table to Third Normal Form (3NF) with an example?