Answer / akki julakanti

Normalization is a process to reduce the redundency in a
table.Here the redundency is reduced but not eliminated.

Answer / tanuj

Normalization is process to remove the data redundancy from
a table.

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

When would you denormalize?

8 Answers   MBT, Microsoft, MMU,

---

how to eliminate null values in a column i.e table vlaues 1 2 3 NULL 3 4 1 5 NULL i want output like this 1 2 3 3 4 1 5 i dnt want to use nvl is null and i dnt want replace the NULL value with any value i.e nvl(col,o);

11 Answers   Satyam,

---

How do you change a value in sql?

0 Answers  

---

What is the usage of distinct keyword?

0 Answers  

---

Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?

0 Answers  

---

How can use stored procedures in sql?

0 Answers  

---

If we declare constraints Unique and Not null on a single column then it will act as a Primary key, so what is the use of primary key??

3 Answers  

---

Do we need commit after truncate?

0 Answers  

---

what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba

0 Answers  

---

What is procedure in pl sql?

0 Answers  

---

Which table is left in join?

0 Answers  

---

Explain correlated query work?

0 Answers  

---