I applied online. I interviewed at Zoplar (Gurgaon, Haryana) in Sept 2023
Interview
The interview process at Zoplar includes two technical rounds, covering SQL, Google Sheets/Excel, Python, problem-solving, and critical thinking, followed by an HR interview focused on cultural fit and soft skills.
Interview questions [1]
Question 1
Table 1:
1
2
3
3
5
6
7
Table 2:
0
2
3
4
5
How would you use different types of joins (inner join, left join, right join, and full outer join) to combine these tables? Explain the results you would expect from each join type, highlighting which rows from Table 1 and Table 2 would appear in the output for each case. Additionally, discuss any scenarios where null values might be included and the reasons behind them
