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

Post New Answer



More SQL PLSQL Interview Questions

select * from emp where sal in(select max(sal) from emp) here there is any limit for in operator how many values accpect ?

2 Answers  


I Defined SP1, Sp2 (sp=StoreProcedures)In Package Specification but I Implemented Sp1, sp2, sp3, sp4, sp5 then What type of Error You will find????

3 Answers   Infosys,


I have the table like this S.No Name ID 01 Xyz 123 I want the result as 01Xyz123 How to write the query to retrieve the entire row data in a single column?

1 Answers  


can i give user defined exception in a package

2 Answers  


What is the Difference between Procedure and Function.Can we call a Function in a DML?

2 Answers   TCS,






check whether all the emp numbers are indeed unique.

6 Answers  


What is extent clause in table space?

1 Answers   TCS,


While inserting/updating million of records into a database table, how do I came to know how many records has been inserted or updated successfully so far?

2 Answers   HSBC,


i have a table with fields(id,name,accnt_type)and in account type are FD,SAVING,RD. Write a query to get How many number of People are in each type of Account?

6 Answers   IBM, Fidelity,


What are Lexical Parameters.How They are used in Reports 6i

2 Answers   eicc,


write a query to find 4th max salary

7 Answers  


what is julian date in oracle

2 Answers  






Categories