4 Capgemini Plsql Developer Interview Questions & Answers | Complete Prep Guide 2025

Capgemini Plsql Developer Interview Experiences

2 interviews found

Plsql Developer Interview Questions & Answers

Imaya Valli

posted on 21 Oct 2023

Interview experience

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 Resume 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...

Add your answer

Round 3 - One-on-one

(1 Question)

Q1. Waiting for round 1 results

Add your answer

Plsql Developer Interview Questions & Answers

Anonymous

posted on 6 Apr 2021

Interview Questionnaire

2 Questions

Q1. Index , collection, partition, package, pragma autonomous transaction

Add your answer

Q2. Answer confidently

Add your answer

Interview questions from similar companies

Plsql Developer Interview Questions & Answers

TCS

Anonymous

posted on 5 May 2019

Interview Questionnaire

2 Questions

Q1. They have only one phone interview

Add your answer

Q2. They asking about full sql and plsql

Add your answer

Interview Preparation Tips

Round: Resume Shortlist
Experience: Detailed description of explaination full topics

Plsql Developer Interview Questions & Answers

Tech Mahindra

Suvham Das

posted on 17 Jul 2024

Interview experience

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

Add your answer

Q2. Sql queries including 2nd highest salary and table joins

Add your answer

Round 2 - Technical

(2 Questions)

Q1. Sql question and table joins

Add your answer

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

Add your answer

Interview Preparation Tips

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

Skills evaluated in this interview

Plsql Developer Interview Questions & Answers

Cognizant

Anonymous

posted on 21 Jun 2021

I applied via Naukri.com and was interviewed in May 2021. There were 3 interview rounds.

Interview Questionnaire

10 Questions

Q1. Oracle instance architecture

Add your answer

Q2. Redo log buffer

View 2 more answers

Q3. Difference between Procedure and function

Ans.

Procedures and functions are both PL/SQL program units, but they have some key differences.

Procedures do not return a value, while functions do.
Procedures can have OUT parameters to pass values back to the caller, while functions cannot.
Functions can be used in SQL statements, while procedures cannot.
Functions must return a value, while procedures do not necessarily have to.
Procedures are typically used for performing ...

Answered by AI

View 4 more answers

Q4. Difference between implicit and explicit cursor

Ans.

Implicit cursors are automatically created by the Oracle server, while explicit cursors are explicitly declared by the programmer.

Implicit cursors are used for single-row queries, while explicit cursors are used for multi-row queries.
Implicit cursors are automatically opened, fetched, and closed by the Oracle server, while explicit cursors need to be manually opened, fetched, and closed by the programmer.
Implicit curso...

Answered by AI

View 2 more answers

Q5. Difference between soft parsing and hard parsing of sql

Ans.

Soft parsing is reusing the existing execution plan while hard parsing is generating a new execution plan.

Soft parsing is faster as it avoids the overhead of generating a new execution plan.
Hard parsing is slower as it involves generating a new execution plan.
Soft parsing occurs when the SQL statement is already in the shared pool.
Hard parsing occurs when the SQL statement is not in the shared pool or needs a new execu...

Answered by AI

View 2 more answers

Q6. Difference between rdbms and dbms

Ans.

RDBMS is a type of DBMS that stores data in a structured manner using tables with relationships.

DBMS is a software system that manages data stored in a computer's memory or disk storage.
RDBMS is a type of DBMS that uses a relational model to store data in tables with relationships.
RDBMS supports ACID properties (Atomicity, Consistency, Isolation, Durability) for data integrity.
Examples of RDBMS include Oracle, MySQL, S...

Answered by AI

Add your answer

Q7. Write a sql to find nth highest salary

Ans.

SQL query to find the nth highest salary

Use the ORDER BY clause to sort the salaries in descending order
Use the LIMIT clause to select the nth highest salary

Answered by AI

View 1 more answer

Q8. Write a sql to delete duplicate records from a table

Ans.

SQL query to delete duplicate records from a table.

Use the DELETE statement with a subquery to identify and delete duplicate records.
The subquery should select the duplicate records based on the criteria for duplication.
Ensure to keep at least one copy of the duplicate records to avoid deleting all instances.

Answered by AI

View 7 more answers

Q9. Difference between delete and truncate

Ans.

Delete is a DML operation that removes specific rows from a table, while truncate is a DDL operation that removes all rows from a table.

Delete is slower than truncate as it generates undo logs and triggers
Delete can be rolled back, while truncate cannot be rolled back
Delete operation maintains the integrity of the transaction log, while truncate operation does not
Delete operation fires delete triggers, while truncate o...

