Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by TCS Team. If you also belong to the team, you can get access from here

TCS Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

TCS Plsql Developer Interview Questions and Answers for Experienced

Updated 21 Feb 2025

TCS Plsql Developer Interview Experiences for Experienced

6 interviews found

Interview experience
1
Bad
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Not Selected

I appeared for an interview in Feb 2023.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Technical 

(2 Questions)

  • Q1. 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 Drawbac...
  • Ans. 

    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: BEFORE, AFTER, INSTEAD OF; e.g., BEFORE INSERT trigger to validate data before insertion.

    • Views are virtual tables based on the result of a query; Materialized Views store the result physically for faster access.

    • Indexes im...

  • Answered by AI
  • Q2. Reason for Job change
  • Ans. 

    I seek new challenges and opportunities for growth that align with my career goals and aspirations in PL/SQL development.

    • Desire for professional growth: I'm looking for a role that offers more opportunities for learning and advancement.

    • Seeking new challenges: I want to tackle more complex projects that can enhance my skills and experience.

    • Cultural fit: I'm looking for a company culture that aligns more closely with my ...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - I gave the interview as an experienced, Got selected but still I haven't received Offer letter
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all tips
Round 2 - HR 

(1 Question)

  • Q1. Salary negotiation, notice period, immediate joining, policy,
Round 3 - Technical 

(1 Question)

  • Q1. Coding is must in plsql developer

Interview Preparation Tips

Interview preparation tips for other job seekers - Keep your notes with you. It's helpful when you give your technical.

Plsql Developer Interview Questions Asked at Other Companies for Experienced

asked in TCS
Q1. What is temp table and temp variable in plsql?
asked in TCS
Q2. What is procedure in plsql and it's syntax and difference between ... read more
asked in TCS
Q3. Write a PL/SQL program to print the sequence 103, 99, 96...3.
asked in TCS
Q4. What is a mutating table or mutating trigger?
asked in Cognizant
Q5. Write a SQL query to delete duplicate records from a table.
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Not Selected

I appeared for an interview in Oct 2022.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Technical 

(1 Question)

  • Q1. Technical question related about based on project and domain knowledge
Round 3 - HR 

(1 Question)

  • Q1. Asked about flexibility and discussion with salary

Interview Preparation Tips

Interview preparation tips for other job seekers - I had selected still I didn’t receive the offer letter

I applied via Approached by Company and was interviewed in Jun 2022. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. 1. Tell me about yourself. 2. Topics like Stored procedure, functions, cursors, package.

Interview Preparation Tips

Topics to prepare for TCS Plsql Developer interview:
  • PLSQL
  • SQL
  • Stored Procedures
  • Sql function
Interview preparation tips for other job seekers - Prepare those topics.
I got shortlisted after the interview but due to some technical issu in their portal, I couldn't upload my documents. I mailed them multiple times but got no help, no calls from any person and some of my friends also told me they faced many situations and none from TCS helped them out.
So, my advice will be don't for that company. Prepare for others.

What people are saying about TCS

View All
a digital marketer
1w
Do you think they're gonna work on employees' work-life balance, OR for just publicity?
Infosys, Infosys, TCS, Genpact Revise Workplace Policies Infosys is sending a warning mail, if an employee overshoots the daily limit while working remotely, the system triggers a notification Genpact introduced a new policy to log in before 11 am But will these companies really change, or is it just a show to mask their issues?
FeedCard Image
Got a question about TCS?
Ask anonymously on communities.

I applied via Naukri.com and was interviewed in Feb 2022. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Technical 

(8 Questions)

  • Q1. What is temp table and temp variable in plsql?
  • Q2. What is mutating table or mutating trigger?
  • Ans. 

    A mutating table or mutating trigger occurs when a trigger tries to update a table that is currently being modified.

    • Mutating table occurs when a trigger references the table that is being modified.

    • It can happen when a trigger is fired by an INSERT, UPDATE, or DELETE statement on the table.

    • This can lead to unpredictable results or errors, such as ORA-04091: table is mutating, trigger/function may not see it.

    • To avoid mut...

  • Answered by AI
  • Q3. What is autonomous transaction?
  • Q4. Cursors definition and types explained
  • Ans. 

    Cursors are used to retrieve and manipulate data from a database in PL/SQL.

    • Cursors are like pointers to a result set, allowing us to fetch and process rows one by one.

    • There are two types of cursors: implicit and explicit.

    • Implicit cursors are automatically created by Oracle when executing a SQL statement.

    • Explicit cursors are declared and used by the programmer.

    • Explicit cursors provide more control and flexibility compar...

  • Answered by AI
  • Q5. Explain about Triggers ?
  • Q6. Truncate vs delete difference?
  • Q7. A plsql programme to print 103,99,96...3?
  • Q8. What is procedure in plsql and it's syntax and difference between procedure and function?
  • Ans. 

    A procedure in PL/SQL is a named block of code that can be called and executed multiple times.

    • Syntax: CREATE [OR REPLACE] PROCEDURE procedure_name [(parameter1 [mode1] datatype1 [, parameter2 [mode2] datatype2]...)] IS

    • Difference between procedure and function: Procedures do not return a value, while functions return a value.

    • Procedures are used to perform an action, while functions are used to calculate and return a val...

  • Answered by AI
