1. If month inbetween jan and jul then 2022 else 2023. What function used to find and how? 2. Analytical functions example 3. Challenges faced in previous project
Sql Developer I Interview Questions
1,524 sql developer i interview questions shared by candidates
They have asked technical questions.
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.
Name and describe the different types of indexes. Are you familiar with column store indexes in SQL Server 2012?
Viewing 621 - 630 interview questions