Answered by AI

View 1 more answer

Q10. Scenario based questions on exceptions in plsql

Add your answer

Skills evaluated in this interview

Plsql Developer Interview Questions & Answers

Cognizant

posted on 2 Dec 2022

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 Resume tips

Round 2 - One-on-one

(2 Questions)

Q1. Triggers , procedures , exception handling , collections, package

Add your answer

Q2. Type , array, partition, performance tuning, AWR

Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - For senior level they will expect knowledge on bulk processing exception handling packages collections

Plsql Developer Interview Questions & Answers

LTIMindtree

Anonymous

posted on 10 Nov 2024

Interview experience

Excellent

Difficulty level

Moderate

Process Duration

Less than 2 weeks

Result

Not Selected

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

Round 1 - Technical

(2 Questions)

Q1. EXPLAIN ABOUT UR PRJECT

Ans.

Developed a PL/SQL project for managing inventory and sales data in a retail store.

Designed database tables to store product information, sales transactions, and customer details.
Implemented PL/SQL procedures and functions for adding, updating, and querying data.
Created triggers to enforce business rules and maintain data integrity.
Developed reports using PL/SQL queries to analyze sales performance and inventory levels

Answered by AI

Add your answer

Q2. How do you work on performance optimization

Ans.

I work on performance optimization by analyzing query execution plans, indexing, and code refactoring.

Analyzing query execution plans to identify bottlenecks
Creating appropriate indexes to improve query performance
Refactoring code to optimize resource usage
Using tools like Explain Plan and SQL Tuning Advisor

Answered by AI

Add your answer

Plsql Developer Interview Questions & Answers

HCLTech

Anonymous

posted on 19 Oct 2023

Interview experience

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

Add your answer

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

Add your answer

Skills evaluated in this interview

Plsql Developer Interview Questions & Answers

HCLTech

Anonymous

posted on 23 Apr 2023

Interview experience

Good

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 Resume tips

Round 2 - Technical

(1 Question)

Q1. Plsql and Oracle SQL

Add your answer

Round 3 - HR

(1 Question)

Q1. Discussion for salary

Add your answer

Plsql Developer Interview Questions & Answers

HCLTech

manasa dasari

posted on 19 Jun 2024

Interview experience

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

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 Resume Shortlist, Technical and One-on-one Round.

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.How to search a text in all database objects- search in all_source table 2.di...read more
Index , collection, partition, package, pragma autonomous transact...read more
Waiting for round 1 resu...read more

Tell us how to improve this page.

Capgemini Interviews By Designations

Interview Questions for Popular Designations

Capgemini Plsql Developer Interview Process

based on 3 interviews

Interview experience

Excellent

TCS Plsql Developer Interview Questions

3.7

• 16 Interviews

Infosys Plsql Developer Interview Questions

3.6

• 10 Interviews

Accenture Plsql Developer Interview Questions

3.8

• 5 Interviews

Cognizant Plsql Developer Interview Questions

3.7

• 4 Interviews

HCLTech Plsql Developer Interview Questions

3.5

• 3 Interviews

Wipro Plsql Developer Interview Questions

3.7

• 1 Interview

Tech Mahindra Plsql Developer Interview Questions

3.5

• 1 Interview

LTIMindtree Plsql Developer Interview Questions

3.8

• 1 Interview

HCL Group Plsql Developer Interview Questions

3.6

• 1 Interview

View all

Lovely Professional University (LPU) Placement Questions

11 Interviews

SRM university (SRMU) Placement Questions

9 Interviews

GLA Institute of Technology and Management, Mathura Placement Questions

6 Interviews

Indian Institute of Technology (IIT), Chennai Placement Questions

6 Interviews

Mumbai University Placement Questions

6 Interviews

Vidyalankar Institute of Technology, Mumbai Placement Questions

5 Interviews

Sathyabama University Placement Questions

5 Interviews

View all

Capgemini Plsql Developer Salary

based on 363 salaries

₹4 L/yr - ₹16 L/yr

46% more than the average Plsql Developer Salary in India

View more details

Capgemini Salaries in India

Consultant 55.1k salaries	₹5.2 L/yr - ₹17.9 L/yr
Associate Consultant 50.7k salaries	₹3 L/yr - ₹11.8 L/yr
Senior Consultant 46.2k salaries	₹7.5 L/yr - ₹24.6 L/yr
Senior Analyst 20.9k salaries	₹2.2 L/yr - ₹9 L/yr
Senior Software Engineer 20.2k salaries	₹3.5 L/yr - ₹12.4 L/yr