Answer Posted / rupa

Most often, Databases have bad designs and are not
normalized. This can greatly affect the speed of your
Database. As a general case, learn the 3 Normal Forms and
apply them at all times. The normal forms above 3rd Normal
Form are often called de-normalization forms but what this
really means is that they break some rules to make the
Database faster.

What I suggest is to stick to the 3rd normal form except if
you are a DBA (which means you know subsequent forms and
know what you're doing). Normalization after the 3rd NF is
often done at a later time, not during design.

for more information go Through below link
http://www.serverwatch.com/tutorials/article.php/2175621

What does where 1/2 mean in sql?

1058

---

How do you exit in sql?

1100

---

how do you tune the slow running queries in oracle db , explain the methodology

2637

---

What are the string functions in sql?

964

---

What is the command used to fetch first 5 characters of the string?

1383

---

What is recursive join in sql?

999

---

What is loop in pl sql?

1031

---

How do you update f as m and m as f from the below table testtable?

1841

---

What is inner join in sql?

1069

---

What is replication id?

926

---

Can %notfound return null after a fetch?

1049

---

Why function is used in sql?

934

---

What does where 1 1 mean in sql?

1024

---

How is debugging done?

961

---

What does (*) mean in sql?

943

---