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, Process, and Tips

Updated 21 Feb 2025

Top TCS Plsql Developer Interview Questions and Answers

View all 36 questions

TCS Plsql Developer Interview Experiences

16 interviews found

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Not Selected

I was interviewed 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.

Plsql Developer Interview Questions Asked at Other Companies

asked in TCS
Q1. What is procedure in plsql and it's syntax and difference between ... read more
asked in TCS
Q2. What is temp table and temp variable in plsql?
asked in TCS
Q3. A plsql programme to print 103,99,96...3?
asked in TCS
Q4. What is mutating table or mutating trigger?
asked in TCS
Q5. How do you find if two table having similer data

I applied via Approached by Company and was interviewed in Mar 2022. There were 3 interview rounds.

Round 1 - One-on-one 

(3 Questions)

  • Q1. What is a cursor. And its types
  • Ans. 

    A cursor is a database object used to retrieve data from a result set one row at a time.

    • Types of cursors: Implicit, Explicit, Ref, and Dynamic

    • Implicit cursor is used for single row queries

    • Explicit cursor is used for multi-row queries

    • Ref cursor is used to point to a cursor variable

    • Dynamic cursor is used to execute dynamic SQL statements

  • Answered by AI
  • Q2. Functions and procedures
  • Q3. Triggers and its types and syntax
  • Ans. 

    Explanation of triggers and their types in PL/SQL

    • Triggers are database objects that are automatically executed in response to certain events

    • Types of triggers include DML, DDL, and system triggers

    • Syntax for creating a trigger: CREATE [OR REPLACE] TRIGGER trigger_name {BEFORE|AFTER} {INSERT|UPDATE|DELETE} ON table_name [FOR EACH ROW] [WHEN condition] BEGIN ... END;

  • Answered by AI
Round 2 - One-on-one 

(1 Question)

  • Q1. What is SQL optimization. Normalization. Pragma usage
  • Ans. 

    SQL optimization, normalization, and pragma usage are important concepts in PL/SQL development.

    • SQL optimization involves improving the performance of SQL queries by analyzing and modifying the query structure, indexes, and data access patterns.

    • Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity.

    • Pragma is a compiler directive that provides additional information ...

  • Answered by AI
Round 3 - HR 

(1 Question)

  • Q1. Salary discussion, asked about having any other offer in hand

Interview Preparation Tips

Interview preparation tips for other job seekers - Brush up SQL queries and procedures, function, triggers

Skills evaluated in this interview

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

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 - Technical 