Round 3 - HR 

(5 Questions)

  • Q1. What are your salary expectations?
  • Q2. Share details of your previous job.
  • Q3. Tell me about yourself.
  • Q4. How do you find if two table having similer data
  • Ans. 

    To find if two tables have similar data, compare the records in both tables using a join or a subquery.

    • Use a join operation to compare the records in both tables based on a common column.

    • If the tables have a primary key, you can join them on that key to check for similar data.

    • Alternatively, you can use a subquery to compare the data in both tables and check for matching records.

    • Consider using the MINUS operator to find...

  • Answered by AI
  • Q5. Difference between having and group by?

Interview Preparation Tips

Topics to prepare for TCS Plsql Developer interview:
  • Crack concepts ,
Interview preparation tips for other job seekers - Learn everything explain it in your way interviewers may confuse with some questions be aware

Skills evaluated in this interview

Interview Questionnaire 

2 Questions

  • Q1. They have only one phone interview
  • Q2. They asking about full sql and plsql

Interview Preparation Tips

Round: Resume Shortlist
Experience: Detailed description of explaination full topics

Interview questions from similar companies

Interview Questionnaire 

2 Questions

  • Q1. Index , collection, partition, package, pragma autonomous transaction
  • Q2. Answer confidently
Are these interview questions helpful?

I applied via Naukri.com and was interviewed in Nov 2021. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Procedure, function, bulk collect,

Interview Preparation Tips

Interview preparation tips for other job seekers - We have to be confidence while answering.they are checking ur ability
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

It is little bit easy

Round 2 - Coding Test 

2 coding question in python

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Company Website and was interviewed in Sep 2024. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. What is packages and types
  • Ans. 

    Packages and types are two important components in PL/SQL used for organizing and defining reusable code and data structures.

    • Packages are containers for related procedures, functions, variables, and other PL/SQL constructs.

    • Types are user-defined data structures that can be used to define new data types in PL/SQL.

    • Packages can contain types as well as other PL/SQL constructs, providing a way to organize and encapsulate r...

  • Answered by AI

Skills evaluated in this interview

TCS Interview FAQs

How many rounds are there in TCS Plsql Developer interview for experienced candidates?
TCS interview process for experienced candidates usually has 2-3 rounds. The most common rounds in the TCS interview process for experienced candidates are Technical, Resume Shortlist and HR.
How to prepare for TCS Plsql Developer interview for experienced candidates?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at TCS. The most common topics and skills that interviewers at TCS expect are PLSQL, SQL, Oracle SQL, Performance Tuning and SQL Development.
What are the top questions asked in TCS Plsql Developer interview for experienced candidates?

Some of the top questions asked at the TCS Plsql Developer interview for experienced candidates -

  1. What is temp table and temp variable in pls...read more
  2. What is procedure in plsql and it's syntax and difference between procedure and...read more
  3. A plsql programme to print 103,99,96.....read more
What are the most common questions asked in TCS Plsql Developer HR round for experienced candidates?

The most common HR questions asked in TCS Plsql Developer interview are for experienced candidates -

  1. What are your salary expectatio...read more
  2. Share details of your previous j...read more
  3. Tell me about yourse...read more
How long is the TCS Plsql Developer interview process?

The duration of TCS Plsql Developer interview process can vary, but typically it takes about less than 2 weeks to complete.

Tell us how to improve this page.

Overall Interview Experience Rating

3/5

based on 3 interview experiences

Difficulty level

Easy 50%
Moderate 50%

Duration

Less than 2 weeks 50%
2-4 weeks 50%
View more
TCS Plsql Developer Salary
based on 1.5k salaries
₹3.2 L/yr - ₹9.3 L/yr
At par with the average Plsql Developer Salary in India
View more details

TCS Plsql Developer Reviews and Ratings

based on 99 reviews

3.7/5

Rating in categories

3.5

Skill development

3.9

Work-life balance

2.8

Salary

4.5

Job security

3.7

Company culture

2.5

Promotions

3.5

Work satisfaction

Explore 99 Reviews and Ratings
System Engineer
1.1L salaries
unlock blur

₹3.9 L/yr - ₹8.3 L/yr

IT Analyst
65.3k salaries
unlock blur

₹8 L/yr - ₹14.5 L/yr

AST Consultant
53.8k salaries
unlock blur

₹12.2 L/yr - ₹20.7 L/yr

Associate Consultant
33.2k salaries
unlock blur

₹16.3 L/yr - ₹28.2 L/yr

Assistant System Engineer
33.2k salaries
unlock blur

₹2.4 L/yr - ₹6.3 L/yr

Explore more salaries
Compare TCS with

Amazon

4.0
Compare

Wipro

3.7
Compare

Infosys

3.6
Compare

Accenture

3.7
Compare
write
Share an Interview