Pl Sql Developer Junior Interview Questions

253 pl sql developer junior interview questions shared by candidates

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 ?
avatar

PL/SQL developer

Interviewed at Capgemini

4.1
May 21, 2024

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 ?

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.
avatar

PL/SQL Developer SQL Developer C#

Interviewed at Pilat Media Global

3.2
Dec 2, 2013

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.

Viewing 91 - 100 interview questions

Glassdoor has 253 interview questions and reports from Pl sql developer junior interviews. Prepare for your interview. Get hired. Love your job.