Answer / sohail

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

Answer / lakshmi

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

Answer / suresh somayajula

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

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.

Answer / abc

normalization is a process to remove data redundancy

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.

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...

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.

Answer / priya

can you explain with example...

using subquery how can i calculate working days in a month?

3 Answers   Spice Telecom,

What is equi join in sql?

0 Answers  

Why we use sql profiler?

0 Answers  

What is the usage of when clause in trigger?

0 Answers  

Why do we use joins?

0 Answers  

What is dcl in sql?

0 Answers  

Why plvtab is considered as the easiest way to access the pl/sql table?

0 Answers  

Can 2 queries be executed simultaneously in a distributed database system?

0 Answers  

declare v_count number(8,3); v_sal scott.emp.sal%type := '&P_sal'; cursor cur_name is select sal from scott.emp where sal between (v_sal-100) and (v_sal +1000); begin v_count :=nvl(sql%rowcount ,0); if v_count = 0 then dbms_output.put_line('no records are fetch in the given sal range'); else dbms_output.put_line('There is/are '||to_char(v_count)|| ' salaries are selected in the given range '); end if; end; in the above programm .....for any sal range ....always it shows the following message.. no records are fetch in the given sal range please find the mistake and share with me...with thansk and regards..sarao....

3 Answers   Satyam,

Initially question was asked to mention the types of indexes. Then asked about BITMAP INDEX and B-Tree Index

2 Answers   Polaris,

where are cookies actually stored on the hard disk? : Sql dba

0 Answers  

what is the difference between implicit conversions and explicit conversions?

2 Answers