Asked about PLSQL basic details
Oracle Plsql Developer Interview Questions
171 oracle plsql developer interview questions shared by candidates
Basic Concepts from Oracle Technology
Mysql Stored Routines, Optimization, Bulk Insert,update,delete and select, Duplicates, Exception handling, Joins, Data Loading, Triggers, Cursors, Types of Indexing mechanisms.
How to check for validation before updating row?
Name exceptions that you have ever user ? How to use when others exception?
joins, unions, rank, dense rank
They ask SQL queries by giving some scenarios
Where r u in the next 5 years?
How to print employees whose salary is more than employees,given there is a table emp with emono ,empname,salary,managerno?
There is a table with column id as 1,2,3.....10 . You need to populate another column as result,if it is odd then populate N into table else populate Y.How can you achieve this by SQL statement?
Viewing 11 - 20 interview questions