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.
In first technical round questions like joins, indexing, difference between view and Materialized view, 2nd highest salary, delete duplicate, concatenate first name and last name etc. were asked. In second technical round roles and responsibilities of current project, other scenario based questions, what did you do for self learning, in aws do we use s3 or s3a etc; and basic of linux and python.
tell me about your method of troubleshooting a problem?
What is RDBMS? How is it different from DBMS? What is the SELECT statement? What are some common clauses used with SELECT query in SQL?
Tell me about a time you worked well as part of a team? What is BLOB and TEXT in MySQL? What is the difference between NOW() and CURRENT_DATE()?
What is the difference between Clustered and Non-clustered index? What is a Subquery? What are its types?
SQL queries,joints,single row functions ,triggers,how to create a table,
Mainly the asked sql theory and some practical Questions
What does your day look like? Have you done clustering, mirroring, log shipping? What kind of issues do you get?
Show me how to schedule a job in SQL Server
basic SQL in a tricky way ! joins , group by vs distinct, full text index
Viewing 1711 - 1720 interview questions