Answer Posted / 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 |
Post New Answer View All Answers
What are the benefits of stored procedures?
what is acid property in database? : Sql dba
How to use sql*plus built-in timers?
What is a field in a database?
Why schema is used in sql?
what is recursive stored procedure? : Sql dba
Does sql view stored data?
how to dump a table to a file with 'mysqldump'? : Sql dba
What are the disadvantages of not performing database normalization?
What is trigger and how to use it in sql?
What is the command used to fetch the first 5 characters of a string?
What does the hierarchical profiler does?
How would you pass hints to the sql processor?
What is sql*plus?
what are the 'mysql' command line options? : Sql dba