Answer Posted / imran khan

First normal form, sets the very basic rules for an
organized database i.e. Eliminate duplicative columns.
Create separate tables for each group of related data and
identify the row with a unique column i.e the primary key.

Second normal form further removes the duplicate data:

i.e. Meet the requirements of the first form of
normalalization. Create relationships between new tables
through foreign keys.

What is Trigger in Oracle?

1070

---

What is varray?

1029

---

What are the different types of database objects?

990

---

How to change system global area (sga) in oracle?

957

---

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

935

---

What is Library Cache in Oracle?

1070

---

What is Data Dictionary Cache in Oracle?

1114

---

Explain an exception and its types?

1008

---

How to open and close an explicit cursor in oracle?

994

---

What are the differences between date and timestamp in oracle?

972

---

What is a table index in oracle?

1063

---

What is the difference between alert log file and tarce file ?

2095

---

What are advantages of dateset in datastage?

2197

---

How can we force the database to use the user specified rollback segment?

1061

---

How to run queries on external tables?

985

---