Ho sostenuto un colloquio presso Tata Consultancy Services
Colloquio nella media
Candidatura
Ho sostenuto un colloquio presso Tata Consultancy Services
Colloquio
Technical round and manager round . In technical round they asked about all PLSQL details like table, trigger, view, cursor syntax. In manager round, easy than technical round.asked behaviour questions
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.
Ho sostenuto un colloquio presso Tata Consultancy Services (Thānesar)
Colloquio
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
Ho presentato la mia candidatura di persona. Ho sostenuto un colloquio presso Tata Consultancy Services (Thāne) nel mese di feb 2025
Colloquio
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
Domande di colloquio [1]
Domanda 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
