Me postulé a través de una agencia de empleos. El proceso tomó 2 días. Acudí a una entrevista en 3i Infotech (Bengaluru) en nov 2017
Entrevista
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
Preguntas de entrevista [1]
Pregunta 1
Every thing mentioned that i mentioned in resume and more on collections
Me postulé a través de otra fuente. Acudí a una entrevista en 3i Infotech (Hyderabad) en oct 2020
Entrevista
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.
Preguntas de entrevista [1]
Pregunta 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.