Answer Posted / hema kumar sunnapu

Database designed based on the E-R model may have some amount of inconsistency, ambiguity and redundancy. To resolve these issues we have to do some amount of refinement is required. This refinement process is called as Normalization.
(OR)
Normalization is the process of efficiently organizing data in database. There are two goals of the normalization process: eliminating redundant data and ensuring data dependency make sense.

Can select statements be used on views in oracle?

981

---

What are the oracle built-in data types?

1008

---

Why is oracle so popular?

940

---

How to count groups returned with the group by clause in oracle?

1010

---

Explain an index segment?

1039

---

If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?

2243

---

How do you bind variables in oracle?

927

---

How would you go about verifying the network name that the local_listener is currently using?

1993

---

How to synchronize 2 schema's objects?

2114

---

How to rename an existing table?

1048

---

How to omit columns with default values in insert statement in oracle?

995

---

Does oracle database need java?

939

---

What is materialized view in Oracle?

1042

---

What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar

4478

---

What are the different types of modules in oracle forms?

951

---