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
CompareProud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
Capgemini Oracle SQL and PLSQL Developer Interview Questions and Answers
Updated
8 May 2023
2 interviews found
Sort by:
Popular
Anonymous
I applied via Approached by Company and was interviewed in Jul 2022.
3 Interview Rounds
1
Technical Round (1 Question)
- Q1. Basic SQL Questions. Joins triggers cursor function procedure materialized view. Group by concept with SQL queries Add Answer
2
Technical Round (1 Question)
- Q1. Triggers cursor function procedure refcursor Add Answer
3
HR Round (1 Question)
- Q1. Salary discussion and other HR questions Add Answer
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
Interview experience
Excellent
Difficulty level
-
Duration
Less than 2 weeks
Result
Selected
I applied via Company Website and was interviewed in Apr 2023.
3 Interview Rounds
1
Resume Shortlist Round
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
2
Coding Test Round
SQL and PLSQL querys writing.
3
HR Round (2 Questions)
- Q1. Self introduction ,and salary discussion Add Answer
- Q2. Self introduction and salary discussion, company details. Add Answer
Interview questions from similar companies
Interview experience
Poor
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
No response
I applied via Company Website
1 Interview Round
1
Technical Round (9 Questions)
- Q1. Question on LIST_AGGR Add Answer
- Q2. Question on dynamic SQL ,what is a bind variable Add Answer
- Q3. Question on constraints ,do we can delete a child table column having connection with foreign key with parent table Add Answer
- Q4. Triggers : do we can use commit or roll back with in trigger ? View Answers (1)
- Q5. Materialized views and how to refresh View Answers (1)
- Q6. Print 1 to 10 using sql View Answers (1)
- Q7. What is Context switching ? And about collection types ... View Answers (1)
- Q8. Tell me about Analytical functions you worked on ? View Answers (1)
- Q9. What are Set operators ,which one keep duplicates among them View Answers (1)
Interview Preparation Tips
Topics to prepare for Infosys Oracle SQL and PLSQL Developer interview:
- Siva academy
- Techtfq
- Kudvenkat
Skills evaluated in this interview
Interview experience
Good
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
No response
I was interviewed in Sep 2024.
1 Interview Round
1
Technical Round (5 Questions)
- Q1. Tell me about OLAP systems. View Answers (1)
- Q2. How to process files in different formats and from different sources to load a single table in Oracle. View Answers (1)
- Q3. More questions on partitioning. Range and List partitioning. Interval partition, split partition etc Add Answer
- Q4. Questions on indexes Add Answer
- Q5. Questions on performance tuning Add Answer
Skills evaluated in this interview
Ani Anita
I applied via Walk-in and was interviewed in Feb 2022.
2 Interview Rounds
1
Resume Shortlist Round
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
2
HR Round (1 Question)
- Q1. Tell me about yourself. Add Answer
Interview Preparation Tips
Topics to prepare for Wipro Oracle SQL and PLSQL Developer interview:
- Oracle SQL and plsql Developer
Interview experience
Good
Difficulty level
-
Duration
-
Result
-
1 Interview Round
1
Technical Round (1 Question)
- Q1. What is sql , index , stored proc , triggers Add Answer
Interview experience
Good
Difficulty level
Easy
Duration
-
Result
-
I applied via Naukri.com and was interviewed in Apr 2024.
1 Interview Round
1
Technical Round (6 Questions)
- Q1. What is view? Can we update in view? View Answers (1)
- Q2. What is synonym? View Answers (1)
- Q3. What is sequence View Answers (1)
- Q4. What is procedures? View Answers (1)
- Q5. What is difference between procedure and functions View Answers (1)
- Q6. What is partitions? View Answers (1)
Skills evaluated in this interview
Interview experience
Poor
Difficulty level
Moderate
Duration
-
Result
Not Selected
I applied via Naukri.com and was interviewed in May 2024.
1 Interview Round
1
Technical Round (2 Questions)
- Q1. How to insert multiple values in one go View Answers (1)
- Q2. Update query using joins View Answers (1)
Interview Preparation Tips
Interview preparation tips for other job seekers - Prepare Basic Questions
Skills evaluated in this interview
Interview experience
Excellent
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
Not Selected
I applied via Company Website and was interviewed in Apr 2024.
3 Interview Rounds
1
Coding Test Round
Test your algorithmic thinking and problem solving skills
2
One-on-one Round (1 Question)
- Q1. Communications,clearity of answers Add Answer
3
HR Round (1 Question)
- Q1. Discussion about packages,joining date Add Answer
Interview Preparation Tips
Interview preparation tips for other job seekers - Self assessment,Techical preparation
Interview experience
Excellent
Difficulty level
Moderate
Duration
2-4 weeks
Result
Selected
I applied via LinkedIn and was interviewed in Jun 2024.
2 Interview Rounds
1
Coding Test Round
Sql queries on top clause
2
HR Round (2 Questions)
- Q1. Why u want to join View Answers (1)
- Q2. What is the salary expectation View Answers (1)
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?
Tell us how to improve this page.
Capgemini Interviews By Designations
- Capgemini Analyst Interview Questions
- Capgemini Consultant Interview Questions
- Capgemini Software Engineer Interview Questions
- Capgemini Senior Consultant Interview Questions
- Capgemini Associate Consultant Interview Questions
- Capgemini Senior Analyst Interview Questions
- Capgemini Software Developer Interview Questions
- Capgemini Senior Software Engineer Interview Questions
- Show more
Interview Questions for Popular Designations
- Plsql Developer Interview Questions
- Senior Plsql Developer Interview Questions
- SQL Developer Interview Questions
- SQL Database Administrator Interview Questions
- MS SQL DBA Interview Questions
- SQL and PL SQL Developer Interview Questions
- SQL Server Developer Interview Questions
- SQL Server Database Administrator Interview Questions
- Show more
People are getting interviews through
based on 2 Capgemini interviews
Company Website
50%
50% candidates got the interview through other sources.
Moderate
Confidence
?
Moderate Confidence means the data is based on a sufficient number of responses received from the candidates
Interview Questions from Similar Companies
Fast track your campus placements
16%
less
than the average Oracle SQL and PLSQL Developer Salary in India
View more details
Capgemini Oracle SQL and PLSQL Developer Reviews and Ratings
based on 1 review
Rating in categories
|
Consultant
57.4k
salaries
|  ₹5.1 L/yr - ₹18 L/yr |
|
Associate Consultant
53.9k
salaries
| ₹2.9 L/yr - ₹10 L/yr |
|
Senior Consultant
47.7k
salaries
| ₹7.5 L/yr - ₹25 L/yr |
|
Senior Analyst
21.2k
salaries
| ₹2 L/yr - ₹9.1 L/yr |
|
Senior Software Engineer
20.4k
salaries
| ₹3.5 L/yr - ₹13 L/yr |
Explore more salaries
Compare Capgemini with
Wipro
Compare
Accenture
Compare
Cognizant
Compare
TCS
Compare
Calculate your in-hand salary
Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and
get your in-hand salary
Did you find this page helpful?
Yes No
- Home >
- Interviews >
- Capgemini Interview Questions >
- Capgemini Oracle SQL and PLSQL Developer Interview Questions
Share an Interview