(8 Questions)

  • Q1. What is temp table and temp variable in plsql?
  • Ans. 

    Temp table is a table created temporarily in memory. Temp variable is a variable that holds temporary data.

    • Temp table is used to store data temporarily during a session

    • Temp variable is used to hold temporary data that is not needed after a certain point

    • Temp table and variable are created using the 'CREATE GLOBAL TEMPORARY' and 'DECLARE' statements respectively

    • Example: CREATE GLOBAL TEMPORARY TABLE temp_table (id NUMBER...

  • Answered by AI
  • 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?
  • Ans. 

    Autonomous transaction is a separate transaction initiated by a parent transaction.

    • It allows a subtransaction to commit or rollback independently of the parent transaction.

    • It is useful for logging or auditing purposes.

    • It can be created using the PRAGMA AUTONOMOUS_TRANSACTION statement.

    • Example: A parent transaction updates a table, while an autonomous transaction logs the changes made.

    • Example: An autonomous transaction ...

  • Answered by AI
  • 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 ?
  • Ans. 

    Triggers are database objects that automatically execute in response to certain events.

    • Triggers can be used to enforce business rules, audit data changes, and maintain referential integrity.

    • They can be defined to execute before or after an event, such as a row being inserted, updated, or deleted.

    • Triggers can also be nested, meaning one trigger can execute another trigger.

    • Examples of triggers include automatically updat...

  • Answered by AI
  • Q6. Truncate vs delete difference?
  • Ans. 

    Truncate removes all data, delete removes selected data.

    • Truncate is faster than delete as it doesn't log individual row deletions.

    • Truncate cannot be rolled back, delete can be.

    • Truncate resets identity columns, delete doesn't.

    • Truncate doesn't fire triggers, delete does.

    • Truncate is a DDL operation, delete is a DML operation.

  • Answered by AI
  • Q7. A plsql programme to print 103,99,96...3?
  • Ans. 

    PL/SQL program to print numbers in descending order from 103 to 3

    • Use a loop to iterate from 103 to 3

    • Print each number in the loop

    • Decrement the loop counter by 3 in each iteration

  • Answered by AI
  • 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?
  • Ans. 

    HAVING is used to filter groups while GROUP BY is used to group rows based on a column.

    • HAVING is used with GROUP BY to filter groups based on a condition

    • GROUP BY is used to group rows based on a column

    • HAVING is used after GROUP BY in a query

    • GROUP BY is used before HAVING in a query

    • Example: SELECT department, AVG(salary) FROM employees GROUP BY department HAVING AVG(salary) > 5000;

  • Answered by AI

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

TCS interview questions for designations

 Oracle SQL and PLSQL Developer

 (2)

 Developer

 (45)

 Software Developer

 (497)

 Java Developer

 (184)

 Salesforce Developer

 (35)

 Web Developer

 (33)

 Python Developer

 (28)

 Application Developer

 (18)

I applied via LinkedIn and was interviewed in May 2022. There were 2 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Properly align and format text in your resume. A recruiter will have to spend more time reading poorly aligned text, leading to high chances of rejection.
View all tips
Round 2 - Technical 

(2 Questions)

  • Q1. Views and triggers basics
  • Q2. Learning capabilities of new softwares
  • Ans. 

    I have a strong ability to learn new software quickly.

    • I am a self-motivated learner and enjoy exploring new technologies.

    • I am comfortable with online tutorials, documentation, and experimenting with new software.

    • I have experience learning new software such as Oracle SQL Developer, Toad, and PL/SQL Developer.

    • I am able to adapt to new software quickly and efficiently.

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Basic sql queries and questions are asked like views, stored procedures and triggers and subqieries and functions

Get interview-ready with Top TCS Interview Questions

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

Plsql Developer Jobs at TCS

View all

TCS Interview FAQs

How many rounds are there in TCS Plsql Developer interview?
TCS interview process usually has 2-3 rounds. The most common rounds in the TCS interview process are Technical, HR and Resume Shortlist.
How to prepare for TCS Plsql Developer interview?
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?

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

  1. What is procedure in plsql and it's syntax and difference between procedure and...read more
  2. What is temp table and temp variable in pls...read more
  3. A plsql programme to print 103,99,96.....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.

TCS Plsql Developer Interview Process

based on 12 interviews

3 Interview rounds

  • Resume Shortlist Round
  • Technical Round
  • HR Round
View more
TCS Plsql Developer Salary
based on 1.5k salaries
₹2.5 L/yr - ₹10.3 L/yr
At par with the average Plsql Developer Salary in India
View more details

TCS Plsql Developer Reviews and Ratings

based on 90 reviews

3.7/5

Rating in categories

3.5

Skill development

3.9

Work-life balance

2.8

Salary

4.5

Job security

3.8

Company culture

2.6

Promotions

3.4

Work satisfaction

Explore 90 Reviews and Ratings
Oracle PLSQL Developer

Ahmedabad

3-5 Yrs

Not Disclosed

Explore more jobs
System Engineer
1.1L salaries
unlock blur

₹1 L/yr - ₹9 L/yr

IT Analyst
66.7k salaries
unlock blur

₹5.1 L/yr - ₹16 L/yr

AST Consultant
51.5k salaries
unlock blur

₹8 L/yr - ₹25 L/yr

Assistant System Engineer
29.8k salaries
unlock blur

₹2.2 L/yr - ₹5.8 L/yr

Associate Consultant
29.4k salaries
unlock blur

₹9 L/yr - ₹32 L/yr

Explore more salaries
Compare TCS with

Amazon

4.1
Compare

Wipro

3.7
Compare

Infosys

3.6
Compare

Accenture

3.8
Compare
Did you find this page helpful?
Yes No
write
Share an Interview