Ho presentato la mia candidatura tramite un'altra fonte. Ho sostenuto un colloquio presso 3i Infotech (Hyderabad) nel mese di ott 2020
Colloquio
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.
Domande di colloquio [1]
Domanda 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.
Ho presentato la mia candidatura tramite un'agenzia di reclutamento personale. La procedura ha richiesto 2 giorni. Ho sostenuto un colloquio presso 3i Infotech (Bengaluru) nel mese di nov 2017
Colloquio
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
Domande di colloquio [1]
Domanda 1
Every thing mentioned that i mentioned in resume and more on collections