Answer Posted / sachin

Normalization is a method of break down complex table’s
structure into simple table structure by using certain
rules. Normalization usually involves dividing a database
into two or more tables and defining relationships between
the tables. The objective of Normalization is to isolate
data so that additions, deletions, and modifications of a
field can be made in just one table and then propagated
through the rest of the database via the defined
relationships. With the help of this method we can reduce
redundancy in a table and remove the problems of
inconsistency and reduce the amount of space.

see more info on this link

http://www.mindstick.com/Articles/88d5a271-b369-4c0a-ae80-01e66df98b6a/?What%20is%20Normalization?

What is a dead lock in oracle?

1122

---

How to view existing locks on the database?

1053

---

Explain view?

1034

---

various types of hints and their usage

2699

---

What is tns entry?

1151

---

what is the difference between substr and instr function in oracle?

1090

---

What is redo log?

1064

---

How to create a stored function in oracle?

1105

---

What is coalesce function?

1071

---

Explain the use of control file?

1113

---

Is it possible to set second Primary Key Constraint in a table in Oracle Database ?

1145

---

Which is better Oracle or MS SQL? Why?

6386

---

What is a cursor in oracle?

1172

---

Can we protect our pl/sql source code?

1042

---

Select all the employees who were hired in last 2 years and who works in dept where max managers are working.

2970

---