Answer Posted / kannan

Defination : Normalization is the process of efficiently
organizing data in a database. There are two goals of the
normalization process: eliminating redundant data (for
example, storing the same data in more than one table) and
ensuring data dependencies make sense (only storing related
data in a table). Both of these are worthy goals as they
reduce the amount of space a database consumes and ensure
that data is logically stored. There are several benefits
for using Normalization in Database.

Benefits :

Eliminate data redundancy
Improve performance
Query optimization
Faster update due to less number of columns in one table
Index improvement

Calculate difference between 2 date / times in oracle sql?

1095

---

How to divide query output into groups in oracle?

1029

---

Is there an oracle sql query that aggregates multiple rows into one row?

1020

---

How to execute the package in oracle?

1132

---

Explain alias?

1188

---

What is the sid in oracle?

1031

---

What is private procedure oracle?

1045

---

What are the varoius components of physical database structure of oracle database?

1037

---

What is oracle server autotrace in oracle?

1218

---

How to create a stored program unit?

1314

---

What is oracle database 10g express edition?

1166

---

Explain an extent?

1150

---

What are the uses of a database trigger?

1033

---

Explain implicit cursor.

1070

---

What is index in Oracle?

1128

---