Ho presentato la mia candidatura online. Ho sostenuto un colloquio presso Tata Consultancy Services (Bengaluru) nel mese di dic 2022
Colloquio
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
Domande di colloquio [1]
Domanda 1
what do u know about pl/SQL delete and truncate d/f explain exception handling and types
Ho presentato la mia candidatura tramite segnalazione di un dipendente. Ho sostenuto un colloquio presso Tata Consultancy Services (Noida)
Colloquio
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
Domande di colloquio [1]
Domanda 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?"
Ho presentato la mia candidatura online. La procedura ha richiesto 2 settimane. Ho sostenuto un colloquio presso Tata Consultancy Services
Colloquio
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 ,
Domande di colloquio [1]
Domanda 1
SQL and Plsql basics question question related to joins cursor function procedure Dml Ddl and some query related to self joins union merge ,
