Answer Posted / rajaram gupta

Database normalization is a technique for designing
relational database tables to minimize duplication of
information and, in so doing, to safeguard the database
against certain types of logical or structural problems,
namely data anomalies.

For example, when multiple instances of a given piece of
information occur in a table, the possibility exists that
these instances will not be kept consistent when the data
within the table is updated, leading to a loss of data
integrity. A table that is sufficiently normalized is less
vulnerable to problems of this kind, because its structure
reflects the basic assumptions for when multiple instances
of the same information should be represented by a single
instance only.

How to upsert (update or insert into a table)?

997

---

How do I know if oracle is installed on windows?

930

---

How to start your 10g xe server?

1037

---

What is the difference between Delete, Truncate and Drop in Oracle?

1129

---

How to export data to a csv file?

1300

---

Is java required for oracle client?

996

---

What is concurrency in oracle?

1005

---

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

2129

---

What language does oracle use?

1098

---

What is Java Pool in Oracle?

1166

---

What is a data lock in oracle?

1112

---

How to use group functions in the select clause using oracle?

1069

---

How do I limit the number of oracle database connections generated by weblogic server?

1069

---

Explain the use of analyse option in exp command.

1124

---

How do we display rows from the table without duplicates?

971

---