Answer Posted / sachin

Normalization is a method of break down complex table’s
structure into simple table structure by using certain
rules. Normalization usually involves dividing a database
into two or more tables and defining relationships between
the tables. The objective of Normalization is to isolate
data so that additions, deletions, and modifications of a
field can be made in just one table and then propagated
through the rest of the database via the defined
relationships. With the help of this method we can reduce
redundancy in a table and remove the problems of
inconsistency and reduce the amount of space.

see more info on this link

http://www.mindstick.com/Articles/88d5a271-b369-4c0a-ae80-01e66df98b6a/?What%20is%20Normalization?

What is oracle thin client?

970

---

Why use resource manager in Oracle?

1049

---

List out the types of joins.

1079

---

How to assign values to data fields in record variables?

972

---

Why do we use bulk collect in oracle?

1008

---

Why do we use coalesce function in oracle?

1050

---

How to experiment a data lock in oracle?

998

---

What are the general rules on data consistency?

955

---

How to compare dates in oracle sql?

1040

---

Explain rename?

922

---

What are joins, explain all types of joins?

2217

---

Difference between inner join vs where ?

976

---

Why do you use stored procedures and state some of its disadvantages?

967

---

What is Data Dictionary Cache in Oracle?

1116

---

Assuming that you are an End User How to find that in the payment Batch some of the Invoice was  Missing To pay How to find That??

1667

---