I applied online. The process took 2 weeks. I interviewed at Tata Consultancy Services
Interview
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 ,
Interview questions [1]
Question 1
SQL and Plsql basics question question related to joins cursor function procedure Dml Ddl and some query related to self joins union merge ,
I applied through an employee referral. I interviewed at Tata Consultancy Services (Noida)
Interview
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
Interview questions [1]
Question 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?"
I applied online. I interviewed at Tata Consultancy Services (Bengaluru) in Dec 2022
Interview
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
Interview questions [1]
Question 1
what do u know about pl/SQL delete and truncate d/f explain exception handling and types