Interview happened on time. Over all it took 50mins to complete the interview. Questions were sharp and clear. Scenario based questions. Technical and project Manager round happened at the same round.
Interview questions [1]
Question 1
Explain the joins. Difference between Delete and Truncate, Difference between where and having clause, window functions
I applied online. I interviewed at Tata Consultancy Services in Jan 2019
Interview
Three rounds of interview thare are First round,
Second round,Third round.
First round is technical mcq and second round is technical voice based interview and third round is HR interview
Interview questions [1]
Question 1
Describe SQL
Describe Keys in SQL
What is join and there types?
I applied online. I interviewed at Tata Consultancy Services (Chennai) in Jan 2023
Interview
These complex PL SQL server questions regularly feature at tech interviews for SQL developers: Define and describe the usage of a linked server. Name and explain the different types of Joins. Explain the different types of authentication modes. Which stored procedure would you run when adding a linked server? Where do you think the user names and passwords will be stored in the SQL server? How would you add email validation using only one query?
Interview questions [1]
Question 1
These complex PL SQL server questions regularly feature at tech interviews for SQL developers: Define and describe the usage of a linked server. Name and explain the different types of Joins. Explain the different types of authentication modes. Which stored procedure would you run when adding a linked server? Where do you think the user names and passwords will be stored in the SQL server? How would you add email validation using only one query?
I applied online. The process took 2 months. I interviewed at Tata Consultancy Services (Ciudad de Mexico) in Aug 2022
Interview
Mal proceso de entrevista. Me llamaron 4 semanas después de las entrevistas para decirme que porque no tenía número de empleado. Prácticamente el de reclutamiento me olvidó por completo y nunca me avisó que ya había entrado