OCI Question:
Download Questions PDF

What is database normalization?

Answer:

Normalization means the process in which raw data is
converted to filtered data.
Types of Normalization are:- 1NF,2NF,3NF.

1NF:- Table that contains one or more repeating groups
Identify and remove repeating groups.

2NF:-Describes a table that is fully functionally dependent
Full functional dependency – means that if B is
functionally dependent on A but not on any proper subset of
A, it is fully functionally dependent on A
Partial dependency – is if there are some attributes from A
that can be removed and the dependency still holds

3NF:- In 3NF we remove the transitive dependencies.
Transitive dependency – A->B and B->C implies that A->C
C is transitionally dependent on A through B

Download OCI (Oracle Call Interface) Interview Questions And Answers PDF

Previous QuestionNext Question
What is difference between SQL Server and Oracle?What is the main difference between foreign key and primary key?