Answer Posted / chirala venkata suresh

It is set of rules that have been established to aid in the
design of tables that are meant to
be connected through relationships. This set of rules is
known as Normalization.

1.Avoiding repetitive entries
2.Reducing required storage space
3.Preventing the need to restructure existing tables to
accommodate new data.
4.Increased speed and flexibility of queries, sorts, and
summaries.

What is MTTR advisor in Oracle?

1058

---

How to define an anonymous procedure without variables?

1059

---

How to select some columns from a table in oracle?

1027

---

What is an oracle wallet?

911

---

What is the relation of a user account and a schema in oracle?

1037

---

If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?

2259

---

What is the Tune Query

2251

---

How to convert characters to times in oracle?

984

---

How many types of table in Oracle?

1083

---

What are the set operators union, union all, minus & intersect meant to do?

961

---

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

2076

---

How to list all tables in your schema?

1007

---

what is the dual table in oracle?

951

---

Explain the difference between sql and oracle?

1045

---

How to create lov dynamically at runtime & attach to text field?

1121

---