What is normalization? dec 2009
Answers were Sorted based on User's Feedback
Answer / akki julakanti
Normalization is a process to reduce the redundency in a
table.Here the redundency is reduced but not eliminated.
Is This Answer Correct ? | 6 Yes | 0 No |
Answer / tanuj
Normalization is process to remove the data redundancy from
a table.
Is This Answer Correct ? | 7 Yes | 2 No |
Answer / ratnam
Normalisation is the process of taking data from a problem
and reducing it to a set of relations while ensuring data
integrity and eliminating data redundancy
Is This Answer Correct ? | 2 Yes | 0 No |
Which are the different character-manipulation functions in sql?
What is embedded sql in db2?
what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba
How do I run a pl sql program?
Name Salary Abc 50000 Abc 50000 xyz 20000 find the max salary using aggregate function?
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....
how do you count the duplicate records in a table
While inserting 10 rows using procedure, if 3rd entry is having some error, what will be the output? How u will handle that error?
What is coalesce in sql?
Does view store data in sql?
What does fetching a cursor do?
What is the life of an sql statement?