Candidatei-me online. O processo levou 2 semanas. Fiz uma entrevista na empresa 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 ,
Perguntas de entrevista [1]
Pergunta 1
SQL and Plsql basics question question related to joins cursor function procedure Dml Ddl and some query related to self joins union merge ,
Candidatei-me por indicação de um funcionário. Fiz uma entrevista na empresa 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
Perguntas de entrevista [1]
Pergunta 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?"
Candidatei-me online. Fui entrevistado pela Tata Consultancy Services (Bengaluru) em dez. de 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
Perguntas de entrevista [1]
Pergunta 1
what do u know about pl/SQL delete and truncate d/f explain exception handling and types
