Cursor and refcursor. Joins Indexes
Plsql Developer Interview Questions
274 plsql developer interview questions shared by candidates
Topics included triggers, indexes and sql tuning concepts and difference between union and union all.
Bulk collect, functions, procedures, exceptions
basic sql , pl sql question , 2nd highest salary , duplicate remove , cursor , joins , unix basic commands
Performance tunning in Oracle PLSQL
Plsql collections,triggers ,cursors,window functions,pipeline functions
why version 1??what do you know about us?
General screening question
one of the senior manager attended in technical interview and he is continuously throwing unnecessary questions in between technical discussion. and he was not happy with my career gap that was only 8 months.
1) What is a correlated sub query? Write an example query? 2) What is decode? Write an example query? 3) What is plsql records? Write a simple record procedure? 4) What is trigger? Write an example trigger? 5) What is exception handling? Define a exception and handle the exception at exception block? 6) What is index? Types of index? 7) Difference between row num and row id? 8) Write query to get top 5 highest salaries from employee table using row num? 9) What is oracle partitioning ? 10) What is with clause?
Viewing 171 - 180 interview questions