ORACLE DATABASE INTERVIEW QUESTIONS

What is normalization in the context of a database?

What is the First Normal Form (1NF) in database normalization?

Why is it important for a table to be in First Normal Form (1NF)?

How do you convert a table that is not in 1NF into First Normal Form?

What are the common violations of the First Normal Form?

Can a table with a composite primary key be in First Normal Form?

How does 1NF relate to data integrity in a relational database?

How does the violation of 1NF affect the performance of SQL queries?

How do you handle null values in a table that is in First Normal Form?

Explain with an example how to ensure a table meets the First Normal Form (1NF) requirements?