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

1086

---

Are truncate and delete commands same? If so why?

1156

---

How do we get field details of a table?

978

---

What is varray?

1137

---

What is a cursor variable?

1132

---

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

1045

---

How do we display rows from the table without duplicates?

973

---

What are the differences between lov and list item?

1067

---

How do we represent comments in oracle?

1049

---

What do you mean by group by clause?

1045

---

What do you know about normalization? Explain in detail?

951

---

What are the different oracle database objects?

1092

---

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

1007

---

What is the difference between translate and replace?

1061

---

How can we delete duplicate rows in a table?

973

---