Answer Posted / dastagiri babu(mca),s.v.pg col

Normalization is a technique which is used to make complex
physical structure into simple physical structure. By using
normalization we can get Redundant free structure(Elimation
of duplicate values)
Advantages:-
1. Redundancy will be reduced
2. Inconsistency will be avoided
3. Related data will be stored in tables

Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.

2262

---

What is oracle sid?

891

---

How do we create privileges in oracle?

993

---

How to test null values?

1044

---

List out the types of joins.

1083

---

What are the original export and import utilities?

1058

---

Is oracle an operator?

885

---

What is the max number of columns in an oracle table?

932

---

What is a connect identifier?

983

---

What is the usage of analyze command in oracle?

1033

---

How can I create database in oracle?

961

---

normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi

2147

---

How to store pictures on to the database?

923

---

What is a sub query? Describe its types?

965

---

Explain what are the characteristics of data files?

1031

---