Candidatei-me por meio de uma agência de recrutamento. Fui entrevistado pela Tata Consultancy Services em dez. de 2020
Entrevista
There were two rounds of screening, one by third party recruiter and then by HR. Then, Both Technical and managerial interview questions were asked in next round. there was a panel of three people. technical guy, HR guy, Manger guy. Interview results were shared within a week along with offer letter
Perguntas de entrevista [1]
Pergunta 1
Most of the questions were asked based on our previuos answers. They will frame question based on our answers. Normalization forms, Joins , index and its backecd, Views, triggers, oracle architecture basics
Fiz uma entrevista na empresa Tata Consultancy Services.
Entrevista
One technical and one hr round was conducted. Complexity of medium level. Should be able to write complex queries. Procedures functions packages with package specification triggers exception handling collections elements nested tables field record record type composite types bulk collect all were covered.
Fiz uma entrevista na empresa Tata Consultancy Services (Thānesar).
Entrevista
Asked about the projects mostly . Explain the project working in the detail.then plsql basic concepts , indexes and cursours . Also they asked about the query tuning methods and steps
Candidatei-me pessoalmente. Fui entrevistado pela Tata Consultancy Services (Thāne) em fev. de 2025
Entrevista
basic interview questions which most of company asks not asked very much into detail, didn't ask very complex question, asked me about rest api and swagger the location for work is in belapur cbd
Perguntas de entrevista [1]
Pergunta 1
What is faster subquery or CTE
What is veiw and materialized view
if we delete a table what will be the result of select * from the view created on the table
what are analytical functions
order salary based on Rownumber,rank,denserank
procedure for a palindrome
write a syntax of procedure with all blocks
what are indexes and its type
merge statement (can we use a same table in merge)
left join and inner join and right join for below
Table 1 Table 2
column 1 column1
1 1
1 0
0 null
null null
second highest salary
