Explain the difference between a procedure and a function? What do you understand by those terms?

1136

---

Are truncate and delete commands same? If so why?

1204

---

How do we get field details of a table?

1031

---

What is varray?

1198

---

What is a cursor variable?

1216

---

Can we store pictures in the database and if so, how it can be done?

1093

---

How do we display rows from the table without duplicates?

1019

---

What are the differences between lov and list item?

1147

---

How do we represent comments in oracle?

1100

---

What do you mean by group by clause?

1094

---

What do you know about normalization? Explain in detail?

1005

---

What are the different oracle database objects?

1150

---

State all possible different index configurations a table can possibly have?

1104

---

What is the difference between translate and replace?

1118

---

How can we delete duplicate rows in a table?

1041

---