Plsql collections,triggers ,cursors,window functions,pipeline functions
Plsql Interview Questions
295 plsql interview questions shared by candidates
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.
Hierarchical Queries and print a series using the concept
Sql queries
que animal eres? donde te ves en 5 años
Materialized view purpose
Mostly asking on performance tuning
Oracle Architecture
Viewing 191 - 200 interview questions