Un-Answered Questions { Oracle General }

What do you know about normalization? Explain in detail?

493


What are the different oracle database objects?

576


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

558


What is the difference between translate and replace?

544


How can we delete duplicate rows in a table?

554


What is a cursor and what are the steps need to be taken?

588


Compare and contrast between sql and sql server and explain its various functions?

519


How different is ms access and oracle?

535


How to display employee records who gets more salary than the average salary in the department?

584


State some uses of redo log files?

548


What is coalesce function?

563


How can we view last record added to a table?

589


What is the maximum number of triggers that can be applied to a single table?

549


What is the usage of merge statement?

663


Explain the difference between a procedure and a function?

549