Answer Posted / prinsha

it is a method for organizing data element in a database into table.it avoid duplication of data,insert anomaly,delete anomaly,update anomaly . 3 stage process first normal form,second normal form,third normal form

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

2261

---

How to connect to a local oracle 10g xe server?

1032

---

What are the system predefined user roles?

1094

---

What is data file?

1149

---

What are the roles of dba?

1136

---

What are the different types of database objects?

1114

---

What is BBED in Oracle?

1196

---

How to define an oracle sub procedure?

1221

---

Which is faster join or subquery in oracle?

1046

---

various types of hints and their usage

2747

---

Explain the use of Merge statement in oracle 11g

1074

---

What is the difference between view and materialized view in Oracle?

1203

---

How to get maxsal , minsal, ename department wise in single query

1601

---

Explain about functional dependency and its relation with table design?

1059

---

Is there a combination of "like" and "in" in sql?

1114

---