Me postulé en línea. El proceso tomó 2 semanas. Acudí a una entrevista en Tata Consultancy Services
Entrevista
SQL and Plsql basics question question related to joins cursor function procedure Dml Ddl , DBMS Data warehousing Performance
Optimization
Debugging and some query related to self joins union merge ,
Preguntas de entrevista [1]
Pregunta 1
SQL and Plsql basics question question related to joins cursor function procedure Dml Ddl and some query related to self joins union merge ,
Me postulé a través de una recomendación de un empleado. Acudí a una entrevista en Tata Consultancy Services (Noida)
Entrevista
Tell me about project , some question project , how to create Temporary table, How to Global table define, How to limit value in data type, How do you combine two tables with differing data and columns without using joins
Preguntas de entrevista [1]
Pregunta 1
"What are the differences between a procedure and a function in PL/SQL?"
"Write a trigger that prevents deletion of records from the employee table on weekends."
"Explain the concept of a mutating table and how it can affect triggers."
"How do you handle errors in PL/SQL, and what are some best practices for error logging?"
"What are bind variables, and how do they improve performance?"
"What is the difference between an implicit and explicit cursor?"
"How do you combine two tables with differing data and columns without using joins?" (Answer: You can't)
"What is GROUP BY, and how is it used in SQL?"
Me postulé en línea. Acudí a una entrevista en Tata Consultancy Services (Bengaluru) en dic 2022
Entrevista
first round resume shortlist second round technical round next HR round, this is a very worst interview experience in my life, he told the result will be announced soon but still, i didn't get results
Preguntas de entrevista [1]
Pregunta 1
what do u know about pl/SQL delete and truncate d/f explain exception handling and types
