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

Difference between varchar and varchar2 data types?

1184

---

How can you merge two tables in oracle?

1001

---

What is a user role in oracle?

1132

---

How can we find out the current date and time in oracle?

1090

---

What is bulk load in oracle?

1070

---

Explain the use of analyse option in exp command.

1128

---

please explain.. DB architecture ...

2023

---

How to use "for" statements in oracle?

1076

---

How to write date and time interval literals in oracle?

1036

---

What do you mean by redo log file mirroring?

1032

---

How do I limit the number of rows returned by an oracle query after ordering?

1170

---

How to run the anonymous block again?

1132

---

i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)

2322

---

Why packages are used in oracle?

1066

---

How to connect to oracle using service name instead of sid?

1026

---