Mostly on sql
Sql Developer Interview Questions
Sql Developer Interview Questions
SQL stands for Structured Query Language, and SQL developers create SQL databases and the applications that work with them. They often use design tables and storing procedures for stability, reliability, and performance. In an SQL developer interview, employers often ask questions about your programming knowledge and problem-solving skills.
Top SQL Developer Interview Questions & How to Answer
Question 1
Question #1: What are the types of keys in SQL, and when would you use them?
How to answer
How to answer: This question lets you demonstrate your knowledge of SQL. Discuss the most common types of SQL keys, and talk about how they can identify rows and columns in tables. Keys work as unique identifiers, allowing users to retrieve data easily.
Question 2
Question #2: What are the types of normalization available in SQL, and how do you use them?
How to answer
How to answer: People use SQL normalization to organize data and reduce redundancies. You can demonstrate your experience by discussing the normalization methods you use most. For example, many developers divide a large table into several smaller ones for easier readability.
Question 3
Question #3: What programming languages are you familiar with?
How to answer
How to answer: Many SQL developers also use JavaScript, HTML, Python, PL/SQL, and other languages. Mention the languages you know and how you used them at your previous job. Also, tell the interviewer about any programming certifications you received.
2,214 sql developer interview questions shared by candidates
Write a bulk collect with exception handling
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.
How to choose referal vaalues from a table in a cursor
SQL Basic, Question. Need to write query and some questions on execution plans.
Tell me about you, What is the SQL server Maintenance Plan,Do I know the upgrade the server? when I can start the the job?
Viewing 921 - 930 interview questions