Upload Button Icon Add office photos
Premium Employer

i

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

Expleo Group

Compare button icon Compare button icon Compare

Filter interviews by

Clear (1)

Expleo Group Plsql Developer Interview Questions and Answers

Updated 25 Apr 2023

Expleo Group Plsql Developer Interview Experiences

1 interview found

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed in Oct 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 - Technical 

(2 Questions)

  • Q1. Difference between sql and plsql
  • Ans. 

    SQL is used to manage relational databases while PL/SQL is used to create procedures, functions, and triggers.

    • SQL is used to retrieve and manipulate data in a database.

    • PL/SQL is used to create stored procedures, functions, and triggers.

    • SQL is a declarative language while PL/SQL is a procedural language.

    • SQL is used to query data while PL/SQL is used to write code that can be executed.

    • SQL is used to create and modify tab...

  • Answered by AI
  • Q2. Difference between drop and truncate
  • Ans. 

    Drop deletes the table and its structure while truncate deletes all the data in the table.

    • Drop is a DDL command while truncate is a DML command.

    • Drop cannot be rolled back while truncate can be rolled back using the undo tablespace.

    • Drop is slower than truncate as it deletes the table structure while truncate only deletes the data.

    • Drop can be used to delete views, sequences, and other database objects while truncate can ...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Ntg

Skills evaluated in this interview

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

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(2 Questions)

  • Q1. CREATE A FUNCTION BASED ONLOGIC SHARED
  • Ans. 

    Create a function based on shared logic

    • Identify common logic that can be reused in multiple functions

    • Create a separate function to encapsulate the shared logic

    • Call the shared function from other functions where the logic is needed

  • Answered by AI
  • Q2. FOR AN ENTITY GIVE DTAILS OF PREVOUS AND NEXT DATE FOR PARTICULAR DEPATMENT
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

Interview experience
5
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
  • 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
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 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
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
4
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
Round 3 - HR 

(1 Question)

  • Q1. Discussion for salary
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
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I was interviewed in Nov 2024.

Round 1 - Technical 

(4 Questions)

  • Q1. Types of partition in sql
  • Q2. Can we edit data in complex views, will the underlying table be effected?
  • Q3. How do you do performance tuning?
  • Q4. Tell about regex
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 Resume 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
Contribute & help others!
anonymous
You can choose to be anonymous

Expleo Group Interview FAQs

How many rounds are there in Expleo Group Plsql Developer interview?
Expleo Group interview process usually has 2 rounds. The most common rounds in the Expleo Group interview process are Resume Shortlist and Technical.
How to prepare for Expleo Group 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 Expleo Group. The most common topics and skills that interviewers at Expleo Group expect are Application Support, DNS, Firewall, JBoss and Middleware.
What are the top questions asked in Expleo Group Plsql Developer interview?

Some of the top questions asked at the Expleo Group Plsql Developer interview -

  1. Difference between sql and pl...read more
  2. Difference between drop and trunc...read more

Recently Viewed

JOBS

Gushwork

14 jobs

JOBS

Browse jobs

Discover jobs you love

JOBS

GroundTruth

33 jobs

PHOTOS

Growisto

7 office photos

SALARIES

Synergy Group

SALARIES

Sandoz

REVIEWS

Expleo Group

No Reviews

REVIEWS

The Muthoot Group

No Reviews

JOBS

SRIDEVI BUILDERS

No Jobs

REVIEWS

The Muthoot Group

No Reviews

Tell us how to improve this page.

Expleo Group Plsql Developer Interview Process

based on 1 interview

Interview experience

3
  
Average
View more
Software Engineer
640 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Software Engineer
428 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Softwaretest Engineer
268 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Associate Software Engineer
187 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

QA Associate
138 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Expleo Group with

TCS

3.7
Compare

Infosys

3.6
Compare

Wipro

3.7
Compare

HCLTech

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