Un-Answered Questions { Oracle General }

What do you know about normalization? Explain in detail?

499


What are the different oracle database objects?

588


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

570


What is the difference between translate and replace?

560


How can we delete duplicate rows in a table?

567


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

601


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

535


How different is ms access and oracle?

547


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

599


State some uses of redo log files?

566


What is coalesce function?

575


How can we view last record added to a table?

601


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

559


What is the usage of merge statement?

672


Explain the difference between a procedure and a function?

561