Comcast

First, there was a written test, which contained CS MCQs and coding questions. Those who were shortlisted then had a technical interview. Finally, from the technical interview, shortlisted candidates proceeded to the HR interview.

I was asked by the interviewer why Comcast, etc., etc. Also, some basic coding questions were asked, like counting the occurrences of a given string, etc. Overall, an easy interview to crack. You can answer in your desired coding language.

1. Introduce yourself. 2. Basic SQL queries. 3. Difference between UNION and UNION ALL. 4. SQL joins. 5. What is indexing? 6. Explain your role and responsibilities in your current company.