I applied through a staffing agency. The process took 2 days. I interviewed at 3i Infotech (Bengaluru) in Nov 2017
Interview
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
Interview questions [1]
Question 1
Every thing mentioned that i mentioned in resume and more on collections
I applied through other source. I interviewed at 3i Infotech (Hyderābād) in Oct 2020
Interview
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.
Interview questions [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.
