Me postulé a través de una agencia de empleos. El proceso tomó 1 semana. Acudí a una entrevista en mPHATEK Systems (Pune) en abr 2018
Entrevista
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.
Preguntas de entrevista [1]
Pregunta 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?