What is normalization ?

Answers were Sorted based on User's Feedback



What is normalization ?..

Answer / sohail

Normalization is a rule applied on the database table in
order to remove redundancy of data.

Is This Answer Correct ?    12 Yes 1 No

What is normalization ?..

Answer / lakshmi

Normalization is the process of breaking of data and
storing it into different tables to reduce the redundency
and to avoid nulls

Is This Answer Correct ?    10 Yes 0 No

What is normalization ?..

Answer / suresh somayajula

Normalization is the process of organizing the table to
remove redundancy.

Is This Answer Correct ?    8 Yes 0 No

What is normalization ?..

Answer / amruta

It is a step by step process to decompose or brake a large
table into smaller no of tables. To eliminate Insertion,
updating and deletion anomalies.

Is This Answer Correct ?    7 Yes 2 No

What is normalization ?..

Answer / abc

normalization is a process to remove data redundancy

Is This Answer Correct ?    5 Yes 0 No

What is normalization ?..

Answer / ganesh

Normalization is the process of splitting a table into
smaller units to avoid redundancy and reducing the retrieval
time of a data. Let consider if your table having more than
one million records. Now you want to pick up the name or
data of a particular person in a table. It will take much
time to display the data. To overcome this drawback we user
normalization.

Is This Answer Correct ?    3 Yes 0 No

What is normalization ?..

Answer / dhivya

Normalization is a process of designing a database in which
the redundancy is avoided. It includes several Normal forms
namely 1NF, 2NF, 3NF, BCNF, 5NF etc...

Is This Answer Correct ?    3 Yes 0 No

What is normalization ?..

Answer / seenuvasan.a

It is a process of the analysing the given relation schemas based on their Functional Dependency(FDs) and primary key to achieve the properties,

-> Minimizing redundancy.
-> Minimizing insertion,deletion,and update anomalies.

Is This Answer Correct ?    1 Yes 0 No

What is normalization ?..

Answer / priya

can you explain with example...

Is This Answer Correct ?    0 Yes 3 No

Post New Answer

More SQL PLSQL Interview Questions

Can We write bulk collect statement in triggers?

1 Answers   Polaris,


What is the difference between delete and truncate commands?

0 Answers  


What is a package ? What are the advantages of packages ?

2 Answers   Symphony,


How to convert comma separated string to array in pl/sql?

0 Answers  


How does one load ebcdic data? : aql loader

0 Answers  






Why is sql*loader direct path so fast?

0 Answers  


what is cursor procedure

1 Answers   iGate,


What is the location of pre_defined_functions.

0 Answers  


Explain locks? : Transact sql

0 Answers  


Explian rowid, rownum?

0 Answers  


Give the order of sql select?

0 Answers  


why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba

0 Answers  


Categories