Answer Posted / prabhu

to reduce the retundant column for that only we r using the
first normal form




create seperate table for not functionality dependent
on primary key this is 2nd normal form

How many types of tables are there in oracle?

1001

---

What is PL/SQL ?

1894

---

How to load data from external tables to regular tables?

981

---

What are the differences between primary key and unique key?

944

---

Explain cascading triggers.

1011

---

Whats the benefit of dbms_stats over analyze?

1927

---

What are the predefined tablespaces in a database?

1003

---

How to put more than 1000 values into an oracle in clause?

968

---

Explain the use of inctype option in exp command.

975

---

Explain oracle instance.

1101

---

Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?

1320

---

Why do you use stored procedures and state some of its disadvantages?

967

---

Difference between hot backup vs. Cold backup?

939

---

What is a cursor and what are the steps need to be taken?

1109

---

How to start your 10g xe server?

964

---