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

1077

---

Are truncate and delete commands same? If so why?

1144

---

How do we get field details of a table?

978

---

What is varray?

1128

---

What is a cursor variable?

1119

---

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

1029

---

How do we display rows from the table without duplicates?

968

---

What are the differences between lov and list item?

1060

---

How do we represent comments in oracle?

1046

---

What do you mean by group by clause?

1042

---

What do you know about normalization? Explain in detail?

946

---

What are the different oracle database objects?

1087

---

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

994

---

What is the difference between translate and replace?

1055

---

How can we delete duplicate rows in a table?

971

---