Lots of basic analytical query. Performance tuning.
Pl Sql Developer Interview Questions
253 pl sql developer interview questions shared by candidates
Technical and coding. Basics of technology.
over all Oracle related question in depth
What is basic difference between procedure and function.? What is cursor and why we use cursor? What is analytical functions? what is trigger and how many triggers we can create? What is the difference between truncate and delete? what is Dynamic sql? what is the join and its type ?
Q: What is views and Materialized views.
They have asked technical questions.
Difference between rank and dense rank
Write a bulk collect with exception handling
Interview: Asked a lot of open ended questions without defining scope or context for the question and expects singular answers to those questions. If you have a lot of experience you will understand that there are many answers to the questions asked (how long is a piece of string type questions). The interviewer doesn't seem to realise this and I put it down to lack of experience on their part. Check online for the resume of your interviewer before attending an interview. Interviewer uses non standard jargon acronyms in questions without realising and has limited exposure to different technologies and therefore doesn't understand the different design methodologies that are born out of the differing technologies that you will have worked with.
Basic sql concepts
Viewing 91 - 100 interview questions