Round 2 – Technical Interview
In the subsequent technical round, the scope expanded to more theoretical concepts. I was asked to explain the OOPs concept, multithreading and some questions from DBMS which are listed below:
- Retrieve the names of employees who have the highest salaries, ordered by salary in descending order.
SELECT FirstName, LastName, Salary
FROM Employees
WHERE Salary = (SELECT MAX(Salary) FROM Employees)
ORDER BY Salary DESC;
- What is the purpose of the GROUP BY clause in SQL?
- What is the difference between INNER JOIN and LEFT JOIN in SQL?
- What is normalization in the context of relational databases?
Loyalty Juggernaut Interview Experience for Product Engineer Role
I applied to Loyalty Juggernaut through the AngelList website and received a call from their HR shortly after to discuss interview scheduling. Given that I was in my 6th semester with the on-campus placement drive approaching, I decided to explore my options. Nonetheless, I proceeded with the interview rounds to gain valuable experience.
Contact Us