Cursor and refcursor. Joins Indexes
Plsql Developer Interview Questions
274 plsql developer interview questions shared by candidates
Bulk collect, functions, procedures, exceptions
Topics included triggers, indexes and sql tuning concepts and difference between union and union all.
basic sql , pl sql question , 2nd highest salary , duplicate remove , cursor , joins , unix basic commands
General screening question
Performance tunning in Oracle PLSQL
Plsql collections,triggers ,cursors,window functions,pipeline functions
why version 1??what do you know about us?
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?
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.
Viewing 171 - 180 interview questions