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

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?
  • 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

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I was interviewed in Jan 2025.

Round 1 - Technical 

(14 Questions)

  • Q1. Queries on joins using inner join, left join, right join, outer join
  • Q2. What are the definitions of case and decode, what are the differences between them, and can you explain the logic for each?
  • Ans. 

    Case and decode are conditional expressions in PL/SQL used for data manipulation.

    • CASE is used for conditional logic in SQL statements, while DECODE is used for conditional logic in SELECT statements.

    • CASE is more flexible and can handle multiple conditions, while DECODE is limited to one condition.

    • CASE can be used in both SQL and PL/SQL, while DECODE is specific to SQL.

    • Example of CASE: SELECT CASE WHEN condition1 THEN r...

  • Answered by AI
  • Q3. What are the primary key and foreign key in database design, and can you provide examples of each?
  • Ans. 

    Primary key uniquely identifies each record in a table, while foreign key establishes a link between two tables.

    • Primary key ensures uniqueness and cannot have null values

    • Foreign key establishes a relationship between tables based on the primary key of another table

    • Example of primary key: EmployeeID in an Employee table

    • Example of foreign key: DepartmentID in an Employee table linking to DepartmentID in a Department tabl

  • Answered by AI
  • Q4. What are the differences between Rank and Dense Rank in SQL?
  • Ans. 

    Rank assigns unique ranks to each distinct row, while Dense Rank assigns consecutive ranks without gaps.

    • Rank may have gaps in the ranking sequence, while Dense Rank does not.

    • Rank assigns the same rank to rows with the same values, while Dense Rank assigns different ranks.

    • Rank function is non-consecutive, while Dense Rank function is consecutive.

  • Answered by AI
  • Q5. What is the difference between procedures and functions?
  • Ans. 

    Procedures are used to perform an action, while functions return a value.

    • Procedures do not return a value, while functions do.

    • Functions can be called from SQL queries, while procedures cannot.

    • Functions must return a value, while procedures do not necessarily have to.

  • Answered by AI
  • Q6. Is it possible to use a package body without a package specification?
  • Ans. 

    No, a package body cannot be used without a package specification.

    • A package body must always be associated with a package specification.

    • The package specification defines the public interface of the package, while the package body contains the implementation details.

    • Attempting to use a package body without a corresponding package specification will result in compilation errors.

  • Answered by AI
  • Q7. What is a SQL query that can be used to find duplicate values in a database?
  • Ans. 

    Use a SQL query with GROUP BY and HAVING clause to find duplicate values in a database.

    • Use GROUP BY clause to group the values that are duplicated.

    • Use HAVING clause to filter out the groups that have more than one occurrence.

    • Example: SELECT column_name, COUNT(*) FROM table_name GROUP BY column_name HAVING COUNT(*) > 1;

  • Answered by AI
  • Q8. Queries using group by and having clause
  • Ans. 

    Group by and having clause are used together to filter groups based on specified conditions.

    • Group by clause is used to group rows that have the same values into summary rows.

    • Having clause is used to filter groups based on specified conditions.

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

  • Answered by AI
  • Q9. What are the definitions of the Substr and Instr functions?
  • Ans. 

    Substr function extracts a substring from a string, while Instr function returns the position of a substring within a string.

    • Substr function syntax: SUBSTR(string, start_position, length)

    • Example: SUBSTR('Hello World', 7, 5) will return 'World'

    • Instr function syntax: INSTR(string, substring)

    • Example: INSTR('Hello World', 'World') will return 7

  • Answered by AI
  • Q10. What is the process for writing a SQL query that includes a subquery?
  • Ans. 

    Writing a SQL query with a subquery involves nesting one query inside another to retrieve specific data.

    • Start by writing the main query that will retrieve the primary data

    • Identify the criteria for the subquery to filter the results

    • Enclose the subquery within parentheses and use it in the WHERE or FROM clause of the main query

    • Ensure that the subquery returns a single value or a single column result

  • Answered by AI
  • Q11. What is the difference between char, varchar, and varchar2 data types?
  • Ans. 

    Char is fixed length, varchar is variable length with max 4000 bytes, varchar2 is variable length with max 32767 bytes.

    • Char is fixed length and always right-padded with spaces, while varchar and varchar2 are variable length.

    • Varchar can store up to 4000 bytes of data, while varchar2 can store up to 32767 bytes.

    • Char is less efficient in terms of storage compared to varchar and varchar2.

  • Answered by AI
  • Q12. Queries using Trunc and round
  • Q13. Is it possible to combine two tables with differing data and columns without utilizing joins?
  • Ans. 

    No, it is not possible to combine two tables with differing data and columns without utilizing joins.

    • Joins are necessary to combine tables based on a common column or key.

    • Different data and columns require a join to match and merge the data properly.

    • Examples of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.

  • Answered by AI
  • Q14. Is it possible to update data in a view?
  • Ans. 

    Yes, it is possible to update data in a view using INSTEAD OF triggers.

    • Views are virtual tables that display data from one or more tables.

    • By using INSTEAD OF triggers, you can update data in a view by specifying the logic to handle the update operation.

    • The trigger intercepts the update operation on the view and executes the specified logic to update the underlying tables.

    • For example, you can create an INSTEAD OF trigge...

  • Answered by AI
