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.

What do you mean by merge in oracle?

943

---

How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?

972

---

What is oracle rowcount?

1041

---

How do we create privileges in oracle?

995

---

How to pass a parameter to a cursor in oracle?

1115

---

Explain view?

985

---

Explain the blob datatype?

1026

---

How to drop an existing table in oracle?

1017

---

What are the uses of a database trigger?

937

---

What is the purpose of tables, private synonyms and public synonyms in Oracle?

992

---

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

2059

---

Please explain oracle left join with an example?

967

---

Where is the export dump file located?

1086

---

src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));

1635

---

How many types of database triggers exist?

1074

---