J'ai postulé via une agence de recrutement. Le processus a pris 2 jours. J'ai passé un entretien chez 3i Infotech (Bengaluru) en nov. 2017
Entretien
Total 3 Rounds written ,Techincal and followed by manager Round
Written was about 25 questions all are basic questions . None of those are MCQ
Need to answer in theory
Technical Round was about 30 min and mostly on indexes and materialized views triggers and collections
Questions d'entretien [1]
Question 1
Every thing mentioned that i mentioned in resume and more on collections
J'ai postulé via une autre source. J'ai passé un entretien chez 3i Infotech (Hyderâbâd) en oct. 2020
Entretien
Worst interview ever attended. I got a call stating they want to have technical discussion and scheduled my call. On the day of technical interview I was suppose to get WhatsApp video call which I did not receive,I called hr and informed about my interview scheduled. Immediately after that I got a call. Trust me the person who took my interview did not even long for 10 min. And it wasn’t a video conferencing it was a simple telephonic call. And the question asked by the interviewer were so confusing that even he was not sure about the questions he was asking. He asked me most of the wrong questions.
Questions d'entretien [1]
Question 1
There are two table. In one table I have values 1,1,1 and t2 table have 1,1,null. If I inner join what is the count? (How can we tell the count?we can tell the values it can return)
2)what is ref cursor
3) query to delete duplicates. I told him partition by query and his reply was this is very time consuming. Tell me something different.
4)components of cursor.
