In this blog, I gathered few Interview Questions asked on Oracle Database. It will be very useful for 2-4 years of Experience IT Professionals.
1. When we should use Materialized view and non materialized view.
2. Difference between Ref cursor and sys ref cursor.
3. What are the different types of TRIGGERS.
4. Difference between SUBSTRING and INSTRING function.
5. If a query is taking more time to display results, What’s first step will you perform to check this issue.
6. Exceptional handling in Oracle procedure.
7. Name PSEUDO columns in Oracle.
8. Difference between Schema and User in oracle.
9. Difference between DECODE and CASE statement in Oracle.
10. What does TRANSLATE function does in oracle

Related posts