Solicité el puesto en persona. Acudí a una entrevista en Tata Consultancy Services (Thāne) en feb 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
Preguntas de entrevista [1]
Pregunta 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
Acudí a una entrevista en 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.
Acudí a una entrevista en 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
