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.

How to create a new tablespace in oracle?

983

---

What privilege is needed for a user to connect to oracle server?

990

---

How to build data dictionary view an new database?

1009

---

What is ASM (Automatic Storage Management) in Oracle?

1192

---

What are the components of logical database structure in oracle database?

1086

---

What is the best way to do multi-row insert in oracle?

1065

---

What is meant by a deadlock situation?

1109

---

What is rich query?

979

---

What is data type in oracle?

1121

---

what is difference between sql plus and sql*plus? (not sql and sql plus).

3895

---

What is Trigger in Oracle?

1170

---

How will you write a query to get a 5th rank student from a table student_report?

1863

---

Explain the different normalization forms?

1088

---

Give the different types of rollback segments.

1030

---

How can we view last record added to a table?

1038

---