ORACLE DATABASE INTERVIEW QUESTIONS

What is the Second Normal Form (2NF) in database normalization?

Why is the Second Normal Form (2NF) important in database design?

How does a table in First Normal Form (1NF) differ from a table in Second Normal Form (2NF)?

What is a partial dependency in the context of 2NF?

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

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

How does 2NF improve query performance in a relational database?

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

Explain the relationship between 2NF and the concept of functional dependency?

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