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 Oracle SQL and PLSQL Developer Interview Questions and Answers

Updated 8 May 2023

Capgemini Oracle SQL and PLSQL Developer Interview Experiences

2 interviews found

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

I applied via Company Website and was interviewed in Apr 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 - Coding Test 

SQL and PLSQL querys writing.

Round 3 - HR 

(2 Questions)

  • Q1. Self introduction ,and salary discussion
  • Q2. Self introduction and salary discussion, company details.

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

Round 1 - Technical 

(1 Question)

  • Q1. Basic SQL Questions. Joins triggers cursor function procedure materialized view. Group by concept with SQL queries
Round 2 - Technical 

(1 Question)

  • Q1. Triggers cursor function procedure refcursor
Round 3 - HR 

(1 Question)

  • Q1. Salary discussion and other HR questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Go through all basics. SQL queries to including group by with agrigate function with windowing clause

Oracle SQL and PLSQL Developer Interview Questions Asked at Other Companies

asked in Infosys
Q1. Tell me about Analytical functions you worked on ?
asked in Infosys
Q2. What is Context switching ? And about collection types ...
asked in Infosys
Q3. What are Set operators ,which one keep duplicates among them
asked in Zoho
Q4. What will happen if we do not use commit in pragma procedure?
asked in Infosys
Q5. Triggers : do we can use commit or roll back with in trigger ?

Interview questions from similar companies

I applied via Company Website and was interviewed before Dec 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Questions on Java,SQL,some trending technologies(IOT,Big data),pattern questions, programming questions with different approaches.

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare basics of DSA, have knowledge about the databases, some common dml ,ddl statements, programming knowledge of a particular language like C,Java, python,etc...have good command on oops concepts... little bit of frameworks knowledge will also help

I applied via Newspaper Ad and was interviewed before Jun 2021. There were 3 interview rounds.

Round 1 - Aptitude Test 
Round 2 - Technical 

(1 Question)

  • Q1. Basic questions of java.
Round 3 - HR 

(1 Question)

  • Q1. Intro and other hr related questions.

Interview Preparation Tips

Interview preparation tips for other job seekers - Cover the basic questions regarding the programming language.

I applied via Referral and was interviewed before Apr 2021. There were 2 interview rounds.

Round 1 - Aptitude Test 

Puzzles, Psychometric Test

Round 2 - One-on-one 

(1 Question)

  • Q1. Some water in 3 Jars question, you had to measure out 5L correctly

Interview Preparation Tips

Interview preparation tips for other job seekers - Make the interview interactive, I got this input from another Senior. Before i went into the interview room the volunteers were telling all those who goes into Room No 1 is screwed. I was praying i don't get room no 1. But fortunately for me I got room no 1 because when the interviewer gave me the puzzle and handed over pen and paper he went back to relax his posture and when i explained i will fill the 5L Jar first, he immediately came forward to listen to me, at that moment i knew i got the job because i felt the previous candidates never made their interview interactive and that's why he went back to relax his posture.

I applied via Company Website and was interviewed before Jun 2021. There were 2 interview rounds.

Round 1 - Aptitude Test 

First round was coding as well as aptitude done together went well I guess focusing on codes helps a lot.

Round 2 - Technical 

(1 Question)

  • Q1. 2nd round included tr and mr round went quite enegritic

Interview Preparation Tips

Interview preparation tips for other job seekers - Resume skills matters a lot don't fill resume the technologies you don't even aware of

I was interviewed in Sep 2016.

Interview Questionnaire 

3 Questions

  • Q1. Tell me about yourself
  • Ans. 

    I am a passionate software developer with experience in Java, Python, and web development.

    • Experienced in Java, Python, and web development technologies

    • Strong problem-solving skills and ability to work in a team

    • Completed multiple projects including a web-based inventory management system

  • Answered by AI
  • Q2. Simple coding questions..Basically pattern.
  • Q3. And also they will ask about your projects.

Interview Preparation Tips

Round: Test
Experience: 60 multiple choice questions so have to manage time carefully.
Tips: Have to give equal importance to all the sections..So try to do well in all section.
Duration: 1 hour 30 minutes
Total Questions: 60

Round: Technical + HR Interview
Experience: Don't panic...Only write those things that you know in your resume.

Skills: Smart Coding
College Name: Jaypee Institute Of Information Technology, Noida

I was interviewed in May 2017.

Interview Preparation Tips

Round: Test
Total Questions: 20

Round: Group Discussion
Duration: 1 hour

Skills: Coding Skills And Knowledge On Data Structures

I was interviewed in Jun 2017.

Interview Preparation Tips

Round: Test
Duration: 1 hour 30 minutes

Skills: Engineering Basics

I was interviewed in May 2017.

Interview Preparation Tips

Round: Group Discussion
Duration: 7 hours

College Name: Andhra university

Capgemini Interview FAQs

How many rounds are there in Capgemini Oracle SQL and PLSQL Developer interview?
Capgemini interview process usually has 3 rounds. The most common rounds in the Capgemini interview process are Technical, HR and Resume Shortlist.
What are the top questions asked in Capgemini Oracle SQL and PLSQL Developer interview?

Some of the top questions asked at the Capgemini Oracle SQL and PLSQL Developer interview -

  1. Basic SQL Questions. Joins triggers cursor function procedure materialized view...read more
  2. Triggers cursor function procedure refcur...read more

Tell us how to improve this page.

Capgemini Oracle SQL and PLSQL Developer Interview Process

based on 2 interviews

Interview experience

4.5
  
Good
View more

Interview Questions from Similar Companies

TCS Interview Questions
3.7
 • 10.4k Interviews
Accenture Interview Questions
3.8
 • 8.1k Interviews
Infosys Interview Questions
3.6
 • 7.5k Interviews
Wipro Interview Questions
3.7
 • 5.6k Interviews
Cognizant Interview Questions
3.7
 • 5.6k Interviews
Tech Mahindra Interview Questions
3.5
 • 3.8k Interviews
HCLTech Interview Questions
3.5
 • 3.8k Interviews
Genpact Interview Questions
3.8
 • 3.1k Interviews
LTIMindtree Interview Questions
3.8
 • 2.9k Interviews
IBM Interview Questions
4.0
 • 2.3k Interviews
View all
Capgemini Oracle SQL and PLSQL Developer Salary
based on 5 salaries
₹3.9 L/yr - ₹8.4 L/yr
At par with the average Oracle SQL and PLSQL Developer Salary in India
View more details
Consultant
55.1k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Associate Consultant
50.7k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Consultant
46.1k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Analyst
20.7k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Software Engineer
20.2k salaries
unlock blur

₹0 L/yr - ₹0 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