Round 2 - Behavioral 

(6 Questions)

  • Q1. Can you describe yourself and provide details about your project, including the brief questions that were asked about it?
  • Q2. Why TCS?
  • Ans. 

    TCS is a global IT services company known for its innovative solutions and commitment to employee growth.

    • TCS has a strong reputation in the IT industry for delivering high-quality services.

    • TCS offers opportunities for professional growth and development through training programs and career advancement.

    • TCS has a diverse and inclusive work culture that values teamwork and collaboration.

  • Answered by AI
  • Q3. What is a dynamic cursor in database management?
  • Ans. 

    A dynamic cursor in database management allows for the execution of different SQL queries at runtime.

    • Dynamic cursors are used when the SQL query to be executed is not known until runtime.

    • They allow for flexibility in querying the database based on user input or other conditions.

    • Dynamic cursors can be used to handle varying result sets or conditions in a more efficient manner.

    • Example: Using a dynamic cursor to search fo...

  • Answered by AI
  • Q4. Did you perform performance tuning, and if so, what steps did you take?
  • Ans. 

    Yes, I have performed performance tuning by identifying bottlenecks and optimizing queries.

    • Identified slow queries using tools like SQL Trace, Explain Plan, and AWR reports.

    • Optimized queries by adding indexes, rewriting SQL statements, and reducing unnecessary data retrieval.

    • Tuned PL/SQL code by using bulk processing, minimizing context switches, and optimizing loops.

    • Utilized database features like partitioning and mat

  • Answered by AI
  • Q5. What is the definition of a package, and is it possible to use a package body without a package specification?
  • Ans. 

    A package in PL/SQL is a collection of related procedures, functions, variables, and other constructs.

    • A package consists of two parts: package specification and package body.

    • The package specification defines the public interface of the package, including declarations of variables, constants, cursors, procedures, and functions.

    • The package body contains the actual implementation of the procedures and functions declared i...

  • Answered by AI
  • Q6. I got more questions from my project related
Round 3 - HR 

(6 Questions)

  • Q1. What are your reasons for wanting to join TCS?
  • Ans. 

    I am excited about the opportunity to work with a global leader like TCS and contribute to innovative projects.

    • TCS is a renowned global company with a strong reputation in the IT industry

    • I am impressed by TCS's commitment to innovation and cutting-edge technology

    • I believe TCS offers great opportunities for professional growth and development

    • I am excited about the chance to work on diverse and challenging projects at TC

  • Answered by AI
  • Q2. What is your current salary package?
  • Ans. 

    I prefer to discuss my salary expectations based on the responsibilities and requirements of the position.

    • Focus on discussing salary expectations based on the job responsibilities and requirements.

    • Avoid disclosing specific current salary package.

    • Emphasize the importance of fair compensation based on market rates and skills.

    • Provide examples of successful projects or achievements that demonstrate your value.

    • Discuss oppor...

  • Answered by AI
  • Q3. What is your expected salary package?
  • Ans. 

    I am looking for a competitive salary package based on my experience and skills.

    • I am open to discussing salary based on the responsibilities and requirements of the role.

    • I have researched the average salary range for Plsql Developers in this location.

    • I am looking for a package that includes benefits such as healthcare, retirement plans, and professional development opportunities.

  • Answered by AI
  • Q4. Are you comfortable with shift work?
  • Ans. 

    Yes, I am comfortable with shift work and have experience working various shifts.

    • I have previous experience working different shifts in my current/previous roles.

    • I am flexible with my schedule and can easily adapt to changing shift patterns.

    • I understand the importance of shift work in ensuring 24/7 coverage for critical systems.

  • Answered by AI
  • Q5. Are you ok with any location
  • Ans. 

    Yes, I am open to any location for the Plsql Developer position.

    • I am willing to relocate for the right opportunity

    • I am open to working in different cities or countries

    • I am flexible with travel requirements for the job

  • Answered by AI
  • Q6. Holding any other offers in hand

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
Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. What is groupby
  • Ans. 

    The GROUP BY clause in SQL is used to group rows that have the same values into summary rows.

    • It is used with aggregate functions like COUNT, SUM, AVG, etc.

    • It is used to group rows based on one or more columns in a table.

    • It is often used in conjunction with the SELECT statement.

  • Answered by AI
  • Q2. What is having

