Upload Button Icon Add office photos
Engaged Employer

i

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

Capgemini Verified Tick

Compare button icon Compare button icon Compare

Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards

zig zag pattern zig zag pattern

Filter interviews by

Capgemini Plsql Developer Interview Questions and Answers

Updated 21 Oct 2023

Capgemini Plsql Developer Interview Experiences

2 interviews found

Plsql Developer Interview Questions & Answers

user image Imaya Valli

posted on 21 Oct 2023

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
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. 1.How to search a text in all database objects- search in all_source table 2.difference between procedure & function 3.difference between case & decode 4.write a query to delete duplicates from table 5.whi...
Round 3 - One-on-one 

(1 Question)

  • Q1. Waiting for round 1 results

Interview Questionnaire 

2 Questions

  • Q1. Index , collection, partition, package, pragma autonomous transaction
  • Q2. Answer confidently

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 questions from similar companies

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

I applied via Naukri.com and was interviewed before Jul 2021. There were 2 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. What is performing tuning?
  • Ans. 

    Performance tuning is the process of optimizing the performance of a system or application.

    • Identifying and resolving performance bottlenecks

    • Optimizing database queries and indexes

    • Improving hardware and network configurations

    • Reducing resource usage and improving response time

    • Monitoring and analyzing system performance

  • Answered by AI
Round 2 - Technical 

(1 Question)

  • Q1. Explain stored procedure and PLSQL concept in detail?
  • Ans. 

    Stored procedure is a precompiled program that is stored in a database and can be called by other programs.

    • Stored procedures are used to encapsulate business logic and improve performance.

    • PL/SQL is a procedural language used to write stored procedures in Oracle databases.

    • Stored procedures can accept input parameters and return output parameters or result sets.

    • They can also be used to enforce security and data integrity...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Need to focus query writing
Stored procedures...and do some practical coding in tools like SQL developer and isqlplus version 11G and more..
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
No response

I applied via Approached by Company and was interviewed in Sep 2023. 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 

(1 Question)

  • Q1. Window Functions in SQL
  • Ans. 

    Window functions in SQL are used to perform calculations across a set of table rows related to the current row.

    • Window functions are used to calculate values based on a set of rows related to the current row.

    • They allow you to perform calculations without grouping the rows into a single output row.

    • Examples of window functions include ROW_NUMBER(), RANK(), and LAG().

  • Answered by AI
Round 3 - Technical 

(1 Question)

  • Q1. Uses of Packages in PL/SQL
  • Ans. 

    Packages in PL/SQL are used to group related procedures, functions, variables, and other PL/SQL constructs together for better organization and security.

    • Packages help in modularizing code for easier maintenance and debugging

    • They provide encapsulation and hide implementation details

    • Packages can contain multiple procedures, functions, variables, cursors, and exceptions

    • They improve performance by reducing network traffic

    • E...

  • Answered by AI

Skills evaluated in this interview

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

I applied via Referral and was interviewed before Jun 2023. There was 1 interview round.

Round 1 - Assignment 

Oracle pl sql developer

Interview Preparation Tips

Interview preparation tips for other job seekers - Np
Round 1 - Technical 

(2 Questions)

  • Q1. Basic SQL related question
  • Q2. Good knowledge on pl SQL is preferred, few in-depth questions . Keep your cool and answer every question with best of your knowledge

Interview Preparation Tips

Interview preparation tips for other job seekers - Don't panic and answer questions with your best experience and knowledge.

I applied via Naukri.com and was interviewed in Jun 2022. There were 2 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 - One-on-one 

(2 Questions)

  • Q1. Triggers , procedures , exception handling , collections, package
  • Q2. Type , array, partition, performance tuning, AWR

Interview Preparation Tips

Interview preparation tips for other job seekers - For senior level they will expect knowledge on bulk processing exception handling packages collections
Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Factorial of a number
  • Ans. 

    Factorial of a number is the product of all positive integers up to that number.

    • To calculate factorial of a number, multiply all positive integers up to that number.

    • Factorial of 0 is 1.

    • Example: Factorial of 5 is 5*4*3*2*1 = 120.

  • Answered by AI
  • Q2. Sql queries including 2nd highest salary and table joins
Round 2 - Technical 

(2 Questions)

  • Q1. Sql question and table joins
  • Q2. Modelling of schema
  • Ans. 

    Modelling of schema involves designing the structure of a database to organize and represent data.

    • Identify entities and their relationships

    • Define attributes for each entity

    • Establish primary and foreign keys

    • Normalize the schema to reduce redundancy

    • Consider performance and scalability

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Some sql queries
1 DSA prime no

Skills evaluated in this interview

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.

Capgemini Interview FAQs

How many rounds are there in Capgemini Plsql Developer interview?
Capgemini interview process usually has 3 rounds. The most common rounds in the Capgemini interview process are One-on-one Round, Resume Shortlist and Technical.
How to prepare for Capgemini 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 Capgemini. The most common topics and skills that interviewers at Capgemini expect are PLSQL, Performance Tuning, Unix Shell Scripting, Unix and Oracle.
What are the top questions asked in Capgemini Plsql Developer interview?

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

  1. 1.How to search a text in all database objects- search in all_source table 2.di...read more
  2. Index , collection, partition, package, pragma autonomous transact...read more
  3. Waiting for round 1 resu...read more

Tell us how to improve this page.

Capgemini Plsql Developer Interview Process

based on 3 interviews

Interview experience

5
  
Excellent
View more
Capgemini Plsql Developer Salary
based on 361 salaries
₹3.6 L/yr - ₹13.4 L/yr
44% more than the average Plsql Developer Salary in India
View more details

Capgemini Plsql Developer Reviews and Ratings

based on 33 reviews

3.8/5

Rating in categories

4.0

Skill development

3.9

Work-life balance

3.5

Salary

4.2

Job security

3.9

Company culture

3.1

Promotions

3.7

Work satisfaction

Explore 33 Reviews and Ratings
Consultant
55.4k salaries
unlock blur

₹5.2 L/yr - ₹18 L/yr

Associate Consultant
50.7k salaries
unlock blur

₹3 L/yr - ₹11.8 L/yr

Senior Consultant
46.5k salaries
unlock blur

₹7.5 L/yr - ₹24.8 L/yr

Senior Analyst
20.8k salaries
unlock blur

₹2.2 L/yr - ₹9 L/yr

Senior Software Engineer
20.4k salaries
unlock blur

₹3.5 L/yr - ₹12.5 L/yr

Explore more salaries
Compare Capgemini with

Wipro

3.7
Compare

Accenture

3.8
Compare

Cognizant

3.7
Compare

TCS

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