Blog Archives

00: 18+ SQL best practices interview Q&As

It is a must to know the order in which the SQL clauses are executed. This is demonstrated with an example below in #5. Have this order of execution visibly pinned and understood. SQL is very easy to learn, but lots of hands-on experience is required to master:

1) to translate business requirements into SQL.
2) to write efficient & maintainable queries.… Read more ...


00: 50+ SQL scenarios based interview Q&As on identifying & deleting duplicate records

50+ SQL interview questions and answers to solve real business scenarios. SQL is widely used in building microservices & Big Data projects. Learning SQL syntax is easy, but being able to convert a given business requirement into a query takes lots of practice. These scenarios based interview questions can assesses your experience.

Considerations & Tips

It is important to first understand the problem statement, and then ask the right questions to solve the problem.… Read more ...

02: 50+ SQL scenarios based interview Q&As on joins, CDC and recursive CTE

This extends 50+ SQL scenarios based interview questions answered on identifying & deleting duplicate records. You practice these in SQLs by setting up the data on db-fiddle MySQL V8.0 or a database server & SQL client of your choice. Q01 When you have a table that maintains history of record…

Read more ...

15+ SQL optimisation interview questions & answers with scenarios

1) Select fields instead of using SELECT *. The “*” is used as a short hand to query all available data from a table. If a table has many fields and rows, this takes database resources by querying a lot of unnecessary data. Inefficient:


2) Avoid SELECT…

Read more ...

25+ SQL interview questions & answers – beginner

SQL interview Questions & Answers is a must for any developer as all non-trivial applications need to talk to a database with CRUD operations. Q3 – Q15 are very popular with the interviewers.

If you want to quickly practice your SQL skills try DB Fiddle or install MySQL locally as shown in the MySQL database getting started.

Q1. Can you explain DDL statements in regards to SQL?… Read more ...


25+ SQL interview questions & answers – intermediate to experienced

This continues 25+ SQL interview questions & answers – beginner

Q16. Why do you have CASE statements in SQL?
A16. CASE statements in SQL are similar to IF and ELSE conditions in programming languages. CASE statements are used to fetch particular values based on certain conditions.

In the above example CASE statement is used to evaluate the “weight_group” column based on the weight_in_kgs column.… Read more ...

Java Developer & Architect Interview Q&As

Java & Big Data Tutorials

Prepare to fast-track & go places

FAQs are marked with 🔥 as some questions are not only more popular with the interviewers, but also required to build robust systems. If you are an interviewer, cover well rounded topics to judge real experience.

Don't be overwhelmed by the number of questions as the technology stacks are so vast. The quality of the answers you provide to some of the key technical & open-ended questions along with your soft skills & attitude will go a long way in getting the job offers.

Note: Some Q&As belong to more than one category.