Answer Posted / sonali

oracle 10g has introduced data pump,awr addm etc

What is connection pooling in oracle?

973

---

What is object data modeling?

965

---

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?

1382

---

How to best split csv strings in oracle 9i?

1041

---

Explain the use of compress option in exp command.

1021

---

What do you understand by a database object? Can you list a few of them?

1018

---

What is ceil and floor in oracle?

1069

---

How to get a list of all user accounts in the database?

1087

---

What is not equal to in oracle?

1003

---

How oracle handles dead locks?

1066

---

hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.

2261

---

What is merge statement used for?

1024

---

Explain the use of ignore option in imp command.

1035

---

What is the Tune Query

2291

---

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

982

---