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 ?    4 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

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 2 No

Post New Answer

More SQL PLSQL Interview Questions

hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews

0 Answers  

when MSQL8.0 is in market

0 Answers  

How do you optimize SQL queries ?

6 Answers   Oracle, Infosys, CarrizalSoft Technologies,

A table has 150 records. How do you retrieve 100th row to 120th row from that table ?

21 Answers   IBM,

How we get all_group_function's(Sum,avg,count,max and min_value of a column(Sal) Using pl/sql anonymous block, with out using group function's. You shouldn't use more than one select statement in entire the program. Like cursor c is select * from <table_name>; except this you can't use another select statement. You can use no of variables as per requirement.

0 Answers  

I have a procedure in a procedure. The inner procedure contains out parameter. How I can call the inner procedure in the out procedure and send the inner procedure parameter value(out parameter value) into out procedure?

2 Answers  

package specification-3 procedures package body-2 procedures will is execute

2 Answers   PWC,

what is the forward decleration in packages?

1 Answers  

What is the relation b/w view and trigger

3 Answers   Accenture, TCS,

how to calcuate the second highest salary of he employee

13 Answers   Synechron,

What are the modes of parameters that can be passed to a procedure ?

3 Answers  

If a procedure within a package is invalidated whether the entire package will be invalid and has to be recompiled again?

2 Answers   IBM, TCS,