si tenia conocimientos de pl/sql. cuantos años he trabajado con java, si sabia angular (pero que casi no tocaría).
Desarrollador Oracle Pl Sql Interview Questions
1,525 desarrollador oracle pl sql interview questions shared by candidates
Lots of basic analytical query. Performance tuning.
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 ?
Different types of SQL join
Tell us about a recent project you worked on and your role in it.
Some basic SQL and programming language questions.
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.
Questions will be geared toward technical, more specifically BI or SQL oriented. Questions could be explain keys / what is DDL,DML,DQL, and DCL? / What are indexes and why use them? / etc
None - very 'standard' interview process. There were no 'trick' questions, and the entire team was very friendly.
SQL Basic, Question. Need to write query and some questions on execution plans.
Viewing 621 - 630 interview questions