The interview process was pleasant.

Interviewers had in-depth knowledge of various technologies.

Interviews were conducted in 3 different phases.

First was an informative round, in which they asked me to introduce myself first, then they briefed me on the technologies they are working on, and gave me a brief idea about their ongoing project.

Then, in the second round, they went through my CV and asked questions about it. They also asked me about all my hobbies.

Finally, the last round was a technical round in which they asked me about the basics of DBMS, Computer architecture, and one scenario-based query was given.

They selected 2 candidates after these 3 processes, but they have chosen my colleague.

Introduce yourself, also tell us about your ongoing projects and the projects that you have completed.

Asked questions based on the CV, and also from the projects that I mentioned.

If you have an employee table that consists of 100M+ entries, your task is to write a SQL query that generates only one output of the recently logged-in user.

What is the difference between a procedure and a function?