J'ai postulé via une agence de recrutement. Le processus a pris 1 semaine. J'ai passé un entretien chez mPHATEK Systems (Pune) en avr. 2018
Entretien
There were three to four rounds:
1) written aptitude based on sql
2) two technical interviews
3) hr interview
The aptitude test was quite easy. The give us tables with data and we have to write queries using joins. There we had to write joins using three tables. there were total 30 questions.
20 questions based on joins and ten question based on theory.
Questions d'entretien [1]
Question 1
Difference between truncate and delete
write query to get third maximum salary.
write query to get all employee belonging to sales department having salary > 20000.
what is view ?
what is trigger?