
Asked in TCS
1. What are Triggers? Explain and differentiate type of Triggers? 2. What are Views? Materialized View? 3. Explain Job role in the Current Company? 4. What is Index? Type of Indexes? Advantages and Drawbacks? 5. Difference in group by and having? 6. Write a query to get number of employee having same salary? 8. Mutating table error and Autonomous transaction? 9. Statement level and row level triggers?

AnswerBot
27d
Overview of PL/SQL concepts including triggers, views, indexes, and more.
Triggers are database procedures that automatically execute in response to certain events on a table or view.
Types of triggers:...read more
Help your peers!
Add answer anonymously...
Top Plsql Developer Interview Questions Asked at TCS
Q. Write queries using group by and having clause.
Q. Is it possible to combine two tables with differing data and columns without uti...read more
Q. What are the definitions of the Substr and Instr functions?
Interview Questions Asked to Plsql Developer at Other Companies
Top Skill-Based Questions for TCS Plsql Developer
SQL Interview Questions and Answers
250 Questions
Triggers Interview Questions and Answers
50 Questions
Stay ahead in your career. Get AmbitionBox app


Trusted by over 1.5 Crore job seekers to find their right fit company
80 L+
Reviews
10L+
Interviews
4 Cr+
Salaries
1.5 Cr+
Users
Contribute to help millions
AmbitionBox Awards
Get AmbitionBox app

