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

Explain the use of indexes option in imp command.

1084

---

What is the database name in oracle?

968

---

Is oracle a relational database?

870

---

What is tns entry?

1058

---

What is user managed backup in Oracle?

1075

---

How to define a data source name (dsn) in odbc manager?

965

---

How do I limit the number of rows returned by an oracle query after ordering?

1098

---

Explain alias?

1077

---

What is a oracle database?

991

---

Explain the use of parfile option in exp command.

987

---

How to create a new oracle data file?

968

---

IS it possible to built the oracle database without setting the kernal parameters?

2268

---

what is insert all statement in sql

6390

---

What happens to the current transaction if the session is killed?

924

---

What is a directory object?

1023

---