Pergunta de entrevista da empresa Tech Mahindra

I had applied for PLSQL developer position The interviewer asked me basics of sql like what will be the output of the query (using group by and analytical functions) -questions on collections -approach to tune a long running query