Explain the difference between a procedure and a function? What do you understand by those terms?
Are truncate and delete commands same? If so why?
How do we get field details of a table?
What is varray?
What is a cursor variable?
Can we store pictures in the database and if so, how it can be done?
How do we display rows from the table without duplicates?
What are the differences between lov and list item?
How do we represent comments in oracle?
What do you mean by group by clause?
What do you know about normalization? Explain in detail?
What are the different oracle database objects?
State all possible different index configurations a table can possibly have?
What is the difference between translate and replace?
How can we delete duplicate rows in a table?