Ho presentato la mia candidatura tramite un'agenzia di reclutamento personale. La procedura ha richiesto una settimana. Ho sostenuto un colloquio presso mPHATEK Systems (Poona) nel mese di apr 2018
Colloquio
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.
Domande di colloquio [1]
Domanda 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?