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.

How to empty your oracle recycle bin?

982

---

What are triggers in oracle?

978

---

List out the difference between commit, rollback, and savepoint?

987

---

How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?

2203

---

How to list all indexes in your schema?

1034

---

How to drop an existing view in oracle?

905

---

How to run create database statement again?

1079

---

How to use group functions in the select clause using oracle?

1025

---

How do you get nicely formatted results from an oracle procedure that returns a reference cursor?

1010

---

What is the difference between primary key and unique key and foreign key in oracle?

921

---

How a tablespace is related to data files?

1062

---

what is port in oracle? how is it related to database application.

1895

---

How to execute the package in oracle?

1039

---

What is an anonymous block?

1158

---

What is the maximum number of triggers that can be applied to a single table?

956

---