What is Normalization ?
Answer Posted / vikas mohan
It is a technique for designing a database system and is a
process in which data in a single table is being replaced
into number of tables with the same data along with some key
relationships being set up among the tables.
and also reducing duplication in the database,with
the ultimate goal of eliminating duplicate data entirely.
all the best
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Why do we use bulk collect in oracle?
How to test null values?
How do you increase the OS limitation for open files (LINUX and/or Solaris)?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
What is Segment Advisor in Oracle?
What is ceil and floor in oracle?
How can Oracle users be audited?
Is there an oracle sql query that aggregates multiple rows into one row?
ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process
Explain the different normalization forms?
What is rowid and rownum in oracle?
What is coalesce function?
What is the order of defining local variables and sub procedures/functions?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
What is the difference between substr & instr functions?