Skills evaluated in this interview

Plsql Developer Interview Questions & Answers

user image Ajay Saxena

posted on 11 Dec 2024

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. What is Groupby
  • Q2. What is cte?

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)

Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
No response

I applied via Naukri.com and was interviewed in Dec 2023. There were 2 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. It was good but not selected
  • Q2. How to delete duplicate records
  • Ans. 

    To delete duplicate records in PL/SQL, use a combination of SELECT DISTINCT and DELETE statements.

    • Identify duplicate records using SELECT DISTINCT with a COUNT(*) function.

    • Use a DELETE statement with a subquery to remove duplicate records.

    • Consider creating a temporary table to store unique records before deleting duplicates.

  • Answered by AI
Round 2 - Technical 

(1 Question)

  • Q1. What is collation
  • Ans. 

    Collation is the set of rules determining how data is sorted and compared in a database.

    • Collation defines the order in which characters are sorted and compared in a database

    • It includes rules for comparing characters with diacritics, case sensitivity, and special characters

    • Different collations can affect sorting order and comparison results

  • Answered by AI

Skills evaluated in this interview

Get interview-ready with Top TCS Interview Questions

Interview experience
2
Poor
Difficulty level
Moderate
Process Duration
4-6 weeks
Result
Not Selected

I applied via Naukri.com and was interviewed in Mar 2024. There was 1 interview round.

Round 1 - HR 

(1 Question)

  • Q1. Difference between delete,drop, truncate
  • Ans. 

    Delete removes specific rows from a table, drop removes the entire table, truncate removes all rows from a table.

    • Delete is a DML command used to remove specific rows from a table based on a condition.

    • Drop is a DDL command used to remove an entire table along with its structure and data.

    • Truncate is a DDL command used to remove all rows from a table but keeps the table structure intact.

    • Delete can be rolled back, drop can...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - After making me wait for one month, during the time of releasing offer letter i was rejected.. as they preferred a candidate who is localite

Skills evaluated in this interview

Plsql Developer Jobs at TCS

View all
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(1 Question)

  • Q1. How to get table size in SQL
  • Ans. 

    Table size can be obtained by querying the data dictionary views in SQL.

    • Use the query 'SELECT table_name, round((num_rows * avg_row_len)/1024/1024,2) as size_mb FROM all_tables WHERE table_name = 'YOUR_TABLE_NAME';'

    • Alternatively, you can use the query 'SELECT segment_name, bytes/1024/1024 as size_mb FROM user_segments WHERE segment_name = 'YOUR_TABLE_NAME';'

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Need to prepare for depth

Skills evaluated in this interview

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

I was interviewed in Feb 2023.

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 

(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...
  • Q2. Reason for Job change

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
Hard
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed before Dec 2023. There were 3 interview rounds.

Round 1 - Aptitude Test 

Presence of mind was checked.

Round 2 - Coding Test 

Queries related to joins and union were mainly asked.

Round 3 - Behavioral 

(1 Question)

  • Q1. Where do you see yourself after 5 years?
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
-

I applied via Naukri.com and was interviewed in Sep 2022. There were 3 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. What was temp variable
  • Ans. 

    A temporary variable used to store data during program execution.

    • Temp variables are used to hold data temporarily during program execution.

    • They are typically used in loops or conditional statements.

    • Once the program execution is complete, the temp variable is no longer needed.

    • Example: int temp = 0; for(int i=0; i<10; i++) { temp += i; }

    • In this example, the temp variable is used to store the sum of the numbers 0-9.

  • Answered by AI
  • Q2. Breif about previous company
Round 3 - HR 

(1 Question)

  • Q1. Document verification and onboarding

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare sql and pl sql , learn all sql concepts, pl sql , rdms software
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Double-check your resume for any spelling mistakes. The recruiter may consider spelling mistakes as careless behavior or poor communication skills.
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.

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