Questions include discussion on Performance tuning, asked to write a stored procedure, cursor syntax.
Oracle Pl Sql Developer Interview Questions
58 oracle pl sql developer interview questions shared by candidates
Plsql - collections, bulk collect SQL -truncate function with dates, logical sql queries Data base modeling Performance tuning
How do you use schedulers and dumping data using schedulers?
what is cursor?
Basic oracle plsql in first two rounds. Client round they will ask more scenario based questions.
Function overloading and can we overload min, Max?
self join, cursors and its types, functions, procedures, can we have commit in functions, framing query for business logic
ArrayList, LinkedList, HashMap, HashTable, int,Integer
The questions are mostly regarding PL SQL packages,procedures,functions,collections and joins
What is trigger, procedure, function, package, indexes and how it works ?
Viewing 41 - 50 